DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE_PATTR dependencies on OE_ORDER_PUB

Line 7: g_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type

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:

Line 8: := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;

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:

Line 9: g_db_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type

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 */

Line 10: := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;

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

Line 15: ( p_Line_Price_Att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type

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

Line 23: , x_Line_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type

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:

Line 92: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;

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;

Line 93: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_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;

Line 96: l_action_request_tbl OE_Order_PUB.Request_Tbl_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;

Line 97: l_x_header_rec OE_Order_PUB.Header_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;

Line 98: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_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;

Line 99: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_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;

Line 100: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_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;

Line 101: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_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;
105: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 102: l_x_line_rec OE_Order_PUB.Line_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;
106: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 103: l_x_line_tbl OE_Order_PUB.Line_Tbl_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;

Line 104: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_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;

Line 105: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_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;

Line 106: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_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;

Line 107: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_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;

Line 108: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_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;

Line 109: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_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;

Line 110: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_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;
114: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 111: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_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;

Line 112: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_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;

Line 113: l_x_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;

Line 114: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_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;

Line 115: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_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;
119:

Line 116: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_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:
120: --

Line 117: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_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: --
121: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 118: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_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;
122: --

Line 149: l_x_old_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;

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;

Line 150: l_x_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;

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;

Line 568: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;

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);

Line 569: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

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;

Line 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;

Line 574: l_x_header_rec OE_Order_PUB.Header_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;

Line 575: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_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;

Line 576: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_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;

Line 577: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_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;

Line 578: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_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;
582: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 579: l_x_line_rec OE_Order_PUB.Line_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;
583: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 580: l_x_line_tbl OE_Order_PUB.Line_Tbl_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;

Line 581: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_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;

Line 582: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_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;

Line 583: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_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;

Line 584: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_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;

Line 585: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_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;

Line 586: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_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;

Line 587: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_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;
591: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 588: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_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;

Line 589: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_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;

Line 590: l_x_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;

Line 591: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_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;

Line 592: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_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;
596:

Line 593: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_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:
597: --

Line 594: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_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: --
598: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 595: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_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;
599: --

Line 626: l_x_old_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;

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;

Line 627: l_x_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;

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;

Line 1360: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;

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:

Line 1361: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;

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;

Line 1362: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_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);

Line 1363: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

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;

Line 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;

Line 1368: l_x_header_rec OE_Order_PUB.Header_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;

Line 1369: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_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;

Line 1370: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_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;

Line 1371: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_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;

Line 1372: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_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;
1376: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 1373: l_x_line_rec OE_Order_PUB.Line_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;
1377: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 1374: l_x_line_tbl OE_Order_PUB.Line_Tbl_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;

Line 1375: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_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;

Line 1376: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_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;

Line 1377: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_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;

Line 1378: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_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;

Line 1379: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_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;

Line 1380: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_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 ;

Line 1381: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_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 ;

Line 1382: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_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 ;

Line 1383: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_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 ;
1387: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;

Line 1384: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_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 ;

Line 1385: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_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;

Line 1386: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_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:

Line 1387: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_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:
1391: --

Line 1388: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_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: --
1392: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1389: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_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;
1393: --

Line 2759: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;

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;

Line 2760: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_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);

Line 2761: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

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;

Line 2762: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_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:

Line 2765: l_action_request_tbl OE_Order_PUB.Request_Tbl_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:
2767: /* OUT NOCOPY parameters for Process Order */
2768:
2769: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 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;

Line 2770: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_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;

Line 2771: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_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;

Line 2772: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_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;

Line 2773: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_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;

Line 2774: l_x_line_rec OE_Order_PUB.Line_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;
2778: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 2775: l_x_line_tbl OE_Order_PUB.Line_Tbl_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;

Line 2776: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_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;

Line 2777: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_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;

Line 2778: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_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;

Line 2779: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_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;

Line 2780: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_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;

Line 2781: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_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 ;

Line 2782: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_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 ;

Line 2783: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_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 ;

Line 2784: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_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 ;
2788: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;

Line 2785: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_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 ;

Line 2786: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_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;

Line 2787: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_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:

Line 2788: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_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:
2792: --

Line 2789: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_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: --
2793: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2790: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_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;
2794: --

Line 2984: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;

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;

Line 2985: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_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);

Line 2986: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

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;

