4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Order_Line_PAttr';
5:
6: PROCEDURE Query_Row
7: ( p_order_price_attrib_id IN NUMBER
8: , x_Line_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
9: )
10: IS
11: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
12: BEGIN
7: ( p_order_price_attrib_id IN NUMBER
8: , x_Line_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
9: )
10: IS
11: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
12: BEGIN
13: Query_Rows
14: ( p_order_price_attrib_id => p_order_price_attrib_id
15: , x_Line_Price_Att_Tbl => l_Line_Price_Att_Tbl
24: ( p_order_price_attrib_id IN NUMBER :=
25: FND_API.G_MISS_NUM
26: , p_Line_id IN NUMBER :=
27: FND_API.G_MISS_NUM
28: , x_Line_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
29: )
30: IS
31: l_count NUMBER;
32:
379:
380:
381: /* Insert Row */
382: PROCEDURE Insert_Row
383: ( p_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
384: )
385: IS
386: l_lock_control NUMBER := 1;
387:
717:
718:
719: /* Update Row */
720: PROCEDURE Update_Row
721: ( p_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
722: )
723: IS
724: l_lock_control NUMBER;
725:
893:
894:
895: PROCEDURE Clear_Dependent_Attr
896: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
897: , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
898: , p_old_Line_Price_Att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type :=
899: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
900: -- , x_Line_Price_Att_rec OUT OE_Order_PUB.Line_Price_Att_Rec_Type
901: )
894:
895: PROCEDURE Clear_Dependent_Attr
896: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
897: , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
898: , p_old_Line_Price_Att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type :=
899: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
900: -- , x_Line_Price_Att_rec OUT OE_Order_PUB.Line_Price_Att_Rec_Type
901: )
902: IS
895: PROCEDURE Clear_Dependent_Attr
896: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
897: , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
898: , p_old_Line_Price_Att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type :=
899: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
900: -- , x_Line_Price_Att_rec OUT OE_Order_PUB.Line_Price_Att_Rec_Type
901: )
902: IS
903: l_index NUMBER := 0;
896: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
897: , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
898: , p_old_Line_Price_Att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type :=
899: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
900: -- , x_Line_Price_Att_rec OUT OE_Order_PUB.Line_Price_Att_Rec_Type
901: )
902: IS
903: l_index NUMBER := 0;
904: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
2105: END Clear_Dependent_Attr;
2106:
2107:
2108: PROCEDURE Complete_Record
2109: ( p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
2110: , p_old_Line_price_att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type
2111: )
2112: IS
2113:
2106:
2107:
2108: PROCEDURE Complete_Record
2109: ( p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
2110: , p_old_Line_price_att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type
2111: )
2112: IS
2113:
2114: l_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type := p_x_Line_Price_Att_rec;
2110: , p_old_Line_price_att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type
2111: )
2112: IS
2113:
2114: l_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type := p_x_Line_Price_Att_rec;
2115: BEGIN
2116:
2117: IF l_Line_price_att_rec.override_flag = FND_API.G_MISS_CHAR THEN
2118: l_Line_price_att_rec.override_flag := p_old_Line_price_att_rec.override_flag;
2646:
2647: END Complete_Record;
2648:
2649: PROCEDURE Convert_Miss_To_Null
2650: ( p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
2651: )
2652: IS
2653: l_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type := p_x_Line_Price_Att_rec;
2654: BEGIN
2649: PROCEDURE Convert_Miss_To_Null
2650: ( p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
2651: )
2652: IS
2653: l_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type := p_x_Line_Price_Att_rec;
2654: BEGIN
2655:
2656: IF l_Line_price_att_rec.override_flag = FND_API.G_MISS_CHAR THEN
2657: l_Line_price_att_rec.override_flag := NULL;
3185:
3186: END Convert_Miss_To_Null;
3187:
3188: PROCEDURE Apply_Attribute_Changes
3189: ( p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
3190: , p_old_Line_price_att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
3191: )
3192: IS
3193: l_price_flag boolean := FALSE;
3186: END Convert_Miss_To_Null;
3187:
3188: PROCEDURE Apply_Attribute_Changes
3189: ( p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
3190: , p_old_Line_price_att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC
3191: )
3192: IS
3193: l_price_flag boolean := FALSE;
3194: l_booked_flag Varchar2(1) := 'N';
4201: --
4202:
4203: PROCEDURE Lock_Row
4204: ( x_return_status OUT NOCOPY VARCHAR2
4205: , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
4206: , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
4207: )
4208: IS
4209: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4205: , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
4206: , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
4207: )
4208: IS
4209: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4210: l_order_price_attrib_id NUMBER;
4211: l_lock_control NUMBER;
4212:
4213: BEGIN
4339: ( p_order_price_attrib_id IN NUMBER
4340: := FND_API.G_MISS_NUM
4341: , p_line_id IN NUMBER
4342: := FND_API.G_MISS_NUM
4343: , x_Line_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
4344: , x_return_status OUT NOCOPY VARCHAR2
4345: )
4346: IS
4347:
4350: FROM oe_order_price_attribs
4351: WHERE line_id = p_line_id
4352: FOR UPDATE NOWAIT;
4353:
4354: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4355: l_order_price_attrib_id NUMBER;
4356: l_lock_control NUMBER;
4357:
4358: BEGIN
4455: , p_to_header_id NUMBER
4456: , x_return_status OUT NOCOPY VARCHAR2
4457: ) IS
4458:
4459: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
4460: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
4461: l_control_rec Oe_Globals.Control_rec_type;
4462: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4463: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4456: , x_return_status OUT NOCOPY VARCHAR2
4457: ) IS
4458:
4459: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
4460: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
4461: l_control_rec Oe_Globals.Control_rec_type;
4462: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4463: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4464: l_header_rec OE_Order_PUB.Header_Rec_Type;
4458:
4459: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
4460: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
4461: l_control_rec Oe_Globals.Control_rec_type;
4462: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4463: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4464: l_header_rec OE_Order_PUB.Header_Rec_Type;
4465: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4466: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4459: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
4460: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
4461: l_control_rec Oe_Globals.Control_rec_type;
4462: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4463: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4464: l_header_rec OE_Order_PUB.Header_Rec_Type;
4465: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4466: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4467: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4460: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
4461: l_control_rec Oe_Globals.Control_rec_type;
4462: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4463: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4464: l_header_rec OE_Order_PUB.Header_Rec_Type;
4465: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4466: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4467: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4468: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4461: l_control_rec Oe_Globals.Control_rec_type;
4462: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4463: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4464: l_header_rec OE_Order_PUB.Header_Rec_Type;
4465: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4466: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4467: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4468: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4469: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4462: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4463: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4464: l_header_rec OE_Order_PUB.Header_Rec_Type;
4465: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4466: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4467: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4468: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4469: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4470: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4463: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4464: l_header_rec OE_Order_PUB.Header_Rec_Type;
4465: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4466: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4467: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4468: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4469: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4470: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4471: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4464: l_header_rec OE_Order_PUB.Header_Rec_Type;
4465: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4466: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4467: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4468: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4469: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4470: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4471: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4472: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4465: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4466: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4467: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4468: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4469: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4470: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4471: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4472: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4473: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4466: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4467: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4468: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4469: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4470: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4471: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4472: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4473: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4474: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4467: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4468: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4469: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4470: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4471: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4472: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4473: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4474: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4475: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4468: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4469: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4470: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4471: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4472: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4473: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4474: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4475: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4476: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4469: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4470: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4471: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4472: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4473: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4474: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4475: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4476: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4477: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4470: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4471: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4472: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4473: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4474: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4475: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4476: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4477: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4478: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4471: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4472: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4473: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4474: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4475: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4476: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4477: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4478: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4479: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4472: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4473: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4474: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4475: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4476: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4477: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4478: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4479: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4480: l_x_msg_count number;
4473: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4474: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4475: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4476: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4477: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4478: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4479: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4480: l_x_msg_count number;
4481: l_x_msg_data Varchar2(2000);
4474: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4475: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4476: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4477: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4478: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4479: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4480: l_x_msg_count number;
4481: l_x_msg_data Varchar2(2000);
4482: l_df_error_code number := 0;
4475: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4476: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4477: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4478: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4479: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4480: l_x_msg_count number;
4481: l_x_msg_data Varchar2(2000);
4482: l_df_error_code number := 0;
4483: --serla begin
4480: l_x_msg_count number;
4481: l_x_msg_data Varchar2(2000);
4482: l_df_error_code number := 0;
4483: --serla begin
4484: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4485: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4486: --serla end
4487: i PLS_INTEGER;
4488:
4481: l_x_msg_data Varchar2(2000);
4482: l_df_error_code number := 0;
4483: --serla begin
4484: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4485: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4486: --serla end
4487: i PLS_INTEGER;
4488:
4489: BEGIN