APPS.MRP_ASSIGNMENT_HANDLERS dependencies on MRP_SR_ASSIGNMENTS

Line 16: UPDATE MRP_SR_ASSIGNMENTS

12: )
13: IS
14: BEGIN
15:
16: UPDATE MRP_SR_ASSIGNMENTS
17: SET ASSIGNMENT_ID = p_Assignment_rec.Assignment_Id
18: , ASSIGNMENT_SET_ID = p_Assignment_rec.Assignment_Set_Id
19: , ASSIGNMENT_TYPE = p_Assignment_rec.Assignment_Type
20: , ATTRIBUTE1 = p_Assignment_rec.Attribute1

Line 81: INSERT INTO MRP_SR_ASSIGNMENTS

77: )
78: IS
79: BEGIN
80:
81: INSERT INTO MRP_SR_ASSIGNMENTS
82: ( ASSIGNMENT_ID
83: , ASSIGNMENT_SET_ID
84: , ASSIGNMENT_TYPE
85: , ATTRIBUTE1

Line 184: DELETE FROM MRP_SR_ASSIGNMENTS

180: )
181: IS
182: BEGIN
183:
184: DELETE FROM MRP_SR_ASSIGNMENTS
185: WHERE ASSIGNMENT_ID = p_Assignment_Id
186: ;
187:
188: EXCEPTION

Line 290: FROM MRP_SR_ASSIGNMENTS

286: , l_Assignment_rec.Secondary_Inventory
287: , l_Assignment_rec.Ship_To_Site_Id
288: , l_Assignment_rec.Sourcing_Rule_Id
289: , l_Assignment_rec.Sourcing_Rule_Type
290: FROM MRP_SR_ASSIGNMENTS
291: WHERE ASSIGNMENT_ID = p_Assignment_rec.Assignment_Id
292: FOR UPDATE NOWAIT;
293:
294: -- Row locked. Compare IN attributes to DB attributes.

Line 671: FROM MRP_SR_ASSIGNMENTS

667: , SECONDARY_INVENTORY
668: , SHIP_TO_SITE_ID
669: , SOURCING_RULE_ID
670: , SOURCING_RULE_TYPE
671: FROM MRP_SR_ASSIGNMENTS
672: WHERE ( ASSIGNMENT_ID = p_Assignment_Id
673: )
674: OR ( ASSIGNMENT_SET_ID = p_Assignment_Set_Id
675: );

Line 841: FROM MRP_SR_ASSIGNMENTS

837: , SECONDARY_INVENTORY
838: , SHIP_TO_SITE_ID
839: , SOURCING_RULE_ID
840: , SOURCING_RULE_TYPE
841: FROM MRP_SR_ASSIGNMENTS
842: WHERE ( ASSIGNMENT_ID = p_Assignment_Id
843: )
844: OR ( ASSIGNMENT_SET_ID = p_Assignment_Set_Id
845: );