APPS.AR_INVOICE_TABLE_HANDLER dependencies on RA_CUSTOMER_TRX_LINES

Line 375: delete from ra_customer_trx_lines where customer_trx_id = p_customer_trx_id;

371:
372: arp_etax_invapi_util.cleanup_tax(p_customer_trx_id);
373:
374: delete from ra_customer_trx where customer_trx_id = p_customer_trx_id;
375: delete from ra_customer_trx_lines where customer_trx_id = p_customer_trx_id;
376: delete from ra_cust_trx_line_gl_dist where customer_trx_id = p_customer_trx_id;
377: delete from ar_payment_schedules where customer_trx_id = p_customer_trx_id;
378: delete from RA_CUST_TRX_LINE_SALESREPS where customer_trx_id = p_customer_trx_id;
379:

Line 409: delete from ra_customer_trx_lines

405: from ar_trx_errors_gt err,
406: ar_trx_header_gt th
407: where err.trx_header_id = th.trx_header_id);
408:
409: delete from ra_customer_trx_lines
410: where customer_trx_id in (
411: select distinct th.customer_trx_id
412: from ar_trx_errors_gt err,
413: ar_trx_header_gt th

Line 463: l_tax_line_rec ra_customer_trx_lines%rowtype;

459: l_gross_unit_selling_price number;
460: l_recalculate_tax_flag boolean;
461: l_status1 varchar2(100);
462: l_status varchar2(100);
463: l_tax_line_rec ra_customer_trx_lines%rowtype;
464: l_freight_line_rec ra_customer_trx_lines%rowtype;
465: l_ct_reference ra_customer_trx.ct_reference%type;
466: l_requery_tax_if_visible boolean;
467: l_batch_id NUMBER;

Line 464: l_freight_line_rec ra_customer_trx_lines%rowtype;

460: l_recalculate_tax_flag boolean;
461: l_status1 varchar2(100);
462: l_status varchar2(100);
463: l_tax_line_rec ra_customer_trx_lines%rowtype;
464: l_freight_line_rec ra_customer_trx_lines%rowtype;
465: l_ct_reference ra_customer_trx.ct_reference%type;
466: l_requery_tax_if_visible boolean;
467: l_batch_id NUMBER;
468: lc_request_id VARCHAR2(40);