APPS.BOMPECOD dependencies on ENG_REVISED_ITEMS

Line 23: ENG_REVISED_ITEMS RI

19: DELETE FROM BOM_REFERENCE_DESIGNATORS R
20: WHERE R.COMPONENT_SEQUENCE_ID IN
21: (SELECT C.COMPONENT_SEQUENCE_ID
22: FROM BOM_INVENTORY_COMPONENTS C,
23: ENG_REVISED_ITEMS RI
24: WHERE RI.REVISED_ITEM_SEQUENCE_ID = C.REVISED_ITEM_SEQUENCE_ID
25: AND RI.ORGANIZATION_ID = P_ORGANIZATION_ID
26: AND RI.CHANGE_NOTICE = P_CHANGE_NOTICE
27: AND C.IMPLEMENTATION_DATE IS NULL);

Line 33: ENG_REVISED_ITEMS RI

29: DELETE FROM BOM_SUBSTITUTE_COMPONENTS S
30: WHERE S.COMPONENT_SEQUENCE_ID IN
31: (SELECT C.COMPONENT_SEQUENCE_ID
32: FROM BOM_INVENTORY_COMPONENTS C,
33: ENG_REVISED_ITEMS RI
34: WHERE RI.REVISED_ITEM_SEQUENCE_ID = C.REVISED_ITEM_SEQUENCE_ID
35: AND RI.ORGANIZATION_ID = P_ORGANIZATION_ID
36: AND RI.CHANGE_NOTICE = P_CHANGE_NOTICE
37: AND C.IMPLEMENTATION_DATE IS NULL);

Line 44: FROM ENG_REVISED_ITEMS R

40: DELETE FROM BOM_INVENTORY_COMPONENTS C
41: WHERE C.IMPLEMENTATION_DATE IS NULL
42: AND C.REVISED_ITEM_SEQUENCE_ID IN
43: (SELECT R.REVISED_ITEM_SEQUENCE_ID
44: FROM ENG_REVISED_ITEMS R
45: WHERE R.ORGANIZATION_ID = P_ORGANIZATION_ID
46: AND R.CHANGE_NOTICE = P_CHANGE_NOTICE);
47:
48: UPDATE BOM_INVENTORY_COMPONENTS C

Line 54: FROM ENG_REVISED_ITEMS R

50: -- C.CHANGE_NOTICE = NULL -- Bug2627917
51: WHERE C.IMPLEMENTATION_DATE IS NOT NULL
52: AND C.REVISED_ITEM_SEQUENCE_ID IN
53: (SELECT R.REVISED_ITEM_SEQUENCE_ID
54: FROM ENG_REVISED_ITEMS R
55: WHERE R.ORGANIZATION_ID = P_ORGANIZATION_ID
56: AND R.CHANGE_NOTICE = P_CHANGE_NOTICE);
57:
58: DELETE FROM ENG_REVISED_COMPONENTS C

Line 61: FROM ENG_REVISED_ITEMS R

57:
58: DELETE FROM ENG_REVISED_COMPONENTS C
59: WHERE EXISTS
60: (SELECT NULL
61: FROM ENG_REVISED_ITEMS R
62: WHERE R.ORGANIZATION_ID = P_ORGANIZATION_ID
63: AND R.CHANGE_NOTICE = P_CHANGE_NOTICE
64: AND R.REVISED_ITEM_SEQUENCE_ID = C.REVISED_ITEM_SEQUENCE_ID);
65:

Line 86: DELETE FROM ENG_REVISED_ITEMS

82: WHERE CHANGE_NOTICE = P_CHANGE_NOTICE
83: AND ORGANIZATION_ID = P_ORGANIZATION_ID
84: AND IMPLEMENTATION_DATE IS NOT NULL;
85:
86: DELETE FROM ENG_REVISED_ITEMS
87: WHERE CHANGE_NOTICE = P_CHANGE_NOTICE
88: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
89:
90: DELETE FROM ENG_ENGINEERING_CHANGES

Line 101: FROM ENG_REVISED_ITEMS R

97: AND NOT EXISTS (SELECT NULL
98: FROM BOM_INVENTORY_COMPONENTS C
99: WHERE C.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID)
100: AND NOT EXISTS (SELECT NULL
101: FROM ENG_REVISED_ITEMS R
102: WHERE R.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID);
103:
104: EXCEPTION
105: WHEN others THEN rollback;