7: );
8:
9: PROCEDURE Query_Rows
10: ( p_price_adj_Assoc_id IN NUMBER :=
11: FND_API.G_MISS_NUM
12: , p_price_adjustment_id IN NUMBER :=
13: FND_API.G_MISS_NUM
14: , x_Line_Adj_Assoc_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
15: );
9: PROCEDURE Query_Rows
10: ( p_price_adj_Assoc_id IN NUMBER :=
11: FND_API.G_MISS_NUM
12: , p_price_adjustment_id IN NUMBER :=
13: FND_API.G_MISS_NUM
14: , x_Line_Adj_Assoc_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
15: );
16:
17: PROCEDURE Insert_Row
23: );
24:
25:
26: PROCEDURE Delete_Row
27: ( p_price_adj_Assoc_id NUMBER := FND_API.G_MISS_NUM
28: , p_price_adjustment_id NUMBER := FND_API.G_MISS_NUM
29: )
30: ;
31: -- Procedure Complete_Record
24:
25:
26: PROCEDURE Delete_Row
27: ( p_price_adj_Assoc_id NUMBER := FND_API.G_MISS_NUM
28: , p_price_adjustment_id NUMBER := FND_API.G_MISS_NUM
29: )
30: ;
31: -- Procedure Complete_Record
32:
54: PROCEDURE Lock_Row
55: ( x_return_status OUT NOCOPY VARCHAR2
56:
57: , p_x_Line_Adj_Assoc_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Rec_Type
58: , p_price_adj_assoc_id IN NUMBER := FND_API.G_MISS_NUM
59: -- , x_Line_Adj_Assoc_rec OUT OE_Order_PUB.Line_Adj_Assoc_Rec_Type
60: );
61:
62: PROCEDURE Lock_Rows
60: );
61:
62: PROCEDURE Lock_Rows
63: ( p_price_adj_assoc_id IN NUMBER
64: := FND_API.G_MISS_NUM
65: , p_price_adjustment_id IN NUMBER
66: := FND_API.G_MISS_NUM
67: , x_Line_Adj_Assoc_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
68: , x_return_status OUT NOCOPY VARCHAR2
62: PROCEDURE Lock_Rows
63: ( p_price_adj_assoc_id IN NUMBER
64: := FND_API.G_MISS_NUM
65: , p_price_adjustment_id IN NUMBER
66: := FND_API.G_MISS_NUM
67: , x_Line_Adj_Assoc_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
68: , x_return_status OUT NOCOPY VARCHAR2
69:
70: );