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 375: delete from ra_customer_trx where customer_trx_id = p_customer_trx_id;

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

Line 376: delete from ra_customer_trx_lines where customer_trx_id = p_customer_trx_id;

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

Line 388: FROM ra_customer_trx ct

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

Line 403: delete from ra_customer_trx

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

Line 410: delete from ra_customer_trx_lines

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

Line 464: l_tax_line_rec ra_customer_trx_lines%rowtype;

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

Line 465: l_freight_line_rec ra_customer_trx_lines%rowtype;

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

Line 466: l_ct_reference ra_customer_trx.ct_reference%type;

462: l_status1 varchar2(100);
463: l_status varchar2(100);
464: l_tax_line_rec ra_customer_trx_lines%rowtype;
465: l_freight_line_rec ra_customer_trx_lines%rowtype;
466: l_ct_reference ra_customer_trx.ct_reference%type;
467: l_requery_tax_if_visible boolean;
468: l_batch_id NUMBER;
469: lc_request_id VARCHAR2(40);
470: l_rec_dist_exist VARCHAR2(1) := 'N';

Line 871: from ra_customer_trx_lines

867: FOR ar_trx_header_rec IN ar_trx_header_c
868: LOOP
869: l_creation_sign :=ar_trx_header_rec.CREATION_SIGN;
870: select sum(extended_amount) into l_amount
871: from ra_customer_trx_lines
872: where customer_trx_id=ar_trx_header_rec.CUSTOMER_TRX_ID;
873: ar_invoice_utils.debug('l_creation_sign:'||l_creation_sign);
874: ar_invoice_utils.debug('l_amount:'||l_amount);
875: ar_invoice_utils.debug('CUSTOMER_TRX_ID:'||ar_trx_header_rec.CUSTOMER_TRX_ID);