3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Line_PAttr';
6:
7: g_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type
8: := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
9: g_db_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type
10: := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
11:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Line_PAttr';
6:
7: g_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type
8: := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
9: g_db_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type
10: := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
11:
12:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_OE_Form_Line_PAttr';
6:
7: g_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type
8: := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
9: g_db_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type
10: := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
11:
12:
13: /* Get Line Pricing Attr */
6:
7: g_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type
8: := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
9: g_db_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type
10: := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
11:
12:
13: /* Get Line Pricing Attr */
14: PROCEDURE Write_Order_Line_PAttr
11:
12:
13: /* Get Line Pricing Attr */
14: PROCEDURE Write_Order_Line_PAttr
15: ( p_Line_Price_Att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type
16: , p_db_record IN BOOLEAN := FALSE
17: );
18:
19: PROCEDURE Get_Order_Line_PAttr
19: PROCEDURE Get_Order_Line_PAttr
20: (
21: p_db_record IN BOOLEAN := FALSE
22: , p_order_price_attrib_id IN NUMBER
23: , x_Line_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
24: );
25:
26: PROCEDURE Clear_Order_Line_Attr;
27:
88: , x_creation_date OUT NOCOPY DATE
89:
90: ) Is
91:
92: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
93: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
94: l_control_rec OE_GLOBALS.Control_Rec_Type;
95: l_return_status VARCHAR2(1);
96: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
89:
90: ) Is
91:
92: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
93: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
94: l_control_rec OE_GLOBALS.Control_Rec_Type;
95: l_return_status VARCHAR2(1);
96: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
97: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
92: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
93: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
94: l_control_rec OE_GLOBALS.Control_Rec_Type;
95: l_return_status VARCHAR2(1);
96: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
97: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
98: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
99: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
100: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
93: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
94: l_control_rec OE_GLOBALS.Control_Rec_Type;
95: l_return_status VARCHAR2(1);
96: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
97: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
98: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
99: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
100: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
101: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
94: l_control_rec OE_GLOBALS.Control_Rec_Type;
95: l_return_status VARCHAR2(1);
96: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
97: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
98: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
99: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
100: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
101: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
102: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
95: l_return_status VARCHAR2(1);
96: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
97: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
98: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
99: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
100: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
101: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
102: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
103: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
96: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
97: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
98: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
99: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
100: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
101: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
102: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
103: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
104: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
97: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
98: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
99: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
100: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
101: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
102: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
103: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
104: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
105: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
98: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
99: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
100: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
101: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
102: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
103: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
104: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
105: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
106: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
99: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
100: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
101: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
102: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
103: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
104: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
105: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
106: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
107: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
100: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
101: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
102: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
103: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
104: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
105: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
106: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
107: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
108: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
101: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
102: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
103: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
104: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
105: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
106: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
107: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
108: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
109: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
102: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
103: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
104: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
105: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
106: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
107: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
108: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
109: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
110: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
103: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
104: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
105: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
106: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
107: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
108: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
109: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
110: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
111: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
104: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
105: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
106: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
107: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
108: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
109: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
110: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
111: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
112: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
105: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
106: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
107: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
108: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
109: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
110: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
111: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
112: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
113: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
106: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
107: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
108: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
109: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
110: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
111: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
112: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
113: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
114: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
107: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
108: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
109: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
110: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
111: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
112: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
113: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
114: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
115: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
108: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
109: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
110: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
111: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
112: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
113: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
114: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
115: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
116: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
109: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
110: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
111: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
112: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
113: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
114: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
115: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
116: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
117: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
110: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
111: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
112: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
113: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
114: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
115: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
116: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
117: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
118: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
111: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
112: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
113: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
114: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
115: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
116: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
117: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
118: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
119:
112: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
113: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
114: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
115: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
116: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
117: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
118: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
119:
120: --
113: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
114: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
115: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
116: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
117: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
118: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
119:
120: --
121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
114: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
115: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
116: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
117: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
118: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
119:
120: --
121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
122: --
145: -----------------------------------------------
146: -- Set attributes to NULL
147: -----------------------------------------------
148:
149: l_x_old_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
150: l_x_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
151: IF l_debug_level > 0 THEN
152: oe_debug_pub.add( ' BEFORE SETTING THINGS TO NULL: OE_ORDER_ADJ_PVT.LINE_PRICE_ATTS' ) ;
153: END IF;
146: -- Set attributes to NULL
147: -----------------------------------------------
148:
149: l_x_old_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
150: l_x_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
151: IF l_debug_level > 0 THEN
152: oe_debug_pub.add( ' BEFORE SETTING THINGS TO NULL: OE_ORDER_ADJ_PVT.LINE_PRICE_ATTS' ) ;
153: END IF;
154: l_x_Line_Price_Att_Rec.header_id := p_header_id;
564: , x_creation_date OUT NOCOPY DATE
565:
566: )
567: IS
568: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
569: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
570:
571: l_control_rec OE_GLOBALS.Control_Rec_Type;
572: l_return_status VARCHAR2(1);
565:
566: )
567: IS
568: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
569: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
570:
571: l_control_rec OE_GLOBALS.Control_Rec_Type;
572: l_return_status VARCHAR2(1);
573: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
569: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
570:
571: l_control_rec OE_GLOBALS.Control_Rec_Type;
572: l_return_status VARCHAR2(1);
573: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
574: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
575: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
576: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
577: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
570:
571: l_control_rec OE_GLOBALS.Control_Rec_Type;
572: l_return_status VARCHAR2(1);
573: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
574: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
575: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
576: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
577: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
578: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
571: l_control_rec OE_GLOBALS.Control_Rec_Type;
572: l_return_status VARCHAR2(1);
573: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
574: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
575: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
576: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
577: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
578: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
579: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
572: l_return_status VARCHAR2(1);
573: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
574: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
575: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
576: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
577: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
578: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
579: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
580: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
573: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
574: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
575: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
576: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
577: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
578: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
579: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
580: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
581: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
574: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
575: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
576: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
577: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
578: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
579: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
580: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
581: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
582: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
575: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
576: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
577: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
578: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
579: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
580: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
581: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
582: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
583: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
576: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
577: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
578: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
579: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
580: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
581: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
582: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
583: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
584: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
577: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
578: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
579: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
580: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
581: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
582: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
583: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
584: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
585: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
578: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
579: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
580: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
581: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
582: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
583: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
584: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
585: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
586: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
579: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
580: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
581: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
582: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
583: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
584: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
585: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
586: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
587: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
580: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
581: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
582: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
583: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
584: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
585: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
586: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
587: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
588: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
581: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
582: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
583: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
584: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
585: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
586: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
587: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
588: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
589: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
582: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
583: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
584: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
585: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
586: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
587: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
588: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
589: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
590: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
583: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
584: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
585: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
586: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
587: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
588: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
589: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
590: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
591: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
584: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
585: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
586: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
587: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
588: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
589: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
590: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
591: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
592: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
585: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
586: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
587: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
588: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
589: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
590: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
591: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
592: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
593: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
586: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
587: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
588: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
589: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
590: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
591: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
592: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
593: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
594: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
587: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
588: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
589: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
590: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
591: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
592: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
593: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
594: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
595: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
588: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
589: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
590: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
591: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
592: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
593: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
594: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
595: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
596:
589: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
590: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
591: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
592: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
593: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
594: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
595: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
596:
597: --
590: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
591: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
592: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
593: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
594: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
595: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
596:
597: --
598: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
591: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
592: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
593: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
594: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
595: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
596:
597: --
598: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
599: --
622: -----------------------------------------------
623: -- Set attributes to NULL
624: -----------------------------------------------
625:
626: l_x_old_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
627: l_x_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
628: IF l_debug_level > 0 THEN
629: oe_debug_pub.add( ' BEFORE SETTING THINGS TO NULL: OE_ORDER_ADJ_PVT.LINE_PRICE_ATTS' ) ;
630: END IF;
623: -- Set attributes to NULL
624: -----------------------------------------------
625:
626: l_x_old_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
627: l_x_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
628: IF l_debug_level > 0 THEN
629: oe_debug_pub.add( ' BEFORE SETTING THINGS TO NULL: OE_ORDER_ADJ_PVT.LINE_PRICE_ATTS' ) ;
630: END IF;
631: l_x_Line_Price_Att_Rec.header_id := p_header_id;
1356:
1357: )
1358: IS
1359:
1360: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
1361: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
1362: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1363: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1364:
1357: )
1358: IS
1359:
1360: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
1361: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
1362: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1363: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1364:
1365: l_control_rec OE_GLOBALS.Control_Rec_Type;
1358: IS
1359:
1360: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
1361: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
1362: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1363: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1364:
1365: l_control_rec OE_GLOBALS.Control_Rec_Type;
1366: l_return_status VARCHAR2(1);
1359:
1360: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
1361: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
1362: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1363: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1364:
1365: l_control_rec OE_GLOBALS.Control_Rec_Type;
1366: l_return_status VARCHAR2(1);
1367: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1363: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1364:
1365: l_control_rec OE_GLOBALS.Control_Rec_Type;
1366: l_return_status VARCHAR2(1);
1367: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1368: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1369: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1370: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1371: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1364:
1365: l_control_rec OE_GLOBALS.Control_Rec_Type;
1366: l_return_status VARCHAR2(1);
1367: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1368: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1369: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1370: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1371: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1372: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1365: l_control_rec OE_GLOBALS.Control_Rec_Type;
1366: l_return_status VARCHAR2(1);
1367: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1368: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1369: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1370: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1371: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1372: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1373: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1366: l_return_status VARCHAR2(1);
1367: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1368: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1369: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1370: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1371: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1372: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1373: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1374: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1367: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1368: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1369: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1370: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1371: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1372: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1373: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1374: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1375: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1368: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
1369: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1370: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1371: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1372: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1373: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1374: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1375: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1376: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1369: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
1370: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1371: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1372: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1373: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1374: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1375: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1376: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1377: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1370: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1371: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1372: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1373: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1374: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1375: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1376: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1377: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1378: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1371: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
1372: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1373: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1374: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1375: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1376: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1377: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1378: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1379: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1372: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1373: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1374: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1375: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1376: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1377: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1378: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1379: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1380: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1373: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
1374: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1375: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1376: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1377: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1378: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1379: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1380: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1381: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1374: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
1375: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1376: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1377: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1378: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1379: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1380: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1381: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1382: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1375: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
1376: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1377: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1378: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1379: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1380: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1381: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1382: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1383: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1376: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1377: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1378: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1379: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1380: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1381: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1382: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1383: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1384: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1377: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
1378: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1379: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1380: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1381: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1382: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1383: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1384: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1385: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1378: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1379: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1380: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1381: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1382: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1383: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1384: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1385: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1386: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1379: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
1380: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1381: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1382: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1383: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1384: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1385: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1386: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1387: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1380: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1381: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1382: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1383: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1384: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1385: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1386: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1387: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1388: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1381: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1382: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1383: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1384: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1385: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1386: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1387: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1388: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1389: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1382: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1383: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1384: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1385: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1386: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1387: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1388: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1389: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1390:
1383: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1384: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1385: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1386: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1387: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1388: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1389: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1390:
1391: --
1384: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1385: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1386: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1387: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1388: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1389: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1390:
1391: --
1392: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1385: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1386: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1387: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
1388: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1389: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1390:
1391: --
1392: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1393: --
2755:
2756: , p_called_from_pattr IN VARCHAR2 DEFAULT 'N'
2757: )
2758: IS
2759: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2760: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2761: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2762: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2763: l_control_rec OE_GLOBALS.Control_Rec_Type;
2756: , p_called_from_pattr IN VARCHAR2 DEFAULT 'N'
2757: )
2758: IS
2759: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2760: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2761: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2762: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2763: l_control_rec OE_GLOBALS.Control_Rec_Type;
2764: l_return_status VARCHAR2(1);
2757: )
2758: IS
2759: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2760: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2761: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2762: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2763: l_control_rec OE_GLOBALS.Control_Rec_Type;
2764: l_return_status VARCHAR2(1);
2765: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2758: IS
2759: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2760: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2761: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2762: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2763: l_control_rec OE_GLOBALS.Control_Rec_Type;
2764: l_return_status VARCHAR2(1);
2765: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2766:
2761: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2762: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2763: l_control_rec OE_GLOBALS.Control_Rec_Type;
2764: l_return_status VARCHAR2(1);
2765: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2766:
2767: /* OUT NOCOPY parameters for Process Order */
2768:
2769: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2765: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2766:
2767: /* OUT NOCOPY parameters for Process Order */
2768:
2769: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2770: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2771: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2772: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2773: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2766:
2767: /* OUT NOCOPY parameters for Process Order */
2768:
2769: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2770: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2771: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2772: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2773: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2774: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2767: /* OUT NOCOPY parameters for Process Order */
2768:
2769: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2770: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2771: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2772: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2773: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2774: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2775: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2768:
2769: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2770: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2771: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2772: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2773: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2774: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2775: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2776: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2769: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2770: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2771: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2772: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2773: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2774: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2775: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2776: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2770: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2771: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2772: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2773: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2774: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2775: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2776: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2778: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2771: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2772: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2773: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2774: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2775: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2776: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2778: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2779: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2772: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2773: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2774: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2775: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2776: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2778: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2779: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2780: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2773: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2774: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2775: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2776: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2778: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2779: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2780: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2781: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2774: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2775: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2776: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2778: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2779: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2780: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2781: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2782: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2775: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2776: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2778: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2779: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2780: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2781: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2782: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2783: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2776: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2778: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2779: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2780: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2781: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2782: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2783: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2784: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2778: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2779: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2780: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2781: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2782: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2783: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2784: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2785: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2778: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2779: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2780: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2781: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2782: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2783: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2784: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2785: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2786: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2779: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2780: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2781: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2782: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2783: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2784: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2785: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2786: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2787: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2780: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2781: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2782: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2783: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2784: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2785: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2786: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2787: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2788: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2781: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2782: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2783: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2784: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2785: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2786: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2787: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2788: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2789: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2782: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2783: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2784: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2785: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2786: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2787: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2788: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2789: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2790: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2783: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2784: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2785: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2786: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2787: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2788: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2789: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2790: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2791:
2784: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2785: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2786: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2787: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2788: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2789: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2790: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2791:
2792: --
2785: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2786: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2787: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2788: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2789: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2790: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2791:
2792: --
2793: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2786: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2787: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2788: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
2789: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2790: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2791:
2792: --
2793: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2794: --
2980:
2981: , p_order_price_attrib_id IN NUMBER
2982: )
2983: IS
2984: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2985: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2986: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2987: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2988: l_control_rec OE_GLOBALS.Control_Rec_Type;
2981: , p_order_price_attrib_id IN NUMBER
2982: )
2983: IS
2984: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2985: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2986: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2987: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2988: l_control_rec OE_GLOBALS.Control_Rec_Type;
2989: l_return_status VARCHAR2(1);
2982: )
2983: IS
2984: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2985: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2986: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2987: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2988: l_control_rec OE_GLOBALS.Control_Rec_Type;
2989: l_return_status VARCHAR2(1);
2990: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2983: IS
2984: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2985: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
2986: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2987: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2988: l_control_rec OE_GLOBALS.Control_Rec_Type;
2989: l_return_status VARCHAR2(1);
2990: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2991:
2986: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2987: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2988: l_control_rec OE_GLOBALS.Control_Rec_Type;
2989: l_return_status VARCHAR2(1);
2990: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2991:
2992: /* out nocopy parameters for Process Order */
2993:
2994: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2990: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
2991:
2992: /* out nocopy parameters for Process Order */
2993:
2994: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2995: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2996: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2997: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2998: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2991:
2992: /* out nocopy parameters for Process Order */
2993:
2994: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2995: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2996: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2997: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2998: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2999: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
2992: /* out nocopy parameters for Process Order */
2993:
2994: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2995: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2996: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2997: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2998: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2999: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3000: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2993:
2994: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2995: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2996: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2997: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2998: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2999: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3000: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3001: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
2994: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2995: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2996: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2997: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2998: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2999: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3000: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3001: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3002: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2995: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
2996: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2997: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2998: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2999: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3000: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3001: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3002: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3003: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
2996: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2997: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2998: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2999: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3000: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3001: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3002: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3003: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3004: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2997: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
2998: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2999: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3000: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3001: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3002: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3003: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3004: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3005: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
2998: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2999: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3000: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3001: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3002: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3003: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3004: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3005: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3006: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2999: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3000: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3001: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3002: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3003: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3004: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3005: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3006: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3007: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3000: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3001: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3002: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3003: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3004: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3005: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3006: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3007: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3008: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3001: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3002: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3003: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3004: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3005: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3006: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3007: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3008: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3009: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3002: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3003: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3004: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3005: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3006: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3007: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3008: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3009: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3010: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3003: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3004: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3005: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3006: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3007: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3008: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3009: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3010: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3011: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3004: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3005: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3006: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3007: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3008: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3009: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3010: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3011: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3012: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3005: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3006: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3007: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3008: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3009: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3010: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3011: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3012: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3013: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3006: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3007: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3008: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3009: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3010: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3011: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3012: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3013: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3014: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3007: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3008: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3009: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3010: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3011: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3012: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3013: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3014: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3015: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3008: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3009: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3010: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3011: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3012: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3013: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3014: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3015: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3016: --
3009: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3010: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3011: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3012: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3013: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3014: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3015: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3016: --
3017: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3010: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3011: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3012: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3013: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3014: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3015: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3016: --
3017: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3018: --
3011: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3012: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3013: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3014: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3015: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3016: --
3017: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3018: --
3019: BEGIN
3156: , p_lock_control IN NUMBER
3157: )
3158: IS
3159: l_return_status VARCHAR2(1);
3160: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3161: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
3162:
3163: --
3164: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3157: )
3158: IS
3159: l_return_status VARCHAR2(1);
3160: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3161: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
3162:
3163: --
3164: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3165: --
3226:
3227: END Lock_Row;
3228:
3229: PROCEDURE Write_Order_Line_PAttr
3230: ( p_Line_Price_Att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type
3231: , p_db_record IN BOOLEAN := FALSE
3232: )
3233: IS
3234:
3249: PROCEDURE Get_Order_Line_PAttr
3250: (
3251: p_db_record IN BOOLEAN := FALSE
3252: , p_order_price_attrib_id IN NUMBER
3253: , x_Line_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
3254: )
3255: IS
3256: --
3257: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3318: --
3319: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3320: --
3321: BEGIN
3322: g_Line_Price_Att_Rec := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC;
3323: g_db_Line_Price_Att_rec := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC;
3324:
3325:
3326: END Clear_Order_Line_Attr;
3319: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3320: --
3321: BEGIN
3322: g_Line_Price_Att_Rec := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC;
3323: g_db_Line_Price_Att_rec := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC;
3324:
3325:
3326: END Clear_Order_Line_Attr;
3327:
3529: , p_called_from_pattr IN VARCHAR2 DEFAULT 'N'
3530:
3531: ) IS
3532:
3533: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
3534: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
3535: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3536: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3537:
3530:
3531: ) IS
3532:
3533: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
3534: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
3535: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3536: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3537:
3538: l_control_rec OE_GLOBALS.Control_Rec_Type;
3531: ) IS
3532:
3533: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
3534: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
3535: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3536: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3537:
3538: l_control_rec OE_GLOBALS.Control_Rec_Type;
3539: l_return_status VARCHAR2(1);
3532:
3533: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
3534: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
3535: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3536: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3537:
3538: l_control_rec OE_GLOBALS.Control_Rec_Type;
3539: l_return_status VARCHAR2(1);
3540: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3536: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3537:
3538: l_control_rec OE_GLOBALS.Control_Rec_Type;
3539: l_return_status VARCHAR2(1);
3540: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3541: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3542: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3543: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3544: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3537:
3538: l_control_rec OE_GLOBALS.Control_Rec_Type;
3539: l_return_status VARCHAR2(1);
3540: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3541: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3542: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3543: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3544: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3545: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3538: l_control_rec OE_GLOBALS.Control_Rec_Type;
3539: l_return_status VARCHAR2(1);
3540: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3541: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3542: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3543: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3544: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3545: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3546: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3539: l_return_status VARCHAR2(1);
3540: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3541: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3542: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3543: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3544: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3545: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3546: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3547: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3540: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
3541: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3542: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3543: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3544: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3545: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3546: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3547: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3548: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3541: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
3542: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3543: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3544: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3545: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3546: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3547: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3548: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3549: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3542: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
3543: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3544: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3545: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3546: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3547: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3548: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3549: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3550: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3543: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
3544: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3545: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3546: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3547: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3548: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3549: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3550: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3551: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3544: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
3545: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3546: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3547: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3548: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3549: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3550: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3551: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3552: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3545: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3546: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3547: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3548: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3549: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3550: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3551: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3552: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3553: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3546: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
3547: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3548: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3549: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3550: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3551: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3552: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3553: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3554: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3547: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
3548: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3549: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3550: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3551: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3552: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3553: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3554: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3555: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3548: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
3549: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3550: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3551: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3552: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3553: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3554: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3555: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3556: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3549: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
3550: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3551: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3552: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3553: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3554: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3555: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3556: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3557: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3550: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
3551: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3552: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3553: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3554: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3555: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3556: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3557: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3558: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3551: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
3552: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3553: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3554: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3555: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3556: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3557: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3558: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3559: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3552: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
3553: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3554: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3555: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3556: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3557: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3558: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3559: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3560: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3553: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
3554: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3555: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3556: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3557: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3558: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3559: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3560: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3561: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3554: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3555: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3556: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3557: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3558: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3559: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3560: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3561: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3562: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3555: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3556: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3557: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3558: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3559: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3560: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3561: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3562: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3563:
3556: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3557: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3558: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3559: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3560: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3561: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3562: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3563:
3564: --
3557: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3558: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3559: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3560: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3561: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3562: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3563:
3564: --
3565: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3558: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
3559: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3560: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;
3561: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
3562: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
3563:
3564: --
3565: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3566: --
4375:
4376: , x_creation_date OUT NOCOPY DATE
4377:
4378: ) IS
4379: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4380: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4381:
4382: l_control_rec OE_GLOBALS.Control_Rec_Type;
4383: l_return_status VARCHAR2(1);
4376: , x_creation_date OUT NOCOPY DATE
4377:
4378: ) IS
4379: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4380: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4381:
4382: l_control_rec OE_GLOBALS.Control_Rec_Type;
4383: l_return_status VARCHAR2(1);
4384: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4380: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4381:
4382: l_control_rec OE_GLOBALS.Control_Rec_Type;
4383: l_return_status VARCHAR2(1);
4384: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4385: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
4386: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4387: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4388: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
4381:
4382: l_control_rec OE_GLOBALS.Control_Rec_Type;
4383: l_return_status VARCHAR2(1);
4384: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4385: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
4386: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4387: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4388: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
4389: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4382: l_control_rec OE_GLOBALS.Control_Rec_Type;
4383: l_return_status VARCHAR2(1);
4384: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4385: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
4386: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4387: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4388: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
4389: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4390: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
4383: l_return_status VARCHAR2(1);
4384: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4385: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
4386: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4387: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4388: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
4389: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4390: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
4391: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4384: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
4385: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
4386: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4387: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4388: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
4389: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4390: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
4391: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4392: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4385: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
4386: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4387: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4388: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
4389: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4390: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
4391: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4392: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4393: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4386: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_Type;
4387: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4388: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
4389: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4390: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
4391: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4392: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4393: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4394: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
4387: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
4388: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
4389: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4390: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
4391: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4392: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4393: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4394: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
4395: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4388: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_Type;
4389: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4390: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
4391: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4392: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4393: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4394: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
4395: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4396: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
4389: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
4390: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
4391: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4392: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4393: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4394: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
4395: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4396: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
4397: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4390: l_x_line_rec OE_Order_PUB.Line_Rec_Type;
4391: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4392: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4393: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4394: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
4395: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4396: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
4397: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4398: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4391: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
4392: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4393: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4394: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
4395: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4396: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
4397: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4398: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4399: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4392: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_Type;
4393: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4394: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
4395: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4396: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
4397: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4398: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4399: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4400: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4393: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
4394: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
4395: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4396: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
4397: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4398: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4399: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4400: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4401: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4394: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;
4395: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4396: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
4397: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4398: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4399: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4400: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4401: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4402: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4395: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4396: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
4397: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4398: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4399: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4400: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4401: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4402: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4403: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4396: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_Type;
4397: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4398: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4399: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4400: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4401: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4402: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4403: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4404: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4397: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4398: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4399: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4400: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4401: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4402: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4403: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4404: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4405: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4398: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
4399: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4400: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4401: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4402: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4403: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4404: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4405: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4406: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4399: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
4400: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4401: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4402: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4403: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4404: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4405: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4406: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4407:
4400: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
4401: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4402: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4403: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4404: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4405: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4406: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4407:
4408: --
4401: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4402: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4403: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4404: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4405: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4406: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4407:
4408: --
4409: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4402: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4403: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
4404: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;
4405: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4406: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4407:
4408: --
4409: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4410: --
4433: -----------------------------------------------
4434: -- Set attributes to NULL
4435: -----------------------------------------------
4436:
4437: l_x_old_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
4438: l_x_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
4439: IF l_debug_level > 0 THEN
4440: oe_debug_pub.add( ' BEFORE SETTING THINGS TO NULL: OE_ORDER_ADJ_PVT.LINE_PRICE_ATTS' ) ;
4441: END IF;
4434: -- Set attributes to NULL
4435: -----------------------------------------------
4436:
4437: l_x_old_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
4438: l_x_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;
4439: IF l_debug_level > 0 THEN
4440: oe_debug_pub.add( ' BEFORE SETTING THINGS TO NULL: OE_ORDER_ADJ_PVT.LINE_PRICE_ATTS' ) ;
4441: END IF;
4442: l_x_Line_Price_Att_Rec.header_id := p_header_id;