APPS.IBE_CATALOG_PVT dependencies on QP_PREQ_GRP

Line 2189: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 2190: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;

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

Line 2193: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;

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

Line 2195: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;

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

Line 2196: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;

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

Line 2693: l_itmid_tbl QP_PREQ_GRP.NUMBER_TYPE;

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

Line 2694: l_uom_code_tbl QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 2696: l_line_quantity_tbl QP_PREQ_GRP.NUMBER_TYPE;

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

Line 2697: l_parentIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;

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

Line 2698: l_childIndex_tbl QP_PREQ_GRP.NUMBER_TYPE;

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