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 141: l_org_id wf_item_attribute_values.number_value%TYPE;

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

Line 1970: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;

1966: p_actid IN NUMBER,
1967: p_funcmode IN VARCHAR2,
1968: p_result OUT NOCOPY VARCHAR2) IS
1969:
1970: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
1971: l_invoicing_rule_id wf_item_attribute_values.number_value%TYPE;
1972: l_need_rule_mesg wf_item_attribute_values.text_value%TYPE;
1973: l_credit_accounting_rule wf_item_attribute_values.text_value%TYPE;
1974: l_reason_code wf_item_attribute_values.text_value%TYPE;

Line 1971: l_invoicing_rule_id wf_item_attribute_values.number_value%TYPE;

1967: p_funcmode IN VARCHAR2,
1968: p_result OUT NOCOPY VARCHAR2) IS
1969:
1970: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
1971: l_invoicing_rule_id wf_item_attribute_values.number_value%TYPE;
1972: l_need_rule_mesg wf_item_attribute_values.text_value%TYPE;
1973: l_credit_accounting_rule wf_item_attribute_values.text_value%TYPE;
1974: l_reason_code wf_item_attribute_values.text_value%TYPE;
1975: l_currency_code wf_item_attribute_values.text_value%TYPE;

Line 1972: l_need_rule_mesg wf_item_attribute_values.text_value%TYPE;

1968: p_result OUT NOCOPY VARCHAR2) IS
1969:
1970: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
1971: l_invoicing_rule_id wf_item_attribute_values.number_value%TYPE;
1972: l_need_rule_mesg wf_item_attribute_values.text_value%TYPE;
1973: l_credit_accounting_rule wf_item_attribute_values.text_value%TYPE;
1974: l_reason_code wf_item_attribute_values.text_value%TYPE;
1975: l_currency_code wf_item_attribute_values.text_value%TYPE;
1976:

Line 1973: l_credit_accounting_rule wf_item_attribute_values.text_value%TYPE;

1969:
1970: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
1971: l_invoicing_rule_id wf_item_attribute_values.number_value%TYPE;
1972: l_need_rule_mesg wf_item_attribute_values.text_value%TYPE;
1973: l_credit_accounting_rule wf_item_attribute_values.text_value%TYPE;
1974: l_reason_code wf_item_attribute_values.text_value%TYPE;
1975: l_currency_code wf_item_attribute_values.text_value%TYPE;
1976:
1977: CURSOR c (p_cust_trx_id NUMBER) IS

Line 1974: l_reason_code wf_item_attribute_values.text_value%TYPE;

1970: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;
1971: l_invoicing_rule_id wf_item_attribute_values.number_value%TYPE;
1972: l_need_rule_mesg wf_item_attribute_values.text_value%TYPE;
1973: l_credit_accounting_rule wf_item_attribute_values.text_value%TYPE;
1974: l_reason_code wf_item_attribute_values.text_value%TYPE;
1975: l_currency_code wf_item_attribute_values.text_value%TYPE;
1976:
1977: CURSOR c (p_cust_trx_id NUMBER) IS
1978: SELECT invoicing_rule_id

Line 1975: l_currency_code wf_item_attribute_values.text_value%TYPE;

1971: l_invoicing_rule_id wf_item_attribute_values.number_value%TYPE;
1972: l_need_rule_mesg wf_item_attribute_values.text_value%TYPE;
1973: l_credit_accounting_rule wf_item_attribute_values.text_value%TYPE;
1974: l_reason_code wf_item_attribute_values.text_value%TYPE;
1975: l_currency_code wf_item_attribute_values.text_value%TYPE;
1976:
1977: CURSOR c (p_cust_trx_id NUMBER) IS
1978: SELECT invoicing_rule_id
1979: FROM ra_customer_trx

Line 2098: l_approval_path wf_item_attribute_values.text_value%TYPE;

2094: p_actid IN NUMBER,
2095: p_funcmode IN VARCHAR2,
2096: p_result OUT NOCOPY VARCHAR2) IS
2097:
2098: l_approval_path wf_item_attribute_values.text_value%TYPE;
2099:
2100: BEGIN
2101:
2102: ----------------------------------------------------------

Line 2195: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;

