APPS.INV_EGO_REVISION_VALIDATE dependencies on EGO_INV_ITEM_CATALOG_PVT

Line 991: EGO_INV_ITEM_CATALOG_PVT.Change_Item_Catalog (

987: IF ((cur.item_catalog_group_id IS NOT NULL) AND ( l_error_status <> 1 ) AND (cur.transaction_type = 'UPDATE'))THEN
988: /* Adding the ttype check and the NVL clause to the ICC change condition */
989: IF (NVL(l_old_catalog_group_id, -1) <> NVL(cur.item_catalog_group_id,-1)) THEN
990: /* Bug 5389029 - Passing Int Table values for Lifecycle/Phase */
991: EGO_INV_ITEM_CATALOG_PVT.Change_Item_Catalog (
992: P_INVENTORY_ITEM_ID => cur.inventory_item_id
993: ,P_ORGANIZATION_ID => cur.organization_id
994: ,P_CATALOG_GROUP_ID => l_old_catalog_group_id
995: ,P_NEW_CATALOG_GROUP_ID => cur.item_catalog_group_id

Line 1373: EGO_INV_ITEM_CATALOG_PVT.Change_Item_Catalog (

1369: IF ((cur.item_catalog_group_id IS NOT NULL) AND ( l_error_status <> 1) AND (cur.transaction_type = 'UPDATE')) THEN
1370: /* Adding the ttype check and the NVL clause to the ICC change condition */
1371: IF (NVL(l_old_catalog_group_id,-1) <> NVL(cur.item_catalog_group_id,-1)) THEN
1372: /* Bug 5389029 - Passing Int Table values for Lifecycle/Phase */
1373: EGO_INV_ITEM_CATALOG_PVT.Change_Item_Catalog (
1374: P_INVENTORY_ITEM_ID => cur.inventory_item_id
1375: ,P_ORGANIZATION_ID => cur.organization_id
1376: ,P_CATALOG_GROUP_ID => l_old_catalog_group_id
1377: ,P_NEW_CATALOG_GROUP_ID => cur.item_catalog_group_id

Line 2372: ,p_object_name => 'EGO_INV_ITEM_CATALOG_PVT') ='Y')

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
2376:

Line 2391: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '

2387: l_column_name := 'LIFECYCLE_ID';
2388:
2389: EXECUTE IMMEDIATE
2390: ' BEGIN '
2391: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '
2392: ||' P_API_VERSION => 1.0 '
2393: ||' ,P_INVENTORY_ITEM_ID => :cur.inventory_item_id '
2394: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2395: ||' ,P_ITEM_REVISION_ID => NULL '

Line 2426: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '

2422: l_column_name := 'LIFECYCLE_ID';
2423:
2424: EXECUTE IMMEDIATE
2425: ' BEGIN '
2426: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '
2427: ||' P_API_VERSION => 1.0 '
2428: ||' ,P_INVENTORY_ITEM_ID => :cur.inventory_item_id '
2429: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2430: ||' ,P_ITEM_REVISION_ID => NULL '

Line 2459: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '

2455: l_column_name := 'CURRENT_PHASE_ID';
2456:
2457: EXECUTE IMMEDIATE
2458: ' BEGIN '
2459: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '
2460: ||' P_API_VERSION => 1.0 '
2461: ||' ,P_INVENTORY_ITEM_ID => :cur.inventory_item_id '
2462: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2463: ||' ,P_ITEM_REVISION_ID => NULL '

Line 2529: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '

2525: l_column_name := 'LIFECYCLE_ID';
2526:
2527: EXECUTE IMMEDIATE
2528: ' BEGIN '
2529: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '
2530: ||' P_API_VERSION => 1.0 '
2531: ||' ,P_INVENTORY_ITEM_ID => :cur.inventory_item_id '
2532: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2533: ||' ,P_ITEM_REVISION_ID => :cur.revision_id '

Line 2563: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '

2559: l_column_name := 'CURRENT_PHASE_ID';
2560:
2561: EXECUTE IMMEDIATE
2562: ' BEGIN '
2563: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '
2564: ||' P_API_VERSION => 1.0 '
2565: ||' ,P_INVENTORY_ITEM_ID => :cur.inventory_item_id '
2566: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2567: ||' ,P_ITEM_REVISION_ID => :cur.revision_id '