APPS.MRP_ASSIGNMENT_SET_HANDLERS dependencies on MRP_ASSIGNMENT_SETS

Line 16: UPDATE MRP_ASSIGNMENT_SETS

12: )
13: IS
14: BEGIN
15:
16: UPDATE MRP_ASSIGNMENT_SETS
17: SET ASSIGNMENT_SET_ID = p_Assignment_Set_rec.Assignment_Set_Id
18: , ASSIGNMENT_SET_NAME = p_Assignment_Set_rec.Assignment_Set_Name
19: , ATTRIBUTE1 = p_Assignment_Set_rec.Attribute1
20: , ATTRIBUTE10 = p_Assignment_Set_rec.Attribute10

Line 72: INSERT INTO MRP_ASSIGNMENT_SETS

68: )
69: IS
70: BEGIN
71:
72: INSERT INTO MRP_ASSIGNMENT_SETS
73: ( ASSIGNMENT_SET_ID
74: , ASSIGNMENT_SET_NAME
75: , ATTRIBUTE1
76: , ATTRIBUTE10

Line 182: DELETE FROM MRP_ASSIGNMENT_SETS

178: END LOOP;
179:
180: CLOSE cur_Assignments;
181:
182: DELETE FROM MRP_ASSIGNMENT_SETS
183: WHERE ASSIGNMENT_SET_ID = p_Assignment_Set_Id
184: ;
185:
186: EXCEPTION

Line 270: FROM MRP_ASSIGNMENT_SETS

266: , l_Assignment_Set_rec.Program_Application_Id
267: , l_Assignment_Set_rec.Program_Id
268: , l_Assignment_Set_rec.Program_Update_Date
269: , l_Assignment_Set_rec.Request_Id
270: FROM MRP_ASSIGNMENT_SETS
271: WHERE ASSIGNMENT_SET_ID = p_Assignment_Set_rec.Assignment_Set_Id
272: FOR UPDATE NOWAIT;
273:
274: -- Row locked. Compare IN attributes to DB attributes.

Line 550: FROM MRP_ASSIGNMENT_SETS

546: , l_Assignment_Set_rec.Program_Application_Id
547: , l_Assignment_Set_rec.Program_Id
548: , l_Assignment_Set_rec.Program_Update_Date
549: , l_Assignment_Set_rec.Request_Id
550: FROM MRP_ASSIGNMENT_SETS
551: WHERE ASSIGNMENT_SET_ID = p_Assignment_Set_Id
552: ;
553:
554: RETURN l_Assignment_Set_rec;

Line 638: FROM MRP_ASSIGNMENT_SETS

634: , x_Assignment_Set_rec.Program_Application_Id
635: , x_Assignment_Set_rec.Program_Id
636: , x_Assignment_Set_rec.Program_Update_Date
637: , x_Assignment_Set_rec.Request_Id
638: FROM MRP_ASSIGNMENT_SETS
639: WHERE ASSIGNMENT_SET_ID = p_Assignment_Set_Id
640: ;
641:
642: