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_ITEM_ATTRIBUTE_VALUES

Line 95: l_org_id wf_item_attribute_values.number_value%TYPE;

91:
92:
93: PROCEDURE restore_context (p_item_key IN VARCHAR2) IS
94:
95: l_org_id wf_item_attribute_values.number_value%TYPE;
96:
97: BEGIN
98:
99: ----------------------------------------------------------

Line 139: l_org_id wf_item_attribute_values.number_value%TYPE;

135: -- application specific context when it resumes.
136: --
137: PROCEDURE save_context (p_item_key IN VARCHAR2) IS
138:
139: l_org_id wf_item_attribute_values.number_value%TYPE;
140:
141: CURSOR c IS
142: SELECT org_id
143: FROM ra_cm_requests_all

Line 1929: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;

1925: p_actid IN NUMBER,
1926: p_funcmode IN VARCHAR2,
1927: p_result OUT NOCOPY VARCHAR2) IS
1928:
1929: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
1930: l_invoicing_rule_id wf_item_attribute_values.number_value%TYPE;
1931: l_need_rule_mesg wf_item_attribute_values.text_value%TYPE;
1932: l_credit_accounting_rule wf_item_attribute_values.text_value%TYPE;
1933: l_reason_code wf_item_attribute_values.text_value%TYPE;

Line 1930: l_invoicing_rule_id wf_item_attribute_values.number_value%TYPE;

1926: p_funcmode IN VARCHAR2,
1927: p_result OUT NOCOPY VARCHAR2) IS
1928:
1929: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
1930: l_invoicing_rule_id wf_item_attribute_values.number_value%TYPE;
1931: l_need_rule_mesg wf_item_attribute_values.text_value%TYPE;
1932: l_credit_accounting_rule wf_item_attribute_values.text_value%TYPE;
1933: l_reason_code wf_item_attribute_values.text_value%TYPE;
1934: l_currency_code wf_item_attribute_values.text_value%TYPE;

Line 1931: l_need_rule_mesg wf_item_attribute_values.text_value%TYPE;

1927: p_result OUT NOCOPY VARCHAR2) IS
1928:
1929: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
1930: l_invoicing_rule_id wf_item_attribute_values.number_value%TYPE;
1931: l_need_rule_mesg wf_item_attribute_values.text_value%TYPE;
1932: l_credit_accounting_rule wf_item_attribute_values.text_value%TYPE;
1933: l_reason_code wf_item_attribute_values.text_value%TYPE;
1934: l_currency_code wf_item_attribute_values.text_value%TYPE;
1935:

Line 1932: l_credit_accounting_rule wf_item_attribute_values.text_value%TYPE;

1928:
1929: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
1930: l_invoicing_rule_id wf_item_attribute_values.number_value%TYPE;
1931: l_need_rule_mesg wf_item_attribute_values.text_value%TYPE;
1932: l_credit_accounting_rule wf_item_attribute_values.text_value%TYPE;
1933: l_reason_code wf_item_attribute_values.text_value%TYPE;
1934: l_currency_code wf_item_attribute_values.text_value%TYPE;
1935:
1936: CURSOR c (p_cust_trx_id NUMBER) IS

Line 1933: l_reason_code wf_item_attribute_values.text_value%TYPE;

1929: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
1930: l_invoicing_rule_id wf_item_attribute_values.number_value%TYPE;
1931: l_need_rule_mesg wf_item_attribute_values.text_value%TYPE;
1932: l_credit_accounting_rule wf_item_attribute_values.text_value%TYPE;
1933: l_reason_code wf_item_attribute_values.text_value%TYPE;
1934: l_currency_code wf_item_attribute_values.text_value%TYPE;
1935:
1936: CURSOR c (p_cust_trx_id NUMBER) IS
1937: SELECT invoicing_rule_id

Line 1934: l_currency_code wf_item_attribute_values.text_value%TYPE;

1930: l_invoicing_rule_id wf_item_attribute_values.number_value%TYPE;
1931: l_need_rule_mesg wf_item_attribute_values.text_value%TYPE;
1932: l_credit_accounting_rule wf_item_attribute_values.text_value%TYPE;
1933: l_reason_code wf_item_attribute_values.text_value%TYPE;
1934: l_currency_code wf_item_attribute_values.text_value%TYPE;
1935:
1936: CURSOR c (p_cust_trx_id NUMBER) IS
1937: SELECT invoicing_rule_id
1938: FROM ra_customer_trx

Line 2057: l_approval_path wf_item_attribute_values.text_value%TYPE;

