Tuesday, 12 July 2011

Assign the "responsibility" to user using plsql code.(this blog is refered from another blog ORACLE GURU")

-----------------------------------------------------------------------------------------------------
DECLARE
  l_user_id NUMBER;
CURSOR cur_rec
IS
SELECT * FROM fnd_responsibility_vl
                           WHERE UPPER (responsibility_name) = UPPER ('AE HRMS Manager');
BEGIN
    SELECT user_id INTO  l_user_id   FROM fnd_user
    WHERE user_name like '%ROHIDAS%123';

    FOR rec_cur IN cur_rec
    LOOP
    fnd_user_resp_groups_api.insert_assignment (
                                                  user_id                                => l_user_id,
                                                  responsibility_id                   => rec_cur.responsibility_id,
                                                  responsibility_application_id => rec_cur.application_id,
                                                  security_group_id                => 0,
                                                  start_date                            => SYSDATE - 1,
                                                  end_date                             => NULL,
                                                  description                           => NULL
                                                 );
                                            COMMIT;
    END LOOP;
END;
------------------------------------------------------------------------------------------------------------

2 comments:

  1. Hello Sir,please put a blog on how to use the following queries:-
    1>creating view,
    2>using join,
    3>retrieving data from two database tables.
    please Sir.
    Thank-you.

    ReplyDelete
  2. amlya salya sir bir mhanu nakos...tuza query pathwto dupar paryant...........

    ReplyDelete