2191: l_next_approver ame_util.approverrecord;
2192: l_admin_approver ame_util.approverrecord;
2193: l_error_message fnd_new_messages.message_text%TYPE;
2194:
2195: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;
2196: l_approver_user_id wf_item_attribute_values.number_value%TYPE;
2197: l_escalation_count NUMBER;
2198: l_timeout_occured VARCHAR2(1) ; /*4139346 */
2199:

Line 2196: l_approver_user_id wf_item_attribute_values.number_value%TYPE;

2192: l_admin_approver ame_util.approverrecord;
2193: l_error_message fnd_new_messages.message_text%TYPE;
2194:
2195: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;
2196: l_approver_user_id wf_item_attribute_values.number_value%TYPE;
2197: l_escalation_count NUMBER;
2198: l_timeout_occured VARCHAR2(1) ; /*4139346 */
2199:
2200: BEGIN

Line 2396: l_approver_user_name wf_item_attribute_values.text_value%TYPE;

2392: p_result OUT NOCOPY VARCHAR2) IS
2393:
2394: l_approver_id fnd_user.user_id%TYPE;
2395: l_employee_id fnd_user.employee_id%TYPE;
2396: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
2397:
2398: CURSOR c (p_user_name VARCHAR2) IS
2399: SELECT employee_id, user_id
2400: FROM fnd_user

Line 2508: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;

2504: l_admin_approver ame_util.approverrecord;
2505: l_error_message fnd_new_messages.message_text%TYPE;
2506: l_count NUMBER;
2507:
2508: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;
2509: l_approver_user_id wf_item_attribute_values.number_value%TYPE;
2510:
2511: BEGIN
2512:

Line 2509: l_approver_user_id wf_item_attribute_values.number_value%TYPE;

2505: l_error_message fnd_new_messages.message_text%TYPE;
2506: l_count NUMBER;
2507:
2508: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;
2509: l_approver_user_id wf_item_attribute_values.number_value%TYPE;
2510:
2511: BEGIN
2512:
2513: ----------------------------------------------------------

Line 2612: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;

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;
2614: l_timeout_occured VARCHAR2(1) ; /*4139346 */
2615: l_escalation_count NUMBER;
2616:

Line 2613: l_approver_user_id wf_item_attribute_values.number_value%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;
2614: l_timeout_occured VARCHAR2(1) ; /*4139346 */
2615: l_escalation_count NUMBER;
2616:
2617: BEGIN

Line 2826: l_approval_path wf_item_attribute_values.text_value%TYPE;

2822: AND trunc(sysdate) BETWEEN effective_start_date
2823: AND effective_end_date;
2824:
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;

Line 3031: l_notes wf_item_attribute_values.text_value%TYPE;

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

Line 3032: l_approver_notes wf_item_attribute_values.text_value%TYPE;

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:
3035: BEGIN
3036:

Line 3364: l_notes wf_item_attribute_values.text_value%TYPE;

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

Line 3365: l_approver_notes wf_item_attribute_values.text_value%TYPE;

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:
3368: BEGIN
3369:

Line 3802: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;

3798: l_next_approver ame_util.approverrecord;
3799: l_admin_approver ame_util.approverrecord;
3800: l_error_message VARCHAR2(2000);
3801:
3802: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;
3803: l_approver_user_id wf_item_attribute_values.number_value%TYPE;
3804:
3805: BEGIN
3806:

Line 3803: l_approver_user_id wf_item_attribute_values.number_value%TYPE;

3799: l_admin_approver ame_util.approverrecord;
3800: l_error_message VARCHAR2(2000);
3801:
3802: l_approver_employee_id wf_item_attribute_values.number_value%TYPE;
3803: l_approver_user_id wf_item_attribute_values.number_value%TYPE;
3804:
3805: BEGIN
3806:
3807: ----------------------------------------------------------

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

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:
4187: BEGIN
4188:
4189: ----------------------------------------------------------

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

