6: , x_Header_Adj_Assoc_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type);
7:
8: PROCEDURE Query_Rows
9: ( p_price_adj_Assoc_id IN NUMBER :=
10: FND_API.G_MISS_NUM
11: , p_price_adjustment_id IN NUMBER :=
12: FND_API.G_MISS_NUM
13: , x_Header_Adj_Assoc_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
14: );
8: PROCEDURE Query_Rows
9: ( p_price_adj_Assoc_id IN NUMBER :=
10: FND_API.G_MISS_NUM
11: , p_price_adjustment_id IN NUMBER :=
12: FND_API.G_MISS_NUM
13: , x_Header_Adj_Assoc_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
14: );
15:
16: PROCEDURE Insert_Row
22: );
23:
24:
25: PROCEDURE Delete_Row
26: ( p_price_adj_Assoc_id NUMBER := FND_API.G_MISS_NUM
27: , p_price_adjustment_id NUMBER := FND_API.G_MISS_NUM
28: )
29: ;
30:
23:
24:
25: PROCEDURE Delete_Row
26: ( p_price_adj_Assoc_id NUMBER := FND_API.G_MISS_NUM
27: , p_price_adjustment_id NUMBER := FND_API.G_MISS_NUM
28: )
29: ;
30:
31: -- Procedure Complete_Record
54: PROCEDURE Lock_Row
55: ( x_return_status OUT NOCOPY VARCHAR2
56:
57: , p_x_Header_Adj_Assoc_rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
58: , p_price_adj_assoc_id IN NUMBER := FND_API.G_MISS_NUM
59: );
60:
61: PROCEDURE Lock_Rows
62: ( p_price_adj_assoc_id IN NUMBER
59: );
60:
61: PROCEDURE Lock_Rows
62: ( p_price_adj_assoc_id IN NUMBER
63: := FND_API.G_MISS_NUM
64: , p_price_adjustment_id IN NUMBER
65: := FND_API.G_MISS_NUM
66: , x_Header_Adj_Assoc_tbl OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
67: , x_return_status OUT NOCOPY VARCHAR2
61: PROCEDURE Lock_Rows
62: ( p_price_adj_assoc_id IN NUMBER
63: := FND_API.G_MISS_NUM
64: , p_price_adjustment_id IN NUMBER
65: := FND_API.G_MISS_NUM
66: , x_Header_Adj_Assoc_tbl OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
67: , x_return_status OUT NOCOPY VARCHAR2
68:
69: );