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_APPROVAL_SS dependencies on WF_USERS

Line 196: l_current_forward_to_username wf_users.name%type;

192: c_transaction_id varchar2(25);
193: c_transaction_type varchar2(25);
194: c_next_approvers ame_util.approverstable2;
195: c_approvalprocesscompleteynout ame_util.charType;
196: l_current_forward_to_username wf_users.name%type;
197: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
198: lv_result_display varchar2(250);
199: lv_test_result_code varchar2(250);
200: lv_comments wf_item_attribute_values.text_value%type;

Line 407: l_current_forward_to_origSys wf_users.orig_system%type;

403: is
404: -- local variables
405: c_proc constant varchar2(30) := 'storeApproverDetails';
406: l_current_forward_to_id per_people_f.person_id%type;
407: l_current_forward_to_origSys wf_users.orig_system%type;
408: l_current_forward_to_username wf_users.name%type;
409: l_current_forward_to_disp_name wf_users.display_name%type;
410:
411: begin

Line 408: l_current_forward_to_username wf_users.name%type;

404: -- local variables
405: c_proc constant varchar2(30) := 'storeApproverDetails';
406: l_current_forward_to_id per_people_f.person_id%type;
407: l_current_forward_to_origSys wf_users.orig_system%type;
408: l_current_forward_to_username wf_users.name%type;
409: l_current_forward_to_disp_name wf_users.display_name%type;
410:
411: begin
412: g_debug := hr_utility.debug_enabled;

Line 409: l_current_forward_to_disp_name wf_users.display_name%type;

405: c_proc constant varchar2(30) := 'storeApproverDetails';
406: l_current_forward_to_id per_people_f.person_id%type;
407: l_current_forward_to_origSys wf_users.orig_system%type;
408: l_current_forward_to_username wf_users.name%type;
409: l_current_forward_to_disp_name wf_users.display_name%type;
410:
411: begin
412: g_debug := hr_utility.debug_enabled;
413: if g_debug then

Line 1581: l_current_forward_to_username wf_users.name%type;

1577: c_transaction_id varchar2(25);
1578: c_transaction_type varchar2(25);
1579: c_next_approvers ame_util.approverstable2;
1580: c_approvalprocesscompleteynout ame_util.charType;
1581: l_current_forward_to_username wf_users.name%type;
1582:
1583: begin
1584: g_debug := hr_utility.debug_enabled;
1585:

Line 1670: l_current_forward_to_username wf_users.name%type;

1666: c_transaction_id varchar2(25);
1667: c_transaction_type varchar2(25);
1668: c_next_approvers ame_util.approverstable2;
1669: c_approvalprocesscompleteynout ame_util.charType;
1670: l_current_forward_to_username wf_users.name%type;
1671:
1672: begin
1673:
1674: g_debug := hr_utility.debug_enabled;

Line 1832: l_current_forward_to_username wf_users.name%type;

1828: -- Variables required for AME API
1829: c_application_id integer;
1830: c_transaction_id varchar2(25);
1831: c_transaction_type varchar2(25);
1832: l_current_forward_to_username wf_users.name%type;
1833: l_curr_fwd_to_orig_system_id number;
1834:
1835: begin
1836: g_debug := hr_utility.debug_enabled;

Line 1932: l_current_forward_to_username wf_users.name%type;

1928: c_transaction_id varchar2(25);
1929: c_transaction_type varchar2(25);
1930: c_next_approvers ame_util.approverstable2;
1931: c_approvalprocesscompleteynout ame_util.charType;
1932: l_current_forward_to_username wf_users.name%type;
1933:
1934: begin
1935: g_debug := hr_utility.debug_enabled;
1936:

Line 2104: l_current_forward_to_username wf_users.name%type;

2100: c_transaction_id varchar2(25);
2101: c_transaction_type varchar2(25);
2102: c_next_approvers ame_util.approverstable2;
2103: c_approvalprocesscompleteynout ame_util.charType;
2104: l_current_forward_to_username wf_users.name%type;
2105: lv_transaction_status varchar2(100);
2106: lv_approval_required varchar2(100);
2107: lv_result varchar2(100);
2108: lv_comments wf_item_attribute_values.text_value%type;