Line 2987: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_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:

Line 2990: l_action_request_tbl OE_Order_PUB.Request_Tbl_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:
2992: /* out nocopy parameters for Process Order */
2993:
2994: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

Line 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;

Line 2995: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_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;

Line 2996: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_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;

Line 2997: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_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;

Line 2998: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_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;

Line 2999: l_x_line_rec OE_Order_PUB.Line_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;
3003: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 3000: l_x_line_tbl OE_Order_PUB.Line_Tbl_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;

Line 3001: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_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;

Line 3002: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_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;

Line 3003: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_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;

Line 3004: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_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;

Line 3005: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_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;

Line 3006: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_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 ;

Line 3007: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_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 ;

Line 3008: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_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 ;

Line 3009: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_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 ;
3013: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;

Line 3010: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_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 ;

Line 3011: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_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;

Line 3012: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_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: --

Line 3013: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_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: --
3017: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3014: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_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;
3018: --

Line 3015: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_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: --
3019: BEGIN

Line 3160: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

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;

Line 3161: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;

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: --

Line 3230: ( p_Line_Price_Att_rec IN OE_Order_PUB.Line_Price_Att_Rec_Type

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:

Line 3253: , x_Line_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type

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;

Line 3322: g_Line_Price_Att_Rec := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC;

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;

Line 3323: g_db_Line_Price_Att_rec := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_REC;

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:

Line 3533: l_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type;

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:

Line 3534: l_old_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;

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;

Line 3535: l_Line_Price_Att_Tbl OE_Order_PUB.Line_Price_Att_Tbl_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);

Line 3536: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

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;

Line 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;

Line 3541: l_x_header_rec OE_Order_PUB.Header_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;

Line 3542: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_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;

Line 3543: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_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;

Line 3544: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_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;

Line 3545: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_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;
3549: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 3546: l_x_line_rec OE_Order_PUB.Line_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;
3550: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 3547: l_x_line_tbl OE_Order_PUB.Line_Tbl_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;

Line 3548: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_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;

Line 3549: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_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;

Line 3550: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_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;

Line 3551: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_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;

Line 3552: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_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;

Line 3553: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_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 ;

Line 3554: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_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 ;

Line 3555: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_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 ;

Line 3556: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_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 ;
3560: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_Type ;

Line 3557: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_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 ;

Line 3558: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_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;

Line 3559: l_x_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_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:

Line 3560: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_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:
3564: --

Line 3561: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_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: --
3565: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3562: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_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;
3566: --

Line 4379: l_Line_Price_Att_rec OE_Order_PUB.Line_Price_Att_Rec_Type;

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);

Line 4380: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

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;

Line 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;

Line 4385: l_x_header_rec OE_Order_PUB.Header_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;

Line 4386: l_x_Header_Adj_rec OE_Order_PUB.Header_Adj_Rec_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;

Line 4387: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_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;

Line 4388: l_x_Header_Scredit_rec OE_Order_PUB.Header_Scredit_Rec_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;

Line 4389: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_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;
4393: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 4390: l_x_line_rec OE_Order_PUB.Line_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;
4394: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_Type;

Line 4391: l_x_line_tbl OE_Order_PUB.Line_Tbl_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;

Line 4392: l_x_Line_Adj_rec OE_Order_PUB.Line_Adj_Rec_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;

Line 4393: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_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;

Line 4394: l_x_Line_Scredit_rec OE_Order_PUB.Line_Scredit_Rec_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;

Line 4395: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_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;

Line 4396: l_x_Lot_Serial_rec OE_Order_PUB.Lot_Serial_Rec_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;

Line 4397: l_x_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_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;

Line 4398: l_x_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_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;
4402: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 4399: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_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;

Line 4400: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_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;

Line 4401: l_x_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;

Line 4402: l_x_Line_Price_Att_tbl OE_Order_PUB.Line_Price_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;

Line 4403: l_x_old_Line_Price_Att_tbl OE_Order_PUB.Line_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;
4407:

Line 4404: l_x_old_Line_Price_Att_Rec OE_Order_PUB.Line_Price_Att_Rec_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:
4408: --

Line 4405: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_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: --
4409: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4406: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_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;
4410: --

Line 4437: l_x_old_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;

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;

Line 4438: l_x_line_price_att_rec := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_REC;

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;