APPS.EGO_INV_ITEM_CATALOG_PVT dependencies on EGO_ITEM_PROJECTS

Line 268: DELETE EGO_ITEM_PROJECTS

264: --
265: -- update item revision project
266: --
267: code_debug(l_api_name||': Delete project associations ');
268: DELETE EGO_ITEM_PROJECTS
269: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
270: AND ORGANIZATION_ID = Item_Rev_Record.organization_id
271: -- AND REVISION = Item_Rev_Record.revision
272: AND revision_id = Item_Rev_Record.revision_id

Line 929: DELETE EGO_ITEM_PROJECTS

925: current_phase_id = NULL
926: WHERE rowid = revision_record.rowid;
927:
928: -- Start 3031284
929: DELETE EGO_ITEM_PROJECTS
930: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
931: AND REVISION = revision_record.revision
932: AND ORGANIZATION_ID = Item_Record.organization_id
933: AND ASSOCIATION_TYPE = 'EGO_ITEM_PROJ_ASSOC_TYPE'

Line 1296: FROM ego_item_projects item_proj

1292: CURSOR c_check_item_proj_assocs (cp_item_id IN NUMBER
1293: ,cp_org_id IN NUMBER
1294: ) IS
1295: SELECT organization_id
1296: FROM ego_item_projects item_proj
1297: WHERE inventory_item_id = cp_item_id
1298: AND EXISTS
1299: (SELECT P2.ORGANIZATION_ID
1300: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2

Line 1315: FROM ego_item_projects rev_proj

1311: ,cp_org_id IN NUMBER
1312: ,cp_rev_id IN NUMBER
1313: ) IS
1314: SELECT organization_id
1315: FROM ego_item_projects rev_proj
1316: WHERE inventory_item_id = cp_item_id
1317: AND EXISTS
1318: (SELECT P2.ORGANIZATION_ID
1319: FROM MTL_PARAMETERS P1, MTL_PARAMETERS P2

Line 1514: DELETE EGO_ITEM_PROJECTS proj

1510: RETURN;
1511: ELSE
1512: -- everything is fine
1513: -- delete the projects associated with the item.
1514: DELETE EGO_ITEM_PROJECTS proj
1515: WHERE inventory_item_id = p_inventory_item_id
1516: -- AND revision IS NULL
1517: AND revision_id IS NULL
1518: AND EXISTS