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 1786: l_request_rec OE_order_pub.Request_Rec_Type;

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

Line 1787: l_request_tbl OE_order_pub.Request_Tbl_Type;

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

Line 1788: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

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

Line 1789: l_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

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

Line 1790: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

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

Line 1791: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

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

Line 1792: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

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

Line 1793: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

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

Line 1796: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

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

Line 1797: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

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

Line 1798: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

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

Line 1799: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

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

Line 1800: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

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

Line 1801: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

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

Line 1802: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

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

Line 1803: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

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

Line 1804: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

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

Line 1805: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

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

Line 1806: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

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

Line 1807: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

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

Line 1808: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

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

Line 1809: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

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

Line 1812: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

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

Line 1813: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

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

Line 1814: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

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

Line 1816: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

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

Line 1817: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

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

Line 1818: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

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

Line 2108: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2104: , p_change_reason_code IN VARCHAR2 Default Null
2105: , p_change_comments IN VARCHAR2 Default Null
2106: )
2107: IS
2108: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2109: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2110: l_control_rec OE_GLOBALS.Control_Rec_Type;
2111: l_return_status VARCHAR2(1);
2112: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 2109: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2105: , p_change_comments IN VARCHAR2 Default Null
2106: )
2107: IS
2108: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2109: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2110: l_control_rec OE_GLOBALS.Control_Rec_Type;
2111: l_return_status VARCHAR2(1);
2112: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2113: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 2112: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

2108: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2109: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2110: l_control_rec OE_GLOBALS.Control_Rec_Type;
2111: l_return_status VARCHAR2(1);
2112: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2113: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2114: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2115: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2116: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2113: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

2109: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2110: l_control_rec OE_GLOBALS.Control_Rec_Type;
2111: l_return_status VARCHAR2(1);
2112: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2113: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2114: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2115: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2116: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2117: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2114: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2110: l_control_rec OE_GLOBALS.Control_Rec_Type;
2111: l_return_status VARCHAR2(1);
2112: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2113: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2114: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2115: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2116: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2117: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2118: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

Line 2115: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2111: l_return_status VARCHAR2(1);
2112: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2113: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2114: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2115: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2116: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2117: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2118: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2119: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2116: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2112: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2113: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2114: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2115: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2116: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2117: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2118: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2119: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2120: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

Line 2117: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2113: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2114: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2115: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2116: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2117: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2118: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2119: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2120: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2121: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 2118: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

2114: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2115: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2116: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2117: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2118: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2119: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2120: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2121: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2122: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 2119: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2115: l_x_old_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2116: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2117: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2118: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2119: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2120: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2121: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2122: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2123: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 2120: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

2116: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2117: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2118: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2119: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2120: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2121: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2122: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2123: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2124: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 2121: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

2117: l_x_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2118: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2119: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2120: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2121: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2122: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2123: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2124: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2125: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2122: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

2118: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2119: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2120: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2121: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2122: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2123: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2124: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2125: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2126: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

Line 2123: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

2119: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2120: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2121: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2122: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2123: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2124: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2125: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2126: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2127: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2124: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

2120: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2121: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2122: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2123: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2124: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2125: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2126: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2127: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2128:

Line 2125: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2121: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2122: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2123: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2124: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2125: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2126: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2127: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2128:
2129:

Line 2126: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

2122: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2123: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2124: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2125: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2126: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2127: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2128:
2129:
2130: --New out parameters

Line 2127: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2123: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2124: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2125: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2126: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2127: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2128:
2129:
2130: --New out parameters
2131:

Line 2132: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2128:
2129:
2130: --New out parameters
2131:
2132: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2133: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2134: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2135:
2136: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2133: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2129:
2130: --New out parameters
2131:
2132: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2133: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2134: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2135:
2136: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2137: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2134: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2130: --New out parameters
2131:
2132: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2133: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2134: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2135:
2136: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2137: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2138: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2136: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2132: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2133: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2134: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2135:
2136: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2137: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2138: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2139:
2140: --

Line 2137: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2133: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2134: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2135:
2136: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2137: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2138: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2139:
2140: --
2141: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2138: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2134: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2135:
2136: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2137: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2138: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2139:
2140: --
2141: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2142: --

Line 2323: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

2319: )
2320: IS
2321: l_control_rec OE_GLOBALS.Control_Rec_Type;
2322: l_return_status VARCHAR2(1);
2323: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2324: l_request_rec OE_Order_Pub.Request_Rec_Type;
2325: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2326: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2327: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

Line 2324: l_request_rec OE_Order_Pub.Request_Rec_Type;

2320: IS
2321: l_control_rec OE_GLOBALS.Control_Rec_Type;
2322: l_return_status VARCHAR2(1);
2323: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2324: l_request_rec OE_Order_Pub.Request_Rec_Type;
2325: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2326: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2327: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2328: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2325: l_request_tbl OE_Order_Pub.Request_Tbl_Type;

2321: l_control_rec OE_GLOBALS.Control_Rec_Type;
2322: l_return_status VARCHAR2(1);
2323: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2324: l_request_rec OE_Order_Pub.Request_Rec_Type;
2325: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2326: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2327: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2328: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2329: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

