7:
8: -- Procedure Update_Row
9:
10: PROCEDURE Update_Row
11: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
12: )
13: IS
14: BEGIN
15:
67:
68: -- Procedure Insert_Row
69:
70: PROCEDURE Insert_Row
71: ( p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
72: )
73: IS
74: BEGIN
75:
217: --
218:
219: PROCEDURE Lock_Row
220: ( x_return_status OUT VARCHAR2
221: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
222: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
223: )
224: IS
225: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
218:
219: PROCEDURE Lock_Row
220: ( x_return_status OUT VARCHAR2
221: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
222: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
223: )
224: IS
225: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
226: BEGIN
221: , p_Sourcing_Rule_rec IN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
222: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
223: )
224: IS
225: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
226: BEGIN
227:
228: SELECT SOURCING_RULE_ID
229: , ATTRIBUTE1
527: -- Function Query_Row
528:
529: FUNCTION Query_Row
530: ( p_Sourcing_Rule_Id IN NUMBER
531: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
532: IS
533: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
534: BEGIN
535:
529: FUNCTION Query_Row
530: ( p_Sourcing_Rule_Id IN NUMBER
531: ) RETURN MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
532: IS
533: l_Sourcing_Rule_rec MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type;
534: BEGIN
535:
536: SELECT SOURCING_RULE_ID
537: , ATTRIBUTE1
622: -- Procedure Query_Entity
623:
624: PROCEDURE Query_Entity
625: ( p_Sourcing_Rule_Id IN NUMBER
626: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
627: , x_Sourcing_Rule_val_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
628: )
629: IS
630: BEGIN
623:
624: PROCEDURE Query_Entity
625: ( p_Sourcing_Rule_Id IN NUMBER
626: , x_Sourcing_Rule_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Rec_Type
627: , x_Sourcing_Rule_val_rec OUT MRP_Sourcing_Rule_PUB.Sourcing_Rule_Val_Rec_Type
628: )
629: IS
630: BEGIN
631: