APPS.MRP_RECEIVING_ORG_HANDLERS dependencies on MRP_SR_RECEIPT_ORG

Line 16: UPDATE MRP_SR_RECEIPT_ORG

12: )
13: IS
14: BEGIN
15:
16: UPDATE MRP_SR_RECEIPT_ORG
17: SET SR_RECEIPT_ID = p_Receiving_Org_rec.Sr_Receipt_Id
18: , ATTRIBUTE1 = p_Receiving_Org_rec.Attribute1
19: , ATTRIBUTE10 = p_Receiving_Org_rec.Attribute10
20: , ATTRIBUTE11 = p_Receiving_Org_rec.Attribute11

Line 74: INSERT INTO MRP_SR_RECEIPT_ORG

70: )
71: IS
72: BEGIN
73:
74: INSERT INTO MRP_SR_RECEIPT_ORG
75: ( SR_RECEIPT_ID
76: , ATTRIBUTE1
77: , ATTRIBUTE10
78: , ATTRIBUTE11

Line 191: DELETE FROM MRP_SR_RECEIPT_ORG

187:
188: CLOSE cur_Shipping_Org;
189:
190:
191: DELETE FROM MRP_SR_RECEIPT_ORG
192: WHERE SR_RECEIPT_ID = p_Sr_Receipt_Id
193: ;
194:
195: EXCEPTION

Line 283: FROM MRP_SR_RECEIPT_ORG

279: , l_Receiving_Org_rec.Program_Update_Date
280: , l_Receiving_Org_rec.Receipt_Organization_Id
281: , l_Receiving_Org_rec.Request_Id
282: , l_Receiving_Org_rec.Sourcing_Rule_Id
283: FROM MRP_SR_RECEIPT_ORG
284: WHERE SR_RECEIPT_ID = p_Receiving_Org_rec.Sr_Receipt_Id
285: FOR UPDATE NOWAIT;
286:
287: -- Row locked. Compare IN attributes to DB attributes.

Line 622: FROM MRP_SR_RECEIPT_ORG

618: , PROGRAM_UPDATE_DATE
619: , RECEIPT_ORGANIZATION_ID
620: , REQUEST_ID
621: , SOURCING_RULE_ID
622: FROM MRP_SR_RECEIPT_ORG
623: WHERE ( SR_RECEIPT_ID = p_Sr_Receipt_Id
624: )
625: OR ( SOURCING_RULE_ID = p_Sourcing_Rule_Id
626: );

Line 778: FROM MRP_SR_RECEIPT_ORG

774: , PROGRAM_UPDATE_DATE
775: , RECEIPT_ORGANIZATION_ID
776: , REQUEST_ID
777: , SOURCING_RULE_ID
778: FROM MRP_SR_RECEIPT_ORG
779: WHERE ( SR_RECEIPT_ID = p_Sr_Receipt_Id
780: )
781: OR ( SOURCING_RULE_ID = p_Sourcing_Rule_Id
782: );