Line 2215: l_current_forward_to_username wf_users.name%type;

2211: c_transaction_id varchar2(25);
2212: c_transaction_type varchar2(25);
2213: c_next_approvers ame_util.approverstable2;
2214: c_approvalprocesscompleteynout ame_util.charType;
2215: l_current_forward_to_username wf_users.name%type;
2216: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2217: lv_result_display varchar2(250);
2218:
2219: begin

Line 2264: l_current_forward_to_username wf_users.name%type;

2260: c_transaction_id varchar2(25);
2261: c_transaction_type varchar2(25);
2262: c_next_approvers ame_util.approverstable2;
2263: c_approvalprocesscompleteynout ame_util.charType;
2264: l_current_forward_to_username wf_users.name%type;
2265: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2266: lv_result_display varchar2(250);
2267:
2268: begin

Line 2339: l_current_forward_to_username wf_users.name%type;

2335: c_transaction_id varchar2(25);
2336: c_transaction_type varchar2(25);
2337: c_next_approvers ame_util.approverstable2;
2338: c_approvalprocesscompleteynout ame_util.charType;
2339: l_current_forward_to_username wf_users.name%type;
2340: rec_forwardee ame_util.approverRecord2;
2341:
2342: l_new_fwd_person_id per_people_f.person_id%type;
2343: l_new_orig_system varchar2(30);

Line 2492: l_current_forward_to_username wf_users.name%type;

2488: c_transaction_id varchar2(25);
2489: c_transaction_type varchar2(25);
2490: c_next_approvers ame_util.approverstable2;
2491: c_approvalprocesscompleteynout ame_util.charType;
2492: l_current_forward_to_username wf_users.name%type;
2493: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2494: lv_result_display varchar2(250);
2495: lv_test_result_code varchar2(250);
2496: lv_comments wf_item_attribute_values.text_value%type;

Line 2553: c_creator_user wf_users.name%Type;

2549: c_transaction_type varchar2(25);
2550: c_all_approvers ame_util.approverstable2;--ame_util.approversTable;
2551: c_approvalprocesscompleteynout ame_util.charType;
2552:
2553: c_creator_user wf_users.name%Type;
2554: c_return_user wf_users.name%Type;
2555: c_match_found varchar2(1);
2556: c_rfc_initiator varchar2(1);
2557:

Line 2554: c_return_user wf_users.name%Type;

2550: c_all_approvers ame_util.approverstable2;--ame_util.approversTable;
2551: c_approvalprocesscompleteynout ame_util.charType;
2552:
2553: c_creator_user wf_users.name%Type;
2554: c_return_user wf_users.name%Type;
2555: c_match_found varchar2(1);
2556: c_rfc_initiator varchar2(1);
2557:
2558: l_proc constant varchar2(100) := g_package || ' reset_ame_to_rfc_state';

Line 2656: c_return_user wf_users.name%Type;

2652: p_item_key in varchar2) is
2653:
2654: -- local variables
2655: c_proc constant varchar2(60) := 'reset_approval_rfc_data';
2656: c_return_user wf_users.name%Type;
2657: c_creator_user wf_users.name%Type;
2658: l_approvalProcessVersion varchar2(10);
2659: l_curr_approver_role wf_roles.name%type;
2660: c_return_user_role_info_tbl wf_directory.wf_local_roles_tbl_type;

Line 2657: c_creator_user wf_users.name%Type;

2653:
2654: -- local variables
2655: c_proc constant varchar2(60) := 'reset_approval_rfc_data';
2656: c_return_user wf_users.name%Type;
2657: c_creator_user wf_users.name%Type;
2658: l_approvalProcessVersion varchar2(10);
2659: l_curr_approver_role wf_roles.name%type;
2660: c_return_user_role_info_tbl wf_directory.wf_local_roles_tbl_type;
2661: l_curr_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;

Line 2845: l_current_forward_to_username wf_users.name%type;

2841: c_transaction_id varchar2(25);
2842: c_transaction_type varchar2(25);
2843: c_next_approvers ame_util.approverstable2;
2844: c_approvalprocesscompleteynout ame_util.charType;
2845: l_current_forward_to_username wf_users.name%type;
2846: lv_creatorUserName wf_roles.name%type;
2847: lv_rfcUserName wf_roles.name%type;
2848: lv_customRFC varchar2(5);
2849:

