[Home] [Help]
42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_pet_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_popl_enrt_typ_cycl_id => p_popl_enrt_typ_cycl_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_popl_enrt_typ_cycl_id;
78: --
79: -- ----------------------------------------------------------------------------
130: and p_validation_end_date >= effective_start_date;
131: --
132: Begin
133: --
134: hr_utility.set_location('Entering:'||l_proc, 5);
135: --
136: l_api_updating := ben_pet_shd.api_updating
137: (p_popl_enrt_typ_cycl_id => p_popl_enrt_typ_cycl_id,
138: p_effective_date => p_effective_date,
177: close chk_unique;
178: --
179: end if;
180: --
181: hr_utility.set_location('Leaving:'||l_proc,10);
182: --
183: end chk_enrt_typ_cycl_cd;
184: --
185: -- ----------------------------------------------------------------------------
216: where enp.popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id;
217: --
218: Begin
219: --
220: hr_utility.set_location('Entering:'||l_proc,5);
221: --
222: --
223: -- check if child rows exists in ben_enrt_perd.
224: --
239: --
240: Return(false);
241: end if;
242: --
243: hr_utility.set_location('Leaving:'||l_proc,10);
244: --
245: End enp_rows_exists;
246:
247: -- ----------------------------------------------------------------------------
284: l_integrity_error Exception;
285: l_table_name all_tables.table_name%TYPE;
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: -- Ensure that the p_datetrack_mode argument is not null
291: --
292: hr_api.mandatory_arg_error
333: End If;
334: --
335: End If;
336: --
337: hr_utility.set_location(' Leaving:'||l_proc, 10);
338: Exception
339: When l_integrity_error Then
340: --
341: -- A referential integrity check was violated therefore
398: l_rows_exist Exception;
399: l_table_name all_tables.table_name%TYPE;
400: --
401: Begin
402: hr_utility.set_location('Entering:'||l_proc, 5);
403: --
404: -- Ensure that the p_datetrack_mode argument is not null
405: --
406: hr_api.mandatory_arg_error
447: Raise l_rows_exist;
448: End If;
449: End If;
450: --
451: hr_utility.set_location(' Leaving:'||l_proc, 10);
452: Exception
453: When l_rows_exist Then
454: --
455: -- A referential integrity check was violated therefore
479: --
480: l_proc varchar2(72) := g_package||'insert_validate';
481: --
482: Begin
483: hr_utility.set_location('Entering:'||l_proc, 5);
484: --
485: -- Call all supporting business operations
486: --
487: --
502: p_validation_end_date => p_validation_end_date,
503: p_business_group_id => p_rec.business_group_id,
504: p_object_version_number => p_rec.object_version_number);
505: --
506: hr_utility.set_location(' Leaving:'||l_proc, 10);
507: End insert_validate;
508: --
509: -- ----------------------------------------------------------------------------
510: -- |---------------------------< update_validate >----------------------------|
518: --
519: l_proc varchar2(72) := g_package||'update_validate';
520: --
521: Begin
522: hr_utility.set_location('Entering:'||l_proc, 5);
523: --
524: -- Call all supporting business operations
525: --
526: --
550: p_datetrack_mode => p_datetrack_mode,
551: p_validation_start_date => p_validation_start_date,
552: p_validation_end_date => p_validation_end_date);
553: --
554: hr_utility.set_location(' Leaving:'||l_proc, 10);
555: End update_validate;
556: --
557: -- ----------------------------------------------------------------------------
558: -- |---------------------------< delete_validate >----------------------------|
566: --
567: l_proc varchar2(72) := g_package||'delete_validate';
568: --
569: Begin
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: -- Call all supporting business operations
573: --
574: dt_delete_validate
576: p_validation_start_date => p_validation_start_date,
577: p_validation_end_date => p_validation_end_date,
578: p_popl_enrt_typ_cycl_id => p_rec.popl_enrt_typ_cycl_id);
579: --
580: hr_utility.set_location(' Leaving:'||l_proc, 10);
581: End delete_validate;
582: --
583: --
584: -- ---------------------------------------------------------------------------
603: l_proc varchar2(72) := g_package||'return_legislation_code';
604: --
605: begin
606: --
607: hr_utility.set_location('Entering:'|| l_proc, 10);
608: --
609: -- Ensure that all the mandatory parameter are not null
610: --
611: hr_api.mandatory_arg_error(p_api_name => l_proc,
628: end if;
629: --
630: close csr_leg_code;
631: --
632: hr_utility.set_location(' Leaving:'|| l_proc, 20);
633: --
634: return l_legislation_code;
635: --
636: end return_legislation_code;