292: x_sctitm_assoc_enddt_tbl := JTF_DATE_TABLE();
293:
294:
295: -- Get the number of items per section.
296: l_str_itms_per_sct := FND_PROFILE.value_specific('IBE_ITEMS_PER_SECTION', NULL, NULL, 671);
297: l_itms_per_sct := NULL;
298: IF (l_str_itms_per_sct IS NOT NULL) THEN
299:
300: l_itms_per_sct := TO_NUMBER(l_str_itms_per_sct);
2070: AND mic.CATEGORY_SET_ID = p_category_set_id;
2071: END IF;
2072:
2073: -- open uom cursor for return if SHALLOW or DEEP load
2074: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);
2075: IF ((l_retrieve_all_uom IS NULL) OR (l_retrieve_all_uom = 'Y')) THEN
2076: IF ((p_load_level = G_ITEM_SHALLOW) OR (p_load_level = G_ITEM_DEEP)) THEN
2077: OPEN x_uom_csr FOR
2078: SELECT miuv.INVENTORY_ITEM_ID, miuv.UOM_CODE
2083: END IF;
2084: END IF;
2085:
2086: -- call configurator API
2087: l_resp_id := FND_PROFILE.value('RESP_ID');
2088: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
2089: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2090: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2091: ibe_util.debug('item id=' || l_itmid);
2084: END IF;
2085:
2086: -- call configurator API
2087: l_resp_id := FND_PROFILE.value('RESP_ID');
2088: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
2089: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2090: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2091: ibe_util.debug('item id=' || l_itmid);
2092: ibe_util.debug('organization id=' || p_organization_id);
2231: l_model_id := p_model_id;
2232: --END IF;
2233: l_model_id_tbl := JTF_NUMBER_TABLE();
2234: idx := 1;
2235: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);
2236: IF p_model_bundle_flag = FND_API.G_TRUE OR l_retrieve_all_uom = 'N' THEN
2237: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2238: IBE_UTIL.debug('pricing for primary uom only...');
2239: END IF;
2622: x_configurable_tbl.EXTEND(p_partnum_tbl.COUNT);
2623: x_model_bundle_flag_tbl.EXTEND(p_partnum_tbl.COUNT); -- bug fix#2234615
2624: END IF;
2625:
2626: l_resp_id := FND_PROFILE.value('RESP_ID');
2627: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
2628:
2629: FOR l_table_index IN 1..x_configurable_tbl.COUNT LOOP
2630: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2623: x_model_bundle_flag_tbl.EXTEND(p_partnum_tbl.COUNT); -- bug fix#2234615
2624: END IF;
2625:
2626: l_resp_id := FND_PROFILE.value('RESP_ID');
2627: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
2628:
2629: FOR l_table_index IN 1..x_configurable_tbl.COUNT LOOP
2630: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2631: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2725: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2726: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':BEGIN');
2727: END IF;
2728: l_start_time := DBMS_UTILITY.GET_TIME;
2729: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);
2730: l_model_id_tbl := JTF_NUMBER_TABLE();
2731: idx := 1;
2732: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2733: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':l_retrieve_all_uom='||l_retrieve_all_uom);
3062:
3063: IBE_UTIL.INSERT_INTO_TEMP_TABLE(p_item_ids(i), 'NUM',l_temp_key, x_query_string);
3064: END LOOP;
3065:
3066: l_resp_id := FND_PROFILE.value('RESP_ID');
3067: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
3068:
3069: x_item_type := JTF_VARCHAR2_TABLE_100();
3070: x_item_type.extend(p_item_ids.COUNT);
3063: IBE_UTIL.INSERT_INTO_TEMP_TABLE(p_item_ids(i), 'NUM',l_temp_key, x_query_string);
3064: END LOOP;
3065:
3066: l_resp_id := FND_PROFILE.value('RESP_ID');
3067: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
3068:
3069: x_item_type := JTF_VARCHAR2_TABLE_100();
3070: x_item_type.extend(p_item_ids.COUNT);
3071:
3275: l_ui_def_id NUMBER;
3276: l_resp_id NUMBER;
3277: l_resp_appl_id NUMBER;
3278: BEGIN
3279: l_resp_id := FND_PROFILE.value('RESP_ID');
3280: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
3281: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3282: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3283: ibe_util.debug('item id=' || p_item_id);
3276: l_resp_id NUMBER;
3277: l_resp_appl_id NUMBER;
3278: BEGIN
3279: l_resp_id := FND_PROFILE.value('RESP_ID');
3280: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
3281: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3282: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3283: ibe_util.debug('item id=' || p_item_id);
3284: ibe_util.debug('organization id=' || p_organization_id);