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: l_employee_id number; -- bug 7559456

Line 439: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;

435: l_freight_amount number;
436: l_created_by number;
437: l_line_credit_flag varchar2(1);
438: l_tax_disclaimer varchar2(250);
439: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
440: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
441:
442:
443:

Line 440: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;

436: l_created_by number;
437: l_line_credit_flag varchar2(1);
438: l_tax_disclaimer varchar2(250);
439: l_orig_trx_number ra_cm_requests_all.orig_trx_number%TYPE;
440: l_tax_ex_cert_num ra_cm_requests_all.tax_ex_cert_num%TYPE;
441:
442:
443:
444: BEGIN

Line 479: ra_cm_requests r

475: l_orig_trx_number,
476: l_tax_ex_cert_num,
477: p_internal_comment
478: from ar_lookups l,
479: ra_cm_requests r
480: where r.request_id = p_item_key
481: and r.cm_reason_code = l.lookup_code
482: and l.lookup_type = 'CREDIT_MEMO_REASON';
483:

Line 601: l_request_url ra_cm_requests.url%TYPE;

597: l_bill_to_customer_number varchar2(30); /* Bug Fix 1882580 */
598: l_ship_to_customer_number varchar2(30);
599: l_ship_to_customer_name varchar2(50);
600: l_trx_number varchar2(20);
601: l_request_url ra_cm_requests.url%TYPE;
602: l_url ra_cm_requests.url%TYPE;
603: l_request_id number;
604: l_trans_url ra_cm_requests.transaction_url%TYPE;
605: l_act_url ra_cm_requests.activities_url%TYPE;

Line 602: l_url ra_cm_requests.url%TYPE;

598: l_ship_to_customer_number varchar2(30);
599: l_ship_to_customer_name varchar2(50);
600: l_trx_number varchar2(20);
601: l_request_url ra_cm_requests.url%TYPE;
602: l_url ra_cm_requests.url%TYPE;
603: l_request_id number;
604: l_trans_url ra_cm_requests.transaction_url%TYPE;
605: l_act_url ra_cm_requests.activities_url%TYPE;
606: wf_flag varchar2(1) := 'Y';

Line 604: l_trans_url ra_cm_requests.transaction_url%TYPE;

600: l_trx_number varchar2(20);
601: l_request_url ra_cm_requests.url%TYPE;
602: l_url ra_cm_requests.url%TYPE;
603: l_request_id number;
604: l_trans_url ra_cm_requests.transaction_url%TYPE;
605: l_act_url ra_cm_requests.activities_url%TYPE;
606: wf_flag varchar2(1) := 'Y';
607:
608:

Line 605: l_act_url ra_cm_requests.activities_url%TYPE;

601: l_request_url ra_cm_requests.url%TYPE;
602: l_url ra_cm_requests.url%TYPE;
603: l_request_id number;
604: l_trans_url ra_cm_requests.transaction_url%TYPE;
605: l_act_url ra_cm_requests.activities_url%TYPE;
606: wf_flag varchar2(1) := 'Y';
607:
608:
609: begin

Line 727: from ra_cm_requests

723: 'WORKFLOW_DOCUMENT_ID');
724:
725: select url
726: into l_url
727: from ra_cm_requests
728: where request_id = p_item_key;
729:
730: l_request_url := l_url;
731:

Line 743: from ra_cm_requests

739: -- set the transaction number URL site.
740:
741: select transaction_url
742: into l_trans_url
743: from ra_cm_requests
744: where request_id = p_item_key;
745:
746:
747: WF_ENGINE.SetItemAttrText(p_item_type,

Line 755: from ra_cm_requests

751:
752:
753: select activities_url
754: into l_act_url
755: from ra_cm_requests
756: where request_id =p_item_key;
757:
758:
759: WF_ENGINE.SetItemAttrText(p_item_type,

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

2947: p_item_type,
2948: p_item_key,
2949: 'WORKFLOW_DOCUMENT_ID');
2950:
2951: -- the amount stored in ra_cm_requests is a negative credit amount, it needs to
2952: -- be negated to get the correct dispute amount
2953: SELECT total_amount * -1
2954: into remove_from_dispute_amt
2955: from ra_cm_requests

Line 2955: from ra_cm_requests

2951: -- the amount stored in ra_cm_requests is a negative credit amount, it needs to
2952: -- be negated to get the correct dispute amount
2953: SELECT total_amount * -1
2954: into remove_from_dispute_amt
2955: from ra_cm_requests
2956: WHERE request_id = l_request_id;
2957:
2958: /*4220382 */
2959: BEGIN

Line 3855: update ra_cm_requests

3851: l_note_text,
3852: l_note_id);
3853:
3854: /* Bug 1908252 : update last_update* fields */
3855: update ra_cm_requests
3856: set status = 'COMPLETE',
3857: approval_date = SYSDATE,
3858: last_updated_by = l_last_updated_by,
3859: last_update_date = SYSDATE,

Line 4175: UPDATE ra_cm_requests

4171: l_note_id);
4172:
4173: /* Bug 1908252 : update last_update* fields */
4174:
4175: UPDATE ra_cm_requests
4176: SET status = 'NOT_APPROVED',
4177: last_updated_by = l_last_updated_by,
4178: last_update_date = SYSDATE,
4179: last_update_login = l_last_update_login

Line 4632: from ra_cm_requests

4628:
4629: begin
4630: select cm_customer_trx_id
4631: into l_credit_memo_id
4632: from ra_cm_requests
4633: where request_id = l_request_id;
4634: exception
4635: when others then
4636: p_result := 'COMPLETE:F';

Line 4666: update ra_cm_requests

4662: end loop;
4663: --End bug 11775249
4664:
4665: /* Bug 1908252 : update last_update* fields */
4666: update ra_cm_requests
4667: set status='COMPLETE',
4668: approval_date = SYSDATE,
4669: last_updated_by = l_last_updated_by,
4670: last_update_date = SYSDATE,

Line 4710: update ra_cm_requests

4706: 'CM_CREATION_ERROR',
4707: l_cm_creation_error);
4708:
4709: /* Bug 1908252 : update last_update* fields */
4710: update ra_cm_requests
4711: set status='APPROVED_PEND_COMP',
4712: approval_date = SYSDATE,
4713: last_updated_by = l_last_updated_by,
4714: last_update_date = SYSDATE,

Line 4911: from ra_cm_requests_all

4907:
4908: BEGIN
4909:
4910: select org_id into l_org_id
4911: from ra_cm_requests_all
4912: where request_id = p_item_key;
4913: ----------------------------------------------------------
4914: l_debug_mesg := 'Get the org_id for the credit memo request';
4915: ----------------------------------------------------------