DBA Data[Home] [Help]

APPS.OE_LINE_PATTR_UTIL dependencies on OE_ORDER_PUB

Line 8: , x_Line_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type

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

Line 11: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

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

Line 28: , x_Line_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type

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:

Line 383: ( p_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type

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:

Line 721: ( p_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type

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:

Line 897: , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type

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: )

Line 898: , p_old_Line_Price_Att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type :=

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

Line 899: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC

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;

Line 900: -- , x_Line_Price_Att_rec OUT OE_Order_PUB.Line_Price_Att_Rec_Type

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;

Line 2109: ( p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_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:

Line 2110: , p_old_Line_price_att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type

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;

Line 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;

Line 2650: ( p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type

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

Line 2653: l_Line_price_att_rec OE_Order_PUB.Line_Price_Att_Rec_Type := p_x_Line_Price_Att_rec;

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;

Line 3189: ( p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type

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;

Line 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

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';

Line 4205: , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type

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;

Line 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

Line 4343: , x_Line_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type

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:

Line 4354: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

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

Line 4459: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;

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;

Line 4460: l_Line_Adj_tbl oe_order_pub.Line_adj_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;

Line 4462: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_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;

Line 4463: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_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;

Line 4464: l_header_rec OE_Order_PUB.Header_Rec_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;

Line 4465: l_x_Header_Adj_tbl OE_Order_PUB.Header_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;
4469: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 4466: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_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;

Line 4467: l_x_line_tbl OE_Order_PUB.Line_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;

Line 4468: l_line_tbl OE_Order_PUB.Line_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;

Line 4469: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_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;

Line 4470: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_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;

Line 4471: l_x_action_request_tbl OE_Order_PUB.request_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;

Line 4472: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_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;

Line 4473: l_x_Header_price_Att_tbl OE_Order_PUB.Header_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;

Line 4474: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_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;

Line 4475: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_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;

Line 4476: l_x_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;

Line 4477: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_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;
4481: l_x_msg_data Varchar2(2000);

Line 4478: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_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);
4482: l_df_error_code number := 0;

Line 4479: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_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;
4483: --serla begin

Line 4484: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_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
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:

Line 4485: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

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