141: );
142:
143: PROCEDURE Query_Rows
144: ( p_order_price_attrib_id IN NUMBER :=
145: FND_API.G_MISS_NUM
146: , p_Line_id IN NUMBER :=
147: FND_API.G_MISS_NUM
148: , x_Line_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Line_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_Line_id IN NUMBER :=
147: FND_API.G_MISS_NUM
148: , x_Line_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
149: );
150:
151:
154: );
155:
156:
157: PROCEDURE Delete_Row
158: ( p_order_price_attrib_id NUMBER := FND_API.G_MISS_NUM
159: , p_line_id NUMBER := FND_API.G_MISS_NUM
160: )
161: ;
162:
155:
156:
157: PROCEDURE Delete_Row
158: ( p_order_price_attrib_id NUMBER := FND_API.G_MISS_NUM
159: , p_line_id NUMBER := FND_API.G_MISS_NUM
160: )
161: ;
162:
163: PROCEDURE Insert_Row
164: ( p_Line_price_att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
165: );
166:
167: PROCEDURE Clear_Dependent_Attr
168: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
169: , p_x_Line_price_att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
170: , p_old_Line_price_att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type
171: := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
172: -- , x_Line_price_att_rec OUT OE_Order_PUB.Line_Price_Att_Rec_Type
199: PROCEDURE Lock_Row
200: ( x_return_status OUT NOCOPY VARCHAR2
201:
202: , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
203: , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
204: -- , x_Line_Price_Att_rec OUT OE_Order_PUB.Line_Price_Att_Rec_Type
205: );
206:
207: PROCEDURE Lock_Rows
205: );
206:
207: PROCEDURE Lock_Rows
208: ( p_order_price_attrib_id IN NUMBER
209: := FND_API.G_MISS_NUM
210: , p_line_id IN NUMBER
211: := FND_API.G_MISS_NUM
212: , x_Line_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
213: , x_return_status OUT NOCOPY VARCHAR2
207: PROCEDURE Lock_Rows
208: ( p_order_price_attrib_id IN NUMBER
209: := FND_API.G_MISS_NUM
210: , p_line_id IN NUMBER
211: := FND_API.G_MISS_NUM
212: , x_Line_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
213: , x_return_status OUT NOCOPY VARCHAR2
214:
215: );