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_APPROVAL_SS dependencies on PER_PEOPLE_F

Line 406: l_current_forward_to_id per_people_f.person_id%type;

402: p_item_key in varchar2)
403: is
404: -- local variables
405: c_proc constant varchar2(30) := 'storeApproverDetails';
406: l_current_forward_to_id per_people_f.person_id%type;
407: l_current_forward_to_origSys wf_users.orig_system%type;
408: l_current_forward_to_username wf_users.name%type;
409: l_current_forward_to_disp_name wf_users.display_name%type;
410:

Line 608: l_creator_person_id per_people_f.person_id%type;

604: p_approver_rec out nocopy ame_util.approverRecord2)
605: is
606: -- local variables
607: c_proc constant varchar2(30) := 'getNextCustomApprover';
608: l_creator_person_id per_people_f.person_id%type;
609: l_forward_to_person_id per_people_f.person_id%type;
610: l_current_forward_to_id per_people_f.person_id%type;
611: l_current_forward_from_id per_people_f.person_id%type;
612: ln_last_default_approver_id per_people_f.person_id%type;

Line 609: l_forward_to_person_id per_people_f.person_id%type;

605: is
606: -- local variables
607: c_proc constant varchar2(30) := 'getNextCustomApprover';
608: l_creator_person_id per_people_f.person_id%type;
609: l_forward_to_person_id per_people_f.person_id%type;
610: l_current_forward_to_id per_people_f.person_id%type;
611: l_current_forward_from_id per_people_f.person_id%type;
612: ln_last_default_approver_id per_people_f.person_id%type;
613: ln_addntl_approvers NUMBER DEFAULT 0;

Line 610: l_current_forward_to_id per_people_f.person_id%type;

606: -- local variables
607: c_proc constant varchar2(30) := 'getNextCustomApprover';
608: l_creator_person_id per_people_f.person_id%type;
609: l_forward_to_person_id per_people_f.person_id%type;
610: l_current_forward_to_id per_people_f.person_id%type;
611: l_current_forward_from_id per_people_f.person_id%type;
612: ln_last_default_approver_id per_people_f.person_id%type;
613: ln_addntl_approvers NUMBER DEFAULT 0;
614: ln_approval_level NUMBER DEFAULT 0;

Line 611: l_current_forward_from_id per_people_f.person_id%type;

607: c_proc constant varchar2(30) := 'getNextCustomApprover';
608: l_creator_person_id per_people_f.person_id%type;
609: l_forward_to_person_id per_people_f.person_id%type;
610: l_current_forward_to_id per_people_f.person_id%type;
611: l_current_forward_from_id per_people_f.person_id%type;
612: ln_last_default_approver_id per_people_f.person_id%type;
613: ln_addntl_approvers NUMBER DEFAULT 0;
614: ln_approval_level NUMBER DEFAULT 0;
615: ln_curr_def_appr_index NUMBER DEFAULT 1;

Line 612: ln_last_default_approver_id per_people_f.person_id%type;

608: l_creator_person_id per_people_f.person_id%type;
609: l_forward_to_person_id per_people_f.person_id%type;
610: l_current_forward_to_id per_people_f.person_id%type;
611: l_current_forward_from_id per_people_f.person_id%type;
612: ln_last_default_approver_id per_people_f.person_id%type;
613: ln_addntl_approvers NUMBER DEFAULT 0;
614: ln_approval_level NUMBER DEFAULT 0;
615: ln_curr_def_appr_index NUMBER DEFAULT 1;
616: ln_current_approver_index NUMBER ;

Line 2333: l_forward_to_person_id per_people_f.person_id%type;

2329: is
2330: -- local variables
2331: c_proc constant varchar2(30) := 'setNtfTransferCtx';
2332: -- Variables required for AME API
2333: l_forward_to_person_id per_people_f.person_id%type;
2334: c_application_id integer;
2335: c_transaction_id varchar2(25);
2336: c_transaction_type varchar2(25);
2337: c_next_approvers ame_util.approverstable2;

Line 2342: l_new_fwd_person_id per_people_f.person_id%type;

2338: c_approvalprocesscompleteynout ame_util.charType;
2339: l_current_forward_to_username wf_users.name%type;
2340: rec_forwardee ame_util.approverRecord2;
2341:
2342: l_new_fwd_person_id per_people_f.person_id%type;
2343: l_new_orig_system varchar2(30);
2344: l_new_fwd_display_name varchar2(360);
2345:
2346: cursor get_person_info is