eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_OE_FORM_HEADER_ADJ dependencies on OE_ORDER_PUB

Line 10: g_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Header_Adj';
7:
8: -- Global variables holding cached record.
9:
10: g_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type
11: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;
12: g_db_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type
13: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;
14:

Line 11: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;

7:
8: -- Global variables holding cached record.
9:
10: g_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type
11: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;
12: g_db_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type
13: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;
14:
15: -- Forward declaration of procedures maintaining entity record cache.

Line 12: g_db_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type

8: -- Global variables holding cached record.
9:
10: g_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type
11: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;
12: g_db_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type
13: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;
14:
15: -- Forward declaration of procedures maintaining entity record cache.
16:

Line 13: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;

9:
10: g_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type
11: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;
12: g_db_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type
13: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;
14:
15: -- Forward declaration of procedures maintaining entity record cache.
16:
17: PROCEDURE Write_Header_Adj

Line 18: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type

14:
15: -- Forward declaration of procedures maintaining entity record cache.
16:
17: PROCEDURE Write_Header_Adj
18: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
19: , p_db_record IN BOOLEAN := FALSE
20: );
21:
22: PROCEDURE Get_Header_Adj

Line 25: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

21:
22: PROCEDURE Get_Header_Adj
23: ( p_db_record IN BOOLEAN := FALSE
24: , p_price_adjustment_id IN NUMBER
25: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
26: );
27:
28: PROCEDURE Clear_Header_Adj;
29:

Line 32: g_opr__tbl OE_Order_PUB.Header_Adj_Tbl_Type;

28: PROCEDURE Clear_Header_Adj;
29:
30: -- Global variable holding performed operations.
31:
32: g_opr__tbl OE_Order_PUB.Header_Adj_Tbl_Type;
33:
34: -- Procedure : Default_Attributes
35: --
36:

Line 201: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

197:
198: --uom end
199: )
200: IS
201: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
202: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
203: l_Header_Adj_val_rec OE_Order_Pub.Header_Adj_Val_Rec_Type;
204: l_control_rec OE_GLOBALS.Control_Rec_Type;
205: l_return_status VARCHAR2(1);

Line 202: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

198: --uom end
199: )
200: IS
201: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
202: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
203: l_Header_Adj_val_rec OE_Order_Pub.Header_Adj_Val_Rec_Type;
204: l_control_rec OE_GLOBALS.Control_Rec_Type;
205: l_return_status VARCHAR2(1);
206: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 203: l_Header_Adj_val_rec OE_Order_Pub.Header_Adj_Val_Rec_Type;

199: )
200: IS
201: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
202: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
203: l_Header_Adj_val_rec OE_Order_Pub.Header_Adj_Val_Rec_Type;
204: l_control_rec OE_GLOBALS.Control_Rec_Type;
205: l_return_status VARCHAR2(1);
206: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
207: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 206: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

202: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
203: l_Header_Adj_val_rec OE_Order_Pub.Header_Adj_Val_Rec_Type;
204: l_control_rec OE_GLOBALS.Control_Rec_Type;
205: l_return_status VARCHAR2(1);
206: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
207: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
208: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
209: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
210: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 207: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

203: l_Header_Adj_val_rec OE_Order_Pub.Header_Adj_Val_Rec_Type;
204: l_control_rec OE_GLOBALS.Control_Rec_Type;
205: l_return_status VARCHAR2(1);
206: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
207: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
208: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
209: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
210: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
211: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 208: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

204: l_control_rec OE_GLOBALS.Control_Rec_Type;
205: l_return_status VARCHAR2(1);
206: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
207: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
208: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
209: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
210: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
211: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
212: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

Line 209: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

205: l_return_status VARCHAR2(1);
206: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
207: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
208: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
209: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
210: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
211: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
212: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
213: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 210: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

206: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
207: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
208: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
209: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
210: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
211: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
212: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
213: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
214: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

Line 211: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

207: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
208: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
209: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
210: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
211: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
212: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
213: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
214: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
215: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 212: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

208: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
209: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
210: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
211: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
212: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
213: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
214: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
215: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
216: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 213: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

