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

Line 398: l_creator_person_id per_people_f.person_id%type;

394: as
395: -- -------------------------------------------------------------------------
396: -- local variables
397: -- -------------------------------------------------------------------------
398: l_creator_person_id per_people_f.person_id%type;
399: l_forward_from_person_id per_people_f.person_id%type;
400: l_forward_from_username wf_users.name%type;
401: l_forward_from_disp_name wf_users.display_name%type;
402: l_forward_to_person_id per_people_f.person_id%type;

Line 399: l_forward_from_person_id per_people_f.person_id%type;

395: -- -------------------------------------------------------------------------
396: -- local variables
397: -- -------------------------------------------------------------------------
398: l_creator_person_id per_people_f.person_id%type;
399: l_forward_from_person_id per_people_f.person_id%type;
400: l_forward_from_username wf_users.name%type;
401: l_forward_from_disp_name wf_users.display_name%type;
402: l_forward_to_person_id per_people_f.person_id%type;
403: l_forward_to_username wf_users.name%type;

Line 402: l_forward_to_person_id per_people_f.person_id%type;

398: l_creator_person_id per_people_f.person_id%type;
399: l_forward_from_person_id per_people_f.person_id%type;
400: l_forward_from_username wf_users.name%type;
401: l_forward_from_disp_name wf_users.display_name%type;
402: l_forward_to_person_id per_people_f.person_id%type;
403: l_forward_to_username wf_users.name%type;
404: l_forward_to_disp_name wf_users.display_name%type;
405: l_proc_name varchar2(61) := g_package||'get_next_approver';
406: l_current_forward_to_id per_people_f.person_id%type;

Line 406: l_current_forward_to_id per_people_f.person_id%type;

402: l_forward_to_person_id per_people_f.person_id%type;
403: l_forward_to_username wf_users.name%type;
404: l_forward_to_disp_name wf_users.display_name%type;
405: l_proc_name varchar2(61) := g_package||'get_next_approver';
406: l_current_forward_to_id per_people_f.person_id%type;
407: l_current_forward_from_id per_people_f.person_id%type;
408:
409: -- Variables required for AME API
410: c_application_id integer;

Line 407: l_current_forward_from_id per_people_f.person_id%type;

403: l_forward_to_username wf_users.name%type;
404: l_forward_to_disp_name wf_users.display_name%type;
405: l_proc_name varchar2(61) := g_package||'get_next_approver';
406: l_current_forward_to_id per_people_f.person_id%type;
407: l_current_forward_from_id per_people_f.person_id%type;
408:
409: -- Variables required for AME API
410: c_application_id integer;
411: c_transaction_id varchar2(25);

Line 575: l_forward_to_person_id per_people_f.person_id%type;

571: funmode in varchar2,
572: result out nocopy varchar2 )
573: as
574:
575: l_forward_to_person_id per_people_f.person_id%type;
576:
577: -- Variables required for AME API
578: c_application_id integer;
579: c_transaction_id varchar2(25);

Line 1910: l_creator_person_id per_people_f.person_id%type;

1906: is
1907: c_proc varchar2(30) default 'getApprovalMsgSubject';
1908: lv_item_type wf_item_activity_statuses.item_type%type;
1909: lv_item_key wf_item_activity_statuses.item_key%type;
1910: l_creator_person_id per_people_f.person_id%type;
1911: l_creator_disp_name wf_users.display_name%type;
1912: l_creator_username wf_users.name%type;
1913: l_current_person_id per_people_f.person_id%type;
1914: l_current_disp_name wf_users.display_name%type;

Line 1913: l_current_person_id per_people_f.person_id%type;

1909: lv_item_key wf_item_activity_statuses.item_key%type;
1910: l_creator_person_id per_people_f.person_id%type;
1911: l_creator_disp_name wf_users.display_name%type;
1912: l_creator_username wf_users.name%type;
1913: l_current_person_id per_people_f.person_id%type;
1914: l_current_disp_name wf_users.display_name%type;
1915: l_current_username wf_users.name%type;
1916: lv_process_display_name wf_runnable_processes_v.display_name%type;
1917: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;

Line 2105: ln_currentApprover_person_id per_people_f.person_id%type;

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;
2109: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';

Line 2106: ln_nextApprover_person_id per_people_f.person_id%type;

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;
2109: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
2110: ln_last_default_approver_id per_people_f.person_id%type;

Line 2110: ln_last_default_approver_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;
2109: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
2110: ln_last_default_approver_id per_people_f.person_id%type;
2111: ln_current_approver_index NUMBER ;
2112: ln_curr_def_appr_index NUMBER;
2113: ln_addntl_approvers NUMBER;
2114: lv_exists VARCHAR2(10);