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