209: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
210: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
211: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
212: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
213: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
214: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
215: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
216: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
217: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 214: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

210: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
211: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
212: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
213: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
214: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
215: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
216: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
217: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
218: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 215: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

211: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
212: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
213: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
214: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
215: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
216: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
217: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
218: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
219: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 216: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

212: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
213: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
214: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
215: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
216: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
217: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
218: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
219: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
220: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

Line 217: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

213: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
214: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
215: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
216: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
217: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
218: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
219: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
220: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
221: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 218: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

214: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
215: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
216: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
217: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
218: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
219: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
220: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
221: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
222:

Line 219: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

215: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
216: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
217: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
218: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
219: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
220: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
221: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
222:
223:

Line 220: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

216: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
217: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
218: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
219: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
220: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
221: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
222:
223:
224: --New out parameters

Line 221: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

217: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
218: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
219: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
220: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
221: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
222:
223:
224: --New out parameters
225: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 225: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

221: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
222:
223:
224: --New out parameters
225: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
226: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
227: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
228:
229: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

Line 226: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

222:
223:
224: --New out parameters
225: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
226: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
227: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
228:
229: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
230: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

Line 227: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

223:
224: --New out parameters
225: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
226: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
227: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
228:
229: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
230: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
231: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 229: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

225: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
226: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
227: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
228:
229: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
230: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
231: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
232:
233: --

Line 230: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

226: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
227: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
228:
229: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
230: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
231: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
232:
233: --
234: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 231: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

227: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
228:
229: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
230: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
231: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
232:
233: --
234: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
235: --

Line 258: l_x_old_header_adj_rec := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;

254: l_control_rec.clear_api_cache := FALSE;
255: l_control_rec.clear_api_requests := FALSE;
256:
257:
258: l_x_old_header_adj_rec := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;
259: l_x_header_adj_rec := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;
260:
261: -- Load IN parameters if any exist
262: l_x_Header_adj_rec.header_id := p_header_id;

Line 259: l_x_header_adj_rec := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;

255: l_control_rec.clear_api_requests := FALSE;
256:
257:
258: l_x_old_header_adj_rec := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;
259: l_x_header_adj_rec := OE_ORDER_PUB.G_MISS_HEADER_ADJ_REC;
260:
261: -- Load IN parameters if any exist
262: l_x_Header_adj_rec.header_id := p_header_id;
263: l_x_Header_adj_rec.line_id := p_line_id;

Line 745: l_request_rec OE_Order_Pub.Request_Rec_Type;

741:
742: --uom end
743: )
744: IS
745: l_request_rec OE_Order_Pub.Request_Rec_Type;
746: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
747: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
748: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
749: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

Line 746: l_request_tbl OE_Order_Pub.Request_Tbl_Type;

742: --uom end
743: )
744: IS
745: l_request_rec OE_Order_Pub.Request_Rec_Type;
746: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
747: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
748: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
749: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
750: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 747: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

743: )
744: IS
745: l_request_rec OE_Order_Pub.Request_Rec_Type;
746: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
747: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
748: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
749: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
750: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
751: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 748: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

744: IS
745: l_request_rec OE_Order_Pub.Request_Rec_Type;
746: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
747: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
748: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
749: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
750: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
751: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
752: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 749: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

745: l_request_rec OE_Order_Pub.Request_Rec_Type;
746: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
747: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
748: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
749: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
750: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
751: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
752: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
753: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;

Line 750: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

746: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
747: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
748: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
749: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
750: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
751: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
752: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
753: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;
754: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 751: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

747: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
748: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
749: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
750: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
751: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
752: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
753: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;
754: l_control_rec OE_GLOBALS.Control_Rec_Type;
755: l_return_status VARCHAR2(1);

Line 752: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

748: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
749: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
750: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
751: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
752: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
753: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;
754: l_control_rec OE_GLOBALS.Control_Rec_Type;
755: l_return_status VARCHAR2(1);
756: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 753: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;

749: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
750: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
751: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
752: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
753: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;
754: l_control_rec OE_GLOBALS.Control_Rec_Type;
755: l_return_status VARCHAR2(1);
756: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
757: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 756: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

