APPS.IBE_CATALOG_PVT dependencies on QP_PREQ_GRP

Line 2188: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

2184:
2185: l_api_name CONSTANT VARCHAR2(30) := 'FETCH_PRICE';
2186: l_api_version CONSTANT NUMBER := 1.0;
2187:
2188: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2189: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;
2190: l_model_id_tbl JTF_NUMBER_TABLE;
2191: l_model_id NUMBER;
2192: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 2189: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;

2185: l_api_name CONSTANT VARCHAR2(30) := 'FETCH_PRICE';
2186: l_api_version CONSTANT NUMBER := 1.0;
2187:
2188: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2189: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;
2190: l_model_id_tbl JTF_NUMBER_TABLE;
2191: l_model_id NUMBER;
2192: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2193: idx BINARY_INTEGER;

Line 2192: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;

2188: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2189: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;
2190: l_model_id_tbl JTF_NUMBER_TABLE;
2191: l_model_id NUMBER;
2192: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2193: idx BINARY_INTEGER;
2194: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2195: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2196:

Line 2194: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;

2190: l_model_id_tbl JTF_NUMBER_TABLE;
2191: l_model_id NUMBER;
2192: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2193: idx BINARY_INTEGER;
2194: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2195: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2196:
2197: CURSOR l_item_uom_csr IS
2198: SELECT miuv.INVENTORY_ITEM_ID, miuv.UOM_CODE

Line 2195: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;

2191: l_model_id NUMBER;
2192: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2193: idx BINARY_INTEGER;
2194: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2195: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2196:
2197: CURSOR l_item_uom_csr IS
2198: SELECT miuv.INVENTORY_ITEM_ID, miuv.UOM_CODE
2199: FROM MTL_ITEM_UOMS_VIEW miuv

Line 2692: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;

2688: l_api_version CONSTANT NUMBER := 1.0;
2689:
2690: l_itmid NUMBER;
2691: l_primary_uom VARCHAR2(40);
2692: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;
2693: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2694: l_model_id_tbl JTF_NUMBER_TABLE;
2695: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2696: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 2693: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

2689:
2690: l_itmid NUMBER;
2691: l_primary_uom VARCHAR2(40);
2692: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;
2693: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2694: l_model_id_tbl JTF_NUMBER_TABLE;
2695: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2696: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2697: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 2695: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;

2691: l_primary_uom VARCHAR2(40);
2692: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;
2693: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2694: l_model_id_tbl JTF_NUMBER_TABLE;
2695: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2696: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2697: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2698: l_table_index NUMBER;
2699: idx BINARY_INTEGER;

Line 2696: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;

2692: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;
2693: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2694: l_model_id_tbl JTF_NUMBER_TABLE;
2695: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2696: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2697: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2698: l_table_index NUMBER;
2699: idx BINARY_INTEGER;
2700:

Line 2697: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;

2693: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2694: l_model_id_tbl JTF_NUMBER_TABLE;
2695: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;
2696: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2697: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;
2698: l_table_index NUMBER;
2699: idx BINARY_INTEGER;
2700:
2701: CURSOR l_primary_uom_csr(l_item_id NUMBER) IS