Line 2997: lv_role_displayName wf_users.display_name%type;

2993: p_orig_system_id in number)
2994: return varchar2 is
2995: -- local variables
2996: c_proc constant varchar2(30) := 'processRFC';
2997: lv_role_displayName wf_users.display_name%type;
2998: lv_roleName wf_users.name%type;
2999: begin
3000: g_debug := hr_utility.debug_enabled;
3001: if g_debug then

Line 2998: lv_roleName wf_users.name%type;

2994: return varchar2 is
2995: -- local variables
2996: c_proc constant varchar2(30) := 'processRFC';
2997: lv_role_displayName wf_users.display_name%type;
2998: lv_roleName wf_users.name%type;
2999: begin
3000: g_debug := hr_utility.debug_enabled;
3001: if g_debug then
3002: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 3030: lv_role_displayName wf_users.display_name%type;

3026: p_orig_system_id in number)
3027: return varchar2 is
3028: -- local variables
3029: c_proc constant varchar2(30) := 'isApproverEditAllowed';
3030: lv_role_displayName wf_users.display_name%type;
3031: lv_roleName wf_users.name%type;
3032: lv_businessGroupId per_all_people_f.business_group_id%type;
3033: lv_orig_systemId wf_roles.orig_system_id%type;
3034: lv_orig_system wf_roles.orig_system%type;

Line 3031: lv_roleName wf_users.name%type;

3027: return varchar2 is
3028: -- local variables
3029: c_proc constant varchar2(30) := 'isApproverEditAllowed';
3030: lv_role_displayName wf_users.display_name%type;
3031: lv_roleName wf_users.name%type;
3032: lv_businessGroupId per_all_people_f.business_group_id%type;
3033: lv_orig_systemId wf_roles.orig_system_id%type;
3034: lv_orig_system wf_roles.orig_system%type;
3035: lv_creator_person_id hr_api_transactions.creator_person_id%type;

Line 3900: l_username wf_users.name%type;

3896: --
3897: l_item_type_attribute_name varchar2(30);
3898: type l_suffix_tab is table of varchar2(30) index by binary_integer;
3899: l_suffix l_suffix_tab;
3900: l_username wf_users.name%type;
3901: l_display_name wf_users.display_name%type;
3902: --
3903: begin
3904: if p_service_orig_sys_id is not null then

Line 3901: l_display_name wf_users.display_name%type;

3897: l_item_type_attribute_name varchar2(30);
3898: type l_suffix_tab is table of varchar2(30) index by binary_integer;
3899: l_suffix l_suffix_tab;
3900: l_username wf_users.name%type;
3901: l_display_name wf_users.display_name%type;
3902: --
3903: begin
3904: if p_service_orig_sys_id is not null then
3905: l_suffix(1) := 'ID';

Line 4839: l_creator_disp_name wf_users.display_name%type;

4835: p_item_key in wf_items.item_key%type,
4836: error_message_text in varchar2)
4837: is
4838:
4839: l_creator_disp_name wf_users.display_name%type;
4840: l_aprv_routing_username varchar2(60);
4841: lv_process_display_name wf_runnable_processes_v.display_name%type;
4842: c_application_id integer;
4843: c_transaction_id varchar2(25);

Line 4845: l_forward_from_display_name wf_users.display_name%type;

4841: lv_process_display_name wf_runnable_processes_v.display_name%type;
4842: c_application_id integer;
4843: c_transaction_id varchar2(25);
4844: c_transaction_type varchar2(25);
4845: l_forward_from_display_name wf_users.display_name%type;
4846: l_forward_to_display_name wf_users.display_name%type;
4847: c_approver_to_notify_rec ame_util.approverRecord2;
4848: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
4849:

Line 4846: l_forward_to_display_name wf_users.display_name%type;

4842: c_application_id integer;
4843: c_transaction_id varchar2(25);
4844: c_transaction_type varchar2(25);
4845: l_forward_from_display_name wf_users.display_name%type;
4846: l_forward_to_display_name wf_users.display_name%type;
4847: c_approver_to_notify_rec ame_util.approverRecord2;
4848: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
4849:
4850: