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

Line 453: l_approver_user_name wf_users.name%TYPE;

449: p_user_id IN NUMBER,
450: p_item_type IN VARCHAR2,
451: p_item_key IN VARCHAR2) IS
452:
453: l_approver_user_name wf_users.name%TYPE;
454: l_approver_display_name wf_users.display_name%TYPE;
455: l_manager_name VARCHAR2(100);
456: l_manager_display_name wf_users.display_name%TYPE;
457:

Line 454: l_approver_display_name wf_users.display_name%TYPE;

450: p_item_type IN VARCHAR2,
451: p_item_key IN VARCHAR2) IS
452:
453: l_approver_user_name wf_users.name%TYPE;
454: l_approver_display_name wf_users.display_name%TYPE;
455: l_manager_name VARCHAR2(100);
456: l_manager_display_name wf_users.display_name%TYPE;
457:
458: BEGIN

Line 456: l_manager_display_name wf_users.display_name%TYPE;

452:
453: l_approver_user_name wf_users.name%TYPE;
454: l_approver_display_name wf_users.display_name%TYPE;
455: l_manager_name VARCHAR2(100);
456: l_manager_display_name wf_users.display_name%TYPE;
457:
458: BEGIN
459:
460:

Line 532: l_responder_user_id wf_users.orig_system_id%TYPE;

528: l_document_id NUMBER;
529: l_customer_trx_id NUMBER;
530: l_note_id NUMBER;
531: l_note_text ar_notes.text%type;
532: l_responder_user_id wf_users.orig_system_id%TYPE;
533: l_responder_user_name wf_users.name%TYPE;
534: l_responder_display_name wf_users.display_name%TYPE;
535:
536: BEGIN

Line 533: l_responder_user_name wf_users.name%TYPE;

529: l_customer_trx_id NUMBER;
530: l_note_id NUMBER;
531: l_note_text ar_notes.text%type;
532: l_responder_user_id wf_users.orig_system_id%TYPE;
533: l_responder_user_name wf_users.name%TYPE;
534: l_responder_display_name wf_users.display_name%TYPE;
535:
536: BEGIN
537:

Line 534: l_responder_display_name wf_users.display_name%TYPE;

530: l_note_id NUMBER;
531: l_note_text ar_notes.text%type;
532: l_responder_user_id wf_users.orig_system_id%TYPE;
533: l_responder_user_name wf_users.name%TYPE;
534: l_responder_display_name wf_users.display_name%TYPE;
535:
536: BEGIN
537:
538: l_responder_user_name := wf_engine.context_text;

Line 972: l_requestor_user_name wf_users.name%TYPE;

968: l_reason_code VARCHAR2(45);
969: l_reason_meaning VARCHAR2(80);
970: l_currency_code VARCHAR2(15);
971: l_requestor_id NUMBER;
972: l_requestor_user_name wf_users.name%TYPE;
973: l_requestor_display_name wf_users.display_name%TYPE;
974: /*Bug3206020 Changed comments size from 240 to 1760. */
975: l_comments VARCHAR2(1760);
976: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

Line 973: l_requestor_display_name wf_users.display_name%TYPE;

969: l_reason_meaning VARCHAR2(80);
970: l_currency_code VARCHAR2(15);
971: l_requestor_id NUMBER;
972: l_requestor_user_name wf_users.name%TYPE;
973: l_requestor_display_name wf_users.display_name%TYPE;
974: /*Bug3206020 Changed comments size from 240 to 1760. */
975: l_comments VARCHAR2(1760);
976: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
977: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;

Line 984: FROM wf_users

980:
981: -- bug 7559456
982: CURSOR c1(emp_id number) is
983: SELECT name, display_name
984: FROM wf_users
985: WHERE orig_system = 'PER'
986: AND orig_system_id = emp_id;
987:
988: CURSOR c2(user_id number) is

Line 990: FROM wf_users

986: AND orig_system_id = emp_id;
987:
988: CURSOR c2(user_id number) is
989: SELECT name, display_name
990: FROM wf_users
991: WHERE orig_system = 'FND_USR'
992: AND orig_system_id = user_id;
993:
994: cursor c3(user_id1 number) is

