APPS.ARW_CMREQ_COVER dependencies on RA_CUSTOMER_TRX

Line 8: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

4:
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,

Line 22: p_trx_number IN ra_customer_trx.trx_number%type DEFAULT NULL,

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,
23: p_credit_method_installments IN VARCHAR2,
24: p_credit_method_rules IN VARCHAR2,
25: p_batch_source_name IN VARCHAR2,
26: /*4556000-4606558*/

Line 632: p_trx_number IN ra_customer_trx.trx_number%type DEFAULT NULL,

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,
633: p_error_tab OUT NOCOPY arp_trx_validate.Message_Tbl_Type,
634: p_status OUT NOCOPY varchar2,
635: p_passed_gl_date IN DATE DEFAULT NULL /*Bug 9536019*/)
636: IS

Line 653: l_trx_header_rec ra_customer_trx%rowtype;

649: l_batch_source_id number;
650: l_cm_cust_trx_type_id number;
651: l_batch_source_name varchar2(30);
652: l_trx_batch_rec ra_batches%rowtype;
653: l_trx_header_rec ra_customer_trx%rowtype;
654: l_cm_header_rec ra_customer_trx%rowtype;
655: p_cm_header_rec ra_customer_trx%rowtype;
656: l_trx_rec_gl_date DATE;
657: l_status varchar2(255);

Line 654: l_cm_header_rec ra_customer_trx%rowtype;

650: l_cm_cust_trx_type_id number;
651: l_batch_source_name varchar2(30);
652: l_trx_batch_rec ra_batches%rowtype;
653: l_trx_header_rec ra_customer_trx%rowtype;
654: l_cm_header_rec ra_customer_trx%rowtype;
655: p_cm_header_rec ra_customer_trx%rowtype;
656: l_trx_rec_gl_date DATE;
657: l_status varchar2(255);
658: l_trx_number ra_customer_trx.trx_number%type;

Line 655: p_cm_header_rec ra_customer_trx%rowtype;

651: l_batch_source_name varchar2(30);
652: l_trx_batch_rec ra_batches%rowtype;
653: l_trx_header_rec ra_customer_trx%rowtype;
654: l_cm_header_rec ra_customer_trx%rowtype;
655: p_cm_header_rec ra_customer_trx%rowtype;
656: l_trx_rec_gl_date DATE;
657: l_status varchar2(255);
658: l_trx_number ra_customer_trx.trx_number%type;
659: l_computed_tax_percent number;

Line 658: l_trx_number ra_customer_trx.trx_number%type;

654: l_cm_header_rec ra_customer_trx%rowtype;
655: p_cm_header_rec ra_customer_trx%rowtype;
656: l_trx_rec_gl_date DATE;
657: l_status varchar2(255);
658: l_trx_number ra_customer_trx.trx_number%type;
659: l_computed_tax_percent number;
660: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
661: l_compute_tax_flag varchar2(1);
662: -- TDEY : bug 1272415 changed type of l_credit_line_table

Line 660: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;

656: l_trx_rec_gl_date DATE;
657: l_status varchar2(255);
658: l_trx_number ra_customer_trx.trx_number%type;
659: l_computed_tax_percent number;
660: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
661: l_compute_tax_flag varchar2(1);
662: -- TDEY : bug 1272415 changed type of l_credit_line_table
663: -- to remove trx api dependency
664: l_credit_line_table arw_cm_cover.credit_lines_table_type;

Line 817: from ra_customer_trx

813: credited */
814:
815: select *
816: into l_trx_header_rec
817: from ra_customer_trx
818: where customer_trx_id = l_customer_trx_id;
819:
820: /* 5041175 - obsoleting ar_transaction_pub and associated
821: routines. Replaced with inline sql logic to fetch