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 WF_USERS

Line 400: l_forward_from_username wf_users.name%type;

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;
404: l_forward_to_disp_name wf_users.display_name%type;

Line 401: l_forward_from_disp_name wf_users.display_name%type;

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;
404: l_forward_to_disp_name wf_users.display_name%type;
405: l_proc_name varchar2(61) := g_package||'get_next_approver';

Line 403: l_forward_to_username wf_users.name%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;
407: l_current_forward_from_id per_people_f.person_id%type;

Line 404: l_forward_to_disp_name wf_users.display_name%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;
407: l_current_forward_from_id per_people_f.person_id%type;
408:

Line 1911: l_creator_disp_name wf_users.display_name%type;

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;
1915: l_current_username wf_users.name%type;

Line 1912: l_creator_username wf_users.name%type;

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;
1915: l_current_username wf_users.name%type;
1916: lv_process_display_name wf_runnable_processes_v.display_name%type;

Line 1914: l_current_disp_name wf_users.display_name%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;
1918: lv_custom_callBack varchar2(60);

Line 1915: l_current_username wf_users.name%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;
1918: lv_custom_callBack varchar2(60);
1919: l_sqlbuf Varchar2(1000);

Line 2107: ln_nextApprover_userName wf_users.name%type;

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;
2111: ln_current_approver_index NUMBER ;

Line 2108: ln_nextApprover_dispName wf_users.display_name%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;
2111: ln_current_approver_index NUMBER ;
2112: ln_curr_def_appr_index NUMBER;