DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on ZX_TRANSACTION_LINES_GT

Line 21802: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;

21798: debug_info VARCHAR2(500);
21799:
21800: --6412397
21801: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
21802: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
21803: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
21804: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
21805: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
21806:

Line 21804: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;

21800: --6412397
21801: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
21802: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
21803: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
21804: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
21805: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
21806:
21807: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
21808: l_allow_tax_code_override varchar2(10);

Line 21807: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

21803: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
21804: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
21805: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
21806:
21807: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
21808: l_allow_tax_code_override varchar2(10);
21809: l_dummy number;
21810: -- Purchase Order Info
21811: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

Line 21811: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

21807: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
21808: l_allow_tax_code_override varchar2(10);
21809: l_dummy number;
21810: -- Purchase Order Info
21811: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
21812: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
21813: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
21814: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
21815: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

Line 21812: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

21808: l_allow_tax_code_override varchar2(10);
21809: l_dummy number;
21810: -- Purchase Order Info
21811: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
21812: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
21813: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
21814: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
21815: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
21816: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

Line 21813: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;

21809: l_dummy number;
21810: -- Purchase Order Info
21811: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
21812: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
21813: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
21814: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
21815: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
21816: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
21817: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

Line 21814: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

21810: -- Purchase Order Info
21811: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
21812: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
21813: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
21814: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
21815: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
21816: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
21817: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
21818:

Line 21815: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

21811: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
21812: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
21813: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
21814: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
21815: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
21816: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
21817: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
21818:
21819: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

Line 21816: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;

21812: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
21813: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
21814: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
21815: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
21816: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
21817: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
21818:
21819: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
21820: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 21817: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;

21813: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
21814: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
21815: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
21816: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
21817: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
21818:
21819: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
21820: l_uom_code mtl_units_of_measure.uom_code%TYPE;
21821:

Line 23440: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

23436: p_invoice_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_invoice_info_rec,
23437: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
23438: p_calling_sequence IN VARCHAR2) return boolean IS
23439:
23440: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
23441: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
23442: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
23443: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
23444: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;

Line 23441: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;

23437: p_invoice_lines_rec IN OUT NOCOPY AP_IMPORT_INVOICES_PKG.r_line_info_rec,
23438: p_calling_sequence IN VARCHAR2) return boolean IS
23439:
23440: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
23441: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
23442: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
23443: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
23444: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
23445: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

Line 23442: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;

23438: p_calling_sequence IN VARCHAR2) return boolean IS
23439:
23440: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
23441: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
23442: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
23443: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
23444: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
23445: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
23446: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;

Line 23443: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;

23439:
23440: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
23441: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
23442: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
23443: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
23444: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
23445: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
23446: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
23447: l_uom_code mtl_units_of_measure.uom_code%TYPE;

Line 23445: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;

23441: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;
23442: l_ref_doc_event_class_code zx_transaction_lines_gt.ref_doc_event_class_code%TYPE;
23443: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
23444: l_po_header_curr_conv_rat po_headers_all.rate%TYPE;
23445: l_ref_doc_trx_level_type zx_transaction_lines_gt.ref_doc_trx_level_type%TYPE;
23446: l_po_header_curr_conv_rate po_headers_all.rate%TYPE;
23447: l_uom_code mtl_units_of_measure.uom_code%TYPE;
23448: l_ref_doc_trx_id po_headers_all.po_header_id%TYPE;
23449: l_error_code varchar2(2000);

Line 23458: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

23454: l_product_category zx_lines_det_factors.product_category%type;
23455: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
23456: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
23457: l_assessable_value zx_lines_det_factors.assessable_value%type;
23458: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
23459: l_dummy number;
23460: debug_info varchar2(1000);
23461: -- bug 8495005 fix starts
23462: l_taxation_country zx_lines_det_factors.default_taxation_country%type;

Line 23469: l_dflt_tax_class_code2 zx_transaction_lines_gt.input_tax_classification_code%type;

23465:
23466: -- bug 8483345: start
23467: l_product_org_id ap_invoices.org_id%TYPE;
23468: l_allow_tax_code_override varchar2(10);
23469: l_dflt_tax_class_code2 zx_transaction_lines_gt.input_tax_classification_code%type;
23470: -- bug 8483345: end
23471:
23472: l_code_combination_id NUMBER ; -- Bug 10050094
23473: l_full_mtch_amt NUMBER; --Bug#13505998