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_credit_method_installments IN VARCHAR2,

Line 49: l_url ra_cm_requests.url%TYPE;

45: l_num_lines number;
46: l_total_amount number;
47: l_total_line_amount number;
48: l_dispute_amount number;
49: l_url ra_cm_requests.url%TYPE;
50: l_status varchar2(255);
51: l_profile_value fnd_profile_option_values.profile_option_value%TYPE;
52: /*Bug 5481525 variables to hold status of CM creation*/
53: l_credit_memo_id number;

Line 89: select ra_cm_requests_s.nextval

85: /*-----------------------------------------+
86: | Get the unique identifier for request_id|
87: +-----------------------------------------*/
88:
89: select ra_cm_requests_s.nextval
90: into l_request_id
91: from sys.dual;
92:
93:

Line 113: INSERT INTO ra_cm_requests

109: | Insert Record into Request Table |
110: +-----------------------------------------*/
111:
112: /*4556000-4606558 added additional columns*/
113: INSERT INTO ra_cm_requests
114: (request_id,
115: customer_trx_id,
116: cm_customer_trx_id,
117: url,

Line 447: UPDATE ra_cm_requests

443: ELSE
444: l_dispute_amount := l_total_amount;
445: END IF;
446:
447: UPDATE ra_cm_requests
448: SET total_amount = l_dispute_amount
449: WHERE request_id = l_request_id;
450:
451:

Line 520: from ra_cm_requests

516: l_credit_memo_id :=-99;
517: begin
518: select cm_customer_trx_id
519: into l_credit_memo_id
520: from ra_cm_requests
521: where request_id = l_request_id;
522: exception
523: when others then
524: l_result := 'FALSE';

Line 527: update ra_cm_requests

523: when others then
524: l_result := 'FALSE';
525: end;
526:
527: update ra_cm_requests
528: set status= DECODE(nvl(l_credit_memo_id,-99),-99,'APPROVED_PEND_COMP','COMPLETE'),
529: approval_date = SYSDATE,
530: last_updated_by = arp_global.last_updated_by,
531: last_update_date = arp_global.last_update_date,

Line 580: p_request_id IN ra_cm_requests.request_id%type,

576:
577: -- bug 2290738 : added p_status to capture error status
578:
579: PROCEDURE ar_autocreate_cm(
580: p_request_id IN ra_cm_requests.request_id%type,
581: p_batch_source_name IN ra_batch_sources.name%type,
582: p_credit_method_rules IN varchar2,
583: p_credit_method_installments IN varchar2,
584: p_error_tab OUT NOCOPY arp_trx_validate.Message_Tbl_Type,

Line 730: from ra_cm_requests

726: pqa_global_attribute_rec.global_attribute24, pqa_global_attribute_rec.global_attribute25,
727: pqa_global_attribute_rec.global_attribute26, pqa_global_attribute_rec.global_attribute27,
728: pqa_global_attribute_rec.global_attribute28, pqa_global_attribute_rec.global_attribute29,
729: pqa_global_attribute_rec.global_attribute30
730: from ra_cm_requests
731: where request_id = p_request_id;
732: --
733: -- TDEY 09/14/99 : defaulting l_computed_tax_amount to l_tax_amount
734: -- l_tax_amount is the amount of tax credit being

Line 1120: UPDATE ra_cm_requests

1116:
1117: END IF;
1118:
1119: IF l_cm_customer_trx_id IS NOT NULL THEN
1120: UPDATE ra_cm_requests
1121: SET cm_customer_trx_id = l_cm_customer_trx_id
1122: WHERE request_id = p_request_id;
1123: END IF;
1124:

Line 1153: update ra_cm_requests_all

1149:
1150: if l_itemtype = 'ARCMREQ' then
1151:
1152: begin
1153: update ra_cm_requests_all
1154: set status = 'CANCELLED'
1155: where request_id = l_itemkey;
1156: exception
1157: when no_data_found then