752: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
753: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;
754: l_control_rec OE_GLOBALS.Control_Rec_Type;
755: l_return_status VARCHAR2(1);
756: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
757: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
758: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
759: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
760: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

Line 757: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

753: l_Header_Adj_val_rec OE_Order_PUB.Header_Adj_Val_Rec_Type;
754: l_control_rec OE_GLOBALS.Control_Rec_Type;
755: l_return_status VARCHAR2(1);
756: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
757: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
758: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
759: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
760: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
761: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 758: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

754: l_control_rec OE_GLOBALS.Control_Rec_Type;
755: l_return_status VARCHAR2(1);
756: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
757: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
758: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
759: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
760: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
761: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
762: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

Line 759: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

755: l_return_status VARCHAR2(1);
756: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
757: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
758: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
759: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
760: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
761: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
762: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
763: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 760: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

756: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
757: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
758: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
759: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
760: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
761: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
762: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
763: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
764: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 761: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

757: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
758: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
759: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
760: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
761: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
762: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
763: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
764: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
765: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 762: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

758: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
759: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
760: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
761: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
762: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
763: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
764: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
765: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
766: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 763: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

759: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
760: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
761: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
762: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
763: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
764: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
765: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
766: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
767: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 764: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

760: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
761: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
762: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
763: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
764: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
765: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
766: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
767: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
768: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

Line 765: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

761: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
762: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
763: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
764: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
765: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
766: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
767: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
768: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
769: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 766: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

762: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
763: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
764: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
765: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
766: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
767: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
768: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
769: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
770:

Line 767: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

763: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
764: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
765: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
766: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
767: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
768: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
769: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
770:
771: --New out parameters

Line 768: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

764: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
765: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
766: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
767: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
768: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
769: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
770:
771: --New out parameters
772: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 769: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

765: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
766: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
767: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
768: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
769: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
770:
771: --New out parameters
772: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
773: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 772: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

768: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
769: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
770:
771: --New out parameters
772: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
773: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
774: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
775:
776: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

Line 773: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

769: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
770:
771: --New out parameters
772: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
773: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
774: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
775:
776: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
777: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

Line 774: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

770:
771: --New out parameters
772: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
773: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
774: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
775:
776: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
777: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
778: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

Line 776: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

772: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
773: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
774: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
775:
776: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
777: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
778: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
779: l_date_format Varchar2(22) := 'DD-MON-YYYY HH24:MI:SS';
780: stmt NUMBER:=0;

Line 777: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

773: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
774: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
775:
776: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
777: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
778: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
779: l_date_format Varchar2(22) := 'DD-MON-YYYY HH24:MI:SS';
780: stmt NUMBER:=0;
781: --

Line 778: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

774: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
775:
776: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
777: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
778: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
779: l_date_format Varchar2(22) := 'DD-MON-YYYY HH24:MI:SS';
780: stmt NUMBER:=0;
781: --
782: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1788: l_request_rec OE_order_pub.Request_Rec_Type;

1784: , x_lock_control OUT NOCOPY NUMBER
1785:
1786: )
1787: IS
1788: l_request_rec OE_order_pub.Request_Rec_Type;
1789: l_request_tbl OE_order_pub.Request_Tbl_Type;
1790: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1791: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1792: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

Line 1789: l_request_tbl OE_order_pub.Request_Tbl_Type;

1785:
1786: )
1787: IS
1788: l_request_rec OE_order_pub.Request_Rec_Type;
1789: l_request_tbl OE_order_pub.Request_Tbl_Type;
1790: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1791: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1792: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1793: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 1790: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

1786: )
1787: IS
1788: l_request_rec OE_order_pub.Request_Rec_Type;
1789: l_request_tbl OE_order_pub.Request_Tbl_Type;
1790: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1791: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1792: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1793: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1794: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 1791: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

1787: IS
1788: l_request_rec OE_order_pub.Request_Rec_Type;
1789: l_request_tbl OE_order_pub.Request_Tbl_Type;
1790: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1791: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1792: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1793: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1794: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1795: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 1792: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

