APPS.HR_WORKFLOW_SS dependencies on PER_ALL_PEOPLE_F

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

644: return number
645: is
646: c_item_type varchar2(50);
647: c_item_key number;
648: c_creator_person_id per_all_people_f.person_id%type default null;
649: c_final_appprover_id per_all_people_f.person_id%type default null;
650: c_forward_to_person_id per_all_people_f.person_id%type default null;
651: lv_response varchar2(3);
652:

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

645: is
646: c_item_type varchar2(50);
647: c_item_key number;
648: c_creator_person_id per_all_people_f.person_id%type default null;
649: c_final_appprover_id per_all_people_f.person_id%type default null;
650: c_forward_to_person_id per_all_people_f.person_id%type default null;
651: lv_response varchar2(3);
652:
653: begin

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

646: c_item_type varchar2(50);
647: c_item_key number;
648: c_creator_person_id per_all_people_f.person_id%type default null;
649: c_final_appprover_id per_all_people_f.person_id%type default null;
650: c_forward_to_person_id per_all_people_f.person_id%type default null;
651: lv_response varchar2(3);
652:
653: begin
654:

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

1671: return number
1672: is
1673: c_item_type varchar2(50);
1674: c_item_key number;
1675: c_creator_person_id per_all_people_f.person_id%type default null;
1676: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1677: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1678:
1679: begin

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

2055: l_current_disp_name := null;
2056: end;
2057:
2058: if(l_current_disp_name is null ) then
2059: -- cud still be null if person doesnot exist in per_all_people_f as of now.
2060: -- resort to the existing code of fetching from wf item attribute.
2061: l_current_disp_name := wf_engine.GetItemAttrText
2062: (itemtype => lv_item_type
2063: ,itemkey => lv_item_key

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

2100: as
2101: -- local variables
2102: lv_procedure_name varchar2(30) default 'getNextApproverForHist';
2103: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2104: ln_creator_person_id per_all_people_f.person_id%type default null;
2105: ln_currentApprover_person_id per_people_f.person_id%type;
2106: ln_nextApprover_person_id per_people_f.person_id%type;
2107: ln_nextApprover_userName wf_users.name%type;
2108: ln_nextApprover_dispName wf_users.display_name%type;