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 451: l_approver_user_name wf_users.name%TYPE;

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

Line 452: l_approver_display_name wf_users.display_name%TYPE;

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

Line 454: l_manager_display_name wf_users.display_name%TYPE;

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

Line 530: l_responder_user_id wf_users.orig_system_id%TYPE;

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

Line 531: l_responder_user_name wf_users.name%TYPE;

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

Line 532: l_responder_display_name wf_users.display_name%TYPE;

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

Line 970: l_requestor_user_name wf_users.name%TYPE;

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

Line 971: l_requestor_display_name wf_users.display_name%TYPE;

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

Line 981: FROM wf_users

977:
978:
979: CURSOR c1 is
980: SELECT name, display_name
981: FROM wf_users
982: WHERE orig_system = 'PER'
983: AND orig_system_id = l_requestor_id;
984:
985: CURSOR c2 is

Line 987: FROM wf_users

983: AND orig_system_id = l_requestor_id;
984:
985: CURSOR c2 is
986: SELECT name, display_name
987: FROM wf_users
988: WHERE orig_system = 'FND_USR'
989: AND orig_system_id = l_requestor_id;
990:
991:

Line 1723: l_collector_user_name wf_users.name%TYPE;

1719: l_collector_employee_id NUMBER(15);
1720: l_collector_user_id NUMBER(15);
1721: l_collector_id NUMBER(15);
1722: l_collector_name VARCHAR2(30); -- name displayed in collector form.
1723: l_collector_user_name wf_users.name%TYPE;
1724: l_collector_display_name wf_users.display_name%TYPE; -- name for collector as employee
1725:
1726: CURSOR c (p_employee_id NUMBER) IS
1727: SELECT collector_id, name

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

1720: l_collector_user_id NUMBER(15);
1721: l_collector_id NUMBER(15);
1722: l_collector_name VARCHAR2(30); -- name displayed in collector form.
1723: l_collector_user_name wf_users.name%TYPE;
1724: l_collector_display_name wf_users.display_name%TYPE; -- name for collector as employee
1725:
1726: CURSOR c (p_employee_id NUMBER) IS
1727: SELECT collector_id, name
1728: FROM ar_collectors

Line 2567: l_approver_display_name wf_users.display_name%TYPE;

2563: p_result OUT NOCOPY VARCHAR2) IS
2564:
2565: l_debug_info VARCHAR2(200);
2566: l_approver_id NUMBER;
2567: l_approver_display_name wf_users.display_name%TYPE;
2568: l_approver_user_name wf_users.name%TYPE;
2569: l_count NUMBER;
2570:
2571: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;

Line 2568: l_approver_user_name wf_users.name%TYPE;

2564:
2565: l_debug_info VARCHAR2(200);
2566: l_approver_id NUMBER;
2567: l_approver_display_name wf_users.display_name%TYPE;
2568: l_approver_user_name wf_users.name%TYPE;
2569: l_count NUMBER;
2570:
2571: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;
2572: l_approver_user_id wf_item_attribute_values.number_value%TYPE;

Line 2788: l_nonresponsive_user_name wf_users.name%TYPE;

2784:
2785: l_approval_path wf_item_attribute_values.text_value%TYPE;
2786: l_nonresponsive_employee_id fnd_user.employee_id%TYPE;
2787: l_nonresponsive_user_id fnd_user.user_id%TYPE;
2788: l_nonresponsive_user_name wf_users.name%TYPE;
2789: l_nonresponsive_display_name wf_users.display_name%TYPE;
2790: l_manager_employee_id fnd_user.employee_id%TYPE;
2791: l_manager_user_name wf_users.name%TYPE;
2792: l_manager_display_name wf_users.display_name%TYPE;

Line 2789: l_nonresponsive_display_name wf_users.display_name%TYPE;

2785: l_approval_path wf_item_attribute_values.text_value%TYPE;
2786: l_nonresponsive_employee_id fnd_user.employee_id%TYPE;
2787: l_nonresponsive_user_id fnd_user.user_id%TYPE;
2788: l_nonresponsive_user_name wf_users.name%TYPE;
2789: l_nonresponsive_display_name wf_users.display_name%TYPE;
2790: l_manager_employee_id fnd_user.employee_id%TYPE;
2791: l_manager_user_name wf_users.name%TYPE;
2792: l_manager_display_name wf_users.display_name%TYPE;
2793: l_escalation_count NUMBER;

Line 2791: l_manager_user_name wf_users.name%TYPE;

