141: );
142:
143: PROCEDURE Query_Rows
144: ( p_order_price_attrib_id IN NUMBER :=
145: FND_API.G_MISS_NUM
146: , p_header_id IN NUMBER :=
147: FND_API.G_MISS_NUM
148: , x_Header_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
149: );
143: PROCEDURE Query_Rows
144: ( p_order_price_attrib_id IN NUMBER :=
145: FND_API.G_MISS_NUM
146: , p_header_id IN NUMBER :=
147: FND_API.G_MISS_NUM
148: , x_Header_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
149: );
150:
151: PROCEDURE Clear_Dependent_Attr
148: , x_Header_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
149: );
150:
151: PROCEDURE Clear_Dependent_Attr
152: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
153: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
154: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
155: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
156: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
187: );
188:
189:
190: PROCEDURE Delete_Row
191: ( p_order_price_attrib_id NUMBER := FND_API.G_MISS_NUM
192: , p_Header_id NUMBER := FND_API.G_MISS_NUM
193: )
194: ;
195:
188:
189:
190: PROCEDURE Delete_Row
191: ( p_order_price_attrib_id NUMBER := FND_API.G_MISS_NUM
192: , p_Header_id NUMBER := FND_API.G_MISS_NUM
193: )
194: ;
195:
196: PROCEDURE Insert_Row
200: PROCEDURE Lock_Row
201: ( x_return_status OUT NOCOPY VARCHAR2
202:
203: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
204: , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
205: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
206: )
207: ;
208:
207: ;
208:
209: PROCEDURE Lock_Rows
210: ( p_order_price_attrib_id IN NUMBER
211: := FND_API.G_MISS_NUM
212: , p_header_id IN NUMBER
213: := FND_API.G_MISS_NUM
214: , x_Header_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
215: , x_return_status OUT NOCOPY VARCHAR2
209: PROCEDURE Lock_Rows
210: ( p_order_price_attrib_id IN NUMBER
211: := FND_API.G_MISS_NUM
212: , p_header_id IN NUMBER
213: := FND_API.G_MISS_NUM
214: , x_Header_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
215: , x_return_status OUT NOCOPY VARCHAR2
216:
217: );