2053: p_actid IN NUMBER,
2054: p_funcmode IN VARCHAR2,
2055: p_result OUT NOCOPY VARCHAR2) IS
2056:
2057: l_approval_path wf_item_attribute_values.text_value%TYPE;
2058:
2059: BEGIN
2060:
2061: ----------------------------------------------------------

Line 2154: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;

2150: l_next_approver ame_util.approverrecord;
2151: l_admin_approver ame_util.approverrecord;
2152: l_error_message fnd_new_messages.message_text%TYPE;
2153:
2154: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;
2155: l_approver_user_id wf_item_attribute_values.number_value%TYPE;
2156: l_escalation_count NUMBER;
2157: l_timeout_occured VARCHAR2(1) ; /*4139346 */
2158:

Line 2155: l_approver_user_id wf_item_attribute_values.number_value%TYPE;

2151: l_admin_approver ame_util.approverrecord;
2152: l_error_message fnd_new_messages.message_text%TYPE;
2153:
2154: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;
2155: l_approver_user_id wf_item_attribute_values.number_value%TYPE;
2156: l_escalation_count NUMBER;
2157: l_timeout_occured VARCHAR2(1) ; /*4139346 */
2158:
2159: BEGIN

Line 2355: l_approver_user_name wf_item_attribute_values.text_value%TYPE;

2351: p_result OUT NOCOPY VARCHAR2) IS
2352:
2353: l_approver_id fnd_user.user_id%TYPE;
2354: l_employee_id fnd_user.employee_id%TYPE;
2355: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
2356:
2357: CURSOR c (p_user_name VARCHAR2) IS
2358: SELECT employee_id, user_id
2359: FROM fnd_user

Line 2467: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;

2463: l_admin_approver ame_util.approverrecord;
2464: l_error_message fnd_new_messages.message_text%TYPE;
2465: l_count NUMBER;
2466:
2467: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;
2468: l_approver_user_id wf_item_attribute_values.number_value%TYPE;
2469:
2470: BEGIN
2471:

Line 2468: l_approver_user_id wf_item_attribute_values.number_value%TYPE;

2464: l_error_message fnd_new_messages.message_text%TYPE;
2465: l_count NUMBER;
2466:
2467: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;
2468: l_approver_user_id wf_item_attribute_values.number_value%TYPE;
2469:
2470: BEGIN
2471:
2472: ----------------------------------------------------------

Line 2571: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;

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;
2573: l_timeout_occured VARCHAR2(1) ; /*4139346 */
2574: l_escalation_count NUMBER;
2575:

Line 2572: l_approver_user_id wf_item_attribute_values.number_value%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;
2573: l_timeout_occured VARCHAR2(1) ; /*4139346 */
2574: l_escalation_count NUMBER;
2575:
2576: BEGIN

Line 2785: l_approval_path wf_item_attribute_values.text_value%TYPE;

2781: AND trunc(sysdate) BETWEEN effective_start_date
2782: AND effective_end_date;
2783:
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;

Line 2990: l_notes wf_item_attribute_values.text_value%TYPE;

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:
2994: BEGIN

Line 2991: l_approver_notes wf_item_attribute_values.text_value%TYPE;

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:
2994: BEGIN
2995:

Line 3323: l_notes wf_item_attribute_values.text_value%TYPE;

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:
3327: BEGIN

Line 3324: l_approver_notes wf_item_attribute_values.text_value%TYPE;

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:
3327: BEGIN
3328:

Line 3702: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;

3698: l_next_approver ame_util.approverrecord;
3699: l_admin_approver ame_util.approverrecord;
3700: l_error_message VARCHAR2(2000);
3701:
3702: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;
3703: l_approver_user_id wf_item_attribute_values.number_value%TYPE;
3704:
3705: BEGIN
3706:

Line 3703: l_approver_user_id wf_item_attribute_values.number_value%TYPE;

3699: l_admin_approver ame_util.approverrecord;
3700: l_error_message VARCHAR2(2000);
3701:
3702: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;
3703: l_approver_user_id wf_item_attribute_values.number_value%TYPE;
3704:
3705: BEGIN
3706:
3707: ----------------------------------------------------------

Line 4085: l_notes wf_item_attribute_values.text_value%TYPE; /5119049 /

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:
4087: BEGIN
4088:
4089: ----------------------------------------------------------

Line 4190: l_notes wf_item_attribute_values.text_value%TYPE; /5119049 /

4186: l_customer_trx_id NUMBER;
4187: l_manager_user_name VARCHAR2(100);
4188: l_note_id NUMBER;
4189: l_note_text ar_notes.text%type;
4190: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4191:
4192: BEGIN
4193:
4194: ----------------------------------------------------------

