APPS.INV_ITEM_CATEGORY_OI dependencies on FND_PROFILE

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

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

Line 367: 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: AND process_flag IN (1,2,4); --R12C
364:
365: -- Bug 6983407 Collect statistics only if the no. of records is bigger than the profile
366: -- option threshold
367: 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
368: IF l_schema IS NOT NULL THEN
369: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_CATEGORIES_INTERFACE');
370: END IF;
371: END IF;

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

1531: PROCEDURE convert_Values_to_Ids
1532: (
1533: )
1534: IS
1535: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1536: BEGIN
1537: END convert_Values_to_Ids;
1538: */
1539:

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

1549: l_api_name CONSTANT VARCHAR2(30) := 'delete_OI_records';
1550: Mctx INV_ITEM_MSG.Msg_Ctx_type;
1551:
1552: l_del_process_flag NUMBER := 7; -- process_flag value for records to be deleted
1553: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1554: BEGIN
1555:
1556: Mctx.Package_Name := G_PKG_NAME;
1557: Mctx.Procedure_Name := l_api_name;