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 298: ar_trx_header_rec IN ar_trx_header_gt%rowtype,

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

Line 391: ar_trx_header_gt head

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

Line 406: ar_trx_header_gt th

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

Line 413: ar_trx_header_gt th

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

Line 420: ar_trx_header_gt th

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

Line 427: ar_trx_header_gt th

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

Line 434: ar_trx_header_gt th

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

Line 511: SELECT * FROM ar_trx_header_gt gt

507: TAX_BAD_DATA EXCEPTION;
508: TAX_OERR EXCEPTION;
509:
510: CURSOR ar_trx_header_c IS
511: SELECT * FROM ar_trx_header_gt gt
512: WHERE NOT EXISTS ( SELECT 'X' FROM
513: ar_trx_errors_gt err
514: WHERE err.trx_header_id = gt.trx_header_id);
515:

Line 688: lv_ship_via ar_trx_header_gt.ship_via%type;

684: BEGIN
685:
686: /* Changes for Bug 5398561 starts. */
687: DECLARE
688: lv_ship_via ar_trx_header_gt.ship_via%type;
689: lv_ship_dt_actual ar_trx_header_gt.ship_date_actual%type;
690: BEGIN
691:
692: IF ar_trx_lines_rec.ship_date_actual is null

Line 689: lv_ship_dt_actual ar_trx_header_gt.ship_date_actual%type;

685:
686: /* Changes for Bug 5398561 starts. */
687: DECLARE
688: lv_ship_via ar_trx_header_gt.ship_via%type;
689: lv_ship_dt_actual ar_trx_header_gt.ship_date_actual%type;
690: BEGIN
691:
692: IF ar_trx_lines_rec.ship_date_actual is null
693: THEN

Line 696: from ar_trx_header_gt

692: IF ar_trx_lines_rec.ship_date_actual is null
693: THEN
694: select ship_via, ship_date_actual
695: into lv_ship_via, lv_ship_dt_actual
696: from ar_trx_header_gt
697: where customer_trx_id = l_cust_trx_id;
698:
699: ar_trx_lines_rec.ship_via := lv_ship_via;
700: ar_trx_lines_rec.ship_date_actual := lv_ship_dt_actual;

Line 704: from ar_trx_header_gt

700: ar_trx_lines_rec.ship_date_actual := lv_ship_dt_actual;
701: ELSE
702: select ship_via
703: into lv_ship_via
704: from ar_trx_header_gt
705: where customer_trx_id = l_cust_trx_id;
706:
707: ar_trx_lines_rec.ship_via := lv_ship_via;
708: END IF;