1788: l_request_rec OE_order_pub.Request_Rec_Type;
1789: l_request_tbl OE_order_pub.Request_Tbl_Type;
1790: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1791: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1792: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1793: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1794: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1795: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1796: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 1793: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

1789: l_request_tbl OE_order_pub.Request_Tbl_Type;
1790: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1791: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1792: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1793: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1794: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1795: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1796: l_control_rec OE_GLOBALS.Control_Rec_Type;
1797: l_return_status VARCHAR2(1);

Line 1794: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

1790: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1791: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1792: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1793: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1794: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1795: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1796: l_control_rec OE_GLOBALS.Control_Rec_Type;
1797: l_return_status VARCHAR2(1);
1798: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 1795: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

1791: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1792: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1793: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1794: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1795: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1796: l_control_rec OE_GLOBALS.Control_Rec_Type;
1797: l_return_status VARCHAR2(1);
1798: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1799: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 1798: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

1794: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1795: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1796: l_control_rec OE_GLOBALS.Control_Rec_Type;
1797: l_return_status VARCHAR2(1);
1798: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1799: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1800: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1801: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1802: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

Line 1799: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

1795: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1796: l_control_rec OE_GLOBALS.Control_Rec_Type;
1797: l_return_status VARCHAR2(1);
1798: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1799: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1800: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1801: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1802: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1803: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 1800: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

1796: l_control_rec OE_GLOBALS.Control_Rec_Type;
1797: l_return_status VARCHAR2(1);
1798: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1799: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1800: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1801: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1802: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1803: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1804: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

Line 1801: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

1797: l_return_status VARCHAR2(1);
1798: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1799: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1800: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1801: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1802: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1803: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1804: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1805: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 1802: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

1798: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1799: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1800: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1801: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1802: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1803: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1804: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1805: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1806: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 1803: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

1799: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1800: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1801: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1802: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1803: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1804: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1805: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1806: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1807: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 1804: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

1800: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1801: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1802: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1803: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1804: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1805: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1806: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1807: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1808: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 1805: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

1801: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1802: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1803: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1804: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1805: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1806: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1807: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1808: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1809: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 1806: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

1802: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1803: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1804: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1805: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1806: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1807: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1808: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1809: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1810: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

Line 1807: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

1803: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1804: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1805: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1806: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1807: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1808: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1809: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1810: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1811: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 1808: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

1804: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1805: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1806: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1807: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1808: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1809: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1810: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1811: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1812:

Line 1809: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1805: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1806: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1807: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1808: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1809: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1810: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1811: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1812:
1813: --New out parameters

Line 1810: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

1806: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1807: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1808: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1809: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1810: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1811: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1812:
1813: --New out parameters
1814: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 1811: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

1807: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1808: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1809: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1810: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1811: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1812:
1813: --New out parameters
1814: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1815: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 1814: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

1810: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1811: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1812:
1813: --New out parameters
1814: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1815: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1816: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1817:
1818: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 1815: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

1811: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1812:
1813: --New out parameters
1814: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1815: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1816: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1817:
1818: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1819: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 1816: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

1812:
1813: --New out parameters
1814: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1815: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1816: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1817:
1818: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1819: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1820: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 1818: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

1814: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1815: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1816: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1817:
1818: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1819: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1820: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1821:
1822: --

Line 1819: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

1815: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1816: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1817:
1818: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1819: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1820: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1821:
1822: --
1823: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1820: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

1816: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1817:
1818: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1819: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1820: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1821:
1822: --
1823: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1824: --

Line 2125: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2121: , p_change_reason_code IN VARCHAR2 Default Null
2122: , p_change_comments IN VARCHAR2 Default Null
2123: )
2124: IS
2125: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2126: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2127: l_control_rec OE_GLOBALS.Control_Rec_Type;
2128: l_return_status VARCHAR2(1);
2129: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 2126: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2122: , p_change_comments IN VARCHAR2 Default Null
2123: )
2124: IS
2125: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2126: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2127: l_control_rec OE_GLOBALS.Control_Rec_Type;
2128: l_return_status VARCHAR2(1);
2129: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2130: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 2129: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

2125: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2126: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2127: l_control_rec OE_GLOBALS.Control_Rec_Type;
2128: l_return_status VARCHAR2(1);
2129: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2130: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2131: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2132: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2133: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2130: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

