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 3514: l_forward_from_username wf_users.name%type;

3510: -- local variables
3511: -- -------------------------------------------------------------------------
3512: l_creator_person_id per_people_f.person_id%type;
3513: l_forward_from_person_id per_people_f.person_id%type;
3514: l_forward_from_username wf_users.name%type;
3515: l_forward_from_disp_name wf_users.display_name%type;
3516: l_forward_to_person_id per_people_f.person_id%type;
3517: l_forward_to_username wf_users.name%type;
3518: l_forward_to_disp_name wf_users.display_name%type;

Line 3515: l_forward_from_disp_name wf_users.display_name%type;

3511: -- -------------------------------------------------------------------------
3512: l_creator_person_id per_people_f.person_id%type;
3513: l_forward_from_person_id per_people_f.person_id%type;
3514: l_forward_from_username wf_users.name%type;
3515: l_forward_from_disp_name wf_users.display_name%type;
3516: l_forward_to_person_id per_people_f.person_id%type;
3517: l_forward_to_username wf_users.name%type;
3518: l_forward_to_disp_name wf_users.display_name%type;
3519: l_proc varchar2(61) := gv_package||' get_next_approver';

Line 3517: l_forward_to_username wf_users.name%type;

3513: l_forward_from_person_id per_people_f.person_id%type;
3514: l_forward_from_username wf_users.name%type;
3515: l_forward_from_disp_name wf_users.display_name%type;
3516: l_forward_to_person_id per_people_f.person_id%type;
3517: l_forward_to_username wf_users.name%type;
3518: l_forward_to_disp_name wf_users.display_name%type;
3519: l_proc varchar2(61) := gv_package||' get_next_approver';
3520: l_current_forward_to_id per_people_f.person_id%type;
3521: l_current_forward_from_id per_people_f.person_id%type;

Line 3518: l_forward_to_disp_name wf_users.display_name%type;

3514: l_forward_from_username wf_users.name%type;
3515: l_forward_from_disp_name wf_users.display_name%type;
3516: l_forward_to_person_id per_people_f.person_id%type;
3517: l_forward_to_username wf_users.name%type;
3518: l_forward_to_disp_name wf_users.display_name%type;
3519: l_proc varchar2(61) := gv_package||' get_next_approver';
3520: l_current_forward_to_id per_people_f.person_id%type;
3521: l_current_forward_from_id per_people_f.person_id%type;
3522: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';

Line 3894: l_current_forward_to_username wf_users.name%type;

3890: c_transaction_type varchar2(25);
3891: --c_next_approver_rec ame_util.approverRecord;
3892:
3893: --
3894: l_current_forward_to_username wf_users.name%type;
3895: v_approvalprocesscompleteynout varchar2(5);
3896: v_next_approver_rec ame_util.approverstable2;
3897:
3898: BEGIN

Line 4440: l_forward_from_username wf_users.name%type;

4436:
4437: -- Local Variables
4438: l_creator_person_id per_people_f.person_id%type;
4439: l_forward_from_person_id per_people_f.person_id%type;
4440: l_forward_from_username wf_users.name%type;
4441: l_forward_from_disp_name wf_users.display_name%type;
4442: l_forward_to_person_id per_people_f.person_id%type;
4443: l_forward_to_username wf_users.name%type;
4444: l_forward_to_disp_name wf_users.display_name%type;

Line 4441: l_forward_from_disp_name wf_users.display_name%type;

4437: -- Local Variables
4438: l_creator_person_id per_people_f.person_id%type;
4439: l_forward_from_person_id per_people_f.person_id%type;
4440: l_forward_from_username wf_users.name%type;
4441: l_forward_from_disp_name wf_users.display_name%type;
4442: l_forward_to_person_id per_people_f.person_id%type;
4443: l_forward_to_username wf_users.name%type;
4444: l_forward_to_disp_name wf_users.display_name%type;
4445: l_proc varchar2(61) := gv_package||'get_next_approver';

Line 4443: l_forward_to_username wf_users.name%type;

4439: l_forward_from_person_id per_people_f.person_id%type;
4440: l_forward_from_username wf_users.name%type;
4441: l_forward_from_disp_name wf_users.display_name%type;
4442: l_forward_to_person_id per_people_f.person_id%type;
4443: l_forward_to_username wf_users.name%type;
4444: l_forward_to_disp_name wf_users.display_name%type;
4445: l_proc varchar2(61) := gv_package||'get_next_approver';
4446: l_current_forward_to_id per_people_f.person_id%type;
4447: l_current_forward_from_id per_people_f.person_id%type;

Line 4444: l_forward_to_disp_name wf_users.display_name%type;

4440: l_forward_from_username wf_users.name%type;
4441: l_forward_from_disp_name wf_users.display_name%type;
4442: l_forward_to_person_id per_people_f.person_id%type;
4443: l_forward_to_username wf_users.name%type;
4444: l_forward_to_disp_name wf_users.display_name%type;
4445: l_proc varchar2(61) := gv_package||'get_next_approver';
4446: l_current_forward_to_id per_people_f.person_id%type;
4447: l_current_forward_from_id per_people_f.person_id%type;
4448: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';

Line 4641: l_forward_from_username wf_users.name%type;

4637:
4638: -- Local Variables
4639: l_creator_person_id per_people_f.person_id%type;
4640: l_forward_from_person_id per_people_f.person_id%type;
4641: l_forward_from_username wf_users.name%type;
4642: l_forward_from_disp_name wf_users.display_name%type;
4643: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;
4644: l_forward_to_username wf_users.name%type;
4645: l_forward_to_disp_name wf_users.display_name%type;

Line 4642: l_forward_from_disp_name wf_users.display_name%type;

4638: -- Local Variables
4639: l_creator_person_id per_people_f.person_id%type;
4640: l_forward_from_person_id per_people_f.person_id%type;
4641: l_forward_from_username wf_users.name%type;
4642: l_forward_from_disp_name wf_users.display_name%type;
4643: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;
4644: l_forward_to_username wf_users.name%type;
4645: l_forward_to_disp_name wf_users.display_name%type;
4646: l_proc varchar2(61) := g_package||'get_next_approver';

Line 4644: l_forward_to_username wf_users.name%type;

4640: l_forward_from_person_id per_people_f.person_id%type;
4641: l_forward_from_username wf_users.name%type;
4642: l_forward_from_disp_name wf_users.display_name%type;
4643: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;
4644: l_forward_to_username wf_users.name%type;
4645: l_forward_to_disp_name wf_users.display_name%type;
4646: l_proc varchar2(61) := g_package||'get_next_approver';
4647: l_current_forward_to_id per_people_f.person_id%type;
4648: l_current_forward_from_id per_people_f.person_id%type;

Line 4645: l_forward_to_disp_name wf_users.display_name%type;

4641: l_forward_from_username wf_users.name%type;
4642: l_forward_from_disp_name wf_users.display_name%type;
4643: l_forward_to_person_id per_people_f.person_id%type DEFAULT NULL;
4644: l_forward_to_username wf_users.name%type;
4645: l_forward_to_disp_name wf_users.display_name%type;
4646: l_proc varchar2(61) := g_package||'get_next_approver';
4647: l_current_forward_to_id per_people_f.person_id%type;
4648: l_current_forward_from_id per_people_f.person_id%type;
4649: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';

Line 5307: prole wf_users.name%type;

5303: resultout in out nocopy varchar2)
5304: is
5305: msg varchar2(30);
5306: msgtype varchar2(8);
5307: prole wf_users.name%type;
5308: expand_role varchar2(1);
5309:
5310: colon pls_integer;
5311: avalue varchar2(240);