Line 4297: l_notes wf_item_attribute_values.text_value%TYPE; /5119049 /

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:
4299: BEGIN
4300:
4301: ----------------------------------------------------------

Line 4405: l_notes wf_item_attribute_values.text_value%TYPE; /5119049 /

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:
4407: l_last_updated_by NUMBER;
4408: l_last_update_login NUMBER;
4409:

Line 4536: l_notes wf_item_attribute_values.text_value%TYPE; /5119049 /

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
4538:
4539: ----------------------------------------------------------
4540: g_debug_mesg := 'Entered INSERTREQUESTAPPROVALNOTES';

Line 4641: l_notes wf_item_attribute_values.text_value%TYPE; /5119049 /

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:
4643: l_approver_id NUMBER;
4644: l_transaction_type VARCHAR2(30);
4645:

Line 4786: l_notes wf_item_attribute_values.text_value%TYPE; /5119049 /

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:
4788: --Bug 1908252
4789: l_last_updated_by NUMBER;
4790: l_last_update_login NUMBER;

Line 4952: l_notes wf_item_attribute_values.text_value%TYPE; /5119049 /

4948: l_credit_memo_number VARCHAR2(20);
4949: l_customer_trx_id NUMBER;
4950: l_note_id NUMBER;
4951: l_note_text ar_notes.text%type;
4952: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4953:
4954: BEGIN
4955:
4956: ----------------------------------------------------------

Line 5704: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;

5700: p_funcmode IN VARCHAR2,
5701: p_result IN OUT NOCOPY VARCHAR2) IS
5702:
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;

Line 5705: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;

5701: p_result IN OUT NOCOPY VARCHAR2) IS
5702:
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:

Line 5799: l_approval_path wf_item_attribute_values.text_value%TYPE;

5795: p_actid IN NUMBER,
5796: p_funcmode IN VARCHAR2,
5797: p_result IN OUT NOCOPY VARCHAR2) IS
5798:
5799: l_approval_path wf_item_attribute_values.text_value%TYPE;
5800: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
5801:
5802: BEGIN
5803:

Line 5800: l_approver_user_name wf_item_attribute_values.text_value%TYPE;

5796: p_funcmode IN VARCHAR2,
5797: p_result IN OUT NOCOPY VARCHAR2) IS
5798:
5799: l_approval_path wf_item_attribute_values.text_value%TYPE;
5800: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
5801:
5802: BEGIN
5803:
5804: ----------------------------------------------------------

Line 5871: l_credit_memo_number wf_item_attribute_values.text_value%TYPE;

5867: p_actid IN NUMBER,
5868: p_funcmode IN VARCHAR2,
5869: p_result IN OUT NOCOPY VARCHAR2) IS
5870:
5871: l_credit_memo_number wf_item_attribute_values.text_value%TYPE;
5872: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
5873: l_dummy wf_item_attribute_values.text_value%TYPE;
5874: l_on_account BOOLEAN DEFAULT FALSE;
5875:

Line 5872: l_approver_user_name wf_item_attribute_values.text_value%TYPE;

5868: p_funcmode IN VARCHAR2,
5869: p_result IN OUT NOCOPY VARCHAR2) IS
5870:
5871: l_credit_memo_number wf_item_attribute_values.text_value%TYPE;
5872: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
5873: l_dummy wf_item_attribute_values.text_value%TYPE;
5874: l_on_account BOOLEAN DEFAULT FALSE;
5875:
5876: -- If the previous customer trx id is null then

Line 5873: l_dummy wf_item_attribute_values.text_value%TYPE;

5869: p_result IN OUT NOCOPY VARCHAR2) IS
5870:
5871: l_credit_memo_number wf_item_attribute_values.text_value%TYPE;
5872: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
5873: l_dummy wf_item_attribute_values.text_value%TYPE;
5874: l_on_account BOOLEAN DEFAULT FALSE;
5875:
5876: -- If the previous customer trx id is null then
5877: -- the credit memo is an on account credit memo.

Line 5943: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;

5939: p_actid IN NUMBER,
5940: p_funcmode IN VARCHAR2,
5941: p_result IN OUT NOCOPY VARCHAR2) IS
5942:
5943: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;
5944: l_collector_user_name wf_item_attribute_values.text_value%TYPE;
5945:
5946: BEGIN
5947:

Line 5944: l_collector_user_name wf_item_attribute_values.text_value%TYPE;

5940: p_funcmode IN VARCHAR2,
5941: p_result IN OUT NOCOPY VARCHAR2) IS
5942:
5943: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;
5944: l_collector_user_name wf_item_attribute_values.text_value%TYPE;
5945:
5946: BEGIN
5947:
5948: ----------------------------------------------------------