DBA Data[Home] [Help]

APPS.HXC_TAT_UPD dependencies on HXC_TAT_SHD

Line 53: (p_rec in out nocopy hxc_tat_shd.g_rec_type

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:

Line 117: hxc_tat_shd.constraint_error

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

Line 120: hxc_tat_shd.constraint_error

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

Line 123: hxc_tat_shd.constraint_error

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:

Line 163: (p_rec in hxc_tat_shd.g_rec_type

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:

Line 212: ,p_rec in hxc_tat_shd.g_rec_type

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:

Line 298: => hxc_tat_shd.g_old_rec.object_version_number

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

Line 300: => hxc_tat_shd.g_old_rec.attribute_category

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

Line 302: => hxc_tat_shd.g_old_rec.attribute1

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

Line 304: => hxc_tat_shd.g_old_rec.attribute2

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

Line 306: => hxc_tat_shd.g_old_rec.attribute3

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

Line 308: => hxc_tat_shd.g_old_rec.attribute4

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

Line 310: => hxc_tat_shd.g_old_rec.attribute5

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

Line 312: => hxc_tat_shd.g_old_rec.attribute6

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

Line 314: => hxc_tat_shd.g_old_rec.attribute7

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

Line 316: => hxc_tat_shd.g_old_rec.attribute8

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

Line 318: => hxc_tat_shd.g_old_rec.attribute9

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

Line 320: => hxc_tat_shd.g_old_rec.attribute10

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

Line 322: => hxc_tat_shd.g_old_rec.attribute11

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

Line 324: => hxc_tat_shd.g_old_rec.attribute12

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

Line 326: => hxc_tat_shd.g_old_rec.attribute13

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

Line 328: => hxc_tat_shd.g_old_rec.attribute14

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

Line 330: => hxc_tat_shd.g_old_rec.attribute15

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

Line 332: => hxc_tat_shd.g_old_rec.attribute16

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

Line 334: => hxc_tat_shd.g_old_rec.attribute17

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

Line 336: => hxc_tat_shd.g_old_rec.attribute18

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

Line 338: => hxc_tat_shd.g_old_rec.attribute19

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

Line 340: => hxc_tat_shd.g_old_rec.attribute20

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

Line 342: => hxc_tat_shd.g_old_rec.attribute21

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

Line 344: => hxc_tat_shd.g_old_rec.attribute22

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

Line 346: => hxc_tat_shd.g_old_rec.attribute23

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

Line 348: => hxc_tat_shd.g_old_rec.attribute24

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

Line 350: => hxc_tat_shd.g_old_rec.attribute25

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

Line 352: => hxc_tat_shd.g_old_rec.attribute26

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

Line 354: => hxc_tat_shd.g_old_rec.attribute27

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

Line 356: => hxc_tat_shd.g_old_rec.attribute28

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

Line 358: => hxc_tat_shd.g_old_rec.attribute29

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

Line 360: => hxc_tat_shd.g_old_rec.attribute30

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:

Line 362: => hxc_tat_shd.g_old_rec.bld_blk_info_type_id

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:

Line 423: (p_rec in out nocopy hxc_tat_shd.g_rec_type

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:

Line 434: hxc_tat_shd.g_old_rec.attribute_category;

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 :=

Line 439: hxc_tat_shd.g_old_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 :=

Line 444: hxc_tat_shd.g_old_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 :=

Line 449: hxc_tat_shd.g_old_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 :=

Line 454: hxc_tat_shd.g_old_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 :=

Line 459: hxc_tat_shd.g_old_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 :=

Line 464: hxc_tat_shd.g_old_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 :=

Line 469: hxc_tat_shd.g_old_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 :=

Line 474: hxc_tat_shd.g_old_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 :=

Line 479: hxc_tat_shd.g_old_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 :=

Line 484: hxc_tat_shd.g_old_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 :=

Line 489: hxc_tat_shd.g_old_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 :=

Line 494: hxc_tat_shd.g_old_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 :=

Line 499: hxc_tat_shd.g_old_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 :=

Line 504: hxc_tat_shd.g_old_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 :=

Line 509: hxc_tat_shd.g_old_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 :=

Line 514: hxc_tat_shd.g_old_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 :=

Line 519: hxc_tat_shd.g_old_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 :=

Line 524: hxc_tat_shd.g_old_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 :=

Line 529: hxc_tat_shd.g_old_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 :=

Line 534: hxc_tat_shd.g_old_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 :=

Line 539: hxc_tat_shd.g_old_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 :=

Line 544: hxc_tat_shd.g_old_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 :=

Line 549: hxc_tat_shd.g_old_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 :=

Line 554: hxc_tat_shd.g_old_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 :=

Line 559: hxc_tat_shd.g_old_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 :=

Line 564: hxc_tat_shd.g_old_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 :=

Line 569: hxc_tat_shd.g_old_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 :=

Line 574: hxc_tat_shd.g_old_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 :=

Line 579: hxc_tat_shd.g_old_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 :=

Line 584: hxc_tat_shd.g_old_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 :=

Line 589: hxc_tat_shd.g_old_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 :=

Line 594: hxc_tat_shd.g_old_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:

Line 604: ,p_rec in out nocopy hxc_tat_shd.g_rec_type

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:

Line 618: hxc_tat_shd.lck

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:

Line 693: l_rec hxc_tat_shd.g_rec_type;

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;

Line 706: hxc_tat_shd.convert_args

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