2126: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2127: l_control_rec OE_GLOBALS.Control_Rec_Type;
2128: l_return_status VARCHAR2(1);
2129: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2130: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2131: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2132: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2133: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2134: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2131: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2127: l_control_rec OE_GLOBALS.Control_Rec_Type;
2128: l_return_status VARCHAR2(1);
2129: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2130: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2131: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2132: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2133: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2134: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2135: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

Line 2132: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2128: l_return_status VARCHAR2(1);
2129: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2130: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2131: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2132: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2133: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2134: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2135: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2136: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2133: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2129: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2130: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2131: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2132: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2133: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2134: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2135: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2136: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2137: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

Line 2134: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2130: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2131: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2132: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2133: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2134: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2135: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2136: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2137: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2138: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 2135: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

2131: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2132: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2133: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2134: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2135: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2136: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2137: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2138: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2139: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 2136: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2132: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2133: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2134: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2135: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2136: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2137: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2138: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2139: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2140: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 2137: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

2133: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2134: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2135: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2136: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2137: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2138: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2139: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2140: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2141: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 2138: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

2134: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2135: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2136: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2137: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2138: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2139: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2140: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2141: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2142: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2139: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

2135: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2136: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2137: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2138: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2139: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2140: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2141: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2142: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2143: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

Line 2140: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

2136: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2137: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2138: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2139: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2140: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2141: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2142: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2143: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2144: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2141: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

2137: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2138: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2139: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2140: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2141: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2142: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2143: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2144: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2145:

Line 2142: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2138: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2139: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2140: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2141: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2142: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2143: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2144: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2145:
2146:

Line 2143: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

2139: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2140: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2141: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2142: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2143: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2144: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2145:
2146:
2147: --New out parameters

Line 2144: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2140: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2141: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2142: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2143: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2144: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2145:
2146:
2147: --New out parameters
2148:

Line 2149: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2145:
2146:
2147: --New out parameters
2148:
2149: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2150: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2151: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2152:
2153: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2150: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2146:
2147: --New out parameters
2148:
2149: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2150: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2151: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2152:
2153: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2154: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2151: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2147: --New out parameters
2148:
2149: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2150: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2151: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2152:
2153: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2154: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2155: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2153: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2149: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2150: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2151: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2152:
2153: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2154: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2155: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2156:
2157: --

Line 2154: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2150: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2151: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2152:
2153: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2154: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2155: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2156:
2157: --
2158: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2155: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2151: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2152:
2153: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2154: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2155: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2156:
2157: --
2158: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2159: --

Line 2340: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

2336: )
2337: IS
2338: l_control_rec OE_GLOBALS.Control_Rec_Type;
2339: l_return_status VARCHAR2(1);
2340: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2341: l_request_rec OE_Order_Pub.Request_Rec_Type;
2342: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2343: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2344: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

Line 2341: l_request_rec OE_Order_Pub.Request_Rec_Type;

2337: IS
2338: l_control_rec OE_GLOBALS.Control_Rec_Type;
2339: l_return_status VARCHAR2(1);
2340: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2341: l_request_rec OE_Order_Pub.Request_Rec_Type;
2342: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2343: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2344: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2345: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2342: l_request_tbl OE_Order_Pub.Request_Tbl_Type;

2338: l_control_rec OE_GLOBALS.Control_Rec_Type;
2339: l_return_status VARCHAR2(1);
2340: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2341: l_request_rec OE_Order_Pub.Request_Rec_Type;
2342: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2343: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2344: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2345: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2346: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

Line 2343: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

2339: l_return_status VARCHAR2(1);
2340: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2341: l_request_rec OE_Order_Pub.Request_Rec_Type;
2342: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2343: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2344: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2345: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2346: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2347: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2344: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2340: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2341: l_request_rec OE_Order_Pub.Request_Rec_Type;
2342: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2343: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2344: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2345: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2346: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2347: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2348: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

Line 2345: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2341: l_request_rec OE_Order_Pub.Request_Rec_Type;
2342: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2343: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2344: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2345: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2346: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2347: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2348: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2349: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 2346: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

