42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_pcd_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_per_cm_prvdd_id => p_per_cm_prvdd_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_per_cm_prvdd_id;
78: --
79: -- ----------------------------------------------------------------------------
117: where a.address_id = p_address_id;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_pcd_shd.api_updating
124: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
125: p_effective_date => p_effective_date,
150: close c1;
151: --
152: end if;
153: --
154: hr_utility.set_location('Leaving:'||l_proc,10);
155: --
156: End chk_address_id;
157: --
158: -- ----------------------------------------------------------------------------
192: l_api_updating boolean;
193: --
194: Begin
195: --
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: l_api_updating := ben_pcd_shd.api_updating
199: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
200: p_effective_date => p_effective_date,
214: end if;
215: --
216: end if;
217: --
218: hr_utility.set_location('Leaving:'||l_proc,10);
219: --
220: end chk_to_be_sent_dt;
221: --
222: -- ----------------------------------------------------------------------------
254: l_api_updating boolean;
255: --
256: Begin
257: --
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: l_api_updating := ben_pcd_shd.api_updating
261: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
262: p_effective_date => p_effective_date,
285: end if;
286: --
287: end if;
288: --
289: hr_utility.set_location('Leaving:'||l_proc,10);
290: --
291: end chk_cm_dlvry_mthd_cd;
292: --
293:
326: l_api_updating boolean;
327: --
328: Begin
329: --
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: l_api_updating := ben_pcd_shd.api_updating
333: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
334: p_effective_date => p_effective_date,
357: end if;
358: --
359: end if;
360: --
361: hr_utility.set_location('Leaving:'||l_proc,10);
362: --
363: end chk_cm_dlvry_med_cd;
364: --
365: -- ----------------------------------------------------------------------------
397: l_api_updating boolean;
398: --
399: Begin
400: --
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: --
403: l_api_updating := ben_pcd_shd.api_updating
404: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
405: p_effective_date => p_effective_date,
428: end if;
429: --
430: end if;
431: --
432: hr_utility.set_location('Leaving:'||l_proc,10);
433: --
434: end chk_per_cm_prvdd_stat_cd;
435: --
436: --
469: l_api_updating boolean;
470: --
471: Begin
472: --
473: hr_utility.set_location('Entering:'||l_proc, 5);
474: --
475: l_api_updating := ben_pcd_shd.api_updating
476: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
477: p_effective_date => p_effective_date,
500: end if;
501: --
502: end if;
503: --
504: hr_utility.set_location('Leaving:'||l_proc,10);
505: --
506: end chk_resnd_rsn_cd;
507: -- ----------------------------------------------------------------------------
508: -- |------< chk_inspn_rqd_flag >------|
539: l_api_updating boolean;
540: --
541: Begin
542: --
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: l_api_updating := ben_pcd_shd.api_updating
546: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
547: p_effective_date => p_effective_date,
570: end if;
571: --
572: end if;
573: --
574: hr_utility.set_location('Leaving:'||l_proc,10);
575: --
576: end chk_inspn_rqd_flag;
577: --
578: -- ----------------------------------------------------------------------------
610: l_api_updating boolean;
611: --
612: Begin
613: --
614: hr_utility.set_location('Entering:'||l_proc, 5);
615: --
616: l_api_updating := ben_pcd_shd.api_updating
617: (p_per_cm_prvdd_id => p_per_cm_prvdd_id,
618: p_effective_date => p_effective_date,
641: end if;
642: --
643: end if;
644: --
645: hr_utility.set_location('Leaving:'||l_proc,10);
646: --
647: end chk_rqstd_flag;
648: --
649: -- ----------------------------------------------------------------------------
685: l_integrity_error Exception;
686: l_table_name all_tables.table_name%TYPE;
687: --
688: Begin
689: hr_utility.set_location('Entering:'||l_proc, 5);
690: --
691: -- Ensure that the p_datetrack_mode argument is not null
692: --
693: hr_api.mandatory_arg_error
724: End If;
725: --
726: End If;
727: --
728: hr_utility.set_location(' Leaving:'||l_proc, 10);
729: Exception
730: When l_integrity_error Then
731: --
732: -- A referential integrity check was violated therefore
790: l_rows_exist Exception;
791: l_table_name all_tables.table_name%TYPE;
792: --
793: Begin
794: hr_utility.set_location('Entering:'||l_proc, 5);
795: --
796: -- Ensure that the p_datetrack_mode argument is not null
797: --
798: hr_api.mandatory_arg_error
827: --
828: --
829: End If;
830: --
831: hr_utility.set_location(' Leaving:'||l_proc, 10);
832: Exception
833: When l_rows_exist Then
834: --
835: -- A referential integrity check was violated therefore
859: --
860: l_proc varchar2(72) := g_package||'insert_validate';
861: --
862: Begin
863: hr_utility.set_location('Entering:'||l_proc, 5);
864: --
865: -- Call all supporting business operations
866: --
867: --
925: p_rqstd_flag => p_rec.rqstd_flag,
926: p_effective_date => p_effective_date,
927: p_object_version_number => p_rec.object_version_number);
928: --
929: hr_utility.set_location(' Leaving:'||l_proc, 10);
930: End insert_validate;
931: --
932: -- ----------------------------------------------------------------------------
933: -- |---------------------------< update_validate >----------------------------|
941: --
942: l_proc varchar2(72) := g_package||'update_validate';
943: --
944: Begin
945: hr_utility.set_location('Entering:'||l_proc, 5);
946: --
947: -- Call all supporting business operations
948: --
949: --
1004: p_datetrack_mode => p_datetrack_mode,
1005: p_validation_start_date => p_validation_start_date,
1006: p_validation_end_date => p_validation_end_date);
1007: --
1008: hr_utility.set_location(' Leaving:'||l_proc, 10);
1009: End update_validate;
1010: --
1011: -- ----------------------------------------------------------------------------
1012: -- |---------------------------< delete_validate >----------------------------|
1020: --
1021: l_proc varchar2(72) := g_package||'delete_validate';
1022: --
1023: Begin
1024: hr_utility.set_location('Entering:'||l_proc, 5);
1025: --
1026: -- Call all supporting business operations
1027: --
1028: dt_delete_validate
1030: p_validation_start_date => p_validation_start_date,
1031: p_validation_end_date => p_validation_end_date,
1032: p_per_cm_prvdd_id => p_rec.per_cm_prvdd_id);
1033: --
1034: hr_utility.set_location(' Leaving:'||l_proc, 10);
1035: End delete_validate;
1036: --
1037: --
1038: -- ---------------------------------------------------------------------------
1057: l_proc varchar2(72) := g_package||'return_legislation_code';
1058: --
1059: begin
1060: --
1061: hr_utility.set_location('Entering:'|| l_proc, 10);
1062: --
1063: -- Ensure that all the mandatory parameter are not null
1064: --
1065: hr_api.mandatory_arg_error(p_api_name => l_proc,
1082: end if;
1083: --
1084: close csr_leg_code;
1085: --
1086: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1087: --
1088: return l_legislation_code;
1089: --
1090: end return_legislation_code;