APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on EGO_ITEM_PROJECTS

Line 282: DELETE EGO_ITEM_PROJECTS

278: --
279: -- update item revision project
280: --
281: code_debug(l_api_name||': Delete project associations ');
282: DELETE EGO_ITEM_PROJECTS
283: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
284: AND ORGANIZATION_ID = Item_Rev_Record.organization_id
285: -- AND REVISION = Item_Rev_Record.revision
286: AND revision_id = Item_Rev_Record.revision_id

Line 996: DELETE EGO_ITEM_PROJECTS

992: current_phase_id = NULL
993: WHERE rowid = revision_record.rowid;
994:
995: -- Start 3031284
996: DELETE EGO_ITEM_PROJECTS
997: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
998: AND REVISION = revision_record.revision
999: AND ORGANIZATION_ID = Item_Record.organization_id
1000: AND ASSOCIATION_TYPE = 'EGO_ITEM_PROJ_ASSOC_TYPE'

Line 1366: FROM ego_item_projects item_proj

1362: CURSOR c_check_item_proj_assocs (cp_item_id IN NUMBER
1363: ,cp_org_id IN NUMBER
1364: ) IS
1365: SELECT organization_id
1366: FROM ego_item_projects item_proj
1367: WHERE inventory_item_id = cp_item_id
1368: AND EXISTS
1369: (SELECT P2.ORGANIZATION_ID
1370: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2

Line 1385: FROM ego_item_projects rev_proj

1381: ,cp_org_id IN NUMBER
1382: ,cp_rev_id IN NUMBER
1383: ) IS
1384: SELECT organization_id
1385: FROM ego_item_projects rev_proj
1386: WHERE inventory_item_id = cp_item_id
1387: AND EXISTS
1388: (SELECT P2.ORGANIZATION_ID
1389: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2

Line 1583: DELETE EGO_ITEM_PROJECTS proj

1579: RETURN;
1580: ELSE
1581: -- everything is fine
1582: -- delete the projects associated with the item.
1583: DELETE EGO_ITEM_PROJECTS proj
1584: WHERE inventory_item_id = p_inventory_item_id
1585: -- AND revision IS NULL
1586: AND revision_id IS NULL
1587: AND EXISTS