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.PO_AME_WF_PVT dependencies on WF_USERS

Line 233: l_next_approver_disp_name WF_USERS.DISPLAY_NAME%TYPE;

229: l_document_type PO_DOCUMENT_TYPES.DOCUMENT_TYPE_CODE%TYPE;
230: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
231: l_next_approver_id NUMBER;
232: l_next_approver_user_name FND_USER.USER_NAME%TYPE;
233: l_next_approver_disp_name WF_USERS.DISPLAY_NAME%TYPE;
234: l_orig_system WF_USERS.ORIG_SYSTEM%TYPE := ame_util.perOrigSystem;
235: l_sequence_num NUMBER;
236: l_approver_type VARCHAR2(30);
237: l_doc_string VARCHAR2(200);

Line 234: l_orig_system WF_USERS.ORIG_SYSTEM%TYPE := ame_util.perOrigSystem;

230: l_document_subtype PO_DOCUMENT_TYPES.DOCUMENT_SUBTYPE%TYPE;
231: l_next_approver_id NUMBER;
232: l_next_approver_user_name FND_USER.USER_NAME%TYPE;
233: l_next_approver_disp_name WF_USERS.DISPLAY_NAME%TYPE;
234: l_orig_system WF_USERS.ORIG_SYSTEM%TYPE := ame_util.perOrigSystem;
235: l_sequence_num NUMBER;
236: l_approver_type VARCHAR2(30);
237: l_doc_string VARCHAR2(200);
238: l_preparer_user_name FND_USER.USER_NAME%TYPE;

Line 537: wf_users wu

