[Home] [Help]
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Header_PAttr';
6:
7: g_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type
8: := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
9: g_db_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type
10: := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
11:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Header_PAttr';
6:
7: g_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type
8: := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
9: g_db_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type
10: := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
11:
12:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Header_PAttr';
6:
7: g_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type
8: := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
9: g_db_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type
10: := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
11:
12:
13: /* Get Header Pricing Attr */
6:
7: g_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type
8: := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
9: g_db_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type
10: := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
11:
12:
13: /* Get Header Pricing Attr */
14: PROCEDURE Write_Order_Header_PAttr
11:
12:
13: /* Get Header Pricing Attr */
14: PROCEDURE Write_Order_Header_PAttr
15: ( p_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
16: , p_db_record IN BOOLEAN := FALSE
17: );
18:
19: PROCEDURE Get_Order_Header_PAttr
19: PROCEDURE Get_Order_Header_PAttr
20: (
21: p_db_record IN BOOLEAN := FALSE
22: , p_order_price_attrib_id IN NUMBER
23: , x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
24: );
25:
26: PROCEDURE Clear_Order_Header_Attr;
27:
283:
284:
285: )
286: IS
287: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
288: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
289:
290: l_control_rec OE_GLOBALS.Control_Rec_Type;
291: l_return_status VARCHAR2(1);
284:
285: )
286: IS
287: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
288: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
289:
290: l_control_rec OE_GLOBALS.Control_Rec_Type;
291: l_return_status VARCHAR2(1);
292: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
288: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
289:
290: l_control_rec OE_GLOBALS.Control_Rec_Type;
291: l_return_status VARCHAR2(1);
292: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
293: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
294: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
295: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
296: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
289:
290: l_control_rec OE_GLOBALS.Control_Rec_Type;
291: l_return_status VARCHAR2(1);
292: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
293: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
294: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
295: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
296: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
297: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
290: l_control_rec OE_GLOBALS.Control_Rec_Type;
291: l_return_status VARCHAR2(1);
292: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
293: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
294: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
295: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
296: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
297: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
298: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
291: l_return_status VARCHAR2(1);
292: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
293: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
294: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
295: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
296: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
297: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
298: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
299: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
292: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
293: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
294: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
295: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
296: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
297: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
298: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
299: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
300: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
293: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
294: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
295: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
296: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
297: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
298: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
299: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
300: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
301: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
294: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
295: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
296: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
297: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
298: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
299: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
300: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
301: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
302: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
295: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
296: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
297: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
298: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
299: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
300: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
301: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
302: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
303: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
296: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
297: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
298: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
299: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
300: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
301: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
302: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
303: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
304: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
297: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
298: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
299: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
300: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
301: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
302: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
303: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
304: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
305: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
298: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
299: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
300: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
301: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
302: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
303: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
304: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
305: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
306: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
299: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
300: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
301: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
302: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
303: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
304: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
305: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
306: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
307: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
300: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
301: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
302: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
303: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
304: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
305: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
306: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
307: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
308: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
301: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
302: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
303: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
304: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
305: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
306: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
307: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
308: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
309: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
302: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
303: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
304: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
305: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
306: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
307: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
308: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
309: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
310: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
303: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
304: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
305: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
306: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
307: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
308: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
309: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
310: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
311: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
304: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
305: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
306: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
307: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
308: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
309: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
310: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
311: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
312: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
305: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
306: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
307: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
308: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
309: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
310: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
311: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
312: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
313: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
306: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
307: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
308: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
309: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
310: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
311: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
312: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
313: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
314: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
307: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
308: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
309: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
310: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
311: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
312: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
313: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
314: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
315:
308: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
309: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
310: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
311: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
312: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
313: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
314: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
315:
316: --
309: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
310: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
311: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
312: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
313: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
314: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
315:
316: --
317: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
310: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
311: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
312: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
313: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
314: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
315:
316: --
317: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
318: --
341: l_control_rec.clear_api_requests := FALSE;
342: -----------------------------------------------
343: -- Set attributes to NULL
344: -----------------------------------------------
345: l_x_old_header_price_att_rec := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
346: l_x_header_price_att_rec := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
347:
348: l_x_Header_Price_Att_rec.header_id := p_header_id;
349: l_x_Header_Price_Att_rec.line_id := p_Line_id;
342: -----------------------------------------------
343: -- Set attributes to NULL
344: -----------------------------------------------
345: l_x_old_header_price_att_rec := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
346: l_x_header_price_att_rec := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
347:
348: l_x_Header_Price_Att_rec.header_id := p_header_id;
349: l_x_Header_Price_Att_rec.line_id := p_Line_id;
350:
1098:
1099: )
1100: IS
1101:
1102: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1103: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1104: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1105: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1106:
1099: )
1100: IS
1101:
1102: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1103: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1104: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1105: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1106:
1107: l_control_rec OE_GLOBALS.Control_Rec_Type;
1100: IS
1101:
1102: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1103: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1104: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1105: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1106:
1107: l_control_rec OE_GLOBALS.Control_Rec_Type;
1108: l_return_status VARCHAR2(1);
1101:
1102: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1103: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
1104: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1105: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1106:
1107: l_control_rec OE_GLOBALS.Control_Rec_Type;
1108: l_return_status VARCHAR2(1);
1109: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1105: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1106:
1107: l_control_rec OE_GLOBALS.Control_Rec_Type;
1108: l_return_status VARCHAR2(1);
1109: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1110: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1111: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1112: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1113: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1106:
1107: l_control_rec OE_GLOBALS.Control_Rec_Type;
1108: l_return_status VARCHAR2(1);
1109: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1110: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1111: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1112: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1113: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1114: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1107: l_control_rec OE_GLOBALS.Control_Rec_Type;
1108: l_return_status VARCHAR2(1);
1109: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1110: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1111: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1112: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1113: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1114: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1115: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1108: l_return_status VARCHAR2(1);
1109: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1110: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1111: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1112: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1113: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1114: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1115: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1116: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1109: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1110: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1111: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1112: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1113: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1114: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1115: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1116: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1117: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1110: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1111: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1112: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1113: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1114: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1115: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1116: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1117: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1118: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1111: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1112: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1113: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1114: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1115: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1116: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1117: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1118: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1119: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1112: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1113: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1114: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1115: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1116: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1117: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1118: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1119: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1120: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1113: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1114: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1115: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1116: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1117: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1118: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1119: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1120: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1121: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1114: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1115: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1116: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1117: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1118: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1119: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1120: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1121: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1122: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1115: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1116: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1117: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1118: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1119: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1120: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1121: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1122: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1123: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1116: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1117: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1118: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1119: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1120: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1121: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1122: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1123: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1124: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1117: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1118: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1119: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1120: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1121: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1122: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1123: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1124: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1125: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1118: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1119: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1120: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1121: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1122: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1123: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1124: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1125: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1126: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1119: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1120: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1121: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1122: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1123: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1124: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1125: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1126: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1127: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1120: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1121: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1122: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1123: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1124: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1125: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1126: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1127: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1128: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1121: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1122: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1123: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1124: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1125: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1126: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1127: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1128: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1129: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1122: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1123: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1124: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1125: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1126: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1127: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1128: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1129: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1130: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1123: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1124: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1125: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1126: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1127: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1128: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1129: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1130: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1131: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1124: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1125: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1126: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1127: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1128: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1129: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1130: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1131: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1132:
1125: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1126: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1127: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1128: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1129: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1130: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1131: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1132:
1133: --
1126: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1127: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1128: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1129: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1130: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1131: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1132:
1133: --
1134: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1127: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1128: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1129: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
1130: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1131: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1132:
1133: --
1134: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1135: --
2468: , x_lock_control OUT NOCOPY NUMBER
2469:
2470: )
2471: IS
2472: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2473: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2474: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2475: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2476: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2469:
2470: )
2471: IS
2472: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2473: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2474: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2475: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2476: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2477: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2470: )
2471: IS
2472: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2473: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2474: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2475: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2476: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2477: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2478: l_control_rec OE_GLOBALS.Control_Rec_Type;
2471: IS
2472: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2473: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2474: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2475: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2476: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2477: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2478: l_control_rec OE_GLOBALS.Control_Rec_Type;
2479: l_return_status VARCHAR2(1);
2472: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2473: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2474: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2475: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2476: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2477: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2478: l_control_rec OE_GLOBALS.Control_Rec_Type;
2479: l_return_status VARCHAR2(1);
2480: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2473: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2474: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2475: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2476: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2477: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2478: l_control_rec OE_GLOBALS.Control_Rec_Type;
2479: l_return_status VARCHAR2(1);
2480: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2481:
2476: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2477: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2478: l_control_rec OE_GLOBALS.Control_Rec_Type;
2479: l_return_status VARCHAR2(1);
2480: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2481:
2482: /* OUT NOCOPY parameters for Process Order */
2483:
2484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2480: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2481:
2482: /* OUT NOCOPY parameters for Process Order */
2483:
2484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2485: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2486: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2487: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2488: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2481:
2482: /* OUT NOCOPY parameters for Process Order */
2483:
2484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2485: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2486: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2487: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2488: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2489: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2482: /* OUT NOCOPY parameters for Process Order */
2483:
2484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2485: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2486: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2487: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2488: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2489: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2490: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2483:
2484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2485: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2486: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2487: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2488: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2489: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2490: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2491: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2484: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2485: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2486: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2487: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2488: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2489: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2490: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2491: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2492: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2485: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2486: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2487: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2488: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2489: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2490: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2491: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2492: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2493: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2486: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2487: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2488: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2489: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2490: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2491: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2492: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2493: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2494: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2487: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2488: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2489: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2490: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2491: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2492: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2493: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2494: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2488: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2489: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2490: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2491: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2492: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2493: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2494: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2496: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2489: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2490: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2491: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2492: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2493: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2494: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2496: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2497: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2490: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2491: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2492: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2493: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2494: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2496: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2497: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2498: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2491: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2492: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2493: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2494: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2496: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2497: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2498: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2499: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2492: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2493: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2494: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2496: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2497: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2498: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2499: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2500: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2493: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2494: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2496: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2497: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2498: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2499: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2500: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2501: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
2494: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2496: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2497: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2498: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2499: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2500: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2501: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
2502: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2495: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2496: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2497: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2498: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2499: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2500: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2501: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
2502: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2503: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2496: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2497: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2498: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2499: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2500: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2501: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
2502: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2503: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2504:
2497: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2498: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2499: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2500: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2501: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
2502: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2503: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2504:
2505: --
2498: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2499: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2500: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2501: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
2502: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2503: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2504:
2505: --
2506: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2499: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2500: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2501: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
2502: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2503: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2504:
2505: --
2506: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2507: --
2681:
2682: , p_order_price_attrib_id IN NUMBER
2683: )
2684: IS
2685: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2686: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2687: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2688: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2689: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2682: , p_order_price_attrib_id IN NUMBER
2683: )
2684: IS
2685: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2686: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2687: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2688: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2689: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2690: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2683: )
2684: IS
2685: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2686: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2687: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2688: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2689: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2690: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2691: l_control_rec OE_GLOBALS.Control_Rec_Type;
2684: IS
2685: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2686: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2687: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2688: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2689: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2690: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2691: l_control_rec OE_GLOBALS.Control_Rec_Type;
2692: l_return_status VARCHAR2(1);
2685: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2686: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2687: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2688: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2689: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2690: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2691: l_control_rec OE_GLOBALS.Control_Rec_Type;
2692: l_return_status VARCHAR2(1);
2693: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2686: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2687: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2688: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2689: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2690: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2691: l_control_rec OE_GLOBALS.Control_Rec_Type;
2692: l_return_status VARCHAR2(1);
2693: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2694:
2689: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2690: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2691: l_control_rec OE_GLOBALS.Control_Rec_Type;
2692: l_return_status VARCHAR2(1);
2693: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2694:
2695: /* out nocopy parameters for Process Order */
2696:
2697: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2693: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2694:
2695: /* out nocopy parameters for Process Order */
2696:
2697: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2698: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2699: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2700: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2701: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2694:
2695: /* out nocopy parameters for Process Order */
2696:
2697: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2698: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2699: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2700: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2701: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2702: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2695: /* out nocopy parameters for Process Order */
2696:
2697: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2698: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2699: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2700: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2701: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2702: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2703: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2696:
2697: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2698: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2699: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2700: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2701: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2702: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2703: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2704: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2697: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2698: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2699: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2700: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2701: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2702: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2703: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2704: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2705: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2698: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2699: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2700: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2701: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2702: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2703: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2704: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2705: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2706: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2699: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2700: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2701: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2702: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2703: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2704: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2705: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2706: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2707: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2700: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2701: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2702: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2703: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2704: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2705: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2706: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2707: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2708: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2701: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2702: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2703: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2704: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2705: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2706: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2707: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2708: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2709: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2702: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2703: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2704: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2705: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2706: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2707: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2708: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2709: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2710: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2703: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2704: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2705: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2706: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2707: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2708: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2709: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2710: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2711: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2704: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2705: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2706: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2707: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2708: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2709: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2710: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2711: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2712: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2705: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2706: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2707: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2708: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2709: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2710: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2711: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2712: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2713: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2706: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2707: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2708: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2709: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2710: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2711: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2712: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2713: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2714: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
2707: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2708: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2709: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2710: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2711: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2712: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2713: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2714: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
2715: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2708: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2709: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2710: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2711: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2712: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2713: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2714: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
2715: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2716: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2709: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2710: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2711: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2712: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2713: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2714: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
2715: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2716: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2717: --
2710: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2711: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2712: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2713: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2714: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
2715: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2716: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2717: --
2718: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2711: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2712: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2713: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2714: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
2715: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2716: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2717: --
2718: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2719: --
2712: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2713: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2714: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
2715: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2716: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2717: --
2718: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2719: --
2720: BEGIN
2857: , p_lock_control IN NUMBER
2858: )
2859: IS
2860: l_return_status VARCHAR2(1);
2861: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2862: l_x_Header_price_Att_Rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2863:
2864: --
2865: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2858: )
2859: IS
2860: l_return_status VARCHAR2(1);
2861: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2862: l_x_Header_price_Att_Rec OE_Order_PUB.Header_Price_Att_Rec_Type;
2863:
2864: --
2865: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2866: --
2926:
2927: END Lock_Row;
2928:
2929: PROCEDURE Write_Order_Header_PAttr
2930: ( p_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
2931: , p_db_record IN BOOLEAN := FALSE
2932: )
2933: IS
2934:
2949: PROCEDURE Get_Order_Header_PAttr
2950: (
2951: p_db_record IN BOOLEAN := FALSE
2952: , p_order_price_attrib_id IN NUMBER
2953: , x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
2954: )
2955: IS
2956: --
2957: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2992: --
2993: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2994: --
2995: BEGIN
2996: g_Header_Price_Att_Rec := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC;
2997: g_db_Header_Price_Att_rec := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC;
2998:
2999:
3000: END Clear_Order_Header_Attr;
2993: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2994: --
2995: BEGIN
2996: g_Header_Price_Att_Rec := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC;
2997: g_db_Header_Price_Att_rec := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC;
2998:
2999:
3000: END Clear_Order_Header_Attr;
3001:
3116: , x_creation_date OUT NOCOPY DATE
3117:
3118: )
3119: IS
3120: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
3121: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3122:
3123: l_control_rec OE_GLOBALS.Control_Rec_Type;
3124: l_return_status VARCHAR2(1);
3117:
3118: )
3119: IS
3120: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
3121: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3122:
3123: l_control_rec OE_GLOBALS.Control_Rec_Type;
3124: l_return_status VARCHAR2(1);
3125: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3121: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3122:
3123: l_control_rec OE_GLOBALS.Control_Rec_Type;
3124: l_return_status VARCHAR2(1);
3125: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3126: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3127: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3128: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3129: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3122:
3123: l_control_rec OE_GLOBALS.Control_Rec_Type;
3124: l_return_status VARCHAR2(1);
3125: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3126: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3127: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3128: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3129: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3130: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3123: l_control_rec OE_GLOBALS.Control_Rec_Type;
3124: l_return_status VARCHAR2(1);
3125: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3126: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3127: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3128: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3129: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3130: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3131: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3124: l_return_status VARCHAR2(1);
3125: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3126: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3127: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3128: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3129: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3130: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3131: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3132: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3125: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3126: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3127: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3128: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3129: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3130: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3131: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3132: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3133: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3126: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3127: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3128: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3129: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3130: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3131: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3132: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3133: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3134: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3127: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3128: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3129: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3130: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3131: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3132: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3133: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3134: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3135: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3128: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3129: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3130: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3131: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3132: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3133: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3134: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3135: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3136: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3129: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3130: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3131: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3132: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3133: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3134: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3135: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3136: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3137: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3130: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3131: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3132: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3133: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3134: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3135: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3136: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3137: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3138: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3131: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3132: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3133: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3134: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3135: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3136: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3137: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3138: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3139: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3132: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3133: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3134: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3135: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3136: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3137: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3138: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3139: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3140: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3133: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3134: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3135: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3136: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3137: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3138: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3139: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3140: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3141: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3134: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3135: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3136: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3137: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3138: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3139: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3140: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3141: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3142: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3135: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3136: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3137: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3138: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3139: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3140: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3141: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3142: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3143: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3136: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3137: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3138: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3139: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3140: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3141: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3142: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3143: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3144: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3137: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3138: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3139: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3140: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3141: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3142: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3143: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3144: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3145: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3138: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3139: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3140: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3141: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3142: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3143: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3144: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3145: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3146: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3139: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3140: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3141: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3142: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3143: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3144: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3145: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3146: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3147: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3140: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3141: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3142: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3143: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3144: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3145: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3146: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3147: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3148:
3141: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3142: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3143: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3144: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3145: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3146: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3147: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3148:
3149: --
3142: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3143: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3144: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3145: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3146: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3147: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3148:
3149: --
3150: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3143: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3144: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3145: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3146: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3147: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3148:
3149: --
3150: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3151: --
3174: l_control_rec.clear_api_requests := FALSE;
3175: -----------------------------------------------
3176: -- Set attributes to NULL
3177: -----------------------------------------------
3178: l_x_old_header_price_att_rec := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
3179: l_x_header_price_att_rec := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
3180:
3181: l_x_Header_Price_Att_rec.header_id := p_header_id;
3182: l_x_Header_Price_Att_rec.line_id := p_Line_id;
3175: -----------------------------------------------
3176: -- Set attributes to NULL
3177: -----------------------------------------------
3178: l_x_old_header_price_att_rec := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
3179: l_x_header_price_att_rec := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_REC;
3180:
3181: l_x_Header_Price_Att_rec.header_id := p_header_id;
3182: l_x_Header_Price_Att_rec.line_id := p_Line_id;
3183:
3553:
3554:
3555: )
3556: IS
3557: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
3558: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
3559: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3560: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3561:
3554:
3555: )
3556: IS
3557: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
3558: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
3559: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3560: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3561:
3562: l_control_rec OE_GLOBALS.Control_Rec_Type;
3555: )
3556: IS
3557: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
3558: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
3559: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3560: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3561:
3562: l_control_rec OE_GLOBALS.Control_Rec_Type;
3563: l_return_status VARCHAR2(1);
3556: IS
3557: l_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
3558: l_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type;
3559: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3560: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3561:
3562: l_control_rec OE_GLOBALS.Control_Rec_Type;
3563: l_return_status VARCHAR2(1);
3564: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3560: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3561:
3562: l_control_rec OE_GLOBALS.Control_Rec_Type;
3563: l_return_status VARCHAR2(1);
3564: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3565: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3566: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3567: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3568: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3561:
3562: l_control_rec OE_GLOBALS.Control_Rec_Type;
3563: l_return_status VARCHAR2(1);
3564: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3565: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3566: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3567: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3568: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3569: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3562: l_control_rec OE_GLOBALS.Control_Rec_Type;
3563: l_return_status VARCHAR2(1);
3564: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3565: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3566: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3567: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3568: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3569: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3570: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3563: l_return_status VARCHAR2(1);
3564: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3565: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3566: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3567: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3568: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3569: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3570: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3571: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3564: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3565: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3566: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3567: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3568: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3569: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3570: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3571: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3572: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3565: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3566: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3567: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3568: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3569: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3570: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3571: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3572: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3573: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3566: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3567: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3568: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3569: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3570: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3571: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3572: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3573: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3574: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3567: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3568: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3569: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3570: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3571: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3572: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3573: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3574: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3575: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3568: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3569: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3570: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3571: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3572: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3573: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3574: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3575: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3576: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3569: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3570: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3571: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3572: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3573: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3574: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3575: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3576: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3577: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3570: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3571: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3572: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3573: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3574: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3575: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3576: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3577: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3578: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3571: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3572: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3573: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3574: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3575: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3576: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3577: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3578: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3579: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3572: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3573: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3574: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3575: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3576: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3577: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3578: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3579: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3580: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3573: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3574: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3575: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3576: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3577: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3578: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3579: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3580: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3581: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3574: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3575: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3576: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3577: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3578: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3579: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3580: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3581: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3582: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3575: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3576: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3577: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3578: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3579: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3580: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3581: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3582: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3583: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3576: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3577: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3578: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3579: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3580: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3581: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3582: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3583: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3584: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3577: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3578: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3579: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3580: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3581: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3582: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3583: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3584: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3585: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3578: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3579: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3580: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3581: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3582: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3583: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3584: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3585: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3586: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3579: l_x_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3580: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3581: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3582: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3583: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3584: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3585: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3586: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3587:
3580: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3581: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3582: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3583: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3584: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3585: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3586: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3587:
3588: --
3581: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3582: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3583: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3584: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3585: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3586: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3587:
3588: --
3589: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3582: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3583: l_x_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3584: l_x_old_Header_Price_Att_rec OE_Order_PUB.Header_Price_Att_Rec_Type ;
3585: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3586: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3587:
3588: --
3589: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3590: --