7:
8: -- Procedure Update_Row
9:
10: PROCEDURE Update_Row
11: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
12: )
13: IS
14: BEGIN
15:
63:
64: -- Procedure Insert_Row
65:
66: PROCEDURE Insert_Row
67: ( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
68: )
69: IS
70: BEGIN
71:
203: --
204:
205: PROCEDURE Lock_Row
206: ( x_return_status OUT VARCHAR2
207: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
208: , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
209: )
210: IS
211: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
204:
205: PROCEDURE Lock_Row
206: ( x_return_status OUT VARCHAR2
207: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
208: , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
209: )
210: IS
211: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
212: BEGIN
207: , p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
208: , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
209: )
210: IS
211: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
212: BEGIN
213:
214: SELECT ASSIGNMENT_SET_ID
215: , ASSIGNMENT_SET_NAME
485: -- Function Query_Row
486:
487: FUNCTION Query_Row
488: ( p_Assignment_Set_Id IN NUMBER
489: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
490: IS
491: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
492: BEGIN
493:
487: FUNCTION Query_Row
488: ( p_Assignment_Set_Id IN NUMBER
489: ) RETURN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
490: IS
491: l_Assignment_Set_rec MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type;
492: BEGIN
493:
494: SELECT ASSIGNMENT_SET_ID
495: , ASSIGNMENT_SET_NAME
572: -- Procedure Query_Entity
573:
574: PROCEDURE Query_Entity
575: ( p_Assignment_Set_Id IN NUMBER
576: , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
577: , x_Assignment_Set_val_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type
578: )
579: IS
580: BEGIN
573:
574: PROCEDURE Query_Entity
575: ( p_Assignment_Set_Id IN NUMBER
576: , x_Assignment_Set_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
577: , x_Assignment_Set_val_rec OUT MRP_Src_Assignment_PUB.Assignment_Set_Val_Rec_Type
578: )
579: IS
580: BEGIN
581: