APPS.AR_INVOICE_TABLE_HANDLER dependencies on AR_TRX_ERRORS_GT

Line 349: INSERT INTO ar_trx_errors_gt (

345: p_error_message VARCHAR2 default NULL,
346: p_invalid_value VARCHAR2 default NULL) AS
347: BEGIN
348:
349: INSERT INTO ar_trx_errors_gt (
350: trx_header_id,
351: trx_line_id,
352: trx_dist_id,
353: trx_salescredit_id,

Line 390: FROM ar_trx_errors_gt err,

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

Line 405: from ar_trx_errors_gt err,

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

Line 412: from ar_trx_errors_gt err,

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

Line 419: from ar_trx_errors_gt err,

415:
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

Line 426: from ar_trx_errors_gt err,

422:
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

Line 433: from ar_trx_errors_gt err,

429:
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;

Line 513: ar_trx_errors_gt err

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:
516: CURSOR ar_trx_lines_c IS
517: SELECT * FROM ar_trx_lines_gt gt

Line 1054: INSERT INTO ar_trx_errors_gt (

1050: THEN
1051: cleanup(p_customer_trx_id => l_cust_trx_id);
1052: x_errmsg := sqlerrm;
1053: x_return_status := fnd_api.g_ret_sts_unexp_error;
1054: INSERT INTO ar_trx_errors_gt (
1055: trx_header_id,
1056: error_message)
1057: VALUES
1058: ( ar_trx_header_rec.trx_header_id,