DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 18374: FROM mtl_units_of_measure

18370: END IF;
18371: BEGIN
18372: SELECT 'Valid UOM'
18373: INTO l_uom_is_valid
18374: FROM mtl_units_of_measure
18375: WHERE unit_of_measure = p_invoice_lines_rec.unit_of_meas_lookup_code
18376: AND AP_IMPORT_INVOICES_PKG.g_inv_sysdate
18377: < nvl(disable_date, AP_IMPORT_INVOICES_PKG.g_inv_sysdate + 1) ;
18378: EXCEPTION

Line 20015: l_uom_code mtl_units_of_measure.uom_code%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:
20017: l_error_code VARCHAR2(500);
20018: l_inv_hdr_org_id ap_invoices_interface.org_id%TYPE;
20019: l_inv_hdr_vendor_id ap_invoices_interface.vendor_id%TYPE;

Line 21588: l_uom_code mtl_units_of_measure.uom_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);
21591: current_calling_sequence VARCHAR2(2000);
21592: l_success boolean;