Line 1764: l_collector_user_name wf_users.name%TYPE;

1760: l_collector_employee_id NUMBER(15);
1761: l_collector_user_id NUMBER(15);
1762: l_collector_id NUMBER(15);
1763: l_collector_name VARCHAR2(30); -- name displayed in collector form.
1764: l_collector_user_name wf_users.name%TYPE;
1765: l_collector_display_name wf_users.display_name%TYPE; -- name for collector as employee
1766:
1767: CURSOR c (p_employee_id NUMBER) IS
1768: SELECT collector_id, name

Line 1765: l_collector_display_name wf_users.display_name%TYPE; -- name for collector as employee

1761: l_collector_user_id NUMBER(15);
1762: l_collector_id NUMBER(15);
1763: l_collector_name VARCHAR2(30); -- name displayed in collector form.
1764: l_collector_user_name wf_users.name%TYPE;
1765: l_collector_display_name wf_users.display_name%TYPE; -- name for collector as employee
1766:
1767: CURSOR c (p_employee_id NUMBER) IS
1768: SELECT collector_id, name
1769: FROM ar_collectors

Line 2608: l_approver_display_name wf_users.display_name%TYPE;

2604: p_result OUT NOCOPY VARCHAR2) IS
2605:
2606: l_debug_info VARCHAR2(200);
2607: l_approver_id NUMBER;
2608: l_approver_display_name wf_users.display_name%TYPE;
2609: l_approver_user_name wf_users.name%TYPE;
2610: l_count NUMBER;
2611:
2612: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;

Line 2609: l_approver_user_name wf_users.name%TYPE;

2605:
2606: l_debug_info VARCHAR2(200);
2607: l_approver_id NUMBER;
2608: l_approver_display_name wf_users.display_name%TYPE;
2609: l_approver_user_name wf_users.name%TYPE;
2610: l_count NUMBER;
2611:
2612: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;
2613: l_approver_user_id wf_item_attribute_values.number_value%TYPE;

Line 2829: l_nonresponsive_user_name wf_users.name%TYPE;

2825:
2826: l_approval_path wf_item_attribute_values.text_value%TYPE;
2827: l_nonresponsive_employee_id fnd_user.employee_id%TYPE;
2828: l_nonresponsive_user_id fnd_user.user_id%TYPE;
2829: l_nonresponsive_user_name wf_users.name%TYPE;
2830: l_nonresponsive_display_name wf_users.display_name%TYPE;
2831: l_manager_employee_id fnd_user.employee_id%TYPE;
2832: l_manager_user_name wf_users.name%TYPE;
2833: l_manager_display_name wf_users.display_name%TYPE;

Line 2830: l_nonresponsive_display_name wf_users.display_name%TYPE;

2826: l_approval_path wf_item_attribute_values.text_value%TYPE;
2827: l_nonresponsive_employee_id fnd_user.employee_id%TYPE;
2828: l_nonresponsive_user_id fnd_user.user_id%TYPE;
2829: l_nonresponsive_user_name wf_users.name%TYPE;
2830: l_nonresponsive_display_name wf_users.display_name%TYPE;
2831: l_manager_employee_id fnd_user.employee_id%TYPE;
2832: l_manager_user_name wf_users.name%TYPE;
2833: l_manager_display_name wf_users.display_name%TYPE;
2834: l_escalation_count NUMBER;

Line 2832: l_manager_user_name wf_users.name%TYPE;

2828: l_nonresponsive_user_id fnd_user.user_id%TYPE;
2829: l_nonresponsive_user_name wf_users.name%TYPE;
2830: l_nonresponsive_display_name wf_users.display_name%TYPE;
2831: l_manager_employee_id fnd_user.employee_id%TYPE;
2832: l_manager_user_name wf_users.name%TYPE;
2833: l_manager_display_name wf_users.display_name%TYPE;
2834: l_escalation_count NUMBER;
2835: l_transaction_type VARCHAR2(30);
2836:

Line 2833: l_manager_display_name wf_users.display_name%TYPE;

