eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on WF_USERS

Line 3444: l_forward_from_username wf_users.name%type;

3440: -- local variables
3441: -- -------------------------------------------------------------------------
3442: l_creator_person_id per_people_f.person_id%type;
3443: l_forward_from_person_id per_people_f.person_id%type;
3444: l_forward_from_username wf_users.name%type;
3445: l_forward_from_disp_name wf_users.display_name%type;
3446: l_forward_to_person_id per_people_f.person_id%type;
3447: l_forward_to_username wf_users.name%type;
3448: l_forward_to_disp_name wf_users.display_name%type;

Line 3445: l_forward_from_disp_name wf_users.display_name%type;

3441: -- -------------------------------------------------------------------------
3442: l_creator_person_id per_people_f.person_id%type;
3443: l_forward_from_person_id per_people_f.person_id%type;
3444: l_forward_from_username wf_users.name%type;
3445: l_forward_from_disp_name wf_users.display_name%type;
3446: l_forward_to_person_id per_people_f.person_id%type;
3447: l_forward_to_username wf_users.name%type;
3448: l_forward_to_disp_name wf_users.display_name%type;
3449: l_proc varchar2(61) := gv_package||' get_next_approver';

Line 3447: l_forward_to_username wf_users.name%type;

3443: l_forward_from_person_id per_people_f.person_id%type;
3444: l_forward_from_username wf_users.name%type;
3445: l_forward_from_disp_name wf_users.display_name%type;
3446: l_forward_to_person_id per_people_f.person_id%type;
3447: l_forward_to_username wf_users.name%type;
3448: l_forward_to_disp_name wf_users.display_name%type;
3449: l_proc varchar2(61) := gv_package||' get_next_approver';
3450: l_current_forward_to_id per_people_f.person_id%type;
3451: l_current_forward_from_id per_people_f.person_id%type;

Line 3448: l_forward_to_disp_name wf_users.display_name%type;

3444: l_forward_from_username wf_users.name%type;
3445: l_forward_from_disp_name wf_users.display_name%type;
3446: l_forward_to_person_id per_people_f.person_id%type;
3447: l_forward_to_username wf_users.name%type;
3448: l_forward_to_disp_name wf_users.display_name%type;
3449: l_proc varchar2(61) := gv_package||' get_next_approver';
3450: l_current_forward_to_id per_people_f.person_id%type;
3451: l_current_forward_from_id per_people_f.person_id%type;
3452: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';

Line 4324: l_forward_from_username wf_users.name%type;

4320:
4321: -- Local Variables
4322: l_creator_person_id per_people_f.person_id%type;
4323: l_forward_from_person_id per_people_f.person_id%type;
4324: l_forward_from_username wf_users.name%type;
4325: l_forward_from_disp_name wf_users.display_name%type;
4326: l_forward_to_person_id per_people_f.person_id%type;
4327: l_forward_to_username wf_users.name%type;
4328: l_forward_to_disp_name wf_users.display_name%type;

Line 4325: l_forward_from_disp_name wf_users.display_name%type;

4321: -- Local Variables
4322: l_creator_person_id per_people_f.person_id%type;
4323: l_forward_from_person_id per_people_f.person_id%type;
4324: l_forward_from_username wf_users.name%type;
4325: l_forward_from_disp_name wf_users.display_name%type;
4326: l_forward_to_person_id per_people_f.person_id%type;
4327: l_forward_to_username wf_users.name%type;
4328: l_forward_to_disp_name wf_users.display_name%type;
4329: l_proc varchar2(61) := gv_package||'get_next_approver';

Line 4327: l_forward_to_username wf_users.name%type;

4323: l_forward_from_person_id per_people_f.person_id%type;
4324: l_forward_from_username wf_users.name%type;
4325: l_forward_from_disp_name wf_users.display_name%type;
4326: l_forward_to_person_id per_people_f.person_id%type;
4327: l_forward_to_username wf_users.name%type;
4328: l_forward_to_disp_name wf_users.display_name%type;
4329: l_proc varchar2(61) := gv_package||'get_next_approver';
4330: l_current_forward_to_id per_people_f.person_id%type;
4331: l_current_forward_from_id per_people_f.person_id%type;

Line 4328: l_forward_to_disp_name wf_users.display_name%type;

4324: l_forward_from_username wf_users.name%type;
4325: l_forward_from_disp_name wf_users.display_name%type;
4326: l_forward_to_person_id per_people_f.person_id%type;
4327: l_forward_to_username wf_users.name%type;
4328: l_forward_to_disp_name wf_users.display_name%type;
4329: l_proc varchar2(61) := gv_package||'get_next_approver';
4330: l_current_forward_to_id per_people_f.person_id%type;
4331: l_current_forward_from_id per_people_f.person_id%type;
4332: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';

Line 4525: l_forward_from_username wf_users.name%type;

4521:
4522: -- Local Variables
4523: l_creator_person_id per_people_f.person_id%type;
4524: l_forward_from_person_id per_people_f.person_id%type;
4525: l_forward_from_username wf_users.name%type;
4526: l_forward_from_disp_name wf_users.display_name%type;
4527: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;
4528: l_forward_to_username wf_users.name%type;
4529: l_forward_to_disp_name wf_users.display_name%type;

Line 4526: l_forward_from_disp_name wf_users.display_name%type;

4522: -- Local Variables
4523: l_creator_person_id per_people_f.person_id%type;
4524: l_forward_from_person_id per_people_f.person_id%type;
4525: l_forward_from_username wf_users.name%type;
4526: l_forward_from_disp_name wf_users.display_name%type;
4527: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;
4528: l_forward_to_username wf_users.name%type;
4529: l_forward_to_disp_name wf_users.display_name%type;
4530: l_proc varchar2(61) := g_package||'get_next_approver';

Line 4528: l_forward_to_username wf_users.name%type;

4524: l_forward_from_person_id per_people_f.person_id%type;
4525: l_forward_from_username wf_users.name%type;
4526: l_forward_from_disp_name wf_users.display_name%type;
4527: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;
4528: l_forward_to_username wf_users.name%type;
4529: l_forward_to_disp_name wf_users.display_name%type;
4530: l_proc varchar2(61) := g_package||'get_next_approver';
4531: l_current_forward_to_id per_people_f.person_id%type;
4532: l_current_forward_from_id per_people_f.person_id%type;

Line 4529: l_forward_to_disp_name wf_users.display_name%type;

4525: l_forward_from_username wf_users.name%type;
4526: l_forward_from_disp_name wf_users.display_name%type;
4527: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;
4528: l_forward_to_username wf_users.name%type;
4529: l_forward_to_disp_name wf_users.display_name%type;
4530: l_proc varchar2(61) := g_package||'get_next_approver';
4531: l_current_forward_to_id per_people_f.person_id%type;
4532: l_current_forward_from_id per_people_f.person_id%type;
4533: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';

Line 5191: prole wf_users.name%type;

5187: resultout in out nocopy varchar2)
5188: is
5189: msg varchar2(30);
5190: msgtype varchar2(8);
5191: prole wf_users.name%type;
5192: expand_role varchar2(1);
5193:
5194: colon pls_integer;
5195: avalue varchar2(240);