12: )
13: IS
14: BEGIN
15:
16: UPDATE MRP_SOURCING_RULES
17: SET SOURCING_RULE_ID = p_Sourcing_Rule_rec.Sourcing_Rule_Id
18: , ATTRIBUTE1 = p_Sourcing_Rule_rec.Attribute1
19: , ATTRIBUTE10 = p_Sourcing_Rule_rec.Attribute10
20: , ATTRIBUTE11 = p_Sourcing_Rule_rec.Attribute11
72: )
73: IS
74: BEGIN
75:
76: INSERT INTO MRP_SOURCING_RULES
77: ( SOURCING_RULE_ID
78: , ATTRIBUTE1
79: , ATTRIBUTE10
80: , ATTRIBUTE11
193: END LOOP;
194:
195: CLOSE cur_Receiving_Org;
196:
197: DELETE FROM MRP_SOURCING_RULES
198: WHERE SOURCING_RULE_ID = p_Sourcing_Rule_Id;
199:
200: EXCEPTION
201:
288: , l_Sourcing_Rule_rec.Request_Id
289: , l_Sourcing_Rule_rec.Sourcing_Rule_Name
290: , l_Sourcing_Rule_rec.Sourcing_Rule_Type
291: , l_Sourcing_Rule_rec.Status
292: FROM MRP_SOURCING_RULES
293: WHERE SOURCING_RULE_ID = p_Sourcing_Rule_rec.Sourcing_Rule_Id
294: FOR UPDATE NOWAIT;
295:
296: -- Row locked. Compare IN attributes to DB attributes.
596: , l_Sourcing_Rule_rec.Request_Id
597: , l_Sourcing_Rule_rec.Sourcing_Rule_Name
598: , l_Sourcing_Rule_rec.Sourcing_Rule_Type
599: , l_Sourcing_Rule_rec.Status
600: FROM MRP_SOURCING_RULES
601: WHERE SOURCING_RULE_ID = p_Sourcing_Rule_Id
602: ;
603:
604: RETURN l_Sourcing_Rule_rec;
692: , x_Sourcing_Rule_rec.Request_Id
693: , x_Sourcing_Rule_rec.Sourcing_Rule_Name
694: , x_Sourcing_Rule_rec.Sourcing_Rule_Type
695: , x_Sourcing_Rule_rec.Status
696: FROM MRP_SOURCING_RULES
697: WHERE SOURCING_RULE_ID = p_Sourcing_Rule_Id
698: ;
699:
700: