APPS.HR_WORKFLOW_SS dependencies on PER_ALL_PEOPLE_F

Line 682: c_creator_person_id per_all_people_f.person_id%type default null;

678: return number
679: is
680: c_item_type varchar2(50);
681: c_item_key number;
682: c_creator_person_id per_all_people_f.person_id%type default null;
683: c_final_appprover_id per_all_people_f.person_id%type default null;
684: c_forward_to_person_id per_all_people_f.person_id%type default null;
685: lv_response varchar2(3);
686:

Line 683: c_final_appprover_id per_all_people_f.person_id%type default null;

679: is
680: c_item_type varchar2(50);
681: c_item_key number;
682: c_creator_person_id per_all_people_f.person_id%type default null;
683: c_final_appprover_id per_all_people_f.person_id%type default null;
684: c_forward_to_person_id per_all_people_f.person_id%type default null;
685: lv_response varchar2(3);
686:
687: begin

Line 684: c_forward_to_person_id per_all_people_f.person_id%type default null;

680: c_item_type varchar2(50);
681: c_item_key number;
682: c_creator_person_id per_all_people_f.person_id%type default null;
683: c_final_appprover_id per_all_people_f.person_id%type default null;
684: c_forward_to_person_id per_all_people_f.person_id%type default null;
685: lv_response varchar2(3);
686:
687: begin
688:

Line 1717: c_creator_person_id per_all_people_f.person_id%type default null;

1713: return number
1714: is
1715: c_item_type varchar2(50);
1716: c_item_key number;
1717: c_creator_person_id per_all_people_f.person_id%type default null;
1718: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1719: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1720:
1721: begin

Line 2103: -- cud still be null if person doesnot exist in per_all_people_f as of now.

2099: l_current_disp_name := null;
2100: end;
2101:
2102: if(l_current_disp_name is null ) then
2103: -- cud still be null if person doesnot exist in per_all_people_f as of now.
2104: -- resort to the existing code of fetching from wf item attribute.
2105: l_current_disp_name := wf_engine.GetItemAttrText
2106: (itemtype => lv_item_type
2107: ,itemkey => lv_item_key

Line 2148: ln_creator_person_id per_all_people_f.person_id%type default null;

2144: as
2145: -- local variables
2146: lv_procedure_name varchar2(30) default 'getNextApproverForHist';
2147: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2148: ln_creator_person_id per_all_people_f.person_id%type default null;
2149: ln_currentApprover_person_id per_people_f.person_id%type;
2150: ln_nextApprover_person_id per_people_f.person_id%type;
2151: ln_nextApprover_userName wf_users.name%type;
2152: ln_nextApprover_dispName wf_users.display_name%type;