APPS.AR_INVOICE_TABLE_HANDLER dependencies on AR_TRX_HEADER_GT

Line 58: ar_trx_header_rec IN ar_trx_header_gt%rowtype,

54:
55:
56: END;
57: PROCEDURE INSERT_TRX_HEADER (
58: ar_trx_header_rec IN ar_trx_header_gt%rowtype,
59: p_batch_id IN NUMBER DEFAULT NULL,
60: x_errmsg OUT NOCOPY VARCHAR2,
61: x_return_status OUT NOCOPY VARCHAR2)
62: IS

Line 299: ar_trx_header_rec IN ar_trx_header_gt%rowtype,

295: is now aligned with autoinvoice (bulk calls and batch processes) rather
296: than the trx workbench (individual calls) for performance reasons. */
297:
298: PROCEDURE GET_DEFAULT_TAX_CODE (
299: ar_trx_header_rec IN ar_trx_header_gt%rowtype,
300: ar_trx_lines_rec IN ar_trx_lines_gt%rowtype,
301: p_vat_tax_id OUT NOCOPY NUMBER,
302: p_amt_incl_tax_flag OUT NOCOPY VARCHAR2,
303: x_errmsg OUT NOCOPY VARCHAR2,

Line 392: ar_trx_header_gt head

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
393: WHERE err.trx_header_id = head.trx_header_id
394: AND head.customer_trx_id = ct.customer_trx_id);
395:
396: BEGIN

Line 407: ar_trx_header_gt th

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
408: where err.trx_header_id = th.trx_header_id);
409:
410: delete from ra_customer_trx_lines
411: where customer_trx_id in (

Line 414: ar_trx_header_gt th

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
415: where err.trx_header_id = th.trx_header_id);
416:
417: delete from ra_cust_trx_line_gl_dist
418: where customer_trx_id in (

Line 421: ar_trx_header_gt th

417: delete from ra_cust_trx_line_gl_dist
418: where customer_trx_id in (
419: select distinct th.customer_trx_id
420: from ar_trx_errors_gt err,
421: ar_trx_header_gt th
422: where err.trx_header_id = th.trx_header_id);
423:
424: delete from ar_payment_schedules
425: where customer_trx_id in (

Line 428: ar_trx_header_gt th

424: delete from ar_payment_schedules
425: where customer_trx_id in (
426: select distinct th.customer_trx_id
427: from ar_trx_errors_gt err,
428: ar_trx_header_gt th
429: where err.trx_header_id = th.trx_header_id);
430:
431: delete from RA_CUST_TRX_LINE_SALESREPS
432: where customer_trx_id in (

Line 435: ar_trx_header_gt th

431: delete from RA_CUST_TRX_LINE_SALESREPS
432: where customer_trx_id in (
433: select distinct th.customer_trx_id
434: from ar_trx_errors_gt err,
435: ar_trx_header_gt th
436: where err.trx_header_id = th.trx_header_id);
437:
438: END;
439:

Line 519: SELECT * FROM ar_trx_header_gt gt

515: TAX_BAD_DATA EXCEPTION;
516: TAX_OERR EXCEPTION;
517:
518: CURSOR ar_trx_header_c IS
519: SELECT * FROM ar_trx_header_gt gt
520: WHERE NOT EXISTS ( SELECT 'X' FROM
521: ar_trx_errors_gt err
522: WHERE err.trx_header_id = gt.trx_header_id);
523:

Line 658: UPDATE ar_trx_header_gt

654: ar_trx_header_rec.gl_date,
655: ar_trx_header_rec.trx_date,
656: l_recalculate_tax_flag);
657:
658: UPDATE ar_trx_header_gt
659: SET gl_date = ar_trx_header_rec.gl_date
660: WHERE trx_header_id=ar_trx_header_rec.trx_header_id;
661:
662: END IF;

Line 702: lv_ship_via ar_trx_header_gt.ship_via%type;

698: BEGIN
699:
700: /* Changes for Bug 5398561 starts. */
701: DECLARE
702: lv_ship_via ar_trx_header_gt.ship_via%type;
703: lv_ship_dt_actual ar_trx_header_gt.ship_date_actual%type;
704: BEGIN
705:
706: IF ar_trx_lines_rec.ship_date_actual is null

Line 703: lv_ship_dt_actual ar_trx_header_gt.ship_date_actual%type;

699:
700: /* Changes for Bug 5398561 starts. */
701: DECLARE
702: lv_ship_via ar_trx_header_gt.ship_via%type;
703: lv_ship_dt_actual ar_trx_header_gt.ship_date_actual%type;
704: BEGIN
705:
706: IF ar_trx_lines_rec.ship_date_actual is null
707: THEN

Line 710: from ar_trx_header_gt

706: IF ar_trx_lines_rec.ship_date_actual is null
707: THEN
708: select ship_via, ship_date_actual
709: into lv_ship_via, lv_ship_dt_actual
710: from ar_trx_header_gt
711: where customer_trx_id = l_cust_trx_id;
712:
713: ar_trx_lines_rec.ship_via := lv_ship_via;
714: ar_trx_lines_rec.ship_date_actual := lv_ship_dt_actual;

Line 718: from ar_trx_header_gt

714: ar_trx_lines_rec.ship_date_actual := lv_ship_dt_actual;
715: ELSE
716: select ship_via
717: into lv_ship_via
718: from ar_trx_header_gt
719: where customer_trx_id = l_cust_trx_id;
720:
721: ar_trx_lines_rec.ship_via := lv_ship_via;
722: END IF;