[Home] [Help]
PACKAGE BODY: APPS.CSI_SYSTEMS_H_PKG
Source
1 PACKAGE BODY csi_systems_h_pkg AS
2 /* $Header: csitsyhb.pls 115.13 2003/09/04 00:22:54 sguthiva ship $ */
3 -- start of comments
4 -- package name : csi_systems_h_pkg
5 -- purpose :
6 -- history :
7 -- note :
8 -- end of comments
9
10
11 g_pkg_name CONSTANT VARCHAR2(30):= 'csi_systems_h_pkg';
12 g_file_name CONSTANT VARCHAR2(12) := 'csitsyhb.pls';
13
14 PROCEDURE insert_row(
15 px_system_history_id IN OUT NOCOPY NUMBER,
16 p_system_id NUMBER,
17 p_transaction_id NUMBER,
18 p_old_customer_id NUMBER,
19 p_new_customer_id NUMBER,
20 p_old_system_type_code VARCHAR2,
21 p_new_system_type_code VARCHAR2,
22 p_old_system_number VARCHAR2,
23 p_new_system_number VARCHAR2,
24 p_old_parent_system_id NUMBER,
25 p_new_parent_system_id NUMBER,
26 p_old_ship_to_contact_id NUMBER,
27 p_new_ship_to_contact_id NUMBER,
28 p_old_bill_to_contact_id NUMBER,
29 p_new_bill_to_contact_id NUMBER,
30 p_old_technical_contact_id NUMBER,
31 p_new_technical_contact_id NUMBER,
32 p_old_service_admin_contact_id NUMBER,
33 p_new_service_admin_contact_id NUMBER,
34 p_old_ship_to_site_use_id NUMBER,
35 p_new_ship_to_site_use_id NUMBER,
36 p_old_install_site_use_id NUMBER,
37 p_new_install_site_use_id NUMBER,
38 p_old_bill_to_site_use_id NUMBER,
39 p_new_bill_to_site_use_id NUMBER,
40 p_old_coterminate_day_month VARCHAR2,
41 p_new_coterminate_day_month VARCHAR2,
42 p_old_start_date_active DATE,
43 p_new_start_date_active DATE,
44 p_old_end_date_active DATE,
45 p_new_end_date_active DATE,
46 p_old_autocreated_from_system NUMBER,
47 p_new_autocreated_from_system NUMBER,
48 p_old_config_system_type VARCHAR2,
49 p_new_config_system_type VARCHAR2,
50 p_old_context VARCHAR2,
51 p_new_context VARCHAR2,
52 p_old_attribute1 VARCHAR2,
53 p_new_attribute1 VARCHAR2,
54 p_old_attribute2 VARCHAR2,
55 p_new_attribute2 VARCHAR2,
56 p_old_attribute3 VARCHAR2,
57 p_new_attribute3 VARCHAR2,
58 p_old_attribute4 VARCHAR2,
59 p_new_attribute4 VARCHAR2,
60 p_old_attribute5 VARCHAR2,
61 p_new_attribute5 VARCHAR2,
62 p_old_attribute6 VARCHAR2,
63 p_new_attribute6 VARCHAR2,
64 p_old_attribute7 VARCHAR2,
65 p_new_attribute7 VARCHAR2,
66 p_old_attribute8 VARCHAR2,
67 p_new_attribute8 VARCHAR2,
68 p_old_attribute9 VARCHAR2,
69 p_new_attribute9 VARCHAR2,
70 p_old_attribute10 VARCHAR2,
71 p_new_attribute10 VARCHAR2,
72 p_old_attribute11 VARCHAR2,
73 p_new_attribute11 VARCHAR2,
74 p_old_attribute12 VARCHAR2,
75 p_new_attribute12 VARCHAR2,
76 p_old_attribute13 VARCHAR2,
77 p_new_attribute13 VARCHAR2,
78 p_old_attribute14 VARCHAR2,
79 p_new_attribute14 VARCHAR2,
80 p_old_attribute15 VARCHAR2,
81 p_new_attribute15 VARCHAR2,
82 p_full_dump_flag VARCHAR2,
83 p_created_by NUMBER,
84 p_creation_date DATE,
85 p_last_updated_by NUMBER,
86 p_last_update_date DATE,
87 p_last_update_login NUMBER,
88 p_object_version_number NUMBER,
89 p_old_name VARCHAR2,
90 p_new_name VARCHAR2,
91 p_old_description VARCHAR2,
92 p_new_description VARCHAR2,
93 p_old_operating_unit_id NUMBER,
94 p_new_operating_unit_id NUMBER)
95
96 IS
97 CURSOR c2 IS SELECT csi_systems_h_s.NEXTVAL FROM sys.dual;
98 BEGIN
99 IF (px_system_history_id IS NULL) OR (px_system_history_id = fnd_api.g_miss_num) THEN
100 OPEN c2;
101 FETCH c2 INTO px_system_history_id;
102 CLOSE c2;
103 END IF;
104 INSERT INTO csi_systems_h(
105 system_history_id,
106 system_id,
107 transaction_id,
108 old_customer_id,
109 new_customer_id,
110 old_system_type_code,
111 new_system_type_code,
112 old_system_number,
113 new_system_number,
114 old_parent_system_id,
115 new_parent_system_id,
116 old_ship_to_contact_id,
117 new_ship_to_contact_id,
118 old_bill_to_contact_id,
119 new_bill_to_contact_id,
120 old_technical_contact_id,
121 new_technical_contact_id,
122 old_service_admin_contact_id,
123 new_service_admin_contact_id,
124 old_ship_to_site_use_id,
125 new_ship_to_site_use_id,
126 old_install_site_use_id,
127 new_install_site_use_id,
128 old_bill_to_site_use_id,
129 new_bill_to_site_use_id,
130 old_coterminate_day_month,
131 new_coterminate_day_month,
132 old_start_date_active,
133 new_start_date_active,
134 old_end_date_active,
135 new_end_date_active,
136 old_autocreated_from_system,
137 new_autocreated_from_system,
138 old_config_system_type,
139 new_config_system_type,
140 old_context,
141 new_context,
142 old_attribute1,
143 new_attribute1,
144 old_attribute2,
145 new_attribute2,
146 old_attribute3,
147 new_attribute3,
148 old_attribute4,
149 new_attribute4,
150 old_attribute5,
151 new_attribute5,
152 old_attribute6,
153 new_attribute6,
154 old_attribute7,
155 new_attribute7,
156 old_attribute8,
157 new_attribute8,
158 old_attribute9,
159 new_attribute9,
160 old_attribute10,
161 new_attribute10,
162 old_attribute11,
163 new_attribute11,
164 old_attribute12,
165 new_attribute12,
166 old_attribute13,
167 new_attribute13,
168 old_attribute14,
169 new_attribute14,
170 old_attribute15,
171 new_attribute15,
172 full_dump_flag,
173 created_by,
174 creation_date,
175 last_updated_by,
176 last_update_date,
177 last_update_login,
178 object_version_number,
179 old_name,
180 new_name,
181 old_description,
182 new_description,
183 old_operating_unit_id,
184 new_operating_unit_id
185 ) VALUES (
186 px_system_history_id,
187 DECODE( p_system_id, fnd_api.g_miss_num, NULL, p_system_id),
188 DECODE( p_transaction_id, fnd_api.g_miss_num, NULL, p_transaction_id),
189 DECODE( p_old_customer_id, fnd_api.g_miss_num, NULL, p_old_customer_id),
190 DECODE( p_new_customer_id, fnd_api.g_miss_num, NULL, p_new_customer_id),
191 DECODE( p_old_system_type_code, fnd_api.g_miss_char, NULL, p_old_system_type_code),
192 DECODE( p_new_system_type_code, fnd_api.g_miss_char, NULL, p_new_system_type_code),
193 DECODE( p_old_system_number, fnd_api.g_miss_char, NULL, p_old_system_number),
194 DECODE( p_new_system_number, fnd_api.g_miss_char, NULL, p_new_system_number),
195 DECODE( p_old_parent_system_id, fnd_api.g_miss_num, NULL, p_old_parent_system_id),
196 DECODE( p_new_parent_system_id, fnd_api.g_miss_num, NULL, p_new_parent_system_id),
197 DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_old_ship_to_contact_id),
198 DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, NULL, p_new_ship_to_contact_id),
199 DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_old_bill_to_contact_id),
200 DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, NULL, p_new_bill_to_contact_id),
201 DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, NULL, p_old_technical_contact_id),
202 DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, NULL, p_new_technical_contact_id),
203 DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_old_service_admin_contact_id),
204 DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, NULL, p_new_service_admin_contact_id),
205 DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_ship_to_site_use_id),
206 DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_ship_to_site_use_id),
207 DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, NULL, p_old_install_site_use_id),
208 DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, NULL, p_new_install_site_use_id),
209 DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_old_bill_to_site_use_id),
210 DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, NULL, p_new_bill_to_site_use_id),
211 DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, NULL, p_old_coterminate_day_month),
212 DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, NULL, p_new_coterminate_day_month),
213 DECODE( p_old_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_start_date_active),
214 DECODE( p_new_start_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_start_date_active),
215 DECODE( p_old_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_old_end_date_active),
216 DECODE( p_new_end_date_active, fnd_api.g_miss_date, to_date(NULL), p_new_end_date_active),
217 DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, NULL, p_old_autocreated_from_system),
218 DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, NULL, p_new_autocreated_from_system),
219 DECODE( p_old_config_system_type, fnd_api.g_miss_char, NULL, p_old_config_system_type),
220 DECODE( p_new_config_system_type, fnd_api.g_miss_char, NULL, p_new_config_system_type),
221 DECODE( p_old_context, fnd_api.g_miss_char, NULL, p_old_context),
222 DECODE( p_new_context, fnd_api.g_miss_char, NULL, p_new_context),
223 DECODE( p_old_attribute1, fnd_api.g_miss_char, NULL, p_old_attribute1),
224 DECODE( p_new_attribute1, fnd_api.g_miss_char, NULL, p_new_attribute1),
225 DECODE( p_old_attribute2, fnd_api.g_miss_char, NULL, p_old_attribute2),
226 DECODE( p_new_attribute2, fnd_api.g_miss_char, NULL, p_new_attribute2),
227 DECODE( p_old_attribute3, fnd_api.g_miss_char, NULL, p_old_attribute3),
228 DECODE( p_new_attribute3, fnd_api.g_miss_char, NULL, p_new_attribute3),
229 DECODE( p_old_attribute4, fnd_api.g_miss_char, NULL, p_old_attribute4),
230 DECODE( p_new_attribute4, fnd_api.g_miss_char, NULL, p_new_attribute4),
231 DECODE( p_old_attribute5, fnd_api.g_miss_char, NULL, p_old_attribute5),
232 DECODE( p_new_attribute5, fnd_api.g_miss_char, NULL, p_new_attribute5),
233 DECODE( p_old_attribute6, fnd_api.g_miss_char, NULL, p_old_attribute6),
234 DECODE( p_new_attribute6, fnd_api.g_miss_char, NULL, p_new_attribute6),
235 DECODE( p_old_attribute7, fnd_api.g_miss_char, NULL, p_old_attribute7),
236 DECODE( p_new_attribute7, fnd_api.g_miss_char, NULL, p_new_attribute7),
237 DECODE( p_old_attribute8, fnd_api.g_miss_char, NULL, p_old_attribute8),
238 DECODE( p_new_attribute8, fnd_api.g_miss_char, NULL, p_new_attribute8),
239 DECODE( p_old_attribute9, fnd_api.g_miss_char, NULL, p_old_attribute9),
240 DECODE( p_new_attribute9, fnd_api.g_miss_char, NULL, p_new_attribute9),
241 DECODE( p_old_attribute10, fnd_api.g_miss_char, NULL, p_old_attribute10),
242 DECODE( p_new_attribute10, fnd_api.g_miss_char, NULL, p_new_attribute10),
243 DECODE( p_old_attribute11, fnd_api.g_miss_char, NULL, p_old_attribute11),
244 DECODE( p_new_attribute11, fnd_api.g_miss_char, NULL, p_new_attribute11),
245 DECODE( p_old_attribute12, fnd_api.g_miss_char, NULL, p_old_attribute12),
246 DECODE( p_new_attribute12, fnd_api.g_miss_char, NULL, p_new_attribute12),
247 DECODE( p_old_attribute13, fnd_api.g_miss_char, NULL, p_old_attribute13),
248 DECODE( p_new_attribute13, fnd_api.g_miss_char, NULL, p_new_attribute13),
249 DECODE( p_old_attribute14, fnd_api.g_miss_char, NULL, p_old_attribute14),
250 DECODE( p_new_attribute14, fnd_api.g_miss_char, NULL, p_new_attribute14),
251 DECODE( p_old_attribute15, fnd_api.g_miss_char, NULL, p_old_attribute15),
252 DECODE( p_new_attribute15, fnd_api.g_miss_char, NULL, p_new_attribute15),
253 DECODE( p_full_dump_flag, fnd_api.g_miss_char, NULL, p_full_dump_flag),
254 DECODE( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
255 DECODE( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
256 DECODE( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
257 DECODE( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
258 DECODE( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
259 DECODE( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number),
260 DECODE( p_old_name, fnd_api.g_miss_char, NULL, p_old_name),
261 DECODE( p_new_name, fnd_api.g_miss_char, NULL, p_new_name),
262 DECODE( p_old_description, fnd_api.g_miss_char, NULL, p_old_description),
263 DECODE( p_new_description, fnd_api.g_miss_char, NULL, p_new_description),
264 DECODE( p_old_operating_unit_id, fnd_api.g_miss_num, NULL, p_old_operating_unit_id),
265 DECODE( p_new_operating_unit_id, fnd_api.g_miss_num, NULL, p_new_operating_unit_id)
266 );
267 END insert_row;
268
269 PROCEDURE Update_Row(
270 p_system_history_id NUMBER ,
271 p_system_id NUMBER ,
272 p_transaction_id NUMBER ,
273 p_old_customer_id NUMBER ,
274 p_new_customer_id NUMBER ,
275 p_old_system_type_code VARCHAR2,
276 p_new_system_type_code VARCHAR2,
277 p_old_system_number VARCHAR2,
278 p_new_system_number VARCHAR2,
279 p_old_parent_system_id NUMBER ,
280 p_new_parent_system_id NUMBER ,
281 p_old_ship_to_contact_id NUMBER ,
282 p_new_ship_to_contact_id NUMBER ,
283 p_old_bill_to_contact_id NUMBER ,
284 p_new_bill_to_contact_id NUMBER ,
285 p_old_technical_contact_id NUMBER ,
286 p_new_technical_contact_id NUMBER ,
287 p_old_service_admin_contact_id NUMBER ,
288 p_new_service_admin_contact_id NUMBER ,
289 p_old_ship_to_site_use_id NUMBER ,
290 p_new_ship_to_site_use_id NUMBER ,
291 p_old_install_site_use_id NUMBER ,
292 p_new_install_site_use_id NUMBER ,
293 p_old_bill_to_site_use_id NUMBER ,
294 p_new_bill_to_site_use_id NUMBER ,
295 p_old_coterminate_day_month VARCHAR2,
296 p_new_coterminate_day_month VARCHAR2,
297 p_old_start_date_active DATE ,
298 p_new_start_date_active DATE ,
299 p_old_end_date_active DATE ,
300 p_new_end_date_active DATE ,
301 p_old_autocreated_from_system NUMBER ,
302 p_new_autocreated_from_system NUMBER ,
306 p_new_context VARCHAR2,
303 p_old_config_system_type VARCHAR2,
304 p_new_config_system_type VARCHAR2,
305 p_old_context VARCHAR2,
307 p_old_attribute1 VARCHAR2,
308 p_new_attribute1 VARCHAR2,
309 p_old_attribute2 VARCHAR2,
310 p_new_attribute2 VARCHAR2,
311 p_old_attribute3 VARCHAR2,
312 p_new_attribute3 VARCHAR2,
313 p_old_attribute4 VARCHAR2,
314 p_new_attribute4 VARCHAR2,
315 p_old_attribute5 VARCHAR2,
316 p_new_attribute5 VARCHAR2,
317 p_old_attribute6 VARCHAR2,
318 p_new_attribute6 VARCHAR2,
319 p_old_attribute7 VARCHAR2,
320 p_new_attribute7 VARCHAR2,
321 p_old_attribute8 VARCHAR2,
322 p_new_attribute8 VARCHAR2,
323 p_old_attribute9 VARCHAR2,
324 p_new_attribute9 VARCHAR2,
325 p_old_attribute10 VARCHAR2,
326 p_new_attribute10 VARCHAR2,
327 p_old_attribute11 VARCHAR2,
328 p_new_attribute11 VARCHAR2,
329 p_old_attribute12 VARCHAR2,
330 p_new_attribute12 VARCHAR2,
331 p_old_attribute13 VARCHAR2,
332 p_new_attribute13 VARCHAR2,
333 p_old_attribute14 VARCHAR2,
334 p_new_attribute14 VARCHAR2,
335 p_old_attribute15 VARCHAR2,
336 p_new_attribute15 VARCHAR2,
337 p_full_dump_flag VARCHAR2,
338 p_created_by NUMBER ,
339 p_creation_date DATE ,
340 p_last_updated_by NUMBER ,
341 p_last_update_date DATE ,
342 p_last_update_login NUMBER ,
343 p_object_version_number NUMBER ,
344 p_old_name VARCHAR2,
345 p_new_name VARCHAR2,
346 p_old_description VARCHAR2,
347 p_new_description VARCHAR2,
348 p_old_operating_unit_id NUMBER,
349 p_new_operating_unit_id NUMBER)
350 IS
351 BEGIN
352 Update csi_systems_h
353 SET
354 system_id = DECODE( p_system_id, fnd_api.g_miss_num, system_id, p_system_id),
355 transaction_id = DECODE( p_transaction_id, fnd_api.g_miss_num, transaction_id, p_transaction_id),
356 old_customer_id = DECODE( p_old_customer_id, fnd_api.g_miss_num, old_customer_id, p_old_customer_id),
357 new_customer_id = DECODE( p_new_customer_id, fnd_api.g_miss_num, new_customer_id, p_new_customer_id),
358 old_system_type_code = DECODE( p_old_system_type_code, fnd_api.g_miss_char, old_system_type_code, p_old_system_type_code),
359 new_system_type_code = DECODE( p_new_system_type_code, fnd_api.g_miss_char, new_system_type_code, p_new_system_type_code),
360 old_system_number = DECODE( p_old_system_number, fnd_api.g_miss_char, old_system_number, p_old_system_number),
361 new_system_number = DECODE( p_new_system_number, fnd_api.g_miss_char, new_system_number, p_new_system_number),
362 old_parent_system_id = DECODE( p_old_parent_system_id, fnd_api.g_miss_num, old_parent_system_id, p_old_parent_system_id),
363 new_parent_system_id = DECODE( p_new_parent_system_id, fnd_api.g_miss_num, new_parent_system_id, p_new_parent_system_id),
364 old_ship_to_contact_id = DECODE( p_old_ship_to_contact_id, fnd_api.g_miss_num, old_ship_to_contact_id, p_old_ship_to_contact_id),
365 new_ship_to_contact_id = DECODE( p_new_ship_to_contact_id, fnd_api.g_miss_num, new_ship_to_contact_id, p_new_ship_to_contact_id),
366 old_bill_to_contact_id = DECODE( p_old_bill_to_contact_id, fnd_api.g_miss_num, old_bill_to_contact_id, p_old_bill_to_contact_id),
367 new_bill_to_contact_id = DECODE( p_new_bill_to_contact_id, fnd_api.g_miss_num, new_bill_to_contact_id, p_new_bill_to_contact_id),
368 old_technical_contact_id = DECODE( p_old_technical_contact_id, fnd_api.g_miss_num, old_technical_contact_id, p_old_technical_contact_id),
369 new_technical_contact_id = DECODE( p_new_technical_contact_id, fnd_api.g_miss_num, new_technical_contact_id, p_new_technical_contact_id),
370 old_service_admin_contact_id = DECODE( p_old_service_admin_contact_id, fnd_api.g_miss_num, old_service_admin_contact_id, p_old_service_admin_contact_id),
371 new_service_admin_contact_id = DECODE( p_new_service_admin_contact_id, fnd_api.g_miss_num, new_service_admin_contact_id, p_new_service_admin_contact_id),
372 old_ship_to_site_use_id = DECODE( p_old_ship_to_site_use_id, fnd_api.g_miss_num, old_ship_to_site_use_id, p_old_ship_to_site_use_id),
373 new_ship_to_site_use_id = DECODE( p_new_ship_to_site_use_id, fnd_api.g_miss_num, new_ship_to_site_use_id, p_new_ship_to_site_use_id),
374 old_install_site_use_id = DECODE( p_old_install_site_use_id, fnd_api.g_miss_num, old_install_site_use_id, p_old_install_site_use_id),
375 new_install_site_use_id = DECODE( p_new_install_site_use_id, fnd_api.g_miss_num, new_install_site_use_id, p_new_install_site_use_id),
379 new_coterminate_day_month = DECODE( p_new_coterminate_day_month, fnd_api.g_miss_char, new_coterminate_day_month, p_new_coterminate_day_month),
376 old_bill_to_site_use_id = DECODE( p_old_bill_to_site_use_id, fnd_api.g_miss_num, old_bill_to_site_use_id, p_old_bill_to_site_use_id),
377 new_bill_to_site_use_id = DECODE( p_new_bill_to_site_use_id, fnd_api.g_miss_num, new_bill_to_site_use_id, p_new_bill_to_site_use_id),
378 old_coterminate_day_month = DECODE( p_old_coterminate_day_month, fnd_api.g_miss_char, old_coterminate_day_month, p_old_coterminate_day_month),
380 old_start_date_active = DECODE( p_old_start_date_active, fnd_api.g_miss_date, old_start_date_active, p_old_start_date_active),
381 new_start_date_active = DECODE( p_new_start_date_active, fnd_api.g_miss_date, new_start_date_active, p_new_start_date_active),
382 old_end_date_active = DECODE( p_old_end_date_active, fnd_api.g_miss_date, old_end_date_active, p_old_end_date_active),
383 new_end_date_active = DECODE( p_new_end_date_active, fnd_api.g_miss_date, new_end_date_active, p_new_end_date_active),
384 old_autocreated_from_system = DECODE( p_old_autocreated_from_system, fnd_api.g_miss_num, old_autocreated_from_system, p_old_autocreated_from_system),
385 new_autocreated_from_system = DECODE( p_new_autocreated_from_system, fnd_api.g_miss_num, new_autocreated_from_system, p_new_autocreated_from_system),
386 old_config_system_type = DECODE( p_old_config_system_type, fnd_api.g_miss_char, old_config_system_type, p_old_config_system_type),
387 new_config_system_type = DECODE( p_new_config_system_type, fnd_api.g_miss_char, new_config_system_type, p_new_config_system_type),
388 old_context = DECODE( p_old_context, fnd_api.g_miss_char, old_context, p_old_context),
389 new_context = DECODE( p_new_context, fnd_api.g_miss_char, new_context, p_new_context),
390 old_attribute1 = DECODE( p_old_attribute1, fnd_api.g_miss_char, old_attribute1, p_old_attribute1),
391 new_attribute1 = DECODE( p_new_attribute1, fnd_api.g_miss_char, new_attribute1, p_new_attribute1),
392 old_attribute2 = DECODE( p_old_attribute2, fnd_api.g_miss_char, old_attribute2, p_old_attribute2),
393 new_attribute2 = DECODE( p_new_attribute2, fnd_api.g_miss_char, new_attribute2, p_new_attribute2),
394 old_attribute3 = DECODE( p_old_attribute3, fnd_api.g_miss_char, old_attribute3, p_old_attribute3),
395 new_attribute3 = DECODE( p_new_attribute3, fnd_api.g_miss_char, new_attribute3, p_new_attribute3),
396 old_attribute4 = DECODE( p_old_attribute4, fnd_api.g_miss_char, old_attribute4, p_old_attribute4),
397 new_attribute4 = DECODE( p_new_attribute4, fnd_api.g_miss_char, new_attribute4, p_new_attribute4),
398 old_attribute5 = DECODE( p_old_attribute5, fnd_api.g_miss_char, old_attribute5, p_old_attribute5),
399 new_attribute5 = DECODE( p_new_attribute5, fnd_api.g_miss_char, new_attribute5, p_new_attribute5),
400 old_attribute6 = DECODE( p_old_attribute6, fnd_api.g_miss_char, old_attribute6, p_old_attribute6),
401 new_attribute6 = DECODE( p_new_attribute6, fnd_api.g_miss_char, new_attribute6, p_new_attribute6),
402 old_attribute7 = DECODE( p_old_attribute7, fnd_api.g_miss_char, old_attribute7, p_old_attribute7),
403 new_attribute7 = DECODE( p_new_attribute7, fnd_api.g_miss_char, new_attribute7, p_new_attribute7),
404 old_attribute8 = DECODE( p_old_attribute8, fnd_api.g_miss_char, old_attribute8, p_old_attribute8),
405 new_attribute8 = DECODE( p_new_attribute8, fnd_api.g_miss_char, new_attribute8, p_new_attribute8),
406 old_attribute9 = DECODE( p_old_attribute9, fnd_api.g_miss_char, old_attribute9, p_old_attribute9),
407 new_attribute9 = DECODE( p_new_attribute9, fnd_api.g_miss_char, new_attribute9, p_new_attribute9),
408 old_attribute10 = DECODE( p_old_attribute10, fnd_api.g_miss_char, old_attribute10, p_old_attribute10),
409 new_attribute10 = DECODE( p_new_attribute10, fnd_api.g_miss_char, new_attribute10, p_new_attribute10),
410 old_attribute11 = DECODE( p_old_attribute11, fnd_api.g_miss_char, old_attribute11, p_old_attribute11),
411 new_attribute11 = DECODE( p_new_attribute11, fnd_api.g_miss_char, new_attribute11, p_new_attribute11),
412 old_attribute12 = DECODE( p_old_attribute12, fnd_api.g_miss_char, old_attribute12, p_old_attribute12),
413 new_attribute12 = DECODE( p_new_attribute12, fnd_api.g_miss_char, new_attribute12, p_new_attribute12),
414 old_attribute13 = DECODE( p_old_attribute13, fnd_api.g_miss_char, old_attribute13, p_old_attribute13),
415 new_attribute13 = DECODE( p_new_attribute13, fnd_api.g_miss_char, new_attribute13, p_new_attribute13),
416 old_attribute14 = DECODE( p_old_attribute14, fnd_api.g_miss_char, old_attribute14, p_old_attribute14),
417 new_attribute14 = DECODE( p_new_attribute14, fnd_api.g_miss_char, new_attribute14, p_new_attribute14),
418 old_attribute15 = DECODE( p_old_attribute15, fnd_api.g_miss_char, old_attribute15, p_old_attribute15),
419 new_attribute15 = DECODE( p_new_attribute15, fnd_api.g_miss_char, new_attribute15, p_new_attribute15),
420 full_dump_flag = DECODE( p_full_dump_flag, fnd_api.g_miss_char, full_dump_flag, p_full_dump_flag),
421 created_by = DECODE( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
422 creation_date = DECODE( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
423 last_updated_by = DECODE( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
424 last_update_date = DECODE( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
425 last_update_login = DECODE( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
426 --object_version_number = DECODE( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number),
427 object_version_number = object_version_number + 1,
428 old_name = DECODE( p_old_name, fnd_api.g_miss_char, old_name, p_old_name),
429 new_name = DECODE( p_new_name, fnd_api.g_miss_char, new_name, p_new_name),
430 old_description = DECODE( p_old_description, fnd_api.g_miss_char, old_description, p_old_description),
431 new_description = DECODE( p_new_description, fnd_api.g_miss_char, new_description, p_new_description),
432 old_operating_unit_id = DECODE(p_old_operating_unit_id,fnd_api.g_miss_num,old_operating_unit_id,p_old_operating_unit_id),
433 new_operating_unit_id = DECODE(p_new_operating_unit_id,fnd_api.g_miss_num,new_operating_unit_id,p_new_operating_unit_id)
434 WHERE system_history_id = p_system_history_id;
435
436 IF (SQL%NOTFOUND) THEN
437 RAISE NO_DATA_FOUND;
438 END IF;
439 END Update_Row;
440
441
442
443
444 END csi_systems_h_pkg;