6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Line_Adj';
7:
8: -- Global variables holding cached record.
9:
10: g_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type
11: := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
12: g_db_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type
13: := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
14:
7:
8: -- Global variables holding cached record.
9:
10: g_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type
11: := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
12: g_db_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type
13: := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
14:
15: -- Forward declaration of procedures maintaining entity record cache.
8: -- Global variables holding cached record.
9:
10: g_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type
11: := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
12: g_db_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type
13: := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
14:
15: -- Forward declaration of procedures maintaining entity record cache.
16:
9:
10: g_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type
11: := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
12: g_db_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type
13: := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
14:
15: -- Forward declaration of procedures maintaining entity record cache.
16:
17: PROCEDURE Write_Line_Adj
14:
15: -- Forward declaration of procedures maintaining entity record cache.
16:
17: PROCEDURE Write_Line_Adj
18: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
19: , p_db_record IN BOOLEAN := FALSE
20: );
21:
22: PROCEDURE Get_Line_Adj
21:
22: PROCEDURE Get_Line_Adj
23: ( p_db_record IN BOOLEAN := FALSE
24: , p_price_adjustment_id IN NUMBER
25: , x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
26: );
27:
28: Procedure Get_Option_Service_Lines(p_top_model_line_id In Number,
29: p_service_line_id In Number Default null,
30: p_mode In VARCHAR2 Default 'SERVICE',
31: x_line_id_tbl out nocopy Oe_Order_Adj_Pvt.Index_Tbl_Type);
32:
33:
34: Procedure Process_Adj(p_parent_adj_rec In Oe_Order_Pub.Line_Adj_Rec_Type,
35: p_line_id_tbl In Oe_Order_Adj_Pvt.Index_Tbl_Type,
36: p_delete_flag In Varchar2 default 'N',
37: p_create_adj_no_validate In Boolean Default FALSE);
38:
39: PROCEDURE Clear_Line_Adj;
40:
41: -- Global variable holding performed operations.
42:
43: g_opr__tbl OE_Order_PUB.Line_Adj_Tbl_Type;
44:
45: -- Procedure : Default_Attributes
46: --
47:
207:
208: --uom end
209: )
210: IS
211: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
212: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
213: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
214: l_control_rec OE_GLOBALS.Control_Rec_Type;
215: l_return_status VARCHAR2(1);
208: --uom end
209: )
210: IS
211: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
212: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
213: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
214: l_control_rec OE_GLOBALS.Control_Rec_Type;
215: l_return_status VARCHAR2(1);
216: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
209: )
210: IS
211: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
212: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
213: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
214: l_control_rec OE_GLOBALS.Control_Rec_Type;
215: l_return_status VARCHAR2(1);
216: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
217: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
212: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
213: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
214: l_control_rec OE_GLOBALS.Control_Rec_Type;
215: l_return_status VARCHAR2(1);
216: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
217: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
218: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
219: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
220: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
213: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
214: l_control_rec OE_GLOBALS.Control_Rec_Type;
215: l_return_status VARCHAR2(1);
216: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
217: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
218: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
219: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
220: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
221: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
214: l_control_rec OE_GLOBALS.Control_Rec_Type;
215: l_return_status VARCHAR2(1);
216: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
217: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
218: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
219: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
220: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
221: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
222: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
215: l_return_status VARCHAR2(1);
216: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
217: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
218: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
219: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
220: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
221: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
222: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
223: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
216: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
217: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
218: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
219: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
220: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
221: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
222: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
223: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
224: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
217: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
218: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
219: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
220: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
221: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
222: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
223: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
224: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
225: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
218: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
219: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
220: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
221: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
222: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
223: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
224: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
225: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
226: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
219: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
220: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
221: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
222: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
223: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
224: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
225: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
226: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
227: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
220: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
221: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
222: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
223: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
224: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
225: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
226: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
227: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
228: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
221: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
222: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
223: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
224: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
225: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
226: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
227: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
228: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
229: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
222: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
223: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
224: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
225: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
226: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
227: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
228: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
229: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
230: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
223: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
224: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
225: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
226: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
227: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
228: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
229: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
230: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
231: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
224: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
225: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
226: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
227: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
228: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
229: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
230: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
231: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
232:
225: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
226: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
227: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
228: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
229: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
230: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
231: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
232:
233: --New out parameters
226: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
227: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
228: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
229: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
230: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
231: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
232:
233: --New out parameters
234: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
227: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
228: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
229: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
230: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
231: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
232:
233: --New out parameters
234: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
235: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
230: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
231: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
232:
233: --New out parameters
234: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
235: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
236: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
237:
238: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
231: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
232:
233: --New out parameters
234: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
235: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
236: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
237:
238: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
239: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
232:
233: --New out parameters
234: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
235: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
236: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
237:
238: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
239: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
240: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
234: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
235: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
236: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
237:
238: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
239: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
240: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
241:
242: --
235: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
236: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
237:
238: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
239: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
240: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
241:
242: --
243: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
236: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
237:
238: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
239: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
240: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
241:
242: --
243: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
244: --
265: -- Instruct API to retain its caches
266: l_control_rec.clear_api_cache := FALSE;
267: l_control_rec.clear_api_requests := FALSE;
268:
269: l_x_old_line_adj_rec := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
270: l_x_line_adj_rec := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
271:
272: -- Load IN parameters if any exist
273: l_x_Line_adj_rec.header_id := p_header_id;
266: l_control_rec.clear_api_cache := FALSE;
267: l_control_rec.clear_api_requests := FALSE;
268:
269: l_x_old_line_adj_rec := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
270: l_x_line_adj_rec := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC;
271:
272: -- Load IN parameters if any exist
273: l_x_Line_adj_rec.header_id := p_header_id;
274: l_x_Line_adj_rec.line_id := p_line_id;
756:
757: --uom end
758: )
759: IS
760: l_request_rec OE_Order_Pub.Request_Rec_Type;
761: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
762: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
763: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
764: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
757: --uom end
758: )
759: IS
760: l_request_rec OE_Order_Pub.Request_Rec_Type;
761: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
762: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
763: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
764: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
765: l_control_rec OE_GLOBALS.Control_Rec_Type;
758: )
759: IS
760: l_request_rec OE_Order_Pub.Request_Rec_Type;
761: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
762: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
763: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
764: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
765: l_control_rec OE_GLOBALS.Control_Rec_Type;
766: l_return_status VARCHAR2(1);
759: IS
760: l_request_rec OE_Order_Pub.Request_Rec_Type;
761: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
762: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
763: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
764: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
765: l_control_rec OE_GLOBALS.Control_Rec_Type;
766: l_return_status VARCHAR2(1);
767: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
760: l_request_rec OE_Order_Pub.Request_Rec_Type;
761: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
762: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
763: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
764: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
765: l_control_rec OE_GLOBALS.Control_Rec_Type;
766: l_return_status VARCHAR2(1);
767: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
768: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
763: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
764: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
765: l_control_rec OE_GLOBALS.Control_Rec_Type;
766: l_return_status VARCHAR2(1);
767: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
768: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
769: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
770: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
771: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
764: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
765: l_control_rec OE_GLOBALS.Control_Rec_Type;
766: l_return_status VARCHAR2(1);
767: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
768: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
769: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
770: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
771: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
772: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
765: l_control_rec OE_GLOBALS.Control_Rec_Type;
766: l_return_status VARCHAR2(1);
767: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
768: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
769: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
770: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
771: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
772: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
773: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
766: l_return_status VARCHAR2(1);
767: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
768: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
769: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
770: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
771: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
772: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
773: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
774: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
767: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
768: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
769: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
770: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
771: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
772: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
773: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
774: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
775: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
768: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
769: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
770: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
771: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
772: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
773: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
774: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
775: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
776: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
769: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
770: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
771: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
772: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
773: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
774: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
775: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
776: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
770: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
771: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
772: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
773: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
774: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
775: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
776: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
778: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
771: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
772: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
773: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
774: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
775: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
776: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
778: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
779: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
772: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
773: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
774: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
775: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
776: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
778: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
779: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
780: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
773: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
774: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
775: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
776: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
778: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
779: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
780: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
781: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
774: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
775: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
776: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
778: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
779: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
780: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
781: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
782: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
775: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
776: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
778: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
779: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
780: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
781: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
782: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
783:
776: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
778: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
779: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
780: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
781: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
782: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
783:
784: --New out parameters
777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
778: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
779: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
780: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
781: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
782: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
783:
784: --New out parameters
785: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
778: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
779: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
780: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
781: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
782: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
783:
784: --New out parameters
785: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
786: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
781: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
782: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
783:
784: --New out parameters
785: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
786: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
787: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
788:
789: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
782: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
783:
784: --New out parameters
785: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
786: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
787: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
788:
789: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
790: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
783:
784: --New out parameters
785: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
786: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
787: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
788:
789: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
790: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
791: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
785: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
786: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
787: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
788:
789: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
790: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
791: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
792:
793: --1790502
786: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
787: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
788:
789: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
790: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
791: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
792:
793: --1790502
794: l_line_rec OE_Order_Pub.Line_Rec_Type;
787: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
788:
789: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
790: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
791: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
792:
793: --1790502
794: l_line_rec OE_Order_Pub.Line_Rec_Type;
795: l_line_id_tbl OE_Order_Adj_Pvt.Index_Tbl_Type;
790: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
791: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
792:
793: --1790502
794: l_line_rec OE_Order_Pub.Line_Rec_Type;
795: l_line_id_tbl OE_Order_Adj_Pvt.Index_Tbl_Type;
796: l_top_model_line_id Number;
797:
798: l_profile_cascade_adjustments Varchar2(1):= NVL(FND_PROFILE.VALUE('ONT_CASCADE_ADJUSTMENTS'),'N');
1968: , x_lock_control OUT NOCOPY NUMBER
1969:
1970: )
1971: IS
1972: l_request_rec OE_Order_Pub.Request_Rec_Type;
1973: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1974: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1975: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1976: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1969:
1970: )
1971: IS
1972: l_request_rec OE_Order_Pub.Request_Rec_Type;
1973: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1974: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1975: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1976: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1977: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1970: )
1971: IS
1972: l_request_rec OE_Order_Pub.Request_Rec_Type;
1973: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1974: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1975: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1976: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1977: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1978: l_control_rec OE_GLOBALS.Control_Rec_Type;
1971: IS
1972: l_request_rec OE_Order_Pub.Request_Rec_Type;
1973: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1974: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1975: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1976: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1977: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1978: l_control_rec OE_GLOBALS.Control_Rec_Type;
1979: l_return_status VARCHAR2(1);
1972: l_request_rec OE_Order_Pub.Request_Rec_Type;
1973: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1974: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1975: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1976: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1977: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1978: l_control_rec OE_GLOBALS.Control_Rec_Type;
1979: l_return_status VARCHAR2(1);
1980: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1973: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1974: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1975: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1976: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1977: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1978: l_control_rec OE_GLOBALS.Control_Rec_Type;
1979: l_return_status VARCHAR2(1);
1980: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1981: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1976: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1977: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1978: l_control_rec OE_GLOBALS.Control_Rec_Type;
1979: l_return_status VARCHAR2(1);
1980: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1981: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1982: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1983: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1984: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1977: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1978: l_control_rec OE_GLOBALS.Control_Rec_Type;
1979: l_return_status VARCHAR2(1);
1980: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1981: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1982: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1983: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1984: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1985: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1978: l_control_rec OE_GLOBALS.Control_Rec_Type;
1979: l_return_status VARCHAR2(1);
1980: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1981: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1982: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1983: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1984: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1985: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1986: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1979: l_return_status VARCHAR2(1);
1980: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1981: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1982: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1983: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1984: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1985: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1986: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1987: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1980: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1981: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1982: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1983: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1984: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1985: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1986: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1987: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1988: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1981: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1982: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1983: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1984: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1985: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1986: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1987: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1988: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1989: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1982: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1983: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1984: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1985: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1986: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1987: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1988: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1989: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1990: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1983: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1984: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1985: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1986: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1987: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1988: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1989: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1990: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1991: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1984: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1985: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1986: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1987: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1988: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1989: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1990: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1991: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1992: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1985: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1986: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1987: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1988: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1989: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1990: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1991: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1992: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1993: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1986: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1987: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1988: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1989: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1990: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1991: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1992: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1993: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1994:
1987: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1988: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1989: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1990: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1991: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1992: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1993: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1994:
1995:
1988: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1989: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1990: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1991: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1992: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1993: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1994:
1995:
1996: --New out parameters
1989: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1990: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1991: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1992: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1993: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1994:
1995:
1996: --New out parameters
1997: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1993: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1994:
1995:
1996: --New out parameters
1997: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1998: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1999: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2000:
2001: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1994:
1995:
1996: --New out parameters
1997: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1998: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1999: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2000:
2001: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2002: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1995:
1996: --New out parameters
1997: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1998: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1999: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2000:
2001: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2002: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2003: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1997: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1998: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1999: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2000:
2001: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2002: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2003: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2004:
2005:
1998: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1999: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2000:
2001: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2002: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2003: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2004:
2005:
2006: --
1999: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2000:
2001: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2002: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2003: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2004:
2005:
2006: --
2007: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2288: , p_change_reason_code IN VARCHAR2 Default Null
2289: , p_change_comments IN VARCHAR2 Default Null
2290: )
2291: IS
2292: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2293: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2294: l_control_rec OE_GLOBALS.Control_Rec_Type;
2295: l_return_status VARCHAR2(1);
2296: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2289: , p_change_comments IN VARCHAR2 Default Null
2290: )
2291: IS
2292: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2293: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2294: l_control_rec OE_GLOBALS.Control_Rec_Type;
2295: l_return_status VARCHAR2(1);
2296: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2297: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2292: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2293: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2294: l_control_rec OE_GLOBALS.Control_Rec_Type;
2295: l_return_status VARCHAR2(1);
2296: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2297: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2298: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2299: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2300: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2293: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2294: l_control_rec OE_GLOBALS.Control_Rec_Type;
2295: l_return_status VARCHAR2(1);
2296: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2297: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2298: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2299: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2300: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2301: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2294: l_control_rec OE_GLOBALS.Control_Rec_Type;
2295: l_return_status VARCHAR2(1);
2296: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2297: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2298: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2299: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2300: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2301: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2302: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2295: l_return_status VARCHAR2(1);
2296: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2297: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2298: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2299: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2300: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2301: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2302: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2303: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2296: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2297: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2298: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2299: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2300: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2301: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2302: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2303: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2304: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2297: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2298: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2299: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2300: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2301: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2302: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2303: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2304: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2305: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2298: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2299: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2300: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2301: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2302: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2303: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2304: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2305: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2306: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2299: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2300: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2301: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2302: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2303: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2304: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2305: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2306: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2307: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2300: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2301: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2302: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2303: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2304: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2305: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2306: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2307: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2308: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2301: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2302: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2303: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2304: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2305: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2306: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2307: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2308: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2309: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2302: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2303: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2304: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2305: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2306: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2307: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2308: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2309: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2310: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2303: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2304: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2305: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2306: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2307: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2308: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2309: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2310: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2311: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2304: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2305: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2306: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2307: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2308: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2309: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2310: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2311: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2312:
2305: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2306: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2307: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2308: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2309: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2310: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2311: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2312:
2313: --New out parameters
2306: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2307: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2308: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2309: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2310: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2311: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2312:
2313: --New out parameters
2314:
2307: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2308: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2309: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2310: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2311: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2312:
2313: --New out parameters
2314:
2315: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2311: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2312:
2313: --New out parameters
2314:
2315: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2316: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2317: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2318:
2319: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2312:
2313: --New out parameters
2314:
2315: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2316: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2317: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2318:
2319: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2320: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2313: --New out parameters
2314:
2315: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2316: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2317: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2318:
2319: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2320: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2321: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2315: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2316: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2317: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2318:
2319: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2320: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2321: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2322:
2323: --1790502
2316: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2317: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2318:
2319: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2320: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2321: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2322:
2323: --1790502
2324: l_line_rec OE_Order_Pub.Line_Rec_Type;
2317: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2318:
2319: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2320: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2321: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2322:
2323: --1790502
2324: l_line_rec OE_Order_Pub.Line_Rec_Type;
2325: l_line_id_tbl OE_Order_Adj_Pvt.Index_Tbl_Type;
2320: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2321: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2322:
2323: --1790502
2324: l_line_rec OE_Order_Pub.Line_Rec_Type;
2325: l_line_id_tbl OE_Order_Adj_Pvt.Index_Tbl_Type;
2326: l_top_model_line_id Number;
2327: l_profile_cascade_adjustments Varchar2(1):= NVL(FND_PROFILE.VALUE('ONT_CASCADE_ADJUSTMENTS'),'N');
2328:
2554: )
2555: IS
2556: l_control_rec OE_GLOBALS.Control_Rec_Type;
2557: l_return_status VARCHAR2(1);
2558: l_request_rec OE_Order_Pub.Request_Rec_Type;
2559: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2560: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2561: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2562: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2555: IS
2556: l_control_rec OE_GLOBALS.Control_Rec_Type;
2557: l_return_status VARCHAR2(1);
2558: l_request_rec OE_Order_Pub.Request_Rec_Type;
2559: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2560: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2561: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2562: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2563: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2556: l_control_rec OE_GLOBALS.Control_Rec_Type;
2557: l_return_status VARCHAR2(1);
2558: l_request_rec OE_Order_Pub.Request_Rec_Type;
2559: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2560: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2561: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2562: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2563: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2564: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2557: l_return_status VARCHAR2(1);
2558: l_request_rec OE_Order_Pub.Request_Rec_Type;
2559: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2560: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2561: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2562: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2563: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2564: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2565: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2558: l_request_rec OE_Order_Pub.Request_Rec_Type;
2559: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2560: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2561: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2562: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2563: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2564: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2565: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2566: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2559: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2560: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2561: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2562: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2563: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2564: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2565: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2566: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2567: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2560: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2561: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2562: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2563: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2564: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2565: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2566: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2567: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2568: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2561: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2562: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2563: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2564: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2565: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2566: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2567: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2568: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2569: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2562: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2563: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2564: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2565: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2566: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2567: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2568: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2569: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2570: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2563: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2564: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2565: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2566: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2567: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2568: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2569: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2570: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2571: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2564: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2565: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2566: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2567: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2568: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2569: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2570: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2571: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2572: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2565: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2566: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2567: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2568: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2569: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2570: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2571: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2572: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2573: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2566: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2567: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2568: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2569: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2570: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2571: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2572: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2573: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2574:
2567: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2568: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2569: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2570: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2571: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2572: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2573: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2574:
2575: --New out parameters
2568: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2569: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2570: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2571: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2572: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2573: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2574:
2575: --New out parameters
2576: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2569: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2570: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2571: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2572: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2573: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2574:
2575: --New out parameters
2576: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2577: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2572: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2573: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2574:
2575: --New out parameters
2576: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2577: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2578: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2579:
2580: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2573: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2574:
2575: --New out parameters
2576: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2577: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2578: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2579:
2580: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2581: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2574:
2575: --New out parameters
2576: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2577: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2578: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2579:
2580: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2581: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2582: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2576: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2577: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2578: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2579:
2580: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2581: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2582: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2583:
2584: --
2577: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2578: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2579:
2580: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2581: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2582: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2583:
2584: --
2585: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2578: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2579:
2580: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2581: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2582: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2583:
2584: --
2585: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2586: --
2822: p_change_reason_code IN Varchar2 :=NULL,
2823: p_change_reason_text IN VARCHAR2 :=NULL
2824: )
2825: IS
2826: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2827: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2828: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2829: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2830: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2823: p_change_reason_text IN VARCHAR2 :=NULL
2824: )
2825: IS
2826: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2827: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2828: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2829: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2830: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2831: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
2824: )
2825: IS
2826: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2827: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2828: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2829: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2830: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2831: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
2832: l_control_rec OE_GLOBALS.Control_Rec_Type;
2825: IS
2826: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2827: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2828: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2829: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2830: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2831: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
2832: l_control_rec OE_GLOBALS.Control_Rec_Type;
2833: l_return_status VARCHAR2(1);
2826: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2827: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2828: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2829: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2830: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2831: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
2832: l_control_rec OE_GLOBALS.Control_Rec_Type;
2833: l_return_status VARCHAR2(1);
2834: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2827: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2828: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2829: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2830: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2831: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
2832: l_control_rec OE_GLOBALS.Control_Rec_Type;
2833: l_return_status VARCHAR2(1);
2834: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2835: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2830: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2831: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
2832: l_control_rec OE_GLOBALS.Control_Rec_Type;
2833: l_return_status VARCHAR2(1);
2834: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2835: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2836: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2837: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2838: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2831: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
2832: l_control_rec OE_GLOBALS.Control_Rec_Type;
2833: l_return_status VARCHAR2(1);
2834: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2835: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2836: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2837: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2838: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2839: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2832: l_control_rec OE_GLOBALS.Control_Rec_Type;
2833: l_return_status VARCHAR2(1);
2834: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2835: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2836: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2837: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2838: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2839: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2840: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2833: l_return_status VARCHAR2(1);
2834: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2835: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2836: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2837: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2838: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2839: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2840: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2841: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2834: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2835: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2836: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2837: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2838: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2839: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2840: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2841: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2842: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2835: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2836: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2837: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2838: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2839: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2840: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2841: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2842: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2843:
2836: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2837: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2838: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2839: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2840: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2841: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2842: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2843:
2844:
2837: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2838: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2839: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2840: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2841: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2842: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2843:
2844:
2845: --New out parameters
2838: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2839: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2840: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2841: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2842: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2843:
2844:
2845: --New out parameters
2846: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2842: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2843:
2844:
2845: --New out parameters
2846: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2847: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2848: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2849:
2850: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2843:
2844:
2845: --New out parameters
2846: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2847: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2848: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2849:
2850: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2851: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2844:
2845: --New out parameters
2846: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2847: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2848: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2849:
2850: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2851: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2852: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2846: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2847: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2848: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2849:
2850: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2851: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2852: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2853:
2854: l_line_rec Oe_Order_Pub.line_rec_type;
2847: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2848: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2849:
2850: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2851: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2852: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2853:
2854: l_line_rec Oe_Order_Pub.line_rec_type;
2855: --
2848: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2849:
2850: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2851: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2852: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2853:
2854: l_line_rec Oe_Order_Pub.line_rec_type;
2855: --
2856: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2850: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2851: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2852: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2853:
2854: l_line_rec Oe_Order_Pub.line_rec_type;
2855: --
2856: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2857: --
2858: BEGIN
3096: , p_lock_control IN NUMBER
3097: )
3098: IS
3099: l_return_status VARCHAR2(1);
3100: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3101: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3102: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3103: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3104:
3097: )
3098: IS
3099: l_return_status VARCHAR2(1);
3100: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3101: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3102: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3103: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3104:
3105: --
3098: IS
3099: l_return_status VARCHAR2(1);
3100: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3101: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3102: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3103: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3104:
3105: --
3106: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3099: l_return_status VARCHAR2(1);
3100: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3101: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3102: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3103: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3104:
3105: --
3106: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3107: --
3178:
3179: -- Procedures maintaining Header_Adj record cache.
3180:
3181: PROCEDURE Write_Line_Adj
3182: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
3183: , p_db_record IN BOOLEAN := FALSE
3184: )
3185: IS
3186: --
3209:
3210: PROCEDURE Get_Line_Adj
3211: ( p_db_record IN BOOLEAN := FALSE
3212: , p_price_adjustment_id IN NUMBER
3213: , x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
3214: )
3215: IS
3216: --
3217: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3269: IF l_debug_level > 0 THEN
3270: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;
3271: END IF;
3272:
3273: g_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3274: g_db_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3275:
3276: IF l_debug_level > 0 THEN
3277: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;
3270: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;
3271: END IF;
3272:
3273: g_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3274: g_db_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3275:
3276: IF l_debug_level > 0 THEN
3277: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;
3278: END IF;
3279:
3280: END Clear_Line_Adj;
3281:
3282: --Manual Begin
3283: Procedure Insert_Row(p_line_adj_rec In Oe_Order_Pub.line_adj_rec_type
3284: ,x_return_status OUT NOCOPY VARCHAR2
3285:
3286: ,x_msg_count OUT NOCOPY NUMBER
3287:
3289:
3290: ,x_price_adjustment_id OUT NOCOPY NUMBER) Is
3291:
3292: l_Control_Rec OE_GLOBALS.Control_Rec_Type;
3293: l_line_adj_tbl Oe_Order_Pub.line_adj_tbl_type;
3294: l_line_rec Oe_Order_Pub.line_rec_type;
3295: l_dummy_tbl Oe_Order_Pub.line_adj_tbl_type;
3296: --
3297: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3290: ,x_price_adjustment_id OUT NOCOPY NUMBER) Is
3291:
3292: l_Control_Rec OE_GLOBALS.Control_Rec_Type;
3293: l_line_adj_tbl Oe_Order_Pub.line_adj_tbl_type;
3294: l_line_rec Oe_Order_Pub.line_rec_type;
3295: l_dummy_tbl Oe_Order_Pub.line_adj_tbl_type;
3296: --
3297: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3298: --
3291:
3292: l_Control_Rec OE_GLOBALS.Control_Rec_Type;
3293: l_line_adj_tbl Oe_Order_Pub.line_adj_tbl_type;
3294: l_line_rec Oe_Order_Pub.line_rec_type;
3295: l_dummy_tbl Oe_Order_Pub.line_adj_tbl_type;
3296: --
3297: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3298: --
3299: Begin
3502: End;
3503:
3504: --This Procedure will either change,create or delete adjustments
3505: --based on parent adjustment record
3506: Procedure Process_Adj(p_parent_adj_rec In Oe_Order_Pub.Line_Adj_Rec_Type,
3507: p_line_id_tbl In Oe_Order_Adj_Pvt.Index_Tbl_Type,
3508: p_delete_flag In Varchar2 Default 'N' ,
3509: p_create_adj_no_validate In Boolean Default FALSE) Is
3510:
3516:
3517: i PLS_INTEGER;
3518: l_price_adjustment_id Number;
3519: l_operand Number;
3520: l_line_adj_rec Oe_Order_Pub.line_adj_rec_type;
3521: l_return_status VARCHAR2(5);
3522: l_msg_count Number;
3523: l_msg_data VARCHAR2(500);
3524: lx_price_adjustment_id Number;