DBA Data[Home] [Help]

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 717: l_creator_person_id per_people_f.person_id%type;

713: p_approver_rec out nocopy ame_util.approverRecord2)
714: is
715: -- local variables
716: c_proc constant varchar2(30) := 'getNextCustomApprover';
717: l_creator_person_id per_people_f.person_id%type;
718: l_forward_to_person_id per_people_f.person_id%type;
719: l_current_forward_to_id per_people_f.person_id%type;
720: l_current_forward_from_id per_people_f.person_id%type;
721: ln_last_default_approver_id per_people_f.person_id%type;

Line 718: l_forward_to_person_id per_people_f.person_id%type;

714: is
715: -- local variables
716: c_proc constant varchar2(30) := 'getNextCustomApprover';
717: l_creator_person_id per_people_f.person_id%type;
718: l_forward_to_person_id per_people_f.person_id%type;
719: l_current_forward_to_id per_people_f.person_id%type;
720: l_current_forward_from_id per_people_f.person_id%type;
721: ln_last_default_approver_id per_people_f.person_id%type;
722: ln_addntl_approvers NUMBER DEFAULT 0;

Line 719: l_current_forward_to_id per_people_f.person_id%type;

715: -- local variables
716: c_proc constant varchar2(30) := 'getNextCustomApprover';
717: l_creator_person_id per_people_f.person_id%type;
718: l_forward_to_person_id per_people_f.person_id%type;
719: l_current_forward_to_id per_people_f.person_id%type;
720: l_current_forward_from_id per_people_f.person_id%type;
721: ln_last_default_approver_id per_people_f.person_id%type;
722: ln_addntl_approvers NUMBER DEFAULT 0;
723: ln_approval_level NUMBER DEFAULT 0;

Line 720: l_current_forward_from_id per_people_f.person_id%type;

716: c_proc constant varchar2(30) := 'getNextCustomApprover';
717: l_creator_person_id per_people_f.person_id%type;
718: l_forward_to_person_id per_people_f.person_id%type;
719: l_current_forward_to_id per_people_f.person_id%type;
720: l_current_forward_from_id per_people_f.person_id%type;
721: ln_last_default_approver_id per_people_f.person_id%type;
722: ln_addntl_approvers NUMBER DEFAULT 0;
723: ln_approval_level NUMBER DEFAULT 0;
724: ln_curr_def_appr_index NUMBER DEFAULT 1;

Line 721: ln_last_default_approver_id per_people_f.person_id%type;

717: l_creator_person_id per_people_f.person_id%type;
718: l_forward_to_person_id per_people_f.person_id%type;
719: l_current_forward_to_id per_people_f.person_id%type;
720: l_current_forward_from_id per_people_f.person_id%type;
721: ln_last_default_approver_id per_people_f.person_id%type;
722: ln_addntl_approvers NUMBER DEFAULT 0;
723: ln_approval_level NUMBER DEFAULT 0;
724: ln_curr_def_appr_index NUMBER DEFAULT 1;
725: ln_current_approver_index NUMBER ;

Line 3147: l_forward_to_person_id per_people_f.person_id%type;

3143: is
3144: -- local variables
3145: c_proc constant varchar2(30) := 'setNtfTransferCtx';
3146: -- Variables required for AME API
3147: l_forward_to_person_id per_people_f.person_id%type;
3148: c_application_id integer;
3149: c_transaction_id varchar2(25);
3150: c_transaction_type varchar2(25);
3151: c_next_approvers ame_util.approverstable2;

Line 3156: l_new_fwd_person_id per_people_f.person_id%type;

3152: c_approvalprocesscompleteynout ame_util.charType;
3153: l_current_forward_to_username wf_users.name%type;
3154: rec_forwardee ame_util.approverRecord2;
3155:
3156: l_new_fwd_person_id per_people_f.person_id%type;
3157: l_new_orig_system varchar2(30);
3158: l_new_fwd_display_name varchar2(360);
3159: l_is_parallel varchar2(10) := null;
3160: