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.ARP_CMREQ_WF dependencies on RA_CM_REQUESTS

Line 57: FROM ra_cm_requests_all

53: p_result IN OUT NOCOPY VARCHAR2) IS
54:
55: CURSOR org IS
56: SELECT org_id
57: FROM ra_cm_requests_all
58: WHERE request_id = p_item_key;
59:
60: l_debug_mesg VARCHAR2(240);
61: l_org_id ra_cm_requests_all.org_id%TYPE;

Line 61: l_org_id ra_cm_requests_all.org_id%TYPE;

57: FROM ra_cm_requests_all
58: WHERE request_id = p_item_key;
59:
60: l_debug_mesg VARCHAR2(240);
61: l_org_id ra_cm_requests_all.org_id%TYPE;
62:
63: BEGIN
64:
65: OPEN org;

Line 150: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

146: l_requestor_user_name varchar2(100);
147: l_requestor_display_name varchar2(100);
148: /* Bug 3206020 Changed comments width from 240 to 1760. */
149: l_comments varchar2(1760);
150: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
151: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
152:
153: /*7367350 storing internal comment and inserting notes*/
154: l_internal_comment VARCHAR2(1760) DEFAULT NULL;

Line 151: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;

147: l_requestor_display_name varchar2(100);
148: /* Bug 3206020 Changed comments width from 240 to 1760. */
149: l_comments varchar2(1760);
150: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
151: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
152:
153: /*7367350 storing internal comment and inserting notes*/
154: l_internal_comment VARCHAR2(1760) DEFAULT NULL;
155:

Line 401: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

397: l_freight_amount number;
398: l_created_by number;
399: l_line_credit_flag varchar2(1);
400: l_tax_disclaimer varchar2(250);
401: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
402: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
403:
404:
405:

Line 402: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;

398: l_created_by number;
399: l_line_credit_flag varchar2(1);
400: l_tax_disclaimer varchar2(250);
401: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
402: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
403:
404:
405:
406: BEGIN

Line 441: ra_cm_requests r

437: l_orig_trx_number,
438: l_tax_ex_cert_num,
439: p_internal_comment
440: from ar_lookups l,
441: ra_cm_requests r
442: where r.request_id = p_item_key
443: and r.cm_reason_code = l.lookup_code
444: and l.lookup_type = 'CREDIT_MEMO_REASON';
445:

Line 560: l_request_url ra_cm_requests.url%TYPE;

556: l_bill_to_customer_number varchar2(30); /* Bug Fix 1882580 */
557: l_ship_to_customer_number varchar2(30);
558: l_ship_to_customer_name varchar2(50);
559: l_trx_number varchar2(20);
560: l_request_url ra_cm_requests.url%TYPE;
561: l_url ra_cm_requests.url%TYPE;
562: l_request_id number;
563: l_trans_url ra_cm_requests.transaction_url%TYPE;
564: l_act_url ra_cm_requests.activities_url%TYPE;

Line 561: l_url ra_cm_requests.url%TYPE;

557: l_ship_to_customer_number varchar2(30);
558: l_ship_to_customer_name varchar2(50);
559: l_trx_number varchar2(20);
560: l_request_url ra_cm_requests.url%TYPE;
561: l_url ra_cm_requests.url%TYPE;
562: l_request_id number;
563: l_trans_url ra_cm_requests.transaction_url%TYPE;
564: l_act_url ra_cm_requests.activities_url%TYPE;
565: wf_flag varchar2(1) := 'Y';

Line 563: l_trans_url ra_cm_requests.transaction_url%TYPE;

559: l_trx_number varchar2(20);
560: l_request_url ra_cm_requests.url%TYPE;
561: l_url ra_cm_requests.url%TYPE;
562: l_request_id number;
563: l_trans_url ra_cm_requests.transaction_url%TYPE;
564: l_act_url ra_cm_requests.activities_url%TYPE;
565: wf_flag varchar2(1) := 'Y';
566:
567:

Line 564: l_act_url ra_cm_requests.activities_url%TYPE;