2829: l_nonresponsive_user_name wf_users.name%TYPE;
2830: l_nonresponsive_display_name wf_users.display_name%TYPE;
2831: l_manager_employee_id fnd_user.employee_id%TYPE;
2832: l_manager_user_name wf_users.name%TYPE;
2833: l_manager_display_name wf_users.display_name%TYPE;
2834: l_escalation_count NUMBER;
2835: l_transaction_type VARCHAR2(30);
2836:
2837: BEGIN

Line 3029: l_collector_display_name wf_users.display_name%TYPE;

3025: p_funcmode IN VARCHAR2,
3026: p_result OUT NOCOPY VARCHAR2) IS
3027:
3028: l_collector_employee_id NUMBER;
3029: l_collector_display_name wf_users.display_name%TYPE;
3030: l_collector_user_name wf_users.name%TYPE;
3031: l_notes wf_item_attribute_values.text_value%TYPE;
3032: l_approver_notes wf_item_attribute_values.text_value%TYPE;
3033: CRLF VARCHAR2(1);

Line 3030: l_collector_user_name wf_users.name%TYPE;

3026: p_result OUT NOCOPY VARCHAR2) IS
3027:
3028: l_collector_employee_id NUMBER;
3029: l_collector_display_name wf_users.display_name%TYPE;
3030: l_collector_user_name wf_users.name%TYPE;
3031: l_notes wf_item_attribute_values.text_value%TYPE;
3032: l_approver_notes wf_item_attribute_values.text_value%TYPE;
3033: CRLF VARCHAR2(1);
3034:

Line 3178: l_approver_display_name wf_users.display_name%TYPE;

3174: p_result OUT NOCOPY VARCHAR2) IS
3175:
3176:
3177: l_approver_id NUMBER;
3178: l_approver_display_name wf_users.display_name%TYPE;
3179: l_approver_user_name wf_users.name%TYPE;
3180:
3181: BEGIN
3182:

Line 3179: l_approver_user_name wf_users.name%TYPE;

3175:
3176:
3177: l_approver_id NUMBER;
3178: l_approver_display_name wf_users.display_name%TYPE;
3179: l_approver_user_name wf_users.name%TYPE;
3180:
3181: BEGIN
3182:
3183: ----------------------------------------------------------

Line 3362: l_approver_user_name wf_users.name%TYPE;

3358: p_funcmode IN VARCHAR2,
3359: p_result OUT NOCOPY VARCHAR2) IS
3360:
3361: l_approver_id NUMBER;
3362: l_approver_user_name wf_users.name%TYPE;
3363: l_approver_display_name wf_users.display_name%TYPE;
3364: l_notes wf_item_attribute_values.text_value%TYPE;
3365: l_approver_notes wf_item_attribute_values.text_value%TYPE;
3366: CRLF VARCHAR2(1);

Line 3363: l_approver_display_name wf_users.display_name%TYPE;

3359: p_result OUT NOCOPY VARCHAR2) IS
3360:
3361: l_approver_id NUMBER;
3362: l_approver_user_name wf_users.name%TYPE;
3363: l_approver_display_name wf_users.display_name%TYPE;
3364: l_notes wf_item_attribute_values.text_value%TYPE;
3365: l_approver_notes wf_item_attribute_values.text_value%TYPE;
3366: CRLF VARCHAR2(1);
3367:

Line 3904: l_approver_user_name wf_users.name%TYPE;

3900: p_funcmode IN VARCHAR2,
3901: p_result OUT NOCOPY VARCHAR2) IS
3902:
3903: l_approver_id NUMBER;
3904: l_approver_user_name wf_users.name%TYPE;
3905: l_approver_display_name wf_users.display_name%TYPE;
3906: l_notification_id NUMBER;
3907:
3908: BEGIN

Line 3905: l_approver_display_name wf_users.display_name%TYPE;

3901: p_result OUT NOCOPY VARCHAR2) IS
3902:
3903: l_approver_id NUMBER;
3904: l_approver_user_name wf_users.name%TYPE;
3905: l_approver_display_name wf_users.display_name%TYPE;
3906: l_notification_id NUMBER;
3907:
3908: BEGIN
3909:

Line 3932: FROM wf_users

