APPS.INV_ITEM_CATEGORY_OI dependencies on FND_PROFILE

Line 330: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

326: l_has_privilege VARCHAR2(1) := 'F';
327: l_udex_catalog_id NUMBER;
328: l_gpc_catalog_id NUMBER; --Bug 5517473
329:
330: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
331:
332: --2698140 : Gather stats before running the IOI
333: l_schema VARCHAR2(30);
334: l_status VARCHAR2(1);

Line 362: IF l_records > nvl(fnd_profile.value('EGO_GATHER_STATS'),100) AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema) THEN

358: AND process_flag IN (1,2,4); --R12C
359:
360: -- Bug 6983407 Collect statistics only if the no. of records is bigger than the profile
361: -- option threshold
362: IF l_records > nvl(fnd_profile.value('EGO_GATHER_STATS'),100) AND FND_INSTALLATION.GET_APP_INFO('INV', l_status, l_industry, l_schema) THEN
363: IF l_schema IS NOT NULL THEN
364: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');
365: END IF;
366: END IF;

Line 1474: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1470: PROCEDURE convert_Values_to_Ids
1471: (
1472: )
1473: IS
1474: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1475: BEGIN
1476: END convert_Values_to_Ids;
1477: */
1478:

Line 1492: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1488: l_api_name CONSTANT VARCHAR2(30) := 'delete_OI_records';
1489: Mctx INV_ITEM_MSG.Msg_Ctx_type;
1490:
1491: l_del_process_flag NUMBER := 7; -- process_flag value for records to be deleted
1492: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1493: BEGIN
1494:
1495: Mctx.Package_Name := G_PKG_NAME;
1496: Mctx.Procedure_Name := l_api_name;