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 403: l_forward_from_username wf_users.name%type;

399: -- local variables
400: -- -------------------------------------------------------------------------
401: l_creator_person_id per_people_f.person_id%type;
402: l_forward_from_person_id per_people_f.person_id%type;
403: l_forward_from_username wf_users.name%type;
404: l_forward_from_disp_name wf_users.display_name%type;
405: l_forward_to_person_id per_people_f.person_id%type;
406: l_forward_to_username wf_users.name%type;
407: l_forward_to_disp_name wf_users.display_name%type;

Line 404: l_forward_from_disp_name wf_users.display_name%type;

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

Line 406: l_forward_to_username wf_users.name%type;

402: l_forward_from_person_id per_people_f.person_id%type;
403: l_forward_from_username wf_users.name%type;
404: l_forward_from_disp_name wf_users.display_name%type;
405: l_forward_to_person_id per_people_f.person_id%type;
406: l_forward_to_username wf_users.name%type;
407: l_forward_to_disp_name wf_users.display_name%type;
408: l_proc_name varchar2(61) := g_package||'get_next_approver';
409: l_current_forward_to_id per_people_f.person_id%type;
410: l_current_forward_from_id per_people_f.person_id%type;

Line 407: l_forward_to_disp_name wf_users.display_name%type;

403: l_forward_from_username wf_users.name%type;
404: l_forward_from_disp_name wf_users.display_name%type;
405: l_forward_to_person_id per_people_f.person_id%type;
406: l_forward_to_username wf_users.name%type;
407: l_forward_to_disp_name wf_users.display_name%type;
408: l_proc_name varchar2(61) := g_package||'get_next_approver';
409: l_current_forward_to_id per_people_f.person_id%type;
410: l_current_forward_from_id per_people_f.person_id%type;
411:

Line 597: l_current_forward_to_username wf_users.name%type;

593: c_transaction_id varchar2(25);
594: c_transaction_type varchar2(25);
595: c_next_approver_rec ame_util.approverRecord;
596:
597: l_current_forward_to_username wf_users.name%type;
598:
599: begin
600:
601: --

Line 1953: l_creator_disp_name wf_users.display_name%type;

1949: c_proc varchar2(30) default 'getApprovalMsgSubject';
1950: lv_item_type wf_item_activity_statuses.item_type%type;
1951: lv_item_key wf_item_activity_statuses.item_key%type;
1952: l_creator_person_id per_people_f.person_id%type;
1953: l_creator_disp_name wf_users.display_name%type;
1954: l_creator_username wf_users.name%type;
1955: l_current_person_id per_people_f.person_id%type;
1956: l_current_disp_name wf_users.display_name%type;
1957: l_current_username wf_users.name%type;

Line 1954: l_creator_username wf_users.name%type;

1950: lv_item_type wf_item_activity_statuses.item_type%type;
1951: lv_item_key wf_item_activity_statuses.item_key%type;
1952: l_creator_person_id per_people_f.person_id%type;
1953: l_creator_disp_name wf_users.display_name%type;
1954: l_creator_username wf_users.name%type;
1955: l_current_person_id per_people_f.person_id%type;
1956: l_current_disp_name wf_users.display_name%type;
1957: l_current_username wf_users.name%type;
1958: lv_process_display_name wf_runnable_processes_v.display_name%type;

Line 1956: l_current_disp_name wf_users.display_name%type;

1952: l_creator_person_id per_people_f.person_id%type;
1953: l_creator_disp_name wf_users.display_name%type;
1954: l_creator_username wf_users.name%type;
1955: l_current_person_id per_people_f.person_id%type;
1956: l_current_disp_name wf_users.display_name%type;
1957: l_current_username wf_users.name%type;
1958: lv_process_display_name wf_runnable_processes_v.display_name%type;
1959: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
1960: lv_custom_callBack varchar2(60);

Line 1957: l_current_username wf_users.name%type;

1953: l_creator_disp_name wf_users.display_name%type;
1954: l_creator_username wf_users.name%type;
1955: l_current_person_id per_people_f.person_id%type;
1956: l_current_disp_name wf_users.display_name%type;
1957: l_current_username wf_users.name%type;
1958: lv_process_display_name wf_runnable_processes_v.display_name%type;
1959: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
1960: lv_custom_callBack varchar2(60);
1961: l_sqlbuf Varchar2(1000);

Line 2151: ln_nextApprover_userName wf_users.name%type;

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;
2153: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
2154: ln_last_default_approver_id per_people_f.person_id%type;
2155: ln_current_approver_index NUMBER ;

Line 2152: ln_nextApprover_dispName wf_users.display_name%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;
2153: lv_last_approver_def VARCHAR2(10) DEFAULT 'Y';
2154: ln_last_default_approver_id per_people_f.person_id%type;
2155: ln_current_approver_index NUMBER ;
2156: ln_curr_def_appr_index NUMBER;

Line 2546: l_creator_disp_name wf_users.display_name%type;

2542: ,actid in number
2543: ,funcmode in varchar2
2544: ,resultout out nocopy varchar2)
2545: IS
2546: l_creator_disp_name wf_users.display_name%type;
2547: l_details varchar2(30) := null;
2548: BEGIN
2549:
2550: if getOrganizationManagersubject(itemtype,itemkey) is not null then