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_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 603: l_trx_header_rec ra_customer_trx%rowtype;

599: l_batch_source_id number;
600: l_cm_cust_trx_type_id number;
601: l_batch_source_name varchar2(30);
602: l_trx_batch_rec ra_batches%rowtype;
603: l_trx_header_rec ra_customer_trx%rowtype;
604: l_cm_header_rec ra_customer_trx%rowtype;
605: p_cm_header_rec ra_customer_trx%rowtype;
606: l_trx_rec_gl_date DATE;
607: l_status varchar2(255);

Line 604: l_cm_header_rec ra_customer_trx%rowtype;

600: l_cm_cust_trx_type_id number;
601: l_batch_source_name varchar2(30);
602: l_trx_batch_rec ra_batches%rowtype;
603: l_trx_header_rec ra_customer_trx%rowtype;
604: l_cm_header_rec ra_customer_trx%rowtype;
605: p_cm_header_rec ra_customer_trx%rowtype;
606: l_trx_rec_gl_date DATE;
607: l_status varchar2(255);
608: l_trx_number ra_customer_trx.trx_number%type;

Line 605: p_cm_header_rec ra_customer_trx%rowtype;

601: l_batch_source_name varchar2(30);
602: l_trx_batch_rec ra_batches%rowtype;
603: l_trx_header_rec ra_customer_trx%rowtype;
604: l_cm_header_rec ra_customer_trx%rowtype;
605: p_cm_header_rec ra_customer_trx%rowtype;
606: l_trx_rec_gl_date DATE;
607: l_status varchar2(255);
608: l_trx_number ra_customer_trx.trx_number%type;
609: l_computed_tax_percent number;

Line 608: l_trx_number ra_customer_trx.trx_number%type;

604: l_cm_header_rec ra_customer_trx%rowtype;
605: p_cm_header_rec ra_customer_trx%rowtype;
606: l_trx_rec_gl_date DATE;
607: l_status varchar2(255);
608: l_trx_number ra_customer_trx.trx_number%type;
609: l_computed_tax_percent number;
610: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
611: -- TDEY : bug 1272415 changed type of l_credit_line_table
612: -- to remove trx api dependency

Line 610: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;

606: l_trx_rec_gl_date DATE;
607: l_status varchar2(255);
608: l_trx_number ra_customer_trx.trx_number%type;
609: l_computed_tax_percent number;
610: l_computed_tax_amount ra_customer_trx_lines.extended_amount%type;
611: -- TDEY : bug 1272415 changed type of l_credit_line_table
612: -- to remove trx api dependency
613: l_credit_line_table arw_cm_cover.credit_lines_table_type;
614: i number :=0;

Line 744: from ra_customer_trx

740: credited */
741:
742: select *
743: into l_trx_header_rec
744: from ra_customer_trx
745: where customer_trx_id = l_customer_trx_id;
746:
747: /* 5041175 - obsoleting ar_transaction_pub and associated
748: routines. Replaced with inline sql logic to fetch