2342: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2343: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2344: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2345: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2346: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2347: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2348: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2349: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2350: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 2347: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2343: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2344: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2345: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2346: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2347: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2348: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2349: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2350: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2351: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 2348: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

2344: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2345: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2346: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2347: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2348: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2349: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2350: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2351: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2352: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 2349: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

2345: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2346: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2347: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2348: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2349: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2350: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2351: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2352: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2353: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2350: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

2346: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2347: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2348: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2349: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2350: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2351: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2352: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2353: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2354: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

Line 2351: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

2347: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2348: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2349: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2350: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2351: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2352: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2353: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2354: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2355: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2352: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

2348: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2349: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2350: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2351: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2352: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2353: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2354: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2355: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2356:

Line 2353: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2349: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2350: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2351: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2352: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2353: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2354: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2355: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2356:
2357: --New out parameters

Line 2354: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

2350: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2351: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2352: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2353: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2354: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2355: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2356:
2357: --New out parameters
2358: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 2355: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2351: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2352: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2353: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2354: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2355: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2356:
2357: --New out parameters
2358: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2359: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 2358: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2354: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2355: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2356:
2357: --New out parameters
2358: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2359: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2360: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2361:
2362: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2359: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2355: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2356:
2357: --New out parameters
2358: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2359: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2360: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2361:
2362: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2363: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2360: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2356:
2357: --New out parameters
2358: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2359: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2360: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2361:
2362: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2363: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2364: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2362: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2358: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2359: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2360: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2361:
2362: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2363: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2364: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2365:
2366:

Line 2363: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2359: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2360: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2361:
2362: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2363: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2364: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2365:
2366:
2367: --

Line 2364: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2360: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2361:
2362: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2363: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2364: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2365:
2366:
2367: --
2368: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2597: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2593: , p_lock_control IN NUMBER
2594: )
2595: IS
2596: l_return_status VARCHAR2(1);
2597: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2598: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2599: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2600: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2601: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2598: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2594: )
2595: IS
2596: l_return_status VARCHAR2(1);
2597: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2598: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2599: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2600: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2601: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2602:

Line 2599: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

2595: IS
2596: l_return_status VARCHAR2(1);
2597: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2598: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2599: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2600: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2601: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2602:
2603: --

Line 2600: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2596: l_return_status VARCHAR2(1);
2597: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2598: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2599: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2600: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2601: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2602:
2603: --
2604: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2601: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2597: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2598: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2599: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2600: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2601: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2602:
2603: --
2604: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2605: --

Line 2679: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type

2675:
2676: -- Procedures maintaining Header_Adj record cache.
2677:
2678: PROCEDURE Write_Header_Adj
2679: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
2680: , p_db_record IN BOOLEAN := FALSE
2681: )
2682: IS
2683: --

Line 2710: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

2706:
2707: PROCEDURE Get_Header_Adj
2708: ( p_db_record IN BOOLEAN := FALSE
2709: , p_price_adjustment_id IN NUMBER
2710: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2711: )
2712: IS
2713: --
2714: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2770: g_Header_Adj_rec := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;

2766: IF l_debug_level > 0 THEN
2767: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_ADJ.CLEAR_HEADER_ADJ' , 1 ) ;
2768: END IF;
2769:
2770: g_Header_Adj_rec := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;
2771: g_db_Header_Adj_rec := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;
2772:
2773: IF l_debug_level > 0 THEN
2774: oe_debug_pub.add( 'EXITING OE_OE_FORM_HEADER_ADJ.CLEAR_HEADER_ADJ' , 1 ) ;

Line 2771: g_db_Header_Adj_rec := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;

2767: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_ADJ.CLEAR_HEADER_ADJ' , 1 ) ;
2768: END IF;
2769:
2770: g_Header_Adj_rec := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;
2771: g_db_Header_Adj_rec := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;
2772:
2773: IF l_debug_level > 0 THEN
2774: oe_debug_pub.add( 'EXITING OE_OE_FORM_HEADER_ADJ.CLEAR_HEADER_ADJ' , 1 ) ;
2775: END IF;