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.AR_INVOICE_TABLE_HANDLER dependencies on RA_CUSTOMER_TRX

Line 63: l_ct_reference ra_customer_trx.ct_reference%type;

59: p_batch_id IN NUMBER DEFAULT NULL,
60: x_errmsg OUT NOCOPY VARCHAR2,
61: x_return_status OUT NOCOPY VARCHAR2)
62: IS
63: l_ct_reference ra_customer_trx.ct_reference%type;
64: l_trx_number ra_customer_trx.trx_number%type;
65: l_org_id NUMBER;
66: l_org_str VARCHAR2(30);
67: l_trx_str VARCHAR2(2000);

Line 64: l_trx_number ra_customer_trx.trx_number%type;

60: x_errmsg OUT NOCOPY VARCHAR2,
61: x_return_status OUT NOCOPY VARCHAR2)
62: IS
63: l_ct_reference ra_customer_trx.ct_reference%type;
64: l_trx_number ra_customer_trx.trx_number%type;
65: l_org_id NUMBER;
66: l_org_str VARCHAR2(30);
67: l_trx_str VARCHAR2(2000);
68: l_copy_doc_number_flag varchar2(1):='N';

Line 79: -- call table handler to insert into ra_customer_trx

75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76: /* 5921925 - removed trx_number sequence from here. Moved it to
77: ar_invoice_utils.populate_doc_sequence */
78:
79: -- call table handler to insert into ra_customer_trx
80: IF pg_debug = 'Y'
81: THEN
82: ar_invoice_utils.debug ('Before calling AR_TRX_BULK_PROCESS_HEADER.insert_row (+)' );
83: END IF;

Line 124: -- call table handler to insert into ra_customer_trx

120: END IF;
121:
122: x_return_status := FND_API.G_RET_STS_SUCCESS;
123:
124: -- call table handler to insert into ra_customer_trx
125: AR_TRX_BULK_PROCESS_LINES.insert_row(
126: p_trx_header_id => ar_trx_lines_rec.trx_header_id,
127: p_trx_line_id => ar_trx_lines_rec.trx_line_id,
128: x_errmsg => x_errmsg,

Line 374: delete from ra_customer_trx where customer_trx_id = p_customer_trx_id;

370: BEGIN
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;

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 387: FROM ra_customer_trx ct

383: l_ret_stat NUMBER;
384:
385: CURSOR c_failed_trx IS
386: SELECT ct.customer_trx_id
387: FROM ra_customer_trx ct
388: WHERE
389: EXISTS (SELECT 'error'
390: FROM ar_trx_errors_gt err,
391: ar_trx_header_gt head

Line 402: delete from ra_customer_trx

398: arp_etax_invapi_util.cleanup_tax(c_bad.customer_trx_id);
399: END LOOP;
400:
401: /* Delete everything else */
402: delete from ra_customer_trx
403: where customer_trx_id in (
404: select distinct th.customer_trx_id
405: from ar_trx_errors_gt err,
406: ar_trx_header_gt th

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);

Line 465: l_ct_reference ra_customer_trx.ct_reference%type;

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);
469: l_rec_dist_exist VARCHAR2(1) := 'N';