DBA Data[Home] [Help]

APPS.OE_ORDER_UTIL dependencies on OE_ORDER_PUB

Line 152: , p_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL

148:
149: PROCEDURE Update_Global_Picture
150: (
151: p_Upd_New_Rec_If_Exists IN BOOLEAN := TRUE
152: , p_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
153: , p_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
154: , p_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
155: , p_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
156: , p_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL

Line 153: , p_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL

149: PROCEDURE Update_Global_Picture
150: (
151: p_Upd_New_Rec_If_Exists IN BOOLEAN := TRUE
152: , p_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
153: , p_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
154: , p_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
155: , p_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
156: , p_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
157: , p_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL

Line 154: , p_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL

150: (
151: p_Upd_New_Rec_If_Exists IN BOOLEAN := TRUE
152: , p_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
153: , p_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
154: , p_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
155: , p_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
156: , p_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
157: , p_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
158: , p_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL

Line 155: , p_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL

151: p_Upd_New_Rec_If_Exists IN BOOLEAN := TRUE
152: , p_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
153: , p_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
154: , p_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
155: , p_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
156: , p_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
157: , p_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
158: , p_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
159: , p_old_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL

Line 156: , p_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL

152: , p_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
153: , p_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
154: , p_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
155: , p_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
156: , p_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
157: , p_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
158: , p_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
159: , p_old_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
160: , p_old_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL

Line 157: , p_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL

153: , p_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
154: , p_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
155: , p_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
156: , p_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
157: , p_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
158: , p_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
159: , p_old_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
160: , p_old_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
161: , p_old_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL

Line 158: , p_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL

154: , p_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
155: , p_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
156: , p_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
157: , p_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
158: , p_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
159: , p_old_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
160: , p_old_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
161: , p_old_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
162: , p_old_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL

Line 159: , p_old_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL

155: , p_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
156: , p_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
157: , p_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
158: , p_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
159: , p_old_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
160: , p_old_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
161: , p_old_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
162: , p_old_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
163: , p_old_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL

Line 160: , p_old_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL

156: , p_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
157: , p_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
158: , p_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
159: , p_old_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
160: , p_old_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
161: , p_old_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
162: , p_old_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
163: , p_old_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
164: , p_old_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL

Line 161: , p_old_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL

157: , p_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
158: , p_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
159: , p_old_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
160: , p_old_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
161: , p_old_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
162: , p_old_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
163: , p_old_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
164: , p_old_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
165: , p_old_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL

Line 162: , p_old_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL

158: , p_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
159: , p_old_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
160: , p_old_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
161: , p_old_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
162: , p_old_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
163: , p_old_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
164: , p_old_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
165: , p_old_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
166: , p_header_id IN NUMBER := NULL

Line 163: , p_old_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL

159: , p_old_Header_Rec IN OE_Order_Pub.Header_Rec_Type := NULL
160: , p_old_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
161: , p_old_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
162: , p_old_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
163: , p_old_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
164: , p_old_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
165: , p_old_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
166: , p_header_id IN NUMBER := NULL
167: , p_line_id IN NUMBER := NULL

Line 164: , p_old_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL

160: , p_old_Line_Rec IN OE_Order_Pub.Line_Rec_Type := NULL
161: , p_old_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
162: , p_old_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
163: , p_old_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
164: , p_old_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
165: , p_old_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
166: , p_header_id IN NUMBER := NULL
167: , p_line_id IN NUMBER := NULL
168: , p_hdr_scr_id IN NUMBER := NULL

Line 165: , p_old_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL

161: , p_old_Hdr_Scr_Rec IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
162: , p_old_Hdr_Adj_Rec IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
163: , p_old_Line_Adj_Rec IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
164: , p_old_Line_Scr_Rec IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
165: , p_old_Lot_Serial_Rec IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
166: , p_header_id IN NUMBER := NULL
167: , p_line_id IN NUMBER := NULL
168: , p_hdr_scr_id IN NUMBER := NULL
169: , p_line_scr_id IN NUMBER := NULL

Line 182: l_old_line_rec OE_Order_Pub.Line_Rec_Type;

178: IS
179: l_ind PLS_INTEGER;
180: l_result VARCHAR2(30);
181: l_return_stat VARCHAR2(1);
182: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
183: l_old_Header_Rec OE_Order_Pub.Header_Rec_Type;
184: l_old_Hdr_Scr_Rec OE_Order_Pub.Header_Scredit_Rec_Type;
185: l_old_Hdr_Adj_Rec OE_Order_Pub.Header_Adj_Rec_Type;
186: l_old_Line_Adj_Rec OE_Order_Pub.Line_Adj_Rec_Type;

Line 183: l_old_Header_Rec OE_Order_Pub.Header_Rec_Type;

179: l_ind PLS_INTEGER;
180: l_result VARCHAR2(30);
181: l_return_stat VARCHAR2(1);
182: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
183: l_old_Header_Rec OE_Order_Pub.Header_Rec_Type;
184: l_old_Hdr_Scr_Rec OE_Order_Pub.Header_Scredit_Rec_Type;
185: l_old_Hdr_Adj_Rec OE_Order_Pub.Header_Adj_Rec_Type;
186: l_old_Line_Adj_Rec OE_Order_Pub.Line_Adj_Rec_Type;
187: l_old_Line_Scr_Rec OE_Order_Pub.Line_Scredit_Rec_Type;

Line 184: l_old_Hdr_Scr_Rec OE_Order_Pub.Header_Scredit_Rec_Type;

180: l_result VARCHAR2(30);
181: l_return_stat VARCHAR2(1);
182: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
183: l_old_Header_Rec OE_Order_Pub.Header_Rec_Type;
184: l_old_Hdr_Scr_Rec OE_Order_Pub.Header_Scredit_Rec_Type;
185: l_old_Hdr_Adj_Rec OE_Order_Pub.Header_Adj_Rec_Type;
186: l_old_Line_Adj_Rec OE_Order_Pub.Line_Adj_Rec_Type;
187: l_old_Line_Scr_Rec OE_Order_Pub.Line_Scredit_Rec_Type;
188: l_old_Lot_Serial_Rec OE_Order_Pub.Lot_Serial_Rec_Type;

Line 185: l_old_Hdr_Adj_Rec OE_Order_Pub.Header_Adj_Rec_Type;

181: l_return_stat VARCHAR2(1);
182: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
183: l_old_Header_Rec OE_Order_Pub.Header_Rec_Type;
184: l_old_Hdr_Scr_Rec OE_Order_Pub.Header_Scredit_Rec_Type;
185: l_old_Hdr_Adj_Rec OE_Order_Pub.Header_Adj_Rec_Type;
186: l_old_Line_Adj_Rec OE_Order_Pub.Line_Adj_Rec_Type;
187: l_old_Line_Scr_Rec OE_Order_Pub.Line_Scredit_Rec_Type;
188: l_old_Lot_Serial_Rec OE_Order_Pub.Lot_Serial_Rec_Type;
189:

Line 186: l_old_Line_Adj_Rec OE_Order_Pub.Line_Adj_Rec_Type;

182: l_old_line_rec OE_Order_Pub.Line_Rec_Type;
183: l_old_Header_Rec OE_Order_Pub.Header_Rec_Type;
184: l_old_Hdr_Scr_Rec OE_Order_Pub.Header_Scredit_Rec_Type;
185: l_old_Hdr_Adj_Rec OE_Order_Pub.Header_Adj_Rec_Type;
186: l_old_Line_Adj_Rec OE_Order_Pub.Line_Adj_Rec_Type;
187: l_old_Line_Scr_Rec OE_Order_Pub.Line_Scredit_Rec_Type;
188: l_old_Lot_Serial_Rec OE_Order_Pub.Lot_Serial_Rec_Type;
189:
190: -- Begin Audit/Versioning Changes

Line 187: l_old_Line_Scr_Rec OE_Order_Pub.Line_Scredit_Rec_Type;

183: l_old_Header_Rec OE_Order_Pub.Header_Rec_Type;
184: l_old_Hdr_Scr_Rec OE_Order_Pub.Header_Scredit_Rec_Type;
185: l_old_Hdr_Adj_Rec OE_Order_Pub.Header_Adj_Rec_Type;
186: l_old_Line_Adj_Rec OE_Order_Pub.Line_Adj_Rec_Type;
187: l_old_Line_Scr_Rec OE_Order_Pub.Line_Scredit_Rec_Type;
188: l_old_Lot_Serial_Rec OE_Order_Pub.Lot_Serial_Rec_Type;
189:
190: -- Begin Audit/Versioning Changes
191: l_reason_existed BOOLEAN := FALSE;

Line 188: l_old_Lot_Serial_Rec OE_Order_Pub.Lot_Serial_Rec_Type;

184: l_old_Hdr_Scr_Rec OE_Order_Pub.Header_Scredit_Rec_Type;
185: l_old_Hdr_Adj_Rec OE_Order_Pub.Header_Adj_Rec_Type;
186: l_old_Line_Adj_Rec OE_Order_Pub.Line_Adj_Rec_Type;
187: l_old_Line_Scr_Rec OE_Order_Pub.Line_Scredit_Rec_Type;
188: l_old_Lot_Serial_Rec OE_Order_Pub.Lot_Serial_Rec_Type;
189:
190: -- Begin Audit/Versioning Changes
191: l_reason_existed BOOLEAN := FALSE;
192: l_change_reason VARCHAR2(30);