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 145: FROM ra_cm_requests_all

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

Line 976: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

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;
978: l_internal_comment VARCHAR2(1760) DEFAULT NULL; /*7367350*/
979: l_employee_id number ; -- bug 7559456
980:

Line 977: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%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;
978: l_internal_comment VARCHAR2(1760) DEFAULT NULL; /*7367350*/
979: l_employee_id number ; -- bug 7559456
980:
981: -- bug 7559456

Line 1293: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

1289: l_freight_amount NUMBER;
1290: l_created_by NUMBER;
1291: l_line_credit_flag VARCHAR2(1);
1292: l_tax_disclaimer VARCHAR2(250);
1293: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
1294: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
1295:
1296: CURSOR c IS
1297: SELECT r.request_id,

Line 1294: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;

1290: l_created_by NUMBER;
1291: l_line_credit_flag VARCHAR2(1);
1292: l_tax_disclaimer VARCHAR2(250);
1293: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
1294: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
1295:
1296: CURSOR c IS
1297: SELECT r.request_id,
1298: r.customer_trx_id,

Line 1311: FROM ar_lookups l, ra_cm_requests r

1307: r.freight_amount,
1308: r.ORIG_TRX_NUMBER,
1309: r.TAX_EX_CERT_NUM,
1310: r.internal_comment
1311: FROM ar_lookups l, ra_cm_requests r
1312: WHERE r.request_id = p_item_key
1313: AND r.cm_reason_code = l.lookup_code
1314: AND l.lookup_type = 'CREDIT_MEMO_REASON';
1315:

Line 1482: l_request_url ra_cm_requests.url%TYPE;

1478: l_bill_to_customer_number VARCHAR2(30);
1479: l_ship_to_customer_number VARCHAR2(30);
1480: l_ship_to_customer_name VARCHAR2(50);
1481: l_trx_number VARCHAR2(20);
1482: l_request_url ra_cm_requests.url%TYPE;
1483: l_url ra_cm_requests.url%TYPE;
1484: l_request_id NUMBER;
1485: l_trans_url ra_cm_requests.transaction_url%TYPE;
1486: l_act_url ra_cm_requests.activities_url%TYPE;

Line 1483: l_url ra_cm_requests.url%TYPE;

1479: l_ship_to_customer_number VARCHAR2(30);
1480: l_ship_to_customer_name VARCHAR2(50);
1481: l_trx_number VARCHAR2(20);
1482: l_request_url ra_cm_requests.url%TYPE;
1483: l_url ra_cm_requests.url%TYPE;
1484: l_request_id NUMBER;
1485: l_trans_url ra_cm_requests.transaction_url%TYPE;
1486: l_act_url ra_cm_requests.activities_url%TYPE;
1487: wf_flag VARCHAR2(1) := 'Y';

Line 1485: l_trans_url ra_cm_requests.transaction_url%TYPE;

1481: l_trx_number VARCHAR2(20);
1482: l_request_url ra_cm_requests.url%TYPE;
1483: l_url ra_cm_requests.url%TYPE;
1484: l_request_id NUMBER;
1485: l_trans_url ra_cm_requests.transaction_url%TYPE;
1486: l_act_url ra_cm_requests.activities_url%TYPE;
1487: wf_flag VARCHAR2(1) := 'Y';
1488:
1489: CURSOR c IS

Line 1486: l_act_url ra_cm_requests.activities_url%TYPE;

1482: l_request_url ra_cm_requests.url%TYPE;
1483: l_url ra_cm_requests.url%TYPE;
1484: l_request_id NUMBER;
1485: l_trans_url ra_cm_requests.transaction_url%TYPE;
1486: l_act_url ra_cm_requests.activities_url%TYPE;
1487: wf_flag VARCHAR2(1) := 'Y';
1488:
1489: CURSOR c IS
1490: SELECT url, transaction_url, activities_url

Line 1491: FROM ra_cm_requests

1487: wf_flag VARCHAR2(1) := 'Y';
1488:
1489: CURSOR c IS
1490: SELECT url, transaction_url, activities_url
1491: FROM ra_cm_requests
1492: WHERE request_id = p_item_key;
1493:
1494: BEGIN
1495: restore_context(p_item_key);

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

3608: p_item_type,
3609: p_item_key,
3610: 'WORKFLOW_DOCUMENT_ID');
3611:
3612: -- the amount stored in ra_cm_requests is the Credit amount, it needs to
3613: -- be negated to get the correct dispute amount
3614: SELECT total_amount * -1
3615: into remove_from_dispute_amt
3616: from ra_cm_requests

Line 3616: from ra_cm_requests

3612: -- the amount stored in ra_cm_requests is the Credit amount, it needs to
3613: -- be negated to get the correct dispute amount
3614: SELECT total_amount * -1
3615: into remove_from_dispute_amt
3616: from ra_cm_requests
3617: WHERE request_id = l_request_id;
3618:
3619:
3620: /*4432212 */

Line 4576: update ra_cm_requests

4572: l_note_text,
4573: l_note_id);
4574:
4575: -- Bug 1908252 : update last_update* fields
4576: update ra_cm_requests
4577: set status = 'COMPLETE',
4578: approval_date = SYSDATE,
4579: last_updated_by = l_last_updated_by,
4580: last_update_date = SYSDATE,

Line 4962: UPDATE ra_cm_requests

4958: l_note_id);
4959:
4960: -- Bug 1908252 : update last_update* fields
4961:
4962: UPDATE ra_cm_requests
4963: SET status = 'NOT_APPROVED',
4964: last_updated_by = l_last_updated_by,
4965: last_update_date = SYSDATE,
4966: last_update_login = l_last_update_login

Line 5492: FROM ra_cm_requests

5488:
5489: BEGIN
5490:
5491: SELECT cm_customer_trx_id INTO l_credit_memo_id
5492: FROM ra_cm_requests
5493: WHERE request_id = l_request_id;
5494:
5495: EXCEPTION
5496: WHEN OTHERS THEN

Line 5527: UPDATE ra_cm_requests

5523: end loop;
5524: -- End bug 11775249
5525:
5526: -- Bug 1908252 : update last_update* fields
5527: UPDATE ra_cm_requests
5528: SET status='COMPLETE',
5529: approval_date = SYSDATE,
5530: last_updated_by = l_last_updated_by,
5531: last_update_date = SYSDATE,

Line 5580: UPDATE ra_cm_requests

5576: || l_last_updated_by || ' '
5577: || l_last_update_login;
5578:
5579:
5580: UPDATE ra_cm_requests
5581: SET status='APPROVED_PEND_COMP',
5582: approval_date = SYSDATE,
5583: last_updated_by = l_last_updated_by,
5584: last_update_date = SYSDATE,