2787: l_nonresponsive_user_id fnd_user.user_id%TYPE;
2788: l_nonresponsive_user_name wf_users.name%TYPE;
2789: l_nonresponsive_display_name wf_users.display_name%TYPE;
2790: l_manager_employee_id fnd_user.employee_id%TYPE;
2791: l_manager_user_name wf_users.name%TYPE;
2792: l_manager_display_name wf_users.display_name%TYPE;
2793: l_escalation_count NUMBER;
2794: l_transaction_type VARCHAR2(30);
2795:

Line 2792: l_manager_display_name wf_users.display_name%TYPE;

2788: l_nonresponsive_user_name wf_users.name%TYPE;
2789: l_nonresponsive_display_name wf_users.display_name%TYPE;
2790: l_manager_employee_id fnd_user.employee_id%TYPE;
2791: l_manager_user_name wf_users.name%TYPE;
2792: l_manager_display_name wf_users.display_name%TYPE;
2793: l_escalation_count NUMBER;
2794: l_transaction_type VARCHAR2(30);
2795:
2796: BEGIN

Line 2988: l_collector_display_name wf_users.display_name%TYPE;

2984: p_funcmode IN VARCHAR2,
2985: p_result OUT NOCOPY VARCHAR2) IS
2986:
2987: l_collector_employee_id NUMBER;
2988: l_collector_display_name wf_users.display_name%TYPE;
2989: l_collector_user_name wf_users.name%TYPE;
2990: l_notes wf_item_attribute_values.text_value%TYPE;
2991: l_approver_notes wf_item_attribute_values.text_value%TYPE;
2992: CRLF VARCHAR2(1);

Line 2989: l_collector_user_name wf_users.name%TYPE;

2985: p_result OUT NOCOPY VARCHAR2) IS
2986:
2987: l_collector_employee_id NUMBER;
2988: l_collector_display_name wf_users.display_name%TYPE;
2989: l_collector_user_name wf_users.name%TYPE;
2990: l_notes wf_item_attribute_values.text_value%TYPE;
2991: l_approver_notes wf_item_attribute_values.text_value%TYPE;
2992: CRLF VARCHAR2(1);
2993:

Line 3137: l_approver_display_name wf_users.display_name%TYPE;

3133: p_result OUT NOCOPY VARCHAR2) IS
3134:
3135:
3136: l_approver_id NUMBER;
3137: l_approver_display_name wf_users.display_name%TYPE;
3138: l_approver_user_name wf_users.name%TYPE;
3139:
3140: BEGIN
3141:

Line 3138: l_approver_user_name wf_users.name%TYPE;

3134:
3135:
3136: l_approver_id NUMBER;
3137: l_approver_display_name wf_users.display_name%TYPE;
3138: l_approver_user_name wf_users.name%TYPE;
3139:
3140: BEGIN
3141:
3142: ----------------------------------------------------------

Line 3321: l_approver_user_name wf_users.name%TYPE;

3317: p_funcmode IN VARCHAR2,
3318: p_result OUT NOCOPY VARCHAR2) IS
3319:
3320: l_approver_id NUMBER;
3321: l_approver_user_name wf_users.name%TYPE;
3322: l_approver_display_name wf_users.display_name%TYPE;
3323: l_notes wf_item_attribute_values.text_value%TYPE;
3324: l_approver_notes wf_item_attribute_values.text_value%TYPE;
3325: CRLF VARCHAR2(1);

Line 3322: l_approver_display_name wf_users.display_name%TYPE;

3318: p_result OUT NOCOPY VARCHAR2) IS
3319:
3320: l_approver_id NUMBER;
3321: l_approver_user_name wf_users.name%TYPE;
3322: l_approver_display_name wf_users.display_name%TYPE;
3323: l_notes wf_item_attribute_values.text_value%TYPE;
3324: l_approver_notes wf_item_attribute_values.text_value%TYPE;
3325: CRLF VARCHAR2(1);
3326:

Line 3804: l_approver_user_name wf_users.name%TYPE;

3800: p_funcmode IN VARCHAR2,
3801: p_result OUT NOCOPY VARCHAR2) IS
3802:
3803: l_approver_id NUMBER;
3804: l_approver_user_name wf_users.name%TYPE;
3805: l_approver_display_name wf_users.display_name%TYPE;
3806: l_notification_id NUMBER;
3807:
3808: BEGIN

Line 3805: l_approver_display_name wf_users.display_name%TYPE;

