[Home] [Help]
PACKAGE BODY: APPS.CUG_SR_TYPE_ATTR_MAPS_PKG_W
Source
1 package body cug_sr_type_attr_maps_pkg_w as
2 /* $Header: CUGSRTYB.pls 115.6 2004/03/29 21:44:16 aneemuch ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 procedure insert_row(x_rowid in out nocopy VARCHAR2
14 , x_sr_type_attr_map_id NUMBER
15 , x_sr_type_attr_seq_num NUMBER
16 , x_object_version_number NUMBER
17 , x_incident_type_id NUMBER
18 , x_sr_attribute_code VARCHAR2
19 , x_sr_attr_mandatory_flag VARCHAR2
20 , x_sr_attr_displayed_flag VARCHAR2
21 , x_sr_attr_dup_check_flag VARCHAR2
22 , x_sr_attribute_list_name VARCHAR2
23 , x_attribute1 VARCHAR2
24 , x_attribute2 VARCHAR2
25 , x_attribute3 VARCHAR2
26 , x_attribute4 VARCHAR2
27 , x_attribute5 VARCHAR2
28 , x_attribute6 VARCHAR2
29 , x_attribute7 VARCHAR2
30 , x_attribute8 VARCHAR2
31 , x_attribute9 VARCHAR2
32 , x_attribute10 VARCHAR2
33 , x_attribute11 VARCHAR2
34 , x_attribute12 VARCHAR2
35 , x_attribute13 VARCHAR2
36 , x_attribute14 VARCHAR2
37 , x_attribute15 VARCHAR2
38 , x_attribute_category VARCHAR2
39 , x_start_date_active date
40 , x_end_date_active date
41 , x_security_group_id NUMBER
42 , x_template_id NUMBER
43 , x_reqd_for_close_flag VARCHAR2
44 , x_show_on_update_flag VARCHAR2
45 , x_update_allowed_flag VARCHAR2
46 , x_sr_attr_default_value VARCHAR2
47 , x_creation_date date
48 , x_created_by NUMBER
49 , x_last_update_date date
50 , x_last_updated_by NUMBER
51 , x_last_update_login NUMBER
52 )
53
54 as
55 ddx_start_date_active date;
56 ddx_end_date_active date;
57 ddx_creation_date date;
58 ddx_last_update_date date;
59 ddindx binary_integer; indx binary_integer;
60 begin
61
62 -- copy data to the local IN or IN-OUT args, if any
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89 ddx_start_date_active := rosetta_g_miss_date_in_map(x_start_date_active);
90
91 ddx_end_date_active := rosetta_g_miss_date_in_map(x_end_date_active);
92
93
94
95
96
97
98
99 ddx_creation_date := rosetta_g_miss_date_in_map(x_creation_date);
100
101
102 ddx_last_update_date := rosetta_g_miss_date_in_map(x_last_update_date);
103
104
105
106 -- here's the delegated call to the old PL/SQL routine
107 cug_sr_type_attr_maps_pkg.insert_row(x_rowid,
108 x_sr_type_attr_map_id,
109 x_sr_type_attr_seq_num,
110 x_object_version_number,
111 x_incident_type_id,
112 x_sr_attribute_code,
113 x_sr_attr_mandatory_flag,
114 x_sr_attr_displayed_flag,
115 x_sr_attr_dup_check_flag,
116 x_sr_attribute_list_name,
117 x_attribute1,
118 x_attribute2,
119 x_attribute3,
120 x_attribute4,
121 x_attribute5,
122 x_attribute6,
123 x_attribute7,
124 x_attribute8,
125 x_attribute9,
126 x_attribute10,
127 x_attribute11,
128 x_attribute12,
129 x_attribute13,
130 x_attribute14,
131 x_attribute15,
132 x_attribute_category,
133 ddx_start_date_active,
134 ddx_end_date_active,
135 x_security_group_id,
136 x_template_id,
137 x_reqd_for_close_flag,
138 x_show_on_update_flag,
139 x_update_allowed_flag,
140 x_sr_attr_default_value,
141 ddx_creation_date,
142 x_created_by,
143 ddx_last_update_date,
144 x_last_updated_by,
145 x_last_update_login);
146
147 -- copy data back from the local variables to OUT or IN-OUT args, if any
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186 end;
187
188 procedure lock_row(x_sr_type_attr_map_id NUMBER
189 , x_sr_type_attr_seq_num NUMBER
190 , x_object_version_number NUMBER
191 , x_incident_type_id NUMBER
192 , x_sr_attribute_code VARCHAR2
193 , x_sr_attr_mandatory_flag VARCHAR2
194 , x_sr_attr_displayed_flag VARCHAR2
195 , x_sr_attr_dup_check_flag VARCHAR2
196 , x_sr_attribute_list_name VARCHAR2
197 , x_attribute1 VARCHAR2
198 , x_attribute2 VARCHAR2
199 , x_attribute3 VARCHAR2
200 , x_attribute4 VARCHAR2
201 , x_attribute5 VARCHAR2
202 , x_attribute6 VARCHAR2
203 , x_attribute7 VARCHAR2
204 , x_attribute8 VARCHAR2
205 , x_attribute9 VARCHAR2
206 , x_attribute10 VARCHAR2
207 , x_attribute11 VARCHAR2
208 , x_attribute12 VARCHAR2
209 , x_attribute13 VARCHAR2
210 , x_attribute14 VARCHAR2
211 , x_attribute15 VARCHAR2
212 , x_attribute_category VARCHAR2
213 , x_start_date_active date
214 , x_end_date_active date
215 , x_security_group_id NUMBER
216 , x_template_id NUMBER
217 , x_reqd_for_close_flag VARCHAR2
218 , x_show_on_update_flag VARCHAR2
219 , x_update_allowed_flag VARCHAR2
220 , x_sr_attr_default_value VARCHAR2
221 )
222
223 as
224 ddx_start_date_active date;
225 ddx_end_date_active date;
226 ddindx binary_integer; indx binary_integer;
227 begin
228
229 -- copy data to the local IN or IN-OUT args, if any
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255 ddx_start_date_active := rosetta_g_miss_date_in_map(x_start_date_active);
256
257 ddx_end_date_active := rosetta_g_miss_date_in_map(x_end_date_active);
258
259
260
261
262
263
264
265 -- here's the delegated call to the old PL/SQL routine
266 cug_sr_type_attr_maps_pkg.lock_row(x_sr_type_attr_map_id,
267 x_sr_type_attr_seq_num,
268 x_object_version_number,
269 x_incident_type_id,
270 x_sr_attribute_code,
271 x_sr_attr_mandatory_flag,
272 x_sr_attr_displayed_flag,
273 x_sr_attr_dup_check_flag,
274 x_sr_attribute_list_name,
275 x_attribute1,
276 x_attribute2,
277 x_attribute3,
278 x_attribute4,
279 x_attribute5,
280 x_attribute6,
281 x_attribute7,
282 x_attribute8,
283 x_attribute9,
284 x_attribute10,
285 x_attribute11,
286 x_attribute12,
287 x_attribute13,
288 x_attribute14,
289 x_attribute15,
290 x_attribute_category,
291 ddx_start_date_active,
292 ddx_end_date_active,
293 x_security_group_id,
294 x_template_id,
295 x_reqd_for_close_flag,
296 x_show_on_update_flag,
297 x_update_allowed_flag,
298 x_sr_attr_default_value);
299
300 -- copy data back from the local variables to OUT or IN-OUT args, if any
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333 end;
334
335 procedure update_row(x_sr_type_attr_map_id NUMBER
336 , x_sr_type_attr_seq_num NUMBER
337 , x_object_version_number NUMBER
338 , x_incident_type_id NUMBER
339 , x_sr_attribute_code VARCHAR2
340 , x_sr_attr_mandatory_flag VARCHAR2
341 , x_sr_attr_displayed_flag VARCHAR2
342 , x_sr_attr_dup_check_flag VARCHAR2
343 , x_sr_attribute_list_name VARCHAR2
344 , x_attribute1 VARCHAR2
345 , x_attribute2 VARCHAR2
346 , x_attribute3 VARCHAR2
347 , x_attribute4 VARCHAR2
348 , x_attribute5 VARCHAR2
349 , x_attribute6 VARCHAR2
350 , x_attribute7 VARCHAR2
351 , x_attribute8 VARCHAR2
352 , x_attribute9 VARCHAR2
353 , x_attribute10 VARCHAR2
354 , x_attribute11 VARCHAR2
355 , x_attribute12 VARCHAR2
356 , x_attribute13 VARCHAR2
357 , x_attribute14 VARCHAR2
358 , x_attribute15 VARCHAR2
359 , x_attribute_category VARCHAR2
360 , x_start_date_active date
361 , x_end_date_active date
362 , x_security_group_id NUMBER
363 , x_template_id NUMBER
364 , x_reqd_for_close_flag VARCHAR2
365 , x_show_on_update_flag VARCHAR2
366 , x_update_allowed_flag VARCHAR2
367 , x_sr_attr_default_value VARCHAR2
368 , x_last_update_date date
369 , x_last_updated_by NUMBER
370 , x_last_update_login NUMBER
371 )
372
373 as
374 ddx_start_date_active date;
375 ddx_end_date_active date;
376 ddx_last_update_date date;
377 ddindx binary_integer; indx binary_integer;
378 begin
379
380 -- copy data to the local IN or IN-OUT args, if any
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406 ddx_start_date_active := rosetta_g_miss_date_in_map(x_start_date_active);
407
408 ddx_end_date_active := rosetta_g_miss_date_in_map(x_end_date_active);
409
410
411
412
413
414
415
416 ddx_last_update_date := rosetta_g_miss_date_in_map(x_last_update_date);
417
418
419
420 -- here's the delegated call to the old PL/SQL routine
421 cug_sr_type_attr_maps_pkg.update_row(x_sr_type_attr_map_id,
422 x_sr_type_attr_seq_num,
423 x_object_version_number,
424 x_incident_type_id,
425 x_sr_attribute_code,
426 x_sr_attr_mandatory_flag,
427 x_sr_attr_displayed_flag,
428 x_sr_attr_dup_check_flag,
429 x_sr_attribute_list_name,
430 x_attribute1,
431 x_attribute2,
432 x_attribute3,
433 x_attribute4,
434 x_attribute5,
435 x_attribute6,
436 x_attribute7,
437 x_attribute8,
438 x_attribute9,
439 x_attribute10,
440 x_attribute11,
441 x_attribute12,
442 x_attribute13,
443 x_attribute14,
444 x_attribute15,
445 x_attribute_category,
446 ddx_start_date_active,
447 ddx_end_date_active,
448 x_security_group_id,
449 x_template_id,
450 x_reqd_for_close_flag,
451 x_show_on_update_flag,
452 x_update_allowed_flag,
453 x_sr_attr_default_value,
454 ddx_last_update_date,
455 x_last_updated_by,
456 x_last_update_login);
457
458 -- copy data back from the local variables to OUT or IN-OUT args, if any
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494 end;
495
496 procedure load_row(x_sr_type_attr_map_id NUMBER
497 , x_incident_type_id NUMBER
498 , x_sr_attribute_code VARCHAR2
499 , x_sr_attr_mandatory_flag VARCHAR2
500 , x_sr_attr_displayed_flag VARCHAR2
501 , x_sr_attr_dup_check_flag VARCHAR2
502 , x_sr_attribute_list_name VARCHAR2
503 , x_start_date_active date
504 , x_end_date_active date
505 , x_sr_attr_default_value VARCHAR2
506 , x_template_id NUMBER
507 , x_reqd_for_close_flag VARCHAR2
508 , x_show_on_update_flag VARCHAR2
509 , x_update_allowed_flag VARCHAR2
510 , x_sr_type_attr_seq_num NUMBER
511 , x_security_group_id NUMBER
512 , x_creation_date VARCHAR2
513 , x_created_by NUMBER
514 , x_last_update_date VARCHAR2
515 , x_last_updated_by NUMBER
516 , x_last_update_login NUMBER
517 , x_owner VARCHAR2
518 )
519
520 as
521 ddx_start_date_active date;
522 ddx_end_date_active date;
523 ddindx binary_integer; indx binary_integer;
524 begin
525
526 -- copy data to the local IN or IN-OUT args, if any
527
528
529
530
531
532
533
534 ddx_start_date_active := rosetta_g_miss_date_in_map(x_start_date_active);
535
536 ddx_end_date_active := rosetta_g_miss_date_in_map(x_end_date_active);
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551 -- here's the delegated call to the old PL/SQL routine
552 cug_sr_type_attr_maps_pkg.load_row(x_sr_type_attr_map_id,
553 x_incident_type_id,
554 x_sr_attribute_code,
555 x_sr_attr_mandatory_flag,
556 x_sr_attr_displayed_flag,
557 x_sr_attr_dup_check_flag,
558 x_sr_attribute_list_name,
559 ddx_start_date_active,
560 ddx_end_date_active,
561 x_sr_attr_default_value,
562 x_template_id,
563 x_reqd_for_close_flag,
564 x_show_on_update_flag,
565 x_update_allowed_flag,
566 x_sr_type_attr_seq_num,
567 x_security_group_id,
568 x_creation_date,
569 x_created_by,
570 x_last_update_date,
571 x_last_updated_by,
572 x_last_update_login,
573 x_owner);
574
575 -- copy data back from the local variables to OUT or IN-OUT args, if any
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597 end;
598
599 end cug_sr_type_attr_maps_pkg_w;