3:
4: -- Procedure Update_Row
5:
6: PROCEDURE Update_Row
7: ( p_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type
8: );
9:
10: -- Procedure Insert_Row
11:
9:
10: -- Procedure Insert_Row
11:
12: PROCEDURE Insert_Row
13: ( p_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type
14: );
15:
16: -- Procedure Delete_Row
17:
23: --
24:
25: PROCEDURE Lock_Row
26: ( x_return_status OUT VARCHAR2
27: , p_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type
28: , x_Assignment_rec OUT MRP_Src_Assignment_PUB.Assignment_Rec_Type
29: );
30:
31: -- Function Query_Row
24:
25: PROCEDURE Lock_Row
26: ( x_return_status OUT VARCHAR2
27: , p_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type
28: , x_Assignment_rec OUT MRP_Src_Assignment_PUB.Assignment_Rec_Type
29: );
30:
31: -- Function Query_Row
32:
31: -- Function Query_Row
32:
33: FUNCTION Query_Row
34: ( p_Assignment_Id IN NUMBER
35: ) RETURN MRP_Src_Assignment_PUB.Assignment_Rec_Type;
36:
37: -- Procedure Query_Entity
38:
39: PROCEDURE Query_Entity
37: -- Procedure Query_Entity
38:
39: PROCEDURE Query_Entity
40: ( p_Assignment_Id IN NUMBER
41: , x_Assignment_rec OUT MRP_Src_Assignment_PUB.Assignment_Rec_Type
42: , x_Assignment_val_rec OUT MRP_Src_Assignment_PUB.Assignment_Val_Rec_Type
43: );
44:
45: -- Function Query_Rows
38:
39: PROCEDURE Query_Entity
40: ( p_Assignment_Id IN NUMBER
41: , x_Assignment_rec OUT MRP_Src_Assignment_PUB.Assignment_Rec_Type
42: , x_Assignment_val_rec OUT MRP_Src_Assignment_PUB.Assignment_Val_Rec_Type
43: );
44:
45: -- Function Query_Rows
46:
50: ( p_Assignment_Id IN NUMBER :=
51: FND_API.G_MISS_NUM
52: , p_Assignment_Set_Id IN NUMBER :=
53: FND_API.G_MISS_NUM
54: ) RETURN MRP_Src_Assignment_PUB.Assignment_Tbl_Type;
55:
56: -- Procedure Query_Entities
57:
58: --
61: ( p_Assignment_Id IN NUMBER :=
62: FND_API.G_MISS_NUM
63: , p_Assignment_Set_Id IN NUMBER :=
64: FND_API.G_MISS_NUM
65: , x_Assignment_tbl OUT MRP_Src_Assignment_PUB.Assignment_Tbl_Type
66: , x_Assignment_val_tbl OUT MRP_Src_Assignment_PUB.Assignment_Val_Tbl_Type
67: );
68:
69: END MRP_Assignment_Handlers;
62: FND_API.G_MISS_NUM
63: , p_Assignment_Set_Id IN NUMBER :=
64: FND_API.G_MISS_NUM
65: , x_Assignment_tbl OUT MRP_Src_Assignment_PUB.Assignment_Tbl_Type
66: , x_Assignment_val_tbl OUT MRP_Src_Assignment_PUB.Assignment_Val_Tbl_Type
67: );
68:
69: END MRP_Assignment_Handlers;