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');
1970: , x_lock_control OUT NOCOPY NUMBER
1971:
1972: )
1973: IS
1974: l_request_rec OE_Order_Pub.Request_Rec_Type;
1975: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1976: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1977: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1978: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1971:
1972: )
1973: IS
1974: l_request_rec OE_Order_Pub.Request_Rec_Type;
1975: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1976: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1977: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1978: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1979: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1972: )
1973: IS
1974: l_request_rec OE_Order_Pub.Request_Rec_Type;
1975: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1976: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1977: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1978: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1979: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1980: l_control_rec OE_GLOBALS.Control_Rec_Type;
1973: IS
1974: l_request_rec OE_Order_Pub.Request_Rec_Type;
1975: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1976: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1977: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1978: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1979: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1980: l_control_rec OE_GLOBALS.Control_Rec_Type;
1981: l_return_status VARCHAR2(1);
1974: l_request_rec OE_Order_Pub.Request_Rec_Type;
1975: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1976: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1977: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1978: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1979: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1980: l_control_rec OE_GLOBALS.Control_Rec_Type;
1981: l_return_status VARCHAR2(1);
1982: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1975: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
1976: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1977: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1978: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1979: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1980: l_control_rec OE_GLOBALS.Control_Rec_Type;
1981: l_return_status VARCHAR2(1);
1982: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1983: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1978: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1979: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1980: l_control_rec OE_GLOBALS.Control_Rec_Type;
1981: l_return_status VARCHAR2(1);
1982: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1983: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1984: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1985: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1986: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1979: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1980: l_control_rec OE_GLOBALS.Control_Rec_Type;
1981: l_return_status VARCHAR2(1);
1982: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1983: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1984: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1985: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1986: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1987: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1980: l_control_rec OE_GLOBALS.Control_Rec_Type;
1981: l_return_status VARCHAR2(1);
1982: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1983: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1984: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1985: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1986: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1987: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1988: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1981: l_return_status VARCHAR2(1);
1982: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1983: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1984: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1985: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1986: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1987: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1988: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1989: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1982: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1983: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1984: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1985: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1986: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1987: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1988: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1989: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1990: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1983: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1984: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1985: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1986: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1987: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1988: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1989: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1990: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1991: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1984: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1985: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1986: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1987: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1988: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1989: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1990: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1991: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1992: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1985: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1986: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1987: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1988: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1989: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1990: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1991: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1992: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1993: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1986: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1987: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1988: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1989: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1990: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1991: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1992: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1993: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1994: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1987: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1988: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1989: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1990: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1991: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1992: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1993: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1994: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1995: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1988: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1989: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1990: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1991: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1992: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1993: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1994: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1995: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1996:
1989: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1990: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1991: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1992: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1993: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1994: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1995: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1996:
1997:
1990: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1991: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1992: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1993: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1994: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1995: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1996:
1997:
1998: --New out parameters
1991: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1992: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1993: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1994: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1995: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1996:
1997:
1998: --New out parameters
1999: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1995: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1996:
1997:
1998: --New out parameters
1999: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2000: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2001: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2002:
2003: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1996:
1997:
1998: --New out parameters
1999: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2000: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2001: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2002:
2003: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2004: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1997:
1998: --New out parameters
1999: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2000: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2001: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2002:
2003: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2004: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2005: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1999: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2000: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2001: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2002:
2003: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2004: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2005: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2006:
2007:
2000: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2001: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2002:
2003: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2004: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2005: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2006:
2007:
2008: --
2001: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2002:
2003: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2004: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2005: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2006:
2007:
2008: --
2009: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2305: , p_change_reason_code IN VARCHAR2 Default Null
2306: , p_change_comments IN VARCHAR2 Default Null
2307: )
2308: IS
2309: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2310: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2311: l_control_rec OE_GLOBALS.Control_Rec_Type;
2312: l_return_status VARCHAR2(1);
2313: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2306: , p_change_comments IN VARCHAR2 Default Null
2307: )
2308: IS
2309: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2310: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2311: l_control_rec OE_GLOBALS.Control_Rec_Type;
2312: l_return_status VARCHAR2(1);
2313: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2314: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2309: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2310: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2311: l_control_rec OE_GLOBALS.Control_Rec_Type;
2312: l_return_status VARCHAR2(1);
2313: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2314: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2315: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2316: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2317: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2310: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2311: l_control_rec OE_GLOBALS.Control_Rec_Type;
2312: l_return_status VARCHAR2(1);
2313: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2314: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2315: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2316: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2317: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2318: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2311: l_control_rec OE_GLOBALS.Control_Rec_Type;
2312: l_return_status VARCHAR2(1);
2313: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2314: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2315: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2316: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2317: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2318: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2319: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2312: l_return_status VARCHAR2(1);
2313: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2314: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2315: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2316: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2317: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2318: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2319: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2320: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2313: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2314: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2315: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2316: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2317: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2318: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2319: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2320: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2321: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2314: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2315: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2316: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2317: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2318: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2319: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2320: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2321: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2322: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2315: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2316: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2317: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2318: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2319: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2320: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2321: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2322: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2323: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2316: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2317: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2318: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2319: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2320: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2321: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2322: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2323: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2324: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2317: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2318: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2319: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2320: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2321: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2322: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2323: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2324: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2325: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2318: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2319: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2320: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2321: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2322: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2323: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2324: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2325: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2326: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2319: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2320: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2321: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2322: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2323: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2324: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2325: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2326: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2327: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2320: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2321: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2322: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2323: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2324: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2325: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2326: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2327: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2328: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2321: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2322: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2323: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2324: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2325: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2326: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2327: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2328: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2329:
2322: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2323: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2324: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2325: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2326: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2327: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2328: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2329:
2330: --New out parameters
2323: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2324: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2325: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2326: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2327: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2328: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2329:
2330: --New out parameters
2331:
2324: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2325: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2326: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2327: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2328: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2329:
2330: --New out parameters
2331:
2332: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2328: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2329:
2330: --New out parameters
2331:
2332: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2333: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2334: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2335:
2336: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2329:
2330: --New out parameters
2331:
2332: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2333: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2334: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2335:
2336: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2337: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2330: --New out parameters
2331:
2332: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2333: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2334: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2335:
2336: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2337: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2338: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2332: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2333: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2334: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2335:
2336: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2337: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2338: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2339:
2340: --1790502
2333: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2334: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2335:
2336: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2337: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2338: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2339:
2340: --1790502
2341: l_line_rec OE_Order_Pub.Line_Rec_Type;
2334: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2335:
2336: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2337: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2338: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2339:
2340: --1790502
2341: l_line_rec OE_Order_Pub.Line_Rec_Type;
2342: l_line_id_tbl OE_Order_Adj_Pvt.Index_Tbl_Type;
2337: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2338: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2339:
2340: --1790502
2341: l_line_rec OE_Order_Pub.Line_Rec_Type;
2342: l_line_id_tbl OE_Order_Adj_Pvt.Index_Tbl_Type;
2343: l_top_model_line_id Number;
2344: l_profile_cascade_adjustments Varchar2(1):= NVL(FND_PROFILE.VALUE('ONT_CASCADE_ADJUSTMENTS'),'N');
2345:
2571: )
2572: IS
2573: l_control_rec OE_GLOBALS.Control_Rec_Type;
2574: l_return_status VARCHAR2(1);
2575: l_request_rec OE_Order_Pub.Request_Rec_Type;
2576: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2577: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2578: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2579: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2572: IS
2573: l_control_rec OE_GLOBALS.Control_Rec_Type;
2574: l_return_status VARCHAR2(1);
2575: l_request_rec OE_Order_Pub.Request_Rec_Type;
2576: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2577: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2578: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2579: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2580: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2573: l_control_rec OE_GLOBALS.Control_Rec_Type;
2574: l_return_status VARCHAR2(1);
2575: l_request_rec OE_Order_Pub.Request_Rec_Type;
2576: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2577: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2578: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2579: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2580: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2581: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2574: l_return_status VARCHAR2(1);
2575: l_request_rec OE_Order_Pub.Request_Rec_Type;
2576: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2577: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2578: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2579: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2580: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2581: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2582: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2575: l_request_rec OE_Order_Pub.Request_Rec_Type;
2576: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2577: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2578: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2579: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2580: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2581: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2582: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2583: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2576: l_request_tbl OE_Order_Pub.Request_Tbl_Type;
2577: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2578: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2579: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2580: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2581: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2582: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2583: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2584: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2577: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2578: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2579: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2580: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2581: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2582: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2583: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2584: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2585: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2578: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2579: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2580: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2581: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2582: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2583: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2584: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2585: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2586: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2579: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2580: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2581: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2582: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2583: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2584: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2585: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2586: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2587: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2580: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2581: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2582: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2583: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2584: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2585: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2586: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2587: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2588: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2581: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2582: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2583: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2584: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2585: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2586: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2587: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2588: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2589: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2582: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2583: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2584: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2585: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2586: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2587: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2588: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2589: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2590: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2583: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2584: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2585: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2586: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2587: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2588: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2589: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2590: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2591:
2584: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2585: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2586: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2587: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2588: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2589: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2590: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2591:
2592: --New out parameters
2585: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2586: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2587: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2588: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2589: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2590: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2591:
2592: --New out parameters
2593: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2586: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2587: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2588: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2589: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2590: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2591:
2592: --New out parameters
2593: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2594: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2589: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2590: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2591:
2592: --New out parameters
2593: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2594: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2595: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2596:
2597: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2590: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2591:
2592: --New out parameters
2593: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2594: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2595: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2596:
2597: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2598: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2591:
2592: --New out parameters
2593: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2594: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2595: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2596:
2597: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2598: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2599: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2593: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2594: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2595: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2596:
2597: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2598: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2599: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2600:
2601: --
2594: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2595: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2596:
2597: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2598: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2599: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2600:
2601: --
2602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2595: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2596:
2597: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2598: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2599: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2600:
2601: --
2602: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2603: --
2839: p_change_reason_code IN Varchar2 :=NULL,
2840: p_change_reason_text IN VARCHAR2 :=NULL
2841: )
2842: IS
2843: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2844: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2845: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2846: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2847: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2840: p_change_reason_text IN VARCHAR2 :=NULL
2841: )
2842: IS
2843: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2844: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2845: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2846: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2847: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2848: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
2841: )
2842: IS
2843: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2844: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2845: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2846: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2847: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2848: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
2849: l_control_rec OE_GLOBALS.Control_Rec_Type;
2842: IS
2843: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2844: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2845: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2846: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2847: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2848: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
2849: l_control_rec OE_GLOBALS.Control_Rec_Type;
2850: l_return_status VARCHAR2(1);
2843: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2844: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2845: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2846: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2847: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2848: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
2849: l_control_rec OE_GLOBALS.Control_Rec_Type;
2850: l_return_status VARCHAR2(1);
2851: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2844: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2845: l_x_old_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2846: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2847: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2848: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
2849: l_control_rec OE_GLOBALS.Control_Rec_Type;
2850: l_return_status VARCHAR2(1);
2851: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2852: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2847: l_x_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2848: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
2849: l_control_rec OE_GLOBALS.Control_Rec_Type;
2850: l_return_status VARCHAR2(1);
2851: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2852: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2853: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2854: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2855: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2848: l_Line_Adj_val_rec OE_Order_PUB.Line_Adj_Val_Rec_Type;
2849: l_control_rec OE_GLOBALS.Control_Rec_Type;
2850: l_return_status VARCHAR2(1);
2851: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2852: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2853: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2854: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2855: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2856: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2849: l_control_rec OE_GLOBALS.Control_Rec_Type;
2850: l_return_status VARCHAR2(1);
2851: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2852: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2853: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2854: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2855: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2856: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2857: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2850: l_return_status VARCHAR2(1);
2851: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2852: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2853: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2854: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2855: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2856: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2857: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2858: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2851: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2852: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2853: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2854: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2855: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2856: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2857: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2858: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2859: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2852: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2853: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2854: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2855: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2856: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2857: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2858: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2859: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2860:
2853: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2854: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2855: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2856: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2857: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2858: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2859: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2860:
2861:
2854: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2855: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2856: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2857: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2858: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2859: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2860:
2861:
2862: --New out parameters
2855: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2856: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2857: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2858: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2859: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2860:
2861:
2862: --New out parameters
2863: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2859: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2860:
2861:
2862: --New out parameters
2863: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2864: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2865: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2866:
2867: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2860:
2861:
2862: --New out parameters
2863: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2864: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2865: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2866:
2867: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2868: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2861:
2862: --New out parameters
2863: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2864: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2865: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2866:
2867: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2868: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2869: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2863: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2864: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2865: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2866:
2867: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2868: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2869: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2870:
2871: l_line_rec Oe_Order_Pub.line_rec_type;
2864: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2865: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2866:
2867: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2868: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2869: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2870:
2871: l_line_rec Oe_Order_Pub.line_rec_type;
2872: --
2865: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2866:
2867: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2868: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2869: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2870:
2871: l_line_rec Oe_Order_Pub.line_rec_type;
2872: --
2873: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2867: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2868: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2869: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2870:
2871: l_line_rec Oe_Order_Pub.line_rec_type;
2872: --
2873: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2874: --
2875: BEGIN
3113: , p_lock_control IN NUMBER
3114: )
3115: IS
3116: l_return_status VARCHAR2(1);
3117: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3118: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3119: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3120: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3121:
3114: )
3115: IS
3116: l_return_status VARCHAR2(1);
3117: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3118: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3119: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3120: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3121:
3122: --
3115: IS
3116: l_return_status VARCHAR2(1);
3117: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3118: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3119: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3120: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3121:
3122: --
3123: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3116: l_return_status VARCHAR2(1);
3117: l_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3118: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3119: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3120: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3121:
3122: --
3123: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3124: --
3195:
3196: -- Procedures maintaining Header_Adj record cache.
3197:
3198: PROCEDURE Write_Line_Adj
3199: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
3200: , p_db_record IN BOOLEAN := FALSE
3201: )
3202: IS
3203: --
3226:
3227: PROCEDURE Get_Line_Adj
3228: ( p_db_record IN BOOLEAN := FALSE
3229: , p_price_adjustment_id IN NUMBER
3230: , x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
3231: )
3232: IS
3233: --
3234: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3286: IF l_debug_level > 0 THEN
3287: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;
3288: END IF;
3289:
3290: g_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3291: g_db_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3292:
3293: IF l_debug_level > 0 THEN
3294: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;
3287: oe_debug_pub.add( 'ENTERING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;
3288: END IF;
3289:
3290: g_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3291: g_db_Line_Adj_rec := OE_Order_PUB.G_MISS_LINE_ADJ_REC;
3292:
3293: IF l_debug_level > 0 THEN
3294: oe_debug_pub.add( 'EXITING OE_OE_FORM_LINE_ADJ.CLEAR_LINE_ADJ' , 1 ) ;
3295: END IF;
3296:
3297: END Clear_Line_Adj;
3298:
3299: --Manual Begin
3300: Procedure Insert_Row(p_line_adj_rec In Oe_Order_Pub.line_adj_rec_type
3301: ,x_return_status OUT NOCOPY VARCHAR2
3302:
3303: ,x_msg_count OUT NOCOPY NUMBER
3304:
3306:
3307: ,x_price_adjustment_id OUT NOCOPY NUMBER) Is
3308:
3309: l_Control_Rec OE_GLOBALS.Control_Rec_Type;
3310: l_line_adj_tbl Oe_Order_Pub.line_adj_tbl_type;
3311: l_line_rec Oe_Order_Pub.line_rec_type;
3312: l_dummy_tbl Oe_Order_Pub.line_adj_tbl_type;
3313: --
3314: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3307: ,x_price_adjustment_id OUT NOCOPY NUMBER) Is
3308:
3309: l_Control_Rec OE_GLOBALS.Control_Rec_Type;
3310: l_line_adj_tbl Oe_Order_Pub.line_adj_tbl_type;
3311: l_line_rec Oe_Order_Pub.line_rec_type;
3312: l_dummy_tbl Oe_Order_Pub.line_adj_tbl_type;
3313: --
3314: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3315: --
3308:
3309: l_Control_Rec OE_GLOBALS.Control_Rec_Type;
3310: l_line_adj_tbl Oe_Order_Pub.line_adj_tbl_type;
3311: l_line_rec Oe_Order_Pub.line_rec_type;
3312: l_dummy_tbl Oe_Order_Pub.line_adj_tbl_type;
3313: --
3314: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3315: --
3316: Begin
3532: End;
3533:
3534: --This Procedure will either change,create or delete adjustments
3535: --based on parent adjustment record
3536: Procedure Process_Adj(p_parent_adj_rec In Oe_Order_Pub.Line_Adj_Rec_Type,
3537: p_line_id_tbl In Oe_Order_Adj_Pvt.Index_Tbl_Type,
3538: p_delete_flag In Varchar2 Default 'N' ,
3539: p_create_adj_no_validate In Boolean Default FALSE) Is
3540:
3546:
3547: i PLS_INTEGER;
3548: l_price_adjustment_id Number;
3549: l_operand Number;
3550: l_line_adj_rec Oe_Order_Pub.line_adj_rec_type;
3551: l_return_status VARCHAR2(5);
3552: l_msg_count Number;
3553: l_msg_data VARCHAR2(500);
3554: lx_price_adjustment_id Number;