APPS.MRP_SHIPPING_ORG_HANDLERS dependencies on MRP_SR_SOURCE_ORG

Line 16: UPDATE MRP_SR_SOURCE_ORG

12: )
13: IS
14: BEGIN
15:
16: UPDATE MRP_SR_SOURCE_ORG
17: SET SR_SOURCE_ID = p_Shipping_Org_rec.Sr_Source_Id
18: , ALLOCATION_PERCENT = p_Shipping_Org_rec.Allocation_Percent
19: , ATTRIBUTE1 = p_Shipping_Org_rec.Attribute1
20: , ATTRIBUTE10 = p_Shipping_Org_rec.Attribute10

Line 79: INSERT INTO MRP_SR_SOURCE_ORG

75: )
76: IS
77: BEGIN
78:
79: INSERT INTO MRP_SR_SOURCE_ORG
80: ( SR_SOURCE_ID
81: , ALLOCATION_PERCENT
82: , ATTRIBUTE1
83: , ATTRIBUTE10

Line 178: DELETE FROM MRP_SR_SOURCE_ORG

174: )
175: IS
176: BEGIN
177:
178: DELETE FROM MRP_SR_SOURCE_ORG
179: WHERE SR_SOURCE_ID = p_Sr_Source_Id
180: ;
181:
182: EXCEPTION

Line 280: FROM MRP_SR_SOURCE_ORG

276: , l_Shipping_Org_rec.Source_Type
277: , l_Shipping_Org_rec.Sr_Receipt_Id
278: , l_Shipping_Org_rec.Vendor_Id
279: , l_Shipping_Org_rec.Vendor_Site_Id
280: FROM MRP_SR_SOURCE_ORG
281: WHERE SR_SOURCE_ID = p_Shipping_Org_rec.Sr_Source_Id
282: FOR UPDATE NOWAIT;
283:
284: -- Row locked. Compare IN attributes to DB attributes.

Line 649: FROM MRP_SR_SOURCE_ORG

645: , SOURCE_TYPE
646: , SR_RECEIPT_ID
647: , VENDOR_ID
648: , VENDOR_SITE_ID
649: FROM MRP_SR_SOURCE_ORG
650: WHERE ( SR_SOURCE_ID = p_Sr_Source_Id
651: )
652: OR ( SR_RECEIPT_ID = p_Sr_Receipt_Id
653: );

Line 815: FROM MRP_SR_SOURCE_ORG

811: , SOURCE_TYPE
812: , SR_RECEIPT_ID
813: , VENDOR_ID
814: , VENDOR_SITE_ID
815: FROM MRP_SR_SOURCE_ORG
816: WHERE ( SR_SOURCE_ID = p_Sr_Source_Id
817: )
818: OR ( SR_RECEIPT_ID = p_Sr_Receipt_Id
819: );