3801: p_result OUT NOCOPY VARCHAR2) IS
3802:
3803: l_approver_id NUMBER;
3804: l_approver_user_name wf_users.name%TYPE;
3805: l_approver_display_name wf_users.display_name%TYPE;
3806: l_notification_id NUMBER;
3807:
3808: BEGIN
3809:

Line 3832: FROM wf_users

3828: l_approver_user_name := wf_engine.context_text;
3829:
3830: SELECT orig_system_id, display_name
3831: INTO l_approver_id, l_approver_display_name
3832: FROM wf_users
3833: WHERE orig_system = 'PER'
3834: AND name = l_approver_user_name;
3835:
3836: wf_engine.SetItemAttrText(p_item_type,

Line 3904: l_requestor_user_name wf_users.name%TYPE;

3900: p_funcmode IN VARCHAR2,
3901: p_result OUT NOCOPY VARCHAR2) IS
3902:
3903: l_document_id NUMBER;
3904: l_requestor_user_name wf_users.name%TYPE;
3905: l_customer_trx_id NUMBER;
3906: l_note_id NUMBER;
3907: l_reason_code VARCHAR2(45);
3908: l_total_credit_to_invoice NUMBER;

Line 4082: l_approver_display_name wf_users.display_name%TYPE;

4078: p_result OUT NOCOPY VARCHAR2) IS
4079:
4080: l_document_id NUMBER;
4081: l_customer_trx_id NUMBER;
4082: l_approver_display_name wf_users.display_name%TYPE;
4083: l_note_id NUMBER;
4084: l_note_text ar_notes.text%type;
4085: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4086:

Line 4294: l_role_display_name wf_users.display_name%TYPE;

4290:
4291: l_document_id NUMBER;
4292: l_customer_trx_id NUMBER;
4293: l_receivable_role VARCHAR2(100);
4294: l_role_display_name wf_users.display_name%TYPE;
4295: l_note_id NUMBER;
4296: l_note_text ar_notes.text%type;
4297: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4298:

Line 4402: l_role_display_name wf_users.display_name%TYPE;

4398:
4399: l_document_id NUMBER;
4400: l_customer_trx_id NUMBER;
4401: l_receivable_role VARCHAR2(100);
4402: l_role_display_name wf_users.display_name%TYPE;
4403: l_note_id NUMBER;
4404: l_note_text ar_notes.text%type;
4405: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4406:

Line 4533: l_approver_display_name wf_users.display_name%TYPE;

4529: p_result OUT NOCOPY VARCHAR2) IS
4530:
4531: l_document_id NUMBER;
4532: l_customer_trx_id NUMBER;
4533: l_approver_display_name wf_users.display_name%TYPE;
4534: l_note_id NUMBER;
4535: l_note_text ar_notes.text%type;
4536: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4537: BEGIN

Line 4638: l_approver_display_name wf_users.display_name%TYPE;

4634: p_result OUT NOCOPY VARCHAR2) IS
4635:
4636: l_document_id NUMBER;
4637: l_customer_trx_id NUMBER;
4638: l_approver_display_name wf_users.display_name%TYPE;
4639: l_note_id NUMBER;
4640: l_note_text ar_notes.text%type;
4641: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4642:

Line 4783: l_approver_display_name wf_users.display_name%TYPE;

4779: p_result OUT NOCOPY VARCHAR2) IS
4780:
4781: l_document_id NUMBER;
4782: l_customer_trx_id NUMBER;
4783: l_approver_display_name wf_users.display_name%TYPE;
4784: l_note_id NUMBER;
4785: l_note_text ar_notes.text%type;
4786: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4787:

Line 5707: l_user_name wf_users.name%TYPE;

5703:
5704: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;
5705: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
5706: l_employee_id ra_salesreps_all.person_id%TYPE;
5707: l_user_name wf_users.name%TYPE;
5708: l_display_name wf_users.display_name%TYPE;
5709:
5710: CURSOR c (p_id IN NUMBER) IS
5711: SELECT rsa.person_id

Line 5708: l_display_name wf_users.display_name%TYPE;

5704: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;
5705: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
5706: l_employee_id ra_salesreps_all.person_id%TYPE;
5707: l_user_name wf_users.name%TYPE;
5708: l_display_name wf_users.display_name%TYPE;
5709:
5710: CURSOR c (p_id IN NUMBER) IS
5711: SELECT rsa.person_id
5712: FROM ra_customer_trx_all rcta, ra_salesreps_all rsa