DBA Data[Home] [Help]

APPS.AP_ETAX_UTILITY_PKG dependencies on ZX_VALIDATION_ERRORS_GT

Line 6047: invoice_id zx_validation_errors_gt.trx_id%TYPE,

6043: trans_lines_gt zx_transaction_lines_gt%ROWTYPE;
6044: tax_lines_gt zx_import_tax_lines_gt%ROWTYPE;
6045:
6046: TYPE rej_lines_rec IS RECORD (
6047: invoice_id zx_validation_errors_gt.trx_id%TYPE,
6048: line_number zx_validation_errors_gt.trx_line_id%TYPE,
6049: rejection_code zx_validation_errors_gt.message_name%TYPE,
6050: summary_tax_line_number zx_validation_errors_gt.summary_tax_line_number%TYPE,
6051: invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE);

Line 6048: line_number zx_validation_errors_gt.trx_line_id%TYPE,

6044: tax_lines_gt zx_import_tax_lines_gt%ROWTYPE;
6045:
6046: TYPE rej_lines_rec IS RECORD (
6047: invoice_id zx_validation_errors_gt.trx_id%TYPE,
6048: line_number zx_validation_errors_gt.trx_line_id%TYPE,
6049: rejection_code zx_validation_errors_gt.message_name%TYPE,
6050: summary_tax_line_number zx_validation_errors_gt.summary_tax_line_number%TYPE,
6051: invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE);
6052:

Line 6049: rejection_code zx_validation_errors_gt.message_name%TYPE,

6045:
6046: TYPE rej_lines_rec IS RECORD (
6047: invoice_id zx_validation_errors_gt.trx_id%TYPE,
6048: line_number zx_validation_errors_gt.trx_line_id%TYPE,
6049: rejection_code zx_validation_errors_gt.message_name%TYPE,
6050: summary_tax_line_number zx_validation_errors_gt.summary_tax_line_number%TYPE,
6051: invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE);
6052:
6053: TYPE rej_lines_tab IS TABLE OF rej_lines_rec;

Line 6050: summary_tax_line_number zx_validation_errors_gt.summary_tax_line_number%TYPE,

6046: TYPE rej_lines_rec IS RECORD (
6047: invoice_id zx_validation_errors_gt.trx_id%TYPE,
6048: line_number zx_validation_errors_gt.trx_line_id%TYPE,
6049: rejection_code zx_validation_errors_gt.message_name%TYPE,
6050: summary_tax_line_number zx_validation_errors_gt.summary_tax_line_number%TYPE,
6051: invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE);
6052:
6053: TYPE rej_lines_tab IS TABLE OF rej_lines_rec;
6054: rej_lines rej_lines_tab;

Line 6074: FROM zx_validation_errors_gt ve,

6070: ve.trx_line_id line_number,
6071: ve.message_name rejection_code,
6072: ve.summary_tax_line_number summary_tax_line_number,
6073: ail.invoice_line_id invoice_line_id
6074: FROM zx_validation_errors_gt ve,
6075: ap_invoice_lines_interface ail
6076: WHERE ve.application_id = 200
6077: AND ve.entity_code = 'AP_INVOICES'
6078: AND ve.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')