560: l_request_url ra_cm_requests.url%TYPE;
561: l_url ra_cm_requests.url%TYPE;
562: l_request_id number;
563: l_trans_url ra_cm_requests.transaction_url%TYPE;
564: l_act_url ra_cm_requests.activities_url%TYPE;
565: wf_flag varchar2(1) := 'Y';
566:
567:
568: begin

Line 686: from ra_cm_requests

682: 'WORKFLOW_DOCUMENT_ID');
683:
684: select url
685: into l_url
686: from ra_cm_requests
687: where request_id = p_item_key;
688:
689: l_request_url := l_url;
690:

Line 702: from ra_cm_requests

698: -- set the transaction number URL site.
699:
700: select transaction_url
701: into l_trans_url
702: from ra_cm_requests
703: where request_id = p_item_key;
704:
705:
706: WF_ENGINE.SetItemAttrText(p_item_type,

Line 714: from ra_cm_requests

710:
711:
712: select activities_url
713: into l_act_url
714: from ra_cm_requests
715: where request_id =p_item_key;
716:
717:
718: WF_ENGINE.SetItemAttrText(p_item_type,

Line 2899: -- the amount stored in ra_cm_requests is a negative credit amount, it needs to

2895: p_item_type,
2896: p_item_key,
2897: 'WORKFLOW_DOCUMENT_ID');
2898:
2899: -- the amount stored in ra_cm_requests is a negative credit amount, it needs to
2900: -- be negated to get the correct dispute amount
2901: SELECT total_amount * -1
2902: into remove_from_dispute_amt
2903: from ra_cm_requests

Line 2903: from ra_cm_requests

2899: -- the amount stored in ra_cm_requests is a negative credit amount, it needs to
2900: -- be negated to get the correct dispute amount
2901: SELECT total_amount * -1
2902: into remove_from_dispute_amt
2903: from ra_cm_requests
2904: WHERE request_id = l_request_id;
2905:
2906: /*4220382 */
2907: BEGIN

Line 3748: update ra_cm_requests

3744: l_note_text,
3745: l_note_id);
3746:
3747: /* Bug 1908252 : update last_update* fields */
3748: update ra_cm_requests
3749: set status = 'COMPLETE',
3750: approval_date = SYSDATE,
3751: last_updated_by = l_last_updated_by,
3752: last_update_date = SYSDATE,

Line 4068: UPDATE ra_cm_requests

4064: l_note_id);
4065:
4066: /* Bug 1908252 : update last_update* fields */
4067:
4068: UPDATE ra_cm_requests
4069: SET status = 'NOT_APPROVED',
4070: last_updated_by = l_last_updated_by,
4071: last_update_date = SYSDATE,
4072: last_update_login = l_last_update_login

Line 4510: from ra_cm_requests

4506:
4507: begin
4508: select cm_customer_trx_id
4509: into l_credit_memo_id
4510: from ra_cm_requests
4511: where request_id = l_request_id;
4512: exception
4513: when others then
4514: p_result := 'COMPLETE:F';

Line 4530: update ra_cm_requests

4526: IF (l_credit_memo_id is not null) THEN
4527: p_result := 'COMPLETE:T';
4528:
4529: /* Bug 1908252 : update last_update* fields */
4530: update ra_cm_requests
4531: set status='COMPLETE',
4532: approval_date = SYSDATE,
4533: last_updated_by = l_last_updated_by,
4534: last_update_date = SYSDATE,

Line 4574: update ra_cm_requests

4570: 'CM_CREATION_ERROR',
4571: l_cm_creation_error);
4572:
4573: /* Bug 1908252 : update last_update* fields */
4574: update ra_cm_requests
4575: set status='APPROVED_PEND_COMP',
4576: approval_date = SYSDATE,
4577: last_updated_by = l_last_updated_by,
4578: last_update_date = SYSDATE,

Line 4775: from ra_cm_requests_all

4771:
4772: BEGIN
4773:
4774: select org_id into l_org_id
4775: from ra_cm_requests_all
4776: where request_id = p_item_key;
4777: ----------------------------------------------------------
4778: l_debug_mesg := 'Get the org_id for the credit memo request';
4779: ----------------------------------------------------------