Line 2326: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

2322: l_return_status VARCHAR2(1);
2323: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2324: l_request_rec OE_Order_Pub.Request_Rec_Type;
2325: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2326: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2327: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2328: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2329: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2330: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2327: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2323: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2324: l_request_rec OE_Order_Pub.Request_Rec_Type;
2325: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2326: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2327: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2328: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2329: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2330: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2331: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

Line 2328: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2324: l_request_rec OE_Order_Pub.Request_Rec_Type;
2325: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2326: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2327: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2328: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2329: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2330: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2331: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2332: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 2329: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;

2325: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2326: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2327: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2328: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2329: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2330: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2331: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2332: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2333: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

Line 2330: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2326: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2327: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2328: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2329: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2330: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2331: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2332: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2333: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2334: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 2331: l_x_line_rec OE_Order_PUB.Line_Rec_Type;

2327: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2328: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2329: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2330: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2331: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2332: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2333: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2334: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2335: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 2332: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

2328: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2329: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2330: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2331: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2332: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2333: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2334: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2335: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2336: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2333: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;

2329: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2330: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2331: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2332: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2333: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2334: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2335: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2336: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2337: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

Line 2334: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

2330: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2331: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2332: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2333: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2334: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2335: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2336: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2337: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2338: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2335: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

2331: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2332: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2333: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2334: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2335: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2336: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2337: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2338: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2339:

Line 2336: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2332: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2333: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2334: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2335: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2336: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2337: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2338: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2339:
2340: --New out parameters

Line 2337: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;

2333: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2334: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2335: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2336: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2337: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2338: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2339:
2340: --New out parameters
2341: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 2338: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2334: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2335: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2336: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2337: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2338: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2339:
2340: --New out parameters
2341: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2342: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 2341: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2337: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2338: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2339:
2340: --New out parameters
2341: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2342: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2343: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2344:
2345: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2342: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2338: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2339:
2340: --New out parameters
2341: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2342: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2343: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2344:
2345: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2346: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2343: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2339:
2340: --New out parameters
2341: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2342: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2343: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2344:
2345: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2346: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2347: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2345: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2341: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2342: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2343: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2344:
2345: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2346: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2347: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2348:
2349:

Line 2346: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2342: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2343: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2344:
2345: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2346: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2347: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2348:
2349:
2350: --

Line 2347: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2343: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2344:
2345: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2346: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2347: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2348:
2349:
2350: --
2351: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2574: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2570: , p_lock_control IN NUMBER
2571: )
2572: IS
2573: l_return_status VARCHAR2(1);
2574: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2575: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2576: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2577: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2578: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 2575: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2571: )
2572: IS
2573: l_return_status VARCHAR2(1);
2574: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2575: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2576: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2577: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2578: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2579:

Line 2576: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

2572: IS
2573: l_return_status VARCHAR2(1);
2574: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2575: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2576: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2577: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2578: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2579:
2580: --

Line 2577: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;

2573: l_return_status VARCHAR2(1);
2574: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2575: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2576: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2577: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2578: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2579:
2580: --
2581: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2578: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2574: l_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2575: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2576: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2577: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2578: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2579:
2580: --
2581: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2582: --

Line 2656: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type

2652:
2653: -- Procedures maintaining Header_Adj record cache.
2654:
2655: PROCEDURE Write_Header_Adj
2656: ( p_Header_Adj_rec IN OE_Order_PUB.Header_Adj_Rec_Type
2657: , p_db_record IN BOOLEAN := FALSE
2658: )
2659: IS
2660: --

Line 2687: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type

2683:
2684: PROCEDURE Get_Header_Adj
2685: ( p_db_record IN BOOLEAN := FALSE
2686: , p_price_adjustment_id IN NUMBER
2687: , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
2688: )
2689: IS
2690: --
2691: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2747: g_Header_Adj_rec := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;

2743: IF l_debug_level > 0 THEN
2744: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_ADJ.CLEAR_HEADER_ADJ' , 1 ) ;
2745: END IF;
2746:
2747: g_Header_Adj_rec := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;
2748: g_db_Header_Adj_rec := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;
2749:
2750: IF l_debug_level > 0 THEN
2751: oe_debug_pub.add( 'EXITING OE_OE_FORM_HEADER_ADJ.CLEAR_HEADER_ADJ' , 1 ) ;

Line 2748: g_db_Header_Adj_rec := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;

2744: oe_debug_pub.add( 'ENTERING OE_OE_FORM_HEADER_ADJ.CLEAR_HEADER_ADJ' , 1 ) ;
2745: END IF;
2746:
2747: g_Header_Adj_rec := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;
2748: g_db_Header_Adj_rec := OE_Order_PUB.G_MISS_HEADER_ADJ_REC;
2749:
2750: IF l_debug_level > 0 THEN
2751: oe_debug_pub.add( 'EXITING OE_OE_FORM_HEADER_ADJ.CLEAR_HEADER_ADJ' , 1 ) ;
2752: END IF;