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

Line 9: p_line_credits_flag IN ra_cm_requests.line_credits_flag%type,

5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
6:
7: FUNCTION ar_request_cm(
8: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
9: p_line_credits_flag IN ra_cm_requests.line_credits_flag%type,
10: p_line_amount IN number,
11: p_tax_amount IN number,
12: p_freight_amount IN number,
13: p_cm_lines_tbl IN Cm_Line_Tbl_Type_Cover,

Line 16: p_url IN ra_cm_requests.url%TYPE,

12: p_freight_amount IN number,
13: p_cm_lines_tbl IN Cm_Line_Tbl_Type_Cover,
14: p_cm_reason_code IN varchar2,
15: p_comments IN varchar2,
16: p_url IN ra_cm_requests.url%TYPE,
17: p_transaction_url IN ra_cm_requests.transaction_url%TYPE,
18: p_trans_act_url IN ra_cm_requests.activities_url%TYPE,
19: p_orig_trx_number IN varchar2,
20: p_tax_ex_cert_num IN varchar2,

Line 17: p_transaction_url IN ra_cm_requests.transaction_url%TYPE,

13: p_cm_lines_tbl IN Cm_Line_Tbl_Type_Cover,
14: p_cm_reason_code IN varchar2,
15: p_comments IN varchar2,
16: p_url IN ra_cm_requests.url%TYPE,
17: p_transaction_url IN ra_cm_requests.transaction_url%TYPE,
18: p_trans_act_url IN ra_cm_requests.activities_url%TYPE,
19: p_orig_trx_number IN varchar2,
20: p_tax_ex_cert_num IN varchar2,
21: p_skip_workflow_flag IN VARCHAR2,

Line 18: p_trans_act_url IN ra_cm_requests.activities_url%TYPE,

14: p_cm_reason_code IN varchar2,
15: p_comments IN varchar2,
16: p_url IN ra_cm_requests.url%TYPE,
17: p_transaction_url IN ra_cm_requests.transaction_url%TYPE,
18: p_trans_act_url IN ra_cm_requests.activities_url%TYPE,
19: p_orig_trx_number IN varchar2,
20: p_tax_ex_cert_num IN varchar2,
21: p_skip_workflow_flag IN VARCHAR2,
22: p_trx_number IN ra_customer_trx.trx_number%type DEFAULT NULL,

Line 55: l_url ra_cm_requests.url%TYPE;

51:
52: l_run_dispute_amount number; /*12998583-M1*/
53: l_max_seq number;
54:
55: l_url ra_cm_requests.url%TYPE;
56: l_status varchar2(255);
57: l_profile_value fnd_profile_option_values.profile_option_value%TYPE;
58: /*Bug 5481525 variables to hold status of CM creation*/
59: l_credit_memo_id number;

Line 104: select ra_cm_requests_s.nextval

100: /*-----------------------------------------+
101: | Get the unique identifier for request_id|
102: +-----------------------------------------*/
103:
104: select ra_cm_requests_s.nextval
105: into l_request_id
106: from sys.dual;
107:
108:

Line 128: INSERT INTO ra_cm_requests

124: | Insert Record into Request Table |
125: +-----------------------------------------*/
126:
127: /*4556000-4606558 added additional columns*/
128: INSERT INTO ra_cm_requests
129: (request_id,
130: customer_trx_id,
131: cm_customer_trx_id,
132: url,

Line 464: UPDATE ra_cm_requests

460: ELSE
461: l_dispute_amount := l_total_amount;
462: END IF;
463:
464: UPDATE ra_cm_requests
465: SET total_amount = l_dispute_amount
466: WHERE request_id = l_request_id;
467:
468:

Line 568: from ra_cm_requests

564: l_credit_memo_id :=-99;
565: begin
566: select cm_customer_trx_id
567: into l_credit_memo_id
568: from ra_cm_requests
569: where request_id = l_request_id;
570: exception
571: when others then
572: l_result := 'FALSE';

Line 575: update ra_cm_requests

571: when others then
572: l_result := 'FALSE';
573: end;
574:
575: update ra_cm_requests
576: set status= DECODE(nvl(l_credit_memo_id,-99),-99,'APPROVED_PEND_COMP','COMPLETE'),
577: approval_date = SYSDATE,
578: last_updated_by = arp_global.last_updated_by,
579: last_update_date = arp_global.last_update_date,

Line 628: p_request_id IN ra_cm_requests.request_id%type,

624:
625: -- bug 2290738 : added p_status to capture error status
626:
627: PROCEDURE ar_autocreate_cm(
628: p_request_id IN ra_cm_requests.request_id%type,
629: p_batch_source_name IN ra_batch_sources.name%type,
630: p_credit_method_rules IN varchar2,
631: p_credit_method_installments IN varchar2,
632: p_trx_number IN ra_customer_trx.trx_number%type DEFAULT NULL,

Line 672: l_dispute_date ra_cm_requests.dispute_date%type;

668: pqa_attribute_rec pq_attribute_rec_type;
669: pqa_interface_attribute_rec pq_interface_rec_type;
670: pqa_global_attribute_rec pq_global_attribute_rec_type;
671:
672: l_dispute_date ra_cm_requests.dispute_date%type;
673: l_responsibility_id ra_cm_requests.responsibility_id%type;
674:
675: CURSOR line_cur IS
676: SELECT customer_trx_line_id, extended_amount, quantity, price,

Line 673: l_responsibility_id ra_cm_requests.responsibility_id%type;

669: pqa_interface_attribute_rec pq_interface_rec_type;
670: pqa_global_attribute_rec pq_global_attribute_rec_type;
671:
672: l_dispute_date ra_cm_requests.dispute_date%type;
673: l_responsibility_id ra_cm_requests.responsibility_id%type;
674:
675: CURSOR line_cur IS
676: SELECT customer_trx_line_id, extended_amount, quantity, price,
677: INTERFACE_LINE_CONTEXT, INTERFACE_LINE_ATTRIBUTE1, INTERFACE_LINE_ATTRIBUTE2,

Line 785: from ra_cm_requests

781: pqa_global_attribute_rec.global_attribute24, pqa_global_attribute_rec.global_attribute25,
782: pqa_global_attribute_rec.global_attribute26, pqa_global_attribute_rec.global_attribute27,
783: pqa_global_attribute_rec.global_attribute28, pqa_global_attribute_rec.global_attribute29,
784: pqa_global_attribute_rec.global_attribute30, l_dispute_date, l_responsibility_id /*Bug 8832584*/
785: from ra_cm_requests
786: where request_id = p_request_id;
787:
788: /* Bug 8832584 */
789: IF PG_DEBUG in ('Y', 'C') THEN

Line 790: arp_util.debug('Responsibility Id stored in ra_cm_requests table : ' || l_responsibility_id);

786: where request_id = p_request_id;
787:
788: /* Bug 8832584 */
789: IF PG_DEBUG in ('Y', 'C') THEN
790: arp_util.debug('Responsibility Id stored in ra_cm_requests table : ' || l_responsibility_id);
791: END IF;
792:
793: IF l_responsibility_id IS NOT NULL THEN
794:

Line 1206: UPDATE ra_cm_requests

1202:
1203: END IF;
1204:
1205: IF l_cm_customer_trx_id IS NOT NULL THEN
1206: UPDATE ra_cm_requests
1207: SET cm_customer_trx_id = l_cm_customer_trx_id
1208: WHERE request_id = p_request_id;
1209: END IF;
1210:

Line 1239: update ra_cm_requests_all

1235: /* bug 8830917*/
1236: if l_itemtype = 'ARCMREQ' OR l_itemtype = 'ARAMECM' then
1237:
1238: begin
1239: update ra_cm_requests_all
1240: set status = 'CANCELLED'
1241: where request_id = l_itemkey;
1242: exception
1243: when no_data_found then