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 RA_CM_REQUESTS

Line 25: FROM ra_cm_requests_all

21: p_result IN OUT NOCOPY VARCHAR2) IS
22:
23: CURSOR org IS
24: SELECT org_id
25: FROM ra_cm_requests_all
26: WHERE request_id = p_item_key;
27:
28: l_debug_mesg VARCHAR2(240);
29: l_org_id ra_cm_requests_all.org_id%TYPE;

Line 29: l_org_id ra_cm_requests_all.org_id%TYPE;

25: FROM ra_cm_requests_all
26: WHERE request_id = p_item_key;
27:
28: l_debug_mesg VARCHAR2(240);
29: l_org_id ra_cm_requests_all.org_id%TYPE;
30:
31: BEGIN
32:
33: OPEN org;

Line 143: FROM ra_cm_requests_all

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
144: WHERE request_id = p_item_key;
145:
146: BEGIN
147:

Line 974: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

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;
976: l_internal_comment VARCHAR2(1760) DEFAULT NULL; /*7367350*/
977:
978:

Line 975: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%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;
976: l_internal_comment VARCHAR2(1760) DEFAULT NULL; /*7367350*/
977:
978:
979: CURSOR c1 is

Line 1254: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

1250: l_freight_amount NUMBER;
1251: l_created_by NUMBER;
1252: l_line_credit_flag VARCHAR2(1);
1253: l_tax_disclaimer VARCHAR2(250);
1254: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
1255: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
1256:
1257: CURSOR c IS
1258: SELECT r.request_id,

Line 1255: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;

1251: l_created_by NUMBER;
1252: l_line_credit_flag VARCHAR2(1);
1253: l_tax_disclaimer VARCHAR2(250);
1254: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
1255: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
1256:
1257: CURSOR c IS
1258: SELECT r.request_id,
1259: r.customer_trx_id,

Line 1272: FROM ar_lookups l, ra_cm_requests r

1268: r.freight_amount,
1269: r.ORIG_TRX_NUMBER,
1270: r.TAX_EX_CERT_NUM,
1271: r.internal_comment
1272: FROM ar_lookups l, ra_cm_requests r
1273: WHERE r.request_id = p_item_key
1274: AND r.cm_reason_code = l.lookup_code
1275: AND l.lookup_type = 'CREDIT_MEMO_REASON';
1276:

Line 1441: l_request_url ra_cm_requests.url%TYPE;

1437: l_bill_to_customer_number VARCHAR2(30);
1438: l_ship_to_customer_number VARCHAR2(30);
1439: l_ship_to_customer_name VARCHAR2(50);
1440: l_trx_number VARCHAR2(20);
1441: l_request_url ra_cm_requests.url%TYPE;
1442: l_url ra_cm_requests.url%TYPE;
1443: l_request_id NUMBER;
1444: l_trans_url ra_cm_requests.transaction_url%TYPE;
1445: l_act_url ra_cm_requests.activities_url%TYPE;

Line 1442: l_url ra_cm_requests.url%TYPE;

1438: l_ship_to_customer_number VARCHAR2(30);
1439: l_ship_to_customer_name VARCHAR2(50);
1440: l_trx_number VARCHAR2(20);
1441: l_request_url ra_cm_requests.url%TYPE;
1442: l_url ra_cm_requests.url%TYPE;
1443: l_request_id NUMBER;
1444: l_trans_url ra_cm_requests.transaction_url%TYPE;
1445: l_act_url ra_cm_requests.activities_url%TYPE;
1446: wf_flag VARCHAR2(1) := 'Y';

Line 1444: l_trans_url ra_cm_requests.transaction_url%TYPE;

1440: l_trx_number VARCHAR2(20);
1441: l_request_url ra_cm_requests.url%TYPE;
1442: l_url ra_cm_requests.url%TYPE;
1443: l_request_id NUMBER;
1444: l_trans_url ra_cm_requests.transaction_url%TYPE;
1445: l_act_url ra_cm_requests.activities_url%TYPE;
1446: wf_flag VARCHAR2(1) := 'Y';
1447:
1448: CURSOR c IS

Line 1445: l_act_url ra_cm_requests.activities_url%TYPE;

1441: l_request_url ra_cm_requests.url%TYPE;
1442: l_url ra_cm_requests.url%TYPE;
1443: l_request_id NUMBER;
1444: l_trans_url ra_cm_requests.transaction_url%TYPE;
1445: l_act_url ra_cm_requests.activities_url%TYPE;
1446: wf_flag VARCHAR2(1) := 'Y';
1447:
1448: CURSOR c IS
1449: SELECT url, transaction_url, activities_url

Line 1450: FROM ra_cm_requests

1446: wf_flag VARCHAR2(1) := 'Y';
1447:
1448: CURSOR c IS
1449: SELECT url, transaction_url, activities_url
1450: FROM ra_cm_requests
1451: WHERE request_id = p_item_key;
1452:
1453: BEGIN
1454:

Line 3560: -- the amount stored in ra_cm_requests is the Credit amount, it needs to

3556: p_item_type,
3557: p_item_key,
3558: 'WORKFLOW_DOCUMENT_ID');
3559:
3560: -- the amount stored in ra_cm_requests is the Credit amount, it needs to
3561: -- be negated to get the correct dispute amount
3562: SELECT total_amount * -1
3563: into remove_from_dispute_amt
3564: from ra_cm_requests

Line 3564: from ra_cm_requests

3560: -- the amount stored in ra_cm_requests is the Credit amount, it needs to
3561: -- be negated to get the correct dispute amount
3562: SELECT total_amount * -1
3563: into remove_from_dispute_amt
3564: from ra_cm_requests
3565: WHERE request_id = l_request_id;
3566:
3567:
3568: /*4432212 */

Line 4476: update ra_cm_requests

4472: l_note_text,
4473: l_note_id);
4474:
4475: -- Bug 1908252 : update last_update* fields
4476: update ra_cm_requests
4477: set status = 'COMPLETE',
4478: approval_date = SYSDATE,
4479: last_updated_by = l_last_updated_by,
4480: last_update_date = SYSDATE,

Line 4862: UPDATE ra_cm_requests

4858: l_note_id);
4859:
4860: -- Bug 1908252 : update last_update* fields
4861:
4862: UPDATE ra_cm_requests
4863: SET status = 'NOT_APPROVED',
4864: last_updated_by = l_last_updated_by,
4865: last_update_date = SYSDATE,
4866: last_update_login = l_last_update_login

Line 5377: FROM ra_cm_requests

5373:
5374: BEGIN
5375:
5376: SELECT cm_customer_trx_id INTO l_credit_memo_id
5377: FROM ra_cm_requests
5378: WHERE request_id = l_request_id;
5379:
5380: EXCEPTION
5381: WHEN OTHERS THEN

Line 5398: UPDATE ra_cm_requests

5394: IF (l_credit_memo_id is NOT NULL) THEN
5395: p_result := 'COMPLETE:T';
5396:
5397: -- Bug 1908252 : update last_update* fields
5398: UPDATE ra_cm_requests
5399: SET status='COMPLETE',
5400: approval_date = SYSDATE,
5401: last_updated_by = l_last_updated_by,
5402: last_update_date = SYSDATE,

Line 5451: UPDATE ra_cm_requests

5447: || l_last_updated_by || ' '
5448: || l_last_update_login;
5449:
5450:
5451: UPDATE ra_cm_requests
5452: SET status='APPROVED_PEND_COMP',
5453: approval_date = SYSDATE,
5454: last_updated_by = l_last_updated_by,
5455: last_update_date = SYSDATE,