533: INTO l_next_approver_id, l_next_approver_name
534: FROM ( SELECT person.person_id, person.full_name
535: FROM per_all_people_f person,
536: per_all_assignments_f asg,
537: wf_users wu
538: WHERE asg.position_id = g_next_approvers(l_approver_index).orig_system_id
539: AND wu.orig_system = ame_util.perorigsystem
540: AND wu.orig_system_id = person.person_id
541: AND TRUNC(SYSDATE) BETWEEN person.effective_start_date AND NVL(person.effective_end_date, TRUNC( SYSDATE))

Line 862: wf_users wu

858: INTO l_next_approver_id, l_next_approver_name
859: FROM ( SELECT person.person_id , person.full_name
860: FROM per_all_people_f person ,
861: per_all_assignments_f asg,
862: wf_users wu
863: WHERE asg.position_id = g_next_approvers (l_approver_index).orig_system_id
864: AND wu.orig_system = ame_util.perorigsystem
865: AND wu.orig_system_id = person.person_id
866: AND TRUNC (sysdate) BETWEEN person.effective_start_date AND NVL (person.effective_end_date ,TRUNC (sysdate))

Line 1391: l_child_approver_user_name wf_users.name%TYPE;

1387: l_progress VARCHAR2(3) := '000';
1388: l_parent_item_type wf_items.parent_item_type%TYPE;
1389: l_parent_item_key wf_items.parent_item_key%TYPE;
1390: l_child_approver_empid NUMBER;
1391: l_child_approver_user_name wf_users.name%TYPE;
1392: l_child_approver_display_name wf_users.display_name%TYPE;
1393: l_api_name VARCHAR2(500) := 'process_response_exception';
1394: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
1395: BEGIN

Line 1392: l_child_approver_display_name wf_users.display_name%TYPE;

1388: l_parent_item_type wf_items.parent_item_type%TYPE;
1389: l_parent_item_key wf_items.parent_item_key%TYPE;
1390: l_child_approver_empid NUMBER;
1391: l_child_approver_user_name wf_users.name%TYPE;
1392: l_child_approver_display_name wf_users.display_name%TYPE;
1393: l_api_name VARCHAR2(500) := 'process_response_exception';
1394: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
1395: BEGIN
1396:

Line 2134: l_child_approver_user_name wf_users.name%TYPE;

2130: l_progress VARCHAR2(3) := '000';
2131: l_parent_item_type wf_items.parent_item_type%TYPE;
2132: l_parent_item_key wf_items.parent_item_key%TYPE;
2133: l_child_approver_empid NUMBER;
2134: l_child_approver_user_name wf_users.name%TYPE;
2135: l_child_approver_display_name wf_users.display_name%TYPE;
2136: l_api_name VARCHAR2(500) := 'process_response_app_forward';
2137: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2138:

Line 2135: l_child_approver_display_name wf_users.display_name%TYPE;

2131: l_parent_item_type wf_items.parent_item_type%TYPE;
2132: l_parent_item_key wf_items.parent_item_key%TYPE;
2133: l_child_approver_empid NUMBER;
2134: l_child_approver_user_name wf_users.name%TYPE;
2135: l_child_approver_display_name wf_users.display_name%TYPE;
2136: l_api_name VARCHAR2(500) := 'process_response_app_forward';
2137: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2138:
2139: BEGIN

Line 2232: l_child_approver_user_name wf_users.name%TYPE;

2228: l_progress VARCHAR2(3) := '000';
2229: l_parent_item_type wf_items.parent_item_type%TYPE;
2230: l_parent_item_key wf_items.parent_item_key%TYPE;
2231: l_child_approver_empid NUMBER;
2232: l_child_approver_user_name wf_users.name%TYPE;
2233: l_child_approver_display_name wf_users.display_name%TYPE;
2234: l_api_name VARCHAR2(500) := 'process_response_approve';
2235: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2236:

Line 2233: l_child_approver_display_name wf_users.display_name%TYPE;

2229: l_parent_item_type wf_items.parent_item_type%TYPE;
2230: l_parent_item_key wf_items.parent_item_key%TYPE;
2231: l_child_approver_empid NUMBER;
2232: l_child_approver_user_name wf_users.name%TYPE;
2233: l_child_approver_display_name wf_users.display_name%TYPE;
2234: l_api_name VARCHAR2(500) := 'process_response_approve';
2235: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2236:
2237: BEGIN

Line 2327: l_child_approver_user_name wf_users.name%TYPE;

2323: l_progress VARCHAR2(3) := '000';
2324: l_parent_item_type wf_items.parent_item_type%TYPE;
2325: l_parent_item_key wf_items.parent_item_key%TYPE;
2326: l_child_approver_empid NUMBER;
2327: l_child_approver_user_name wf_users.name%TYPE;
2328: l_child_approver_display_name wf_users.display_name%TYPE;
2329: l_api_name VARCHAR2(500) := 'process_response_reject';
2330: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2331:

Line 2328: l_child_approver_display_name wf_users.display_name%TYPE;

2324: l_parent_item_type wf_items.parent_item_type%TYPE;
2325: l_parent_item_key wf_items.parent_item_key%TYPE;
2326: l_child_approver_empid NUMBER;
2327: l_child_approver_user_name wf_users.name%TYPE;
2328: l_child_approver_display_name wf_users.display_name%TYPE;
2329: l_api_name VARCHAR2(500) := 'process_response_reject';
2330: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2331:
2332: BEGIN

Line 2424: l_child_approver_user_name wf_users.name%TYPE;

2420: l_progress VARCHAR2(3) := '000';
2421: l_parent_item_type wf_items.parent_item_type%TYPE;
2422: l_parent_item_key wf_items.parent_item_key%TYPE;
2423: l_child_approver_empid NUMBER;
2424: l_child_approver_user_name wf_users.name%TYPE;
2425: l_child_approver_display_name wf_users.display_name%TYPE;
2426: l_api_name VARCHAR2(500) := 'process_response_forward';
2427: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2428: BEGIN

Line 2425: l_child_approver_display_name wf_users.display_name%TYPE;

2421: l_parent_item_type wf_items.parent_item_type%TYPE;
2422: l_parent_item_key wf_items.parent_item_key%TYPE;
2423: l_child_approver_empid NUMBER;
2424: l_child_approver_user_name wf_users.name%TYPE;
2425: l_child_approver_display_name wf_users.display_name%TYPE;
2426: l_api_name VARCHAR2(500) := 'process_response_forward';
2427: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2428: BEGIN
2429:

Line 2518: l_child_approver_user_name wf_users.name%TYPE;

2514: l_progress VARCHAR2(3) := '000';
2515: l_parent_item_type wf_items.parent_item_type%TYPE;
2516: l_parent_item_key wf_items.parent_item_key%TYPE;
2517: l_child_approver_empid NUMBER;
2518: l_child_approver_user_name wf_users.name%TYPE;
2519: l_child_approver_display_name wf_users.display_name%TYPE;
2520: l_api_name VARCHAR2(500) := 'process_response_timeout';
2521: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2522:

Line 2519: l_child_approver_display_name wf_users.display_name%TYPE;

2515: l_parent_item_type wf_items.parent_item_type%TYPE;
2516: l_parent_item_key wf_items.parent_item_key%TYPE;
2517: l_child_approver_empid NUMBER;
2518: l_child_approver_user_name wf_users.name%TYPE;
2519: l_child_approver_display_name wf_users.display_name%TYPE;
2520: l_api_name VARCHAR2(500) := 'process_response_timeout';
2521: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2522:
2523: BEGIN

Line 3863: wf_users wu

3859: INTO l_person_id
3860: FROM ( SELECT person.person_id
3861: FROM per_all_people_f person,
3862: per_all_assignments_f asg,
3863: wf_users wu
3864: WHERE asg.position_id = l_orig_system_id
3865: AND wu.orig_system = ame_util.perorigsystem
3866: AND wu.orig_system_id = person.person_id
3867: AND TRUNC(SYSDATE) BETWEEN person.effective_start_date AND NVL(person.effective_end_date, TRUNC( SYSDATE) )

Line 5340: wf_users wu

5336: INTO l_next_approver_id, l_next_approver_name
5337: FROM ( SELECT person.person_id , person.full_name
5338: FROM per_all_people_f person ,
5339: per_all_assignments_f asg ,
5340: wf_users wu
5341: WHERE asg.position_id = ApproverList(l_approver_index).orig_system_id
5342: AND wu.orig_system = ame_util.perorigsystem
5343: AND wu.orig_system_id = person.person_id
5344: AND TRUNC (sysdate) BETWEEN person.effective_start_date AND NVL (person.effective_end_date ,TRUNC (sysdate))

Line 5626: l_preparer_user_name WF_USERS.name%TYPE;

5622: l_return_status VARCHAR2(1);
5623: l_msg_count NUMBER;
5624: l_msg_data VARCHAR2(2000);
5625: l_doc_string VARCHAR2(200);
5626: l_preparer_user_name WF_USERS.name%TYPE;
5627: l_trans_status VARCHAR2(10);
5628: l_response_code FND_LOOKUP_VALUES.meaning%TYPE;
5629: l_reason_code FND_LOOKUP_VALUES.meaning%TYPE;
5630: l_signer_type FND_LOOKUP_VALUES.meaning%TYPE;