49: --
50: -- {end Of Comments}
51: -- --------------------------------------------------------------------------
52: procedure update_dml
53: (p_rec in out nocopy hxc_tat_shd.g_rec_type
54: ) is
55:
56: l_proc varchar2(72) ;
57:
113: end if;
114:
115: exception
116: when hr_api.check_integrity_violated then
117: hxc_tat_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: when hr_api.parent_integrity_violated then
120: hxc_tat_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: when hr_api.check_integrity_violated then
117: hxc_tat_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: when hr_api.parent_integrity_violated then
120: hxc_tat_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: when hr_api.unique_integrity_violated then
123: hxc_tat_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: when hr_api.parent_integrity_violated then
120: hxc_tat_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: when hr_api.unique_integrity_violated then
123: hxc_tat_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: when others then
126: raise;
127:
159: --
160: -- {end Of Comments}
161: -- --------------------------------------------------------------------------
162: procedure pre_update
163: (p_rec in hxc_tat_shd.g_rec_type
164: ) is
165:
166: l_proc varchar2(72) ;
167:
208: -- {end Of Comments}
209: -- --------------------------------------------------------------------------
210: procedure post_update
211: (p_effective_date in date
212: ,p_rec in hxc_tat_shd.g_rec_type
213: ) is
214:
215: l_proc varchar2(72) ;
216:
294: => p_rec.attribute30
295: ,p_bld_blk_info_type_id
296: => p_rec.bld_blk_info_type_id
297: ,p_object_version_number_o
298: => hxc_tat_shd.g_old_rec.object_version_number
299: ,p_attribute_category_o
300: => hxc_tat_shd.g_old_rec.attribute_category
301: ,p_attribute1_o
302: => hxc_tat_shd.g_old_rec.attribute1
296: => p_rec.bld_blk_info_type_id
297: ,p_object_version_number_o
298: => hxc_tat_shd.g_old_rec.object_version_number
299: ,p_attribute_category_o
300: => hxc_tat_shd.g_old_rec.attribute_category
301: ,p_attribute1_o
302: => hxc_tat_shd.g_old_rec.attribute1
303: ,p_attribute2_o
304: => hxc_tat_shd.g_old_rec.attribute2
298: => hxc_tat_shd.g_old_rec.object_version_number
299: ,p_attribute_category_o
300: => hxc_tat_shd.g_old_rec.attribute_category
301: ,p_attribute1_o
302: => hxc_tat_shd.g_old_rec.attribute1
303: ,p_attribute2_o
304: => hxc_tat_shd.g_old_rec.attribute2
305: ,p_attribute3_o
306: => hxc_tat_shd.g_old_rec.attribute3
300: => hxc_tat_shd.g_old_rec.attribute_category
301: ,p_attribute1_o
302: => hxc_tat_shd.g_old_rec.attribute1
303: ,p_attribute2_o
304: => hxc_tat_shd.g_old_rec.attribute2
305: ,p_attribute3_o
306: => hxc_tat_shd.g_old_rec.attribute3
307: ,p_attribute4_o
308: => hxc_tat_shd.g_old_rec.attribute4
302: => hxc_tat_shd.g_old_rec.attribute1
303: ,p_attribute2_o
304: => hxc_tat_shd.g_old_rec.attribute2
305: ,p_attribute3_o
306: => hxc_tat_shd.g_old_rec.attribute3
307: ,p_attribute4_o
308: => hxc_tat_shd.g_old_rec.attribute4
309: ,p_attribute5_o
310: => hxc_tat_shd.g_old_rec.attribute5
304: => hxc_tat_shd.g_old_rec.attribute2
305: ,p_attribute3_o
306: => hxc_tat_shd.g_old_rec.attribute3
307: ,p_attribute4_o
308: => hxc_tat_shd.g_old_rec.attribute4
309: ,p_attribute5_o
310: => hxc_tat_shd.g_old_rec.attribute5
311: ,p_attribute6_o
312: => hxc_tat_shd.g_old_rec.attribute6
306: => hxc_tat_shd.g_old_rec.attribute3
307: ,p_attribute4_o
308: => hxc_tat_shd.g_old_rec.attribute4
309: ,p_attribute5_o
310: => hxc_tat_shd.g_old_rec.attribute5
311: ,p_attribute6_o
312: => hxc_tat_shd.g_old_rec.attribute6
313: ,p_attribute7_o
314: => hxc_tat_shd.g_old_rec.attribute7
308: => hxc_tat_shd.g_old_rec.attribute4
309: ,p_attribute5_o
310: => hxc_tat_shd.g_old_rec.attribute5
311: ,p_attribute6_o
312: => hxc_tat_shd.g_old_rec.attribute6
313: ,p_attribute7_o
314: => hxc_tat_shd.g_old_rec.attribute7
315: ,p_attribute8_o
316: => hxc_tat_shd.g_old_rec.attribute8
310: => hxc_tat_shd.g_old_rec.attribute5
311: ,p_attribute6_o
312: => hxc_tat_shd.g_old_rec.attribute6
313: ,p_attribute7_o
314: => hxc_tat_shd.g_old_rec.attribute7
315: ,p_attribute8_o
316: => hxc_tat_shd.g_old_rec.attribute8
317: ,p_attribute9_o
318: => hxc_tat_shd.g_old_rec.attribute9
312: => hxc_tat_shd.g_old_rec.attribute6
313: ,p_attribute7_o
314: => hxc_tat_shd.g_old_rec.attribute7
315: ,p_attribute8_o
316: => hxc_tat_shd.g_old_rec.attribute8
317: ,p_attribute9_o
318: => hxc_tat_shd.g_old_rec.attribute9
319: ,p_attribute10_o
320: => hxc_tat_shd.g_old_rec.attribute10
314: => hxc_tat_shd.g_old_rec.attribute7
315: ,p_attribute8_o
316: => hxc_tat_shd.g_old_rec.attribute8
317: ,p_attribute9_o
318: => hxc_tat_shd.g_old_rec.attribute9
319: ,p_attribute10_o
320: => hxc_tat_shd.g_old_rec.attribute10
321: ,p_attribute11_o
322: => hxc_tat_shd.g_old_rec.attribute11
316: => hxc_tat_shd.g_old_rec.attribute8
317: ,p_attribute9_o
318: => hxc_tat_shd.g_old_rec.attribute9
319: ,p_attribute10_o
320: => hxc_tat_shd.g_old_rec.attribute10
321: ,p_attribute11_o
322: => hxc_tat_shd.g_old_rec.attribute11
323: ,p_attribute12_o
324: => hxc_tat_shd.g_old_rec.attribute12
318: => hxc_tat_shd.g_old_rec.attribute9
319: ,p_attribute10_o
320: => hxc_tat_shd.g_old_rec.attribute10
321: ,p_attribute11_o
322: => hxc_tat_shd.g_old_rec.attribute11
323: ,p_attribute12_o
324: => hxc_tat_shd.g_old_rec.attribute12
325: ,p_attribute13_o
326: => hxc_tat_shd.g_old_rec.attribute13
320: => hxc_tat_shd.g_old_rec.attribute10
321: ,p_attribute11_o
322: => hxc_tat_shd.g_old_rec.attribute11
323: ,p_attribute12_o
324: => hxc_tat_shd.g_old_rec.attribute12
325: ,p_attribute13_o
326: => hxc_tat_shd.g_old_rec.attribute13
327: ,p_attribute14_o
328: => hxc_tat_shd.g_old_rec.attribute14
322: => hxc_tat_shd.g_old_rec.attribute11
323: ,p_attribute12_o
324: => hxc_tat_shd.g_old_rec.attribute12
325: ,p_attribute13_o
326: => hxc_tat_shd.g_old_rec.attribute13
327: ,p_attribute14_o
328: => hxc_tat_shd.g_old_rec.attribute14
329: ,p_attribute15_o
330: => hxc_tat_shd.g_old_rec.attribute15
324: => hxc_tat_shd.g_old_rec.attribute12
325: ,p_attribute13_o
326: => hxc_tat_shd.g_old_rec.attribute13
327: ,p_attribute14_o
328: => hxc_tat_shd.g_old_rec.attribute14
329: ,p_attribute15_o
330: => hxc_tat_shd.g_old_rec.attribute15
331: ,p_attribute16_o
332: => hxc_tat_shd.g_old_rec.attribute16
326: => hxc_tat_shd.g_old_rec.attribute13
327: ,p_attribute14_o
328: => hxc_tat_shd.g_old_rec.attribute14
329: ,p_attribute15_o
330: => hxc_tat_shd.g_old_rec.attribute15
331: ,p_attribute16_o
332: => hxc_tat_shd.g_old_rec.attribute16
333: ,p_attribute17_o
334: => hxc_tat_shd.g_old_rec.attribute17
328: => hxc_tat_shd.g_old_rec.attribute14
329: ,p_attribute15_o
330: => hxc_tat_shd.g_old_rec.attribute15
331: ,p_attribute16_o
332: => hxc_tat_shd.g_old_rec.attribute16
333: ,p_attribute17_o
334: => hxc_tat_shd.g_old_rec.attribute17
335: ,p_attribute18_o
336: => hxc_tat_shd.g_old_rec.attribute18
330: => hxc_tat_shd.g_old_rec.attribute15
331: ,p_attribute16_o
332: => hxc_tat_shd.g_old_rec.attribute16
333: ,p_attribute17_o
334: => hxc_tat_shd.g_old_rec.attribute17
335: ,p_attribute18_o
336: => hxc_tat_shd.g_old_rec.attribute18
337: ,p_attribute19_o
338: => hxc_tat_shd.g_old_rec.attribute19
332: => hxc_tat_shd.g_old_rec.attribute16
333: ,p_attribute17_o
334: => hxc_tat_shd.g_old_rec.attribute17
335: ,p_attribute18_o
336: => hxc_tat_shd.g_old_rec.attribute18
337: ,p_attribute19_o
338: => hxc_tat_shd.g_old_rec.attribute19
339: ,p_attribute20_o
340: => hxc_tat_shd.g_old_rec.attribute20
334: => hxc_tat_shd.g_old_rec.attribute17
335: ,p_attribute18_o
336: => hxc_tat_shd.g_old_rec.attribute18
337: ,p_attribute19_o
338: => hxc_tat_shd.g_old_rec.attribute19
339: ,p_attribute20_o
340: => hxc_tat_shd.g_old_rec.attribute20
341: ,p_attribute21_o
342: => hxc_tat_shd.g_old_rec.attribute21
336: => hxc_tat_shd.g_old_rec.attribute18
337: ,p_attribute19_o
338: => hxc_tat_shd.g_old_rec.attribute19
339: ,p_attribute20_o
340: => hxc_tat_shd.g_old_rec.attribute20
341: ,p_attribute21_o
342: => hxc_tat_shd.g_old_rec.attribute21
343: ,p_attribute22_o
344: => hxc_tat_shd.g_old_rec.attribute22
338: => hxc_tat_shd.g_old_rec.attribute19
339: ,p_attribute20_o
340: => hxc_tat_shd.g_old_rec.attribute20
341: ,p_attribute21_o
342: => hxc_tat_shd.g_old_rec.attribute21
343: ,p_attribute22_o
344: => hxc_tat_shd.g_old_rec.attribute22
345: ,p_attribute23_o
346: => hxc_tat_shd.g_old_rec.attribute23
340: => hxc_tat_shd.g_old_rec.attribute20
341: ,p_attribute21_o
342: => hxc_tat_shd.g_old_rec.attribute21
343: ,p_attribute22_o
344: => hxc_tat_shd.g_old_rec.attribute22
345: ,p_attribute23_o
346: => hxc_tat_shd.g_old_rec.attribute23
347: ,p_attribute24_o
348: => hxc_tat_shd.g_old_rec.attribute24
342: => hxc_tat_shd.g_old_rec.attribute21
343: ,p_attribute22_o
344: => hxc_tat_shd.g_old_rec.attribute22
345: ,p_attribute23_o
346: => hxc_tat_shd.g_old_rec.attribute23
347: ,p_attribute24_o
348: => hxc_tat_shd.g_old_rec.attribute24
349: ,p_attribute25_o
350: => hxc_tat_shd.g_old_rec.attribute25
344: => hxc_tat_shd.g_old_rec.attribute22
345: ,p_attribute23_o
346: => hxc_tat_shd.g_old_rec.attribute23
347: ,p_attribute24_o
348: => hxc_tat_shd.g_old_rec.attribute24
349: ,p_attribute25_o
350: => hxc_tat_shd.g_old_rec.attribute25
351: ,p_attribute26_o
352: => hxc_tat_shd.g_old_rec.attribute26
346: => hxc_tat_shd.g_old_rec.attribute23
347: ,p_attribute24_o
348: => hxc_tat_shd.g_old_rec.attribute24
349: ,p_attribute25_o
350: => hxc_tat_shd.g_old_rec.attribute25
351: ,p_attribute26_o
352: => hxc_tat_shd.g_old_rec.attribute26
353: ,p_attribute27_o
354: => hxc_tat_shd.g_old_rec.attribute27
348: => hxc_tat_shd.g_old_rec.attribute24
349: ,p_attribute25_o
350: => hxc_tat_shd.g_old_rec.attribute25
351: ,p_attribute26_o
352: => hxc_tat_shd.g_old_rec.attribute26
353: ,p_attribute27_o
354: => hxc_tat_shd.g_old_rec.attribute27
355: ,p_attribute28_o
356: => hxc_tat_shd.g_old_rec.attribute28
350: => hxc_tat_shd.g_old_rec.attribute25
351: ,p_attribute26_o
352: => hxc_tat_shd.g_old_rec.attribute26
353: ,p_attribute27_o
354: => hxc_tat_shd.g_old_rec.attribute27
355: ,p_attribute28_o
356: => hxc_tat_shd.g_old_rec.attribute28
357: ,p_attribute29_o
358: => hxc_tat_shd.g_old_rec.attribute29
352: => hxc_tat_shd.g_old_rec.attribute26
353: ,p_attribute27_o
354: => hxc_tat_shd.g_old_rec.attribute27
355: ,p_attribute28_o
356: => hxc_tat_shd.g_old_rec.attribute28
357: ,p_attribute29_o
358: => hxc_tat_shd.g_old_rec.attribute29
359: ,p_attribute30_o
360: => hxc_tat_shd.g_old_rec.attribute30
354: => hxc_tat_shd.g_old_rec.attribute27
355: ,p_attribute28_o
356: => hxc_tat_shd.g_old_rec.attribute28
357: ,p_attribute29_o
358: => hxc_tat_shd.g_old_rec.attribute29
359: ,p_attribute30_o
360: => hxc_tat_shd.g_old_rec.attribute30
361: ,p_bld_blk_info_type_id_o
362: => hxc_tat_shd.g_old_rec.bld_blk_info_type_id
356: => hxc_tat_shd.g_old_rec.attribute28
357: ,p_attribute29_o
358: => hxc_tat_shd.g_old_rec.attribute29
359: ,p_attribute30_o
360: => hxc_tat_shd.g_old_rec.attribute30
361: ,p_bld_blk_info_type_id_o
362: => hxc_tat_shd.g_old_rec.bld_blk_info_type_id
363: );
364:
358: => hxc_tat_shd.g_old_rec.attribute29
359: ,p_attribute30_o
360: => hxc_tat_shd.g_old_rec.attribute30
361: ,p_bld_blk_info_type_id_o
362: => hxc_tat_shd.g_old_rec.bld_blk_info_type_id
363: );
364:
365: exception
366:
419: --
420: -- {end Of Comments}
421: -- --------------------------------------------------------------------------
422: procedure convert_defs
423: (p_rec in out nocopy hxc_tat_shd.g_rec_type
424: ) is
425:
426: begin
427:
430: -- default is being used then we must set to the 'current' argument value.
431:
432: if (p_rec.attribute_category = hr_api.g_varchar2) then
433: p_rec.attribute_category :=
434: hxc_tat_shd.g_old_rec.attribute_category;
435: end if;
436:
437: if (p_rec.attribute1 = hr_api.g_varchar2) then
438: p_rec.attribute1 :=
435: end if;
436:
437: if (p_rec.attribute1 = hr_api.g_varchar2) then
438: p_rec.attribute1 :=
439: hxc_tat_shd.g_old_rec.attribute1;
440: end if;
441:
442: if (p_rec.attribute2 = hr_api.g_varchar2) then
443: p_rec.attribute2 :=
440: end if;
441:
442: if (p_rec.attribute2 = hr_api.g_varchar2) then
443: p_rec.attribute2 :=
444: hxc_tat_shd.g_old_rec.attribute2;
445: end if;
446:
447: if (p_rec.attribute3 = hr_api.g_varchar2) then
448: p_rec.attribute3 :=
445: end if;
446:
447: if (p_rec.attribute3 = hr_api.g_varchar2) then
448: p_rec.attribute3 :=
449: hxc_tat_shd.g_old_rec.attribute3;
450: end if;
451:
452: if (p_rec.attribute4 = hr_api.g_varchar2) then
453: p_rec.attribute4 :=
450: end if;
451:
452: if (p_rec.attribute4 = hr_api.g_varchar2) then
453: p_rec.attribute4 :=
454: hxc_tat_shd.g_old_rec.attribute4;
455: end if;
456:
457: if (p_rec.attribute5 = hr_api.g_varchar2) then
458: p_rec.attribute5 :=
455: end if;
456:
457: if (p_rec.attribute5 = hr_api.g_varchar2) then
458: p_rec.attribute5 :=
459: hxc_tat_shd.g_old_rec.attribute5;
460: end if;
461:
462: if (p_rec.attribute6 = hr_api.g_varchar2) then
463: p_rec.attribute6 :=
460: end if;
461:
462: if (p_rec.attribute6 = hr_api.g_varchar2) then
463: p_rec.attribute6 :=
464: hxc_tat_shd.g_old_rec.attribute6;
465: end if;
466:
467: if (p_rec.attribute7 = hr_api.g_varchar2) then
468: p_rec.attribute7 :=
465: end if;
466:
467: if (p_rec.attribute7 = hr_api.g_varchar2) then
468: p_rec.attribute7 :=
469: hxc_tat_shd.g_old_rec.attribute7;
470: end if;
471:
472: if (p_rec.attribute8 = hr_api.g_varchar2) then
473: p_rec.attribute8 :=
470: end if;
471:
472: if (p_rec.attribute8 = hr_api.g_varchar2) then
473: p_rec.attribute8 :=
474: hxc_tat_shd.g_old_rec.attribute8;
475: end if;
476:
477: if (p_rec.attribute9 = hr_api.g_varchar2) then
478: p_rec.attribute9 :=
475: end if;
476:
477: if (p_rec.attribute9 = hr_api.g_varchar2) then
478: p_rec.attribute9 :=
479: hxc_tat_shd.g_old_rec.attribute9;
480: end if;
481:
482: if (p_rec.attribute10 = hr_api.g_varchar2) then
483: p_rec.attribute10 :=
480: end if;
481:
482: if (p_rec.attribute10 = hr_api.g_varchar2) then
483: p_rec.attribute10 :=
484: hxc_tat_shd.g_old_rec.attribute10;
485: end if;
486:
487: if (p_rec.attribute11 = hr_api.g_varchar2) then
488: p_rec.attribute11 :=
485: end if;
486:
487: if (p_rec.attribute11 = hr_api.g_varchar2) then
488: p_rec.attribute11 :=
489: hxc_tat_shd.g_old_rec.attribute11;
490: end if;
491:
492: if (p_rec.attribute12 = hr_api.g_varchar2) then
493: p_rec.attribute12 :=
490: end if;
491:
492: if (p_rec.attribute12 = hr_api.g_varchar2) then
493: p_rec.attribute12 :=
494: hxc_tat_shd.g_old_rec.attribute12;
495: end if;
496:
497: if (p_rec.attribute13 = hr_api.g_varchar2) then
498: p_rec.attribute13 :=
495: end if;
496:
497: if (p_rec.attribute13 = hr_api.g_varchar2) then
498: p_rec.attribute13 :=
499: hxc_tat_shd.g_old_rec.attribute13;
500: end if;
501:
502: if (p_rec.attribute14 = hr_api.g_varchar2) then
503: p_rec.attribute14 :=
500: end if;
501:
502: if (p_rec.attribute14 = hr_api.g_varchar2) then
503: p_rec.attribute14 :=
504: hxc_tat_shd.g_old_rec.attribute14;
505: end if;
506:
507: if (p_rec.attribute15 = hr_api.g_varchar2) then
508: p_rec.attribute15 :=
505: end if;
506:
507: if (p_rec.attribute15 = hr_api.g_varchar2) then
508: p_rec.attribute15 :=
509: hxc_tat_shd.g_old_rec.attribute15;
510: end if;
511:
512: if (p_rec.attribute16 = hr_api.g_varchar2) then
513: p_rec.attribute16 :=
510: end if;
511:
512: if (p_rec.attribute16 = hr_api.g_varchar2) then
513: p_rec.attribute16 :=
514: hxc_tat_shd.g_old_rec.attribute16;
515: end if;
516:
517: if (p_rec.attribute17 = hr_api.g_varchar2) then
518: p_rec.attribute17 :=
515: end if;
516:
517: if (p_rec.attribute17 = hr_api.g_varchar2) then
518: p_rec.attribute17 :=
519: hxc_tat_shd.g_old_rec.attribute17;
520: end if;
521:
522: if (p_rec.attribute18 = hr_api.g_varchar2) then
523: p_rec.attribute18 :=
520: end if;
521:
522: if (p_rec.attribute18 = hr_api.g_varchar2) then
523: p_rec.attribute18 :=
524: hxc_tat_shd.g_old_rec.attribute18;
525: end if;
526:
527: if (p_rec.attribute19 = hr_api.g_varchar2) then
528: p_rec.attribute19 :=
525: end if;
526:
527: if (p_rec.attribute19 = hr_api.g_varchar2) then
528: p_rec.attribute19 :=
529: hxc_tat_shd.g_old_rec.attribute19;
530: end if;
531:
532: if (p_rec.attribute20 = hr_api.g_varchar2) then
533: p_rec.attribute20 :=
530: end if;
531:
532: if (p_rec.attribute20 = hr_api.g_varchar2) then
533: p_rec.attribute20 :=
534: hxc_tat_shd.g_old_rec.attribute20;
535: end if;
536:
537: if (p_rec.attribute21 = hr_api.g_varchar2) then
538: p_rec.attribute21 :=
535: end if;
536:
537: if (p_rec.attribute21 = hr_api.g_varchar2) then
538: p_rec.attribute21 :=
539: hxc_tat_shd.g_old_rec.attribute21;
540: end if;
541:
542: if (p_rec.attribute22 = hr_api.g_varchar2) then
543: p_rec.attribute22 :=
540: end if;
541:
542: if (p_rec.attribute22 = hr_api.g_varchar2) then
543: p_rec.attribute22 :=
544: hxc_tat_shd.g_old_rec.attribute22;
545: end if;
546:
547: if (p_rec.attribute23 = hr_api.g_varchar2) then
548: p_rec.attribute23 :=
545: end if;
546:
547: if (p_rec.attribute23 = hr_api.g_varchar2) then
548: p_rec.attribute23 :=
549: hxc_tat_shd.g_old_rec.attribute23;
550: end if;
551:
552: if (p_rec.attribute24 = hr_api.g_varchar2) then
553: p_rec.attribute24 :=
550: end if;
551:
552: if (p_rec.attribute24 = hr_api.g_varchar2) then
553: p_rec.attribute24 :=
554: hxc_tat_shd.g_old_rec.attribute24;
555: end if;
556:
557: if (p_rec.attribute25 = hr_api.g_varchar2) then
558: p_rec.attribute25 :=
555: end if;
556:
557: if (p_rec.attribute25 = hr_api.g_varchar2) then
558: p_rec.attribute25 :=
559: hxc_tat_shd.g_old_rec.attribute25;
560: end if;
561:
562: if (p_rec.attribute26 = hr_api.g_varchar2) then
563: p_rec.attribute26 :=
560: end if;
561:
562: if (p_rec.attribute26 = hr_api.g_varchar2) then
563: p_rec.attribute26 :=
564: hxc_tat_shd.g_old_rec.attribute26;
565: end if;
566:
567: if (p_rec.attribute27 = hr_api.g_varchar2) then
568: p_rec.attribute27 :=
565: end if;
566:
567: if (p_rec.attribute27 = hr_api.g_varchar2) then
568: p_rec.attribute27 :=
569: hxc_tat_shd.g_old_rec.attribute27;
570: end if;
571:
572: if (p_rec.attribute28 = hr_api.g_varchar2) then
573: p_rec.attribute28 :=
570: end if;
571:
572: if (p_rec.attribute28 = hr_api.g_varchar2) then
573: p_rec.attribute28 :=
574: hxc_tat_shd.g_old_rec.attribute28;
575: end if;
576:
577: if (p_rec.attribute29 = hr_api.g_varchar2) then
578: p_rec.attribute29 :=
575: end if;
576:
577: if (p_rec.attribute29 = hr_api.g_varchar2) then
578: p_rec.attribute29 :=
579: hxc_tat_shd.g_old_rec.attribute29;
580: end if;
581:
582: if (p_rec.attribute30 = hr_api.g_varchar2) then
583: p_rec.attribute30 :=
580: end if;
581:
582: if (p_rec.attribute30 = hr_api.g_varchar2) then
583: p_rec.attribute30 :=
584: hxc_tat_shd.g_old_rec.attribute30;
585: end if;
586:
587: if (p_rec.bld_blk_info_type_id = hr_api.g_number) then
588: p_rec.bld_blk_info_type_id :=
585: end if;
586:
587: if (p_rec.bld_blk_info_type_id = hr_api.g_number) then
588: p_rec.bld_blk_info_type_id :=
589: hxc_tat_shd.g_old_rec.bld_blk_info_type_id;
590: end if;
591:
592: if (p_rec.data_set_id = hr_api.g_number) then
593: p_rec.data_set_id :=
590: end if;
591:
592: if (p_rec.data_set_id = hr_api.g_number) then
593: p_rec.data_set_id :=
594: hxc_tat_shd.g_old_rec.data_set_id;
595: end if;
596:
597: end convert_defs;
598:
600: -- |---------------------------------< upd >--------------------------------|
601: -- --------------------------------------------------------------------------
602: procedure upd
603: (p_effective_date in date
604: ,p_rec in out nocopy hxc_tat_shd.g_rec_type
605: ) is
606:
607: l_proc varchar2(72) ;
608:
614: end if;
615:
616: -- we must lock the row which we need to update.
617:
618: hxc_tat_shd.lck
619: (p_rec.time_attribute_id
620: ,p_rec.object_version_number
621: );
622:
689: ,p_bld_blk_info_type_id in varchar2 default hr_api.g_number
690: ,p_data_set_id in number default hr_api.g_number
691: ) is
692:
693: l_rec hxc_tat_shd.g_rec_type;
694: l_proc varchar2(72) ;
695:
696: begin
697: g_debug :=hr_utility.debug_enabled;
702:
703: -- call conversion function to turn arguments into the l_rec structure.
704:
705: l_rec :=
706: hxc_tat_shd.convert_args
707: (p_time_attribute_id
708: ,p_object_version_number
709: ,p_attribute_category
710: ,p_attribute1