DBA Data[Home] [Help]

APPS.IBE_CATALOG_PVT dependencies on FND_PROFILE

Line 296: l_str_itms_per_sct := FND_PROFILE.value_specific('IBE_ITEMS_PER_SECTION', NULL, NULL, 671);

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);

Line 2073: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);

2069: AND mic.CATEGORY_SET_ID = p_category_set_id;
2070: END IF;
2071:
2072: -- open uom cursor for return if SHALLOW or DEEP load
2073: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);
2074: IF ((l_retrieve_all_uom IS NULL) OR (l_retrieve_all_uom = 'Y')) THEN
2075: IF ((p_load_level = G_ITEM_SHALLOW) OR (p_load_level = G_ITEM_DEEP)) THEN
2076: OPEN x_uom_csr FOR
2077: SELECT miuv.INVENTORY_ITEM_ID, miuv.UOM_CODE

Line 2086: l_resp_id := FND_PROFILE.value('RESP_ID');

2082: END IF;
2083: END IF;
2084:
2085: -- call configurator API
2086: l_resp_id := FND_PROFILE.value('RESP_ID');
2087: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
2088: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2089: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2090: ibe_util.debug('item id=' || l_itmid);

Line 2087: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');

2083: END IF;
2084:
2085: -- call configurator API
2086: l_resp_id := FND_PROFILE.value('RESP_ID');
2087: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
2088: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2089: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
2090: ibe_util.debug('item id=' || l_itmid);
2091: ibe_util.debug('organization id=' || p_organization_id);

Line 2234: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);

2230: l_model_id := p_model_id;
2231: --END IF;
2232: l_model_id_tbl := JTF_NUMBER_TABLE();
2233: idx := 1;
2234: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);
2235: IF p_model_bundle_flag = FND_API.G_TRUE OR l_retrieve_all_uom = 'N' THEN
2236: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2237: IBE_UTIL.debug('pricing for primary uom only...');
2238: END IF;

Line 2625: l_resp_id := FND_PROFILE.value('RESP_ID');

2621: x_configurable_tbl.EXTEND(p_partnum_tbl.COUNT);
2622: x_model_bundle_flag_tbl.EXTEND(p_partnum_tbl.COUNT); -- bug fix#2234615
2623: END IF;
2624:
2625: l_resp_id := FND_PROFILE.value('RESP_ID');
2626: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
2627:
2628: FOR l_table_index IN 1..x_configurable_tbl.COUNT LOOP
2629: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 2626: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');

2622: x_model_bundle_flag_tbl.EXTEND(p_partnum_tbl.COUNT); -- bug fix#2234615
2623: END IF;
2624:
2625: l_resp_id := FND_PROFILE.value('RESP_ID');
2626: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
2627:
2628: FOR l_table_index IN 1..x_configurable_tbl.COUNT LOOP
2629: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2630: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));

Line 2728: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);

2724: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2725: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':BEGIN');
2726: END IF;
2727: l_start_time := DBMS_UTILITY.GET_TIME;
2728: l_retrieve_all_uom := fnd_profile.value_specific('IBE_RETRIEVE_ALL_ITEM_UOMS', NULL, NULL, 671);
2729: l_model_id_tbl := JTF_NUMBER_TABLE();
2730: idx := 1;
2731: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
2732: IBE_UTIL.debug(G_PKG_NAME||'.'||l_api_name||':l_retrieve_all_uom='||l_retrieve_all_uom);

Line 3065: l_resp_id := FND_PROFILE.value('RESP_ID');

3061:
3062: IBE_UTIL.INSERT_INTO_TEMP_TABLE(p_item_ids(i), 'NUM',l_temp_key, x_query_string);
3063: END LOOP;
3064:
3065: l_resp_id := FND_PROFILE.value('RESP_ID');
3066: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
3067:
3068: x_item_type := JTF_VARCHAR2_TABLE_100();
3069: x_item_type.extend(p_item_ids.COUNT);

Line 3066: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');

3062: IBE_UTIL.INSERT_INTO_TEMP_TABLE(p_item_ids(i), 'NUM',l_temp_key, x_query_string);
3063: END LOOP;
3064:
3065: l_resp_id := FND_PROFILE.value('RESP_ID');
3066: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
3067:
3068: x_item_type := JTF_VARCHAR2_TABLE_100();
3069: x_item_type.extend(p_item_ids.COUNT);
3070:

Line 3278: l_resp_id := FND_PROFILE.value('RESP_ID');

3274: l_ui_def_id NUMBER;
3275: l_resp_id NUMBER;
3276: l_resp_appl_id NUMBER;
3277: BEGIN
3278: l_resp_id := FND_PROFILE.value('RESP_ID');
3279: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
3280: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3281: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3282: ibe_util.debug('item id=' || p_item_id);

Line 3279: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');

3275: l_resp_id NUMBER;
3276: l_resp_appl_id NUMBER;
3277: BEGIN
3278: l_resp_id := FND_PROFILE.value('RESP_ID');
3279: l_resp_appl_id := FND_PROFILE.value('RESP_APPL_ID');
3280: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
3281: IBE_UTIL.debug('Calling CZ_CF_API.UI_FOR_ITEM ' || TO_CHAR(SYSDATE,'DD-MON-YYYY:HH24:MI:SS'));
3282: ibe_util.debug('item id=' || p_item_id);
3283: ibe_util.debug('organization id=' || p_organization_id);