4286: l_customer_trx_id NUMBER;
4287: l_manager_user_name VARCHAR2(100);
4288: l_note_id NUMBER;
4289: l_note_text ar_notes.text%type;
4290: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
4291:
4292: BEGIN
4293:
4294: ----------------------------------------------------------

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

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:
4399: BEGIN
4400:
4401: ----------------------------------------------------------

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

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:
4507: l_last_updated_by NUMBER;
4508: l_last_update_login NUMBER;
4509:

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

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
4638:
4639: ----------------------------------------------------------
4640: g_debug_mesg := 'Entered INSERTREQUESTAPPROVALNOTES';

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

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:
4743: l_approver_id NUMBER;
4744: l_transaction_type VARCHAR2(30);
4745:

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

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:
4888: --Bug 1908252
4889: l_last_updated_by NUMBER;
4890: l_last_update_login NUMBER;

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

5048: l_credit_memo_number VARCHAR2(20);
5049: l_customer_trx_id NUMBER;
5050: l_note_id NUMBER;
5051: l_note_text ar_notes.text%type;
5052: l_notes wf_item_attribute_values.text_value%TYPE; /*5119049 */
5053:
5054: BEGIN
5055:
5056: ----------------------------------------------------------

Line 5833: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;

5829: p_funcmode IN VARCHAR2,
5830: p_result IN OUT NOCOPY VARCHAR2) IS
5831:
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;

Line 5834: l_customer_trx_id wf_item_attribute_values.number_value%TYPE;

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

Line 5928: l_approval_path wf_item_attribute_values.text_value%TYPE;

5924: p_actid IN NUMBER,
5925: p_funcmode IN VARCHAR2,
5926: p_result IN OUT NOCOPY VARCHAR2) IS
5927:
5928: l_approval_path wf_item_attribute_values.text_value%TYPE;
5929: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
5930:
5931: BEGIN
5932:

Line 5929: l_approver_user_name wf_item_attribute_values.text_value%TYPE;

5925: p_funcmode IN VARCHAR2,
5926: p_result IN OUT NOCOPY VARCHAR2) IS
5927:
5928: l_approval_path wf_item_attribute_values.text_value%TYPE;
5929: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
5930:
5931: BEGIN
5932:
5933: ----------------------------------------------------------

Line 6000: l_credit_memo_number wf_item_attribute_values.text_value%TYPE;

5996: p_actid IN NUMBER,
5997: p_funcmode IN VARCHAR2,
5998: p_result IN OUT NOCOPY VARCHAR2) IS
5999:
6000: l_credit_memo_number wf_item_attribute_values.text_value%TYPE;
6001: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
6002: l_dummy wf_item_attribute_values.text_value%TYPE;
6003: l_on_account BOOLEAN DEFAULT FALSE;
6004:

Line 6001: l_approver_user_name wf_item_attribute_values.text_value%TYPE;

5997: p_funcmode IN VARCHAR2,
5998: p_result IN OUT NOCOPY VARCHAR2) IS
5999:
6000: l_credit_memo_number wf_item_attribute_values.text_value%TYPE;
6001: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
6002: l_dummy wf_item_attribute_values.text_value%TYPE;
6003: l_on_account BOOLEAN DEFAULT FALSE;
6004:
6005: -- If the previous customer trx id is null then

Line 6002: l_dummy wf_item_attribute_values.text_value%TYPE;

5998: p_result IN OUT NOCOPY VARCHAR2) IS
5999:
6000: l_credit_memo_number wf_item_attribute_values.text_value%TYPE;
6001: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
6002: l_dummy wf_item_attribute_values.text_value%TYPE;
6003: l_on_account BOOLEAN DEFAULT FALSE;
6004:
6005: -- If the previous customer trx id is null then
6006: -- the credit memo is an on account credit memo.

Line 6072: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;

6068: p_actid IN NUMBER,
6069: p_funcmode IN VARCHAR2,
6070: p_result IN OUT NOCOPY VARCHAR2) IS
6071:
6072: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;
6073: l_collector_user_name wf_item_attribute_values.text_value%TYPE;
6074:
6075: BEGIN
6076:

Line 6073: l_collector_user_name wf_item_attribute_values.text_value%TYPE;

6069: p_funcmode IN VARCHAR2,
6070: p_result IN OUT NOCOPY VARCHAR2) IS
6071:
6072: l_requestor_user_name wf_item_attribute_values.text_value%TYPE;
6073: l_collector_user_name wf_item_attribute_values.text_value%TYPE;
6074:
6075: BEGIN
6076:
6077: ----------------------------------------------------------