DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on ZX_TRANSACTION_LINES_GT

Line 19997: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

19993: debug_info VARCHAR2(500);
19994:
19995: --6412397
19996: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
19997: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
19998: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
19999: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
20000: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
20001:

Line 19999: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

19995: --6412397
19996: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
19997: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
19998: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
19999: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
20000: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
20001:
20002: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
20003: l_allow_tax_code_override varchar2(10);

Line 20002: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

19998: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
19999: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
20000: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
20001:
20002: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
20003: l_allow_tax_code_override varchar2(10);
20004: l_dummy number;
20005: -- Purchase Order Info
20006: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

Line 20006: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

20002: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
20003: l_allow_tax_code_override varchar2(10);
20004: l_dummy number;
20005: -- Purchase Order Info
20006: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
20007: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
20008: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
20009: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
20010: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

Line 20007: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

20003: l_allow_tax_code_override varchar2(10);
20004: l_dummy number;
20005: -- Purchase Order Info
20006: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
20007: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
20008: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
20009: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
20010: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
20011: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

Line 20008: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;

20004: l_dummy number;
20005: -- Purchase Order Info
20006: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
20007: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
20008: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
20009: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
20010: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
20011: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
20012: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

Line 20009: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

20005: -- Purchase Order Info
20006: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
20007: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
20008: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
20009: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
20010: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
20011: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
20012: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
20013:

Line 20010: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

20006: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
20007: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
20008: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
20009: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
20010: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
20011: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
20012: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
20013:
20014: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

Line 20011: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

20007: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
20008: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
20009: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
20010: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
20011: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
20012: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
20013:
20014: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
20015: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 20012: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

20008: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
20009: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
20010: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
20011: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
20012: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
20013:
20014: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
20015: l_uom_code mtl_units_of_measure.uom_code%TYPE;
20016:

Line 21581: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

21577: p_invoice_rec IN AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
21578: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
21579: p_calling_sequence IN VARCHAR2) return boolean IS
21580:
21581: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
21582: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
21583: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
21584: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
21585: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;

Line 21582: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

21578: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
21579: p_calling_sequence IN VARCHAR2) return boolean IS
21580:
21581: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
21582: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
21583: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
21584: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
21585: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
21586: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

Line 21583: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;

21579: p_calling_sequence IN VARCHAR2) return boolean IS
21580:
21581: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
21582: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
21583: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
21584: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
21585: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
21586: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
21587: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

Line 21584: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

21580:
21581: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
21582: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
21583: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
21584: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
21585: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
21586: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
21587: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
21588: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 21586: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

21582: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
21583: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
21584: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
21585: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
21586: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
21587: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
21588: l_uom_code mtl_units_of_measure.uom_code%TYPE;
21589: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;
21590: l_error_code varchar2(2000);

Line 21599: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

21595: l_product_category zx_lines_det_factors.product_category%type;
21596: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
21597: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
21598: l_assessable_value zx_lines_det_factors.assessable_value%type;
21599: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
21600: l_dummy number;
21601: debug_info varchar2(1000);
21602:
21603: BEGIN