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 4164: , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type

4160: --
4161:
4162: PROCEDURE Lock_Row
4163: ( x_return_status OUT NOCOPY VARCHAR2
4164: , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
4165: , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
4166: )
4167: IS
4168: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;

Line 4168: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;

4164: , p_x_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
4165: , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
4166: )
4167: IS
4168: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4169: l_order_price_attrib_id NUMBER;
4170: l_lock_control NUMBER;
4171:
4172: BEGIN

Line 4302: , x_Line_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type

4298: ( p_order_price_attrib_id IN NUMBER
4299: := FND_API.G_MISS_NUM
4300: , p_line_id IN NUMBER
4301: := FND_API.G_MISS_NUM
4302: , x_Line_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
4303: , x_return_status OUT NOCOPY VARCHAR2
4304: )
4305: IS
4306:

Line 4313: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

4309: FROM oe_order_price_attribs
4310: WHERE line_id = p_line_id
4311: FOR UPDATE NOWAIT;
4312:
4313: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4314: l_order_price_attrib_id NUMBER;
4315: l_lock_control NUMBER;
4316:
4317: BEGIN

Line 4418: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;

4414: , p_to_header_id NUMBER
4415: , x_return_status OUT NOCOPY VARCHAR2
4416: ) IS
4417:
4418: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
4419: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
4420: l_control_rec Oe_Globals.Control_rec_type;
4421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

Line 4419: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;

4415: , x_return_status OUT NOCOPY VARCHAR2
4416: ) IS
4417:
4418: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
4419: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
4420: l_control_rec Oe_Globals.Control_rec_type;
4421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4423: l_header_rec OE_Order_PUB.Header_Rec_Type;

Line 4421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

4417:
4418: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
4419: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
4420: l_control_rec Oe_Globals.Control_rec_type;
4421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4423: l_header_rec OE_Order_PUB.Header_Rec_Type;
4424: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4425: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 4422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

4418: l_Header_Adj_tbl oe_order_pub.Header_adj_tbl_type;
4419: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
4420: l_control_rec Oe_Globals.Control_rec_type;
4421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4423: l_header_rec OE_Order_PUB.Header_Rec_Type;
4424: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4425: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4426: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 4423: l_header_rec OE_Order_PUB.Header_Rec_Type;

4419: l_Line_Adj_tbl oe_order_pub.Line_adj_tbl_type;
4420: l_control_rec Oe_Globals.Control_rec_type;
4421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4423: l_header_rec OE_Order_PUB.Header_Rec_Type;
4424: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4425: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4426: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4427: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 4424: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

4420: l_control_rec Oe_Globals.Control_rec_type;
4421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4423: l_header_rec OE_Order_PUB.Header_Rec_Type;
4424: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4425: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4426: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4427: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4428: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 4425: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

4421: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4423: l_header_rec OE_Order_PUB.Header_Rec_Type;
4424: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4425: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4426: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4427: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4428: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4429: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 4426: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

4422: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4423: l_header_rec OE_Order_PUB.Header_Rec_Type;
4424: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4425: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4426: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4427: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4428: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4429: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4430: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

Line 4427: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

4423: l_header_rec OE_Order_PUB.Header_Rec_Type;
4424: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4425: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4426: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4427: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4428: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4429: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4430: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4431: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

Line 4428: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

4424: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4425: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4426: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4427: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4428: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4429: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4430: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4431: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4432: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;

Line 4429: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

4425: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4426: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4427: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4428: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4429: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4430: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4431: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4432: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4433: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;

Line 4430: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;

4426: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4427: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4428: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4429: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4430: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4431: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4432: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4433: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4434: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;

Line 4431: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;

4427: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
4428: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4429: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4430: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4431: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4432: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4433: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4434: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4435: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;

Line 4432: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;

4428: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4429: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4430: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4431: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4432: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4433: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4434: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4435: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4436: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

Line 4433: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;

4429: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4430: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4431: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4432: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4433: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4434: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4435: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4436: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4437: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

Line 4434: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;

4430: l_x_action_request_tbl OE_Order_PUB.request_tbl_type;
4431: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4432: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4433: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4434: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4435: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4436: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4437: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4438: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 4435: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;

4431: l_x_lot_serial_tbl OE_Order_PUB.lot_serial_tbl_type;
4432: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4433: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4434: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4435: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4436: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4437: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4438: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4439: l_x_msg_count number;

Line 4436: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;

4432: l_x_Header_price_Att_tbl OE_Order_PUB.Header_price_Att_tbl_type;
4433: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4434: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4435: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4436: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4437: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4438: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4439: l_x_msg_count number;
4440: l_x_msg_data Varchar2(2000);

Line 4437: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;

4433: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_tbl_type;
4434: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4435: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4436: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4437: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4438: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4439: l_x_msg_count number;
4440: l_x_msg_data Varchar2(2000);
4441: l_df_error_code number := 0;

Line 4438: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

4434: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_tbl_type;
4435: l_x_Line_price_Att_tbl OE_Order_PUB.Line_price_Att_tbl_type;
4436: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_tbl_type;
4437: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_tbl_type;
4438: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4439: l_x_msg_count number;
4440: l_x_msg_data Varchar2(2000);
4441: l_df_error_code number := 0;
4442: --serla begin

Line 4443: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

4439: l_x_msg_count number;
4440: l_x_msg_data Varchar2(2000);
4441: l_df_error_code number := 0;
4442: --serla begin
4443: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4444: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4445: --serla end
4446: i PLS_INTEGER;
4447:

Line 4444: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

4440: l_x_msg_data Varchar2(2000);
4441: l_df_error_code number := 0;
4442: --serla begin
4443: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
4444: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4445: --serla end
4446: i PLS_INTEGER;
4447:
4448: BEGIN