3928: l_approver_user_name := wf_engine.context_text;
3929:
3930: SELECT orig_system_id, display_name
3931: INTO l_approver_id, l_approver_display_name
3932: FROM wf_users
3933: WHERE orig_system = 'PER'
3934: AND name = l_approver_user_name;
3935:
3936: wf_engine.SetItemAttrText(p_item_type,

Line 4004: l_requestor_user_name wf_users.name%TYPE;

4000: p_funcmode IN VARCHAR2,
4001: p_result OUT NOCOPY VARCHAR2) IS
4002:
4003: l_document_id NUMBER;
4004: l_requestor_user_name wf_users.name%TYPE;
4005: l_customer_trx_id NUMBER;
4006: l_note_id NUMBER;
4007: l_reason_code VARCHAR2(45);
4008: l_total_credit_to_invoice NUMBER;

Line 4182: l_approver_display_name wf_users.display_name%TYPE;

4178: p_result OUT NOCOPY VARCHAR2) IS
4179:
4180: l_document_id NUMBER;
4181: l_customer_trx_id NUMBER;
4182: l_approver_display_name wf_users.display_name%TYPE;
4183: l_note_id NUMBER;
4184: l_note_text ar_notes.text%type;
4185: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4186:

Line 4394: l_role_display_name wf_users.display_name%TYPE;

4390:
4391: l_document_id NUMBER;
4392: l_customer_trx_id NUMBER;
4393: l_receivable_role VARCHAR2(100);
4394: l_role_display_name wf_users.display_name%TYPE;
4395: l_note_id NUMBER;
4396: l_note_text ar_notes.text%type;
4397: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4398:

Line 4502: l_role_display_name wf_users.display_name%TYPE;

4498:
4499: l_document_id NUMBER;
4500: l_customer_trx_id NUMBER;
4501: l_receivable_role VARCHAR2(100);
4502: l_role_display_name wf_users.display_name%TYPE;
4503: l_note_id NUMBER;
4504: l_note_text ar_notes.text%type;
4505: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4506:

Line 4633: l_approver_display_name wf_users.display_name%TYPE;

4629: p_result OUT NOCOPY VARCHAR2) IS
4630:
4631: l_document_id NUMBER;
4632: l_customer_trx_id NUMBER;
4633: l_approver_display_name wf_users.display_name%TYPE;
4634: l_note_id NUMBER;
4635: l_note_text ar_notes.text%type;
4636: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4637: BEGIN

Line 4738: l_approver_display_name wf_users.display_name%TYPE;

4734: p_result OUT NOCOPY VARCHAR2) IS
4735:
4736: l_document_id NUMBER;
4737: l_customer_trx_id NUMBER;
4738: l_approver_display_name wf_users.display_name%TYPE;
4739: l_note_id NUMBER;
4740: l_note_text ar_notes.text%type;
4741: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4742:

Line 4883: l_approver_display_name wf_users.display_name%TYPE;

4879: p_result OUT NOCOPY VARCHAR2) IS
4880:
4881: l_document_id NUMBER;
4882: l_customer_trx_id NUMBER;
4883: l_approver_display_name wf_users.display_name%TYPE;
4884: l_note_id NUMBER;
4885: l_note_text ar_notes.text%type;
4886: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4887:

Line 5836: l_user_name wf_users.name%TYPE;

5832:
5833: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;
5834: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
5835: l_employee_id ra_salesreps_all.person_id%TYPE;
5836: l_user_name wf_users.name%TYPE;
5837: l_display_name wf_users.display_name%TYPE;
5838:
5839: CURSOR c (p_id IN NUMBER) IS
5840: SELECT rsa.person_id

Line 5837: l_display_name wf_users.display_name%TYPE;

5833: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;
5834: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
5835: l_employee_id ra_salesreps_all.person_id%TYPE;
5836: l_user_name wf_users.name%TYPE;
5837: l_display_name wf_users.display_name%TYPE;
5838:
5839: CURSOR c (p_id IN NUMBER) IS
5840: SELECT rsa.person_id
5841: FROM ra_customer_trx_all rcta, ra_salesreps_all rsa