APPS.INV_EGO_REVISION_VALIDATE dependencies on INV_ITEM_UTIL

Line 795: IF (l_ego_exists ='Y' AND INV_Item_Util.g_Appl_Inst.EGO <> 0) THEN -- Bug 4175124 THEN

791: OPEN c_ego_exists;
792: FETCH c_ego_exists INTO l_ego_exists;
793: CLOSE c_ego_exists;
794:
795: IF (l_ego_exists ='Y' AND INV_Item_Util.g_Appl_Inst.EGO <> 0) THEN -- Bug 4175124 THEN
796:
797: IF (INSTR(NVL(G_PROCESS_CONTROL,'PLM_UI:N'),'PLM_UI:Y') = 0 )
798: THEN
799:

Line 2370: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND

2366: err_text VARCHAR2(2000);
2367:
2368: BEGIN
2369:
2370: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2371: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2372: ,p_object_name => 'EGO_INV_ITEM_CATALOG_PVT') ='Y')
2373: THEN
2374:

Line 2371: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'

2367:
2368: BEGIN
2369:
2370: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2371: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2372: ,p_object_name => 'EGO_INV_ITEM_CATALOG_PVT') ='Y')
2373: THEN
2374:
2375: FOR cur IN c_get_valid_item_records LOOP

Line 2612: END IF; --INV_Item_Util.g_Appl_Inst.EGO <> 0

2608: ,err_text);
2609: END IF;
2610: END LOOP;
2611:
2612: END IF; --INV_Item_Util.g_Appl_Inst.EGO <> 0
2613:
2614: EXCEPTION
2615: WHEN OTHERS THEN
2616: NULL;

Line 2634: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND

2630: l_message_count NUMBER;
2631: l_msg_data VARCHAR2(2000);
2632: l_errorcode NUMBER;
2633: BEGIN
2634: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2635: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2636: ,p_object_name => 'EGO_UPGRADE_USER_ATTR_VAL_PUB') ='Y')
2637: THEN
2638: EXECUTE IMMEDIATE

Line 2635: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'

2631: l_msg_data VARCHAR2(2000);
2632: l_errorcode NUMBER;
2633: BEGIN
2634: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2635: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2636: ,p_object_name => 'EGO_UPGRADE_USER_ATTR_VAL_PUB') ='Y')
2637: THEN
2638: EXECUTE IMMEDIATE
2639: 'BEGIN

Line 2683: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND

2679: ,x_message_text OUT NOCOPY VARCHAR2
2680: ) IS
2681:
2682: BEGIN
2683: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2684: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2685: ,p_object_name => 'EGO_ITEM_AML_PUB') ='Y')
2686: THEN
2687: EXECUTE IMMEDIATE

Line 2684: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'

2680: ) IS
2681:
2682: BEGIN
2683: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2684: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2685: ,p_object_name => 'EGO_ITEM_AML_PUB') ='Y')
2686: THEN
2687: EXECUTE IMMEDIATE
2688: ' BEGIN '

Line 2734: IF (INV_ITEM_UTIL.APPL_INST_EGO <> 0) THEN

2730: ) IS
2731: l_template_exists NUMBER := 0;
2732: BEGIN
2733:
2734: IF (INV_ITEM_UTIL.APPL_INST_EGO <> 0) THEN
2735: EXECUTE IMMEDIATE
2736: 'SELECT count(*)
2737: FROM dual
2738: WHERE EXISTS(SELECT 1 FROM ego_cat_grp_templates

Line 2773: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND

2769: IS
2770: l_sql VARCHAR2(15000);
2771: l_suppress_flag VARCHAR2(10);
2772: BEGIN
2773: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2774: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2775: ,p_object_name => 'EGO_GTIN_PVT') ='Y') THEN
2776: --Bug:4174218 BOM rollup code is calling ego-pvt with supress_rollup
2777: IF NVL(G_PROCESS_CONTROL,'N') <> 'SUPPRESS_ROLLUP' THEN

Line 2774: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'

2770: l_sql VARCHAR2(15000);
2771: l_suppress_flag VARCHAR2(10);
2772: BEGIN
2773: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2774: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2775: ,p_object_name => 'EGO_GTIN_PVT') ='Y') THEN
2776: --Bug:4174218 BOM rollup code is calling ego-pvt with supress_rollup
2777: IF NVL(G_PROCESS_CONTROL,'N') <> 'SUPPRESS_ROLLUP' THEN
2778: l_suppress_flag := 'N';

Line 3165: IF NOT (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND

3161: BEGIN
3162: x_return_status := FND_API.G_RET_STS_SUCCESS;
3163: x_msg_count := 0;
3164: x_msg_data := NULL;
3165: IF NOT (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
3166: INV_ITEM_UTIL.Object_Exists
3167: (p_object_type => 'PACKAGE'
3168: ,p_object_name => 'EGO_ITEM_BULKLOAD_PKG') ='Y') THEN
3169: -- EGO not installed here no need to do further processing

Line 3166: INV_ITEM_UTIL.Object_Exists

3162: x_return_status := FND_API.G_RET_STS_SUCCESS;
3163: x_msg_count := 0;
3164: x_msg_data := NULL;
3165: IF NOT (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
3166: INV_ITEM_UTIL.Object_Exists
3167: (p_object_type => 'PACKAGE'
3168: ,p_object_name => 'EGO_ITEM_BULKLOAD_PKG') ='Y') THEN
3169: -- EGO not installed here no need to do further processing
3170: RETURN;