APPS.ICX_CAT_R12_UPGRADE_PVT dependencies on PO_LINES_ALL

Line 2387: --extracted items in po_lines_all and po_attribute_values

2383: g_po_line_attrval_int_rec.supplier_part_auxid := l_supplier_part_auxid_tbl(i);
2384: g_po_line_attrval_int_rec.catalog_name := l_catalog_name_tbl(i);
2385: g_po_line_attrval_int_rec.ip_category_id := l_primary_category_id_tbl(i);
2386: --Put the following to null, because we cannot update these for
2387: --extracted items in po_lines_all and po_attribute_values
2388: g_po_line_attrval_int_rec.unit_price := null;
2389: g_po_line_attrval_int_rec.uom_code := null;
2390: g_po_line_attrval_int_rec.negotiated_by_preparer_flag := null;
2391: g_po_line_attrval_int_rec.category_id := null;

Line 3042: l_vendor_product_num po_lines_all.vendor_product_num%TYPE := '';

3038: l_document_line_id NUMBER := NULL;
3039: l_document_type_code po_headers_all.type_lookup_code%TYPE := '';
3040: l_document_line_num NUMBER := NULL;
3041: l_buyer_id NUMBER := NULL;
3042: l_vendor_product_num po_lines_all.vendor_product_num%TYPE := '';
3043: l_purchasing_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE := '';
3044: l_icx_schema_name VARCHAR2(30) := NULL;
3045:
3046: l_as_index PLS_INTEGER := 0;

Line 3043: l_purchasing_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE := '';

3039: l_document_type_code po_headers_all.type_lookup_code%TYPE := '';
3040: l_document_line_num NUMBER := NULL;
3041: l_buyer_id NUMBER := NULL;
3042: l_vendor_product_num po_lines_all.vendor_product_num%TYPE := '';
3043: l_purchasing_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE := '';
3044: l_icx_schema_name VARCHAR2(30) := NULL;
3045:
3046: l_as_index PLS_INTEGER := 0;
3047: l_as_org_id_tbl DBMS_SQL.NUMBER_TABLE;