APPS.INV_EGO_REVISION_VALIDATE dependencies on EGO_INV_ITEM_CATALOG_PVT

Line 1048: EGO_INV_ITEM_CATALOG_PVT.Change_Item_Catalog (

1044: IF ((cur.item_catalog_group_id IS NOT NULL) AND ( l_error_status <> 1 ) AND (cur.transaction_type = 'UPDATE'))THEN
1045: /* Adding the ttype check and the NVL clause to the ICC change condition */
1046: IF (NVL(l_old_catalog_group_id, -1) <> NVL(cur.item_catalog_group_id,-1)) THEN
1047: /* Bug 5389029 - Passing Int Table values for Lifecycle/Phase */
1048: EGO_INV_ITEM_CATALOG_PVT.Change_Item_Catalog (
1049: P_INVENTORY_ITEM_ID => cur.inventory_item_id
1050: ,P_ORGANIZATION_ID => cur.organization_id
1051: ,P_CATALOG_GROUP_ID => l_old_catalog_group_id
1052: ,P_NEW_CATALOG_GROUP_ID => cur.item_catalog_group_id

Line 1128: EGO_INV_ITEM_CATALOG_PVT.Change_Item_Lifecycle(

1124: -- for master and child orgs also.
1125: ELSE
1126: IF(((cur.lifecycle_id IS NOT NULL) OR (cur.current_phase_id IS NOT NULL)) AND (cur.transaction_type = 'UPDATE')) THEN
1127: IF ( (NVL(l_old_lifecycle_id, -1) <> NVL(cur.lifecycle_id,-1)) OR (NVL(l_old_current_phase_id, -1) <> NVL(cur.current_phase_id,-1)) ) THEN
1128: EGO_INV_ITEM_CATALOG_PVT.Change_Item_Lifecycle(
1129: p_inventory_item_id => cur.inventory_item_id,
1130: p_organization_id => cur.organization_id,
1131: p_new_catalog_category_id => cur.item_catalog_group_id,
1132: p_new_lifecycle_id => cur.lifecycle_id,

Line 1471: EGO_INV_ITEM_CATALOG_PVT.Change_Item_Catalog (

1467: IF ((cur.item_catalog_group_id IS NOT NULL) AND ( l_error_status <> 1) AND (cur.transaction_type = 'UPDATE')) THEN
1468: /* Adding the ttype check and the NVL clause to the ICC change condition */
1469: IF (NVL(l_old_catalog_group_id,-1) <> NVL(cur.item_catalog_group_id,-1)) THEN
1470: /* Bug 5389029 - Passing Int Table values for Lifecycle/Phase */
1471: EGO_INV_ITEM_CATALOG_PVT.Change_Item_Catalog (
1472: P_INVENTORY_ITEM_ID => cur.inventory_item_id
1473: ,P_ORGANIZATION_ID => cur.organization_id
1474: ,P_CATALOG_GROUP_ID => l_old_catalog_group_id
1475: ,P_NEW_CATALOG_GROUP_ID => cur.item_catalog_group_id

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

2539: BEGIN
2540:
2541: IF (INV_Item_Util.g_Appl_Inst.EGO <> 0 AND
2542: INV_ITEM_UTIL.Object_Exists(p_object_type => 'PACKAGE'
2543: ,p_object_name => 'EGO_INV_ITEM_CATALOG_PVT') ='Y')
2544: THEN
2545:
2546: FOR cur IN c_get_valid_item_records LOOP
2547:

Line 2562: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '

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

Line 2597: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '

2593: l_column_name := 'LIFECYCLE_ID';
2594:
2595: EXECUTE IMMEDIATE
2596: ' BEGIN '
2597: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '
2598: ||' P_API_VERSION => 1.0 '
2599: ||' ,P_INVENTORY_ITEM_ID => :cur.inventory_item_id '
2600: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2601: ||' ,P_ITEM_REVISION_ID => NULL '

Line 2630: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '

2626: l_column_name := 'CURRENT_PHASE_ID';
2627:
2628: EXECUTE IMMEDIATE
2629: ' BEGIN '
2630: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '
2631: ||' P_API_VERSION => 1.0 '
2632: ||' ,P_INVENTORY_ITEM_ID => :cur.inventory_item_id '
2633: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2634: ||' ,P_ITEM_REVISION_ID => NULL '

Line 2700: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '

2696: l_column_name := 'LIFECYCLE_ID';
2697:
2698: EXECUTE IMMEDIATE
2699: ' BEGIN '
2700: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '
2701: ||' P_API_VERSION => 1.0 '
2702: ||' ,P_INVENTORY_ITEM_ID => :cur.inventory_item_id '
2703: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2704: ||' ,P_ITEM_REVISION_ID => :cur.revision_id '

Line 2734: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '

2730: l_column_name := 'CURRENT_PHASE_ID';
2731:
2732: EXECUTE IMMEDIATE
2733: ' BEGIN '
2734: ||' EGO_INV_ITEM_CATALOG_PVT.CHANGE_ITEM_LC_DEPENDECIES( '
2735: ||' P_API_VERSION => 1.0 '
2736: ||' ,P_INVENTORY_ITEM_ID => :cur.inventory_item_id '
2737: ||' ,P_ORGANIZATION_ID => :cur.organization_id '
2738: ||' ,P_ITEM_REVISION_ID => :cur.revision_id '