DBA Data[Home] [Help]

APPS.AP_ETAX_UTILITY_PKG dependencies on ZX_VALIDATION_ERRORS_GT

Line 4880: invoice_id zx_validation_errors_gt.trx_id%TYPE,

4876: trans_lines_gt zx_transaction_lines_gt%ROWTYPE;
4877: tax_lines_gt zx_import_tax_lines_gt%ROWTYPE;
4878:
4879: TYPE rej_lines_rec IS RECORD (
4880: invoice_id zx_validation_errors_gt.trx_id%TYPE,
4881: line_number zx_validation_errors_gt.trx_line_id%TYPE,
4882: rejection_code zx_validation_errors_gt.message_name%TYPE,
4883: summary_tax_line_number zx_validation_errors_gt.summary_tax_line_number%TYPE,
4884: invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE);

Line 4881: line_number zx_validation_errors_gt.trx_line_id%TYPE,

4877: tax_lines_gt zx_import_tax_lines_gt%ROWTYPE;
4878:
4879: TYPE rej_lines_rec IS RECORD (
4880: invoice_id zx_validation_errors_gt.trx_id%TYPE,
4881: line_number zx_validation_errors_gt.trx_line_id%TYPE,
4882: rejection_code zx_validation_errors_gt.message_name%TYPE,
4883: summary_tax_line_number zx_validation_errors_gt.summary_tax_line_number%TYPE,
4884: invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE);
4885:

Line 4882: rejection_code zx_validation_errors_gt.message_name%TYPE,

4878:
4879: TYPE rej_lines_rec IS RECORD (
4880: invoice_id zx_validation_errors_gt.trx_id%TYPE,
4881: line_number zx_validation_errors_gt.trx_line_id%TYPE,
4882: rejection_code zx_validation_errors_gt.message_name%TYPE,
4883: summary_tax_line_number zx_validation_errors_gt.summary_tax_line_number%TYPE,
4884: invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE);
4885:
4886: TYPE rej_lines_tab IS TABLE OF rej_lines_rec;

Line 4883: summary_tax_line_number zx_validation_errors_gt.summary_tax_line_number%TYPE,

4879: TYPE rej_lines_rec IS RECORD (
4880: invoice_id zx_validation_errors_gt.trx_id%TYPE,
4881: line_number zx_validation_errors_gt.trx_line_id%TYPE,
4882: rejection_code zx_validation_errors_gt.message_name%TYPE,
4883: summary_tax_line_number zx_validation_errors_gt.summary_tax_line_number%TYPE,
4884: invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE);
4885:
4886: TYPE rej_lines_tab IS TABLE OF rej_lines_rec;
4887: rej_lines rej_lines_tab;

Line 4907: FROM zx_validation_errors_gt ve,

4903: ve.trx_line_id line_number,
4904: ve.message_name rejection_code,
4905: ve.summary_tax_line_number summary_tax_line_number,
4906: ail.invoice_line_id invoice_line_id
4907: FROM zx_validation_errors_gt ve,
4908: ap_invoice_lines_interface ail
4909: WHERE ve.application_id = 200
4910: AND ve.entity_code = 'AP_INVOICES'
4911: AND ve.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')