42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_lop_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_ler_chg_oipl_enrt_id;
78: --
79: -- ----------------------------------------------------------------------------
111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_lop_shd.api_updating
118: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
119: p_effective_date => p_effective_date,
142: end if;
143: --
144: end if;
145: --
146: hr_utility.set_location('Leaving:'||l_proc,10);
147: --
148: end chk_auto_enrt_flag;
149: --
150: -- ----------------------------------------------------------------------------
182: l_api_updating boolean;
183: --
184: Begin
185: --
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: l_api_updating := ben_lop_shd.api_updating
189: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
190: p_effective_date => p_effective_date,
211: end if;
212: --
213: end if;
214: --
215: hr_utility.set_location('Leaving:'||l_proc,10);
216: --
217: end chk_stl_elig_cant_chg_flag;
218: --
219: -- ----------------------------------------------------------------------------
251: l_api_updating boolean;
252: --
253: Begin
254: --
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: l_api_updating := ben_lop_shd.api_updating
258: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
259: p_effective_date => p_effective_date,
280: end if;
281: --
282: end if;
283: --
284: hr_utility.set_location('Leaving:'||l_proc,10);
285: --
286: end chk_dflt_flag;
287: --
288: -- ----------------------------------------------------------------------------
320: l_api_updating boolean;
321: --
322: Begin
323: --
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: l_api_updating := ben_lop_shd.api_updating
327: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
328: p_effective_date => p_effective_date,
349: end if;
350: --
351: end if;
352: --
353: hr_utility.set_location('Leaving:'||l_proc,10);
354: --
355: end chk_dflt_enrt_cd;
356: --
357: -- ----------------------------------------------------------------------------
407: and ff.effective_end_date;
408: --
409: Begin
410: --
411: hr_utility.set_location('Entering:'||l_proc, 5);
412: --
413: l_api_updating := ben_lop_shd.api_updating
414: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
415: p_effective_date => p_effective_date,
445: close c1;
446: --
447: end if;
448: --
449: hr_utility.set_location('Leaving:'||l_proc,10);
450: --
451: end chk_dflt_enrt_rl;
452: --
453: -- ----------------------------------------------------------------------------
485: l_api_updating boolean;
486: --
487: Begin
488: --
489: hr_utility.set_location('Entering:'||l_proc, 5);
490: --
491: l_api_updating := ben_lop_shd.api_updating
492: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
493: p_effective_date => p_effective_date,
514: end if;
515: --
516: end if;
517: --
518: hr_utility.set_location('Leaving:'||l_proc,10);
519: --
520: end chk_enrt_cd;
521: --
522: -- ----------------------------------------------------------------------------
572: and ff.effective_end_date;
573: --
574: Begin
575: --
576: hr_utility.set_location('Entering:'||l_proc, 5);
577: --
578: l_api_updating := ben_lop_shd.api_updating
579: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
580: p_effective_date => p_effective_date,
610: close c1;
611: --
612: end if;
613: --
614: hr_utility.set_location('Leaving:'||l_proc,10);
615: --
616: end chk_enrt_rl;
617: --
618: -- ----------------------------------------------------------------------------
668: and ff.effective_end_date;
669: --
670: Begin
671: --
672: hr_utility.set_location('Entering:'||l_proc, 5);
673: --
674: l_api_updating := ben_lop_shd.api_updating
675: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
676: p_effective_date => p_effective_date,
706: close c1;
707: --
708: end if;
709: --
710: hr_utility.set_location('Leaving:'||l_proc,10);
711: --
712: end chk_auto_enrt_mthd_rl;
713: --
714: -- ----------------------------------------------------------------------------
748: l_api_updating boolean;
749: --
750: Begin
751: --
752: hr_utility.set_location('Entering:'||l_proc, 5);
753: --
754: l_api_updating := ben_lop_shd.api_updating
755: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
756: p_effective_date => p_effective_date,
777: end if;
778: --
779: end if;
780: --
781: hr_utility.set_location('Leaving:'||l_proc,10);
782: --
783: end chk_use_schedd_enrt_dfns_flag;
784: --
785: */
821: l_api_updating boolean;
822: --
823: Begin
824: --
825: hr_utility.set_location('Entering:'||l_proc, 5);
826: --
827: l_api_updating := ben_lop_shd.api_updating
828: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
829: p_effective_date => p_effective_date,
850: end if;
851: --
852: end if;
853: --
854: hr_utility.set_location('Leaving:'||l_proc,10);
855: --
856: end chk_use_schedd_enrt_dflts_flag;
857: --
858: */
893: l_api_updating boolean;
894: --
895: Begin
896: --
897: hr_utility.set_location('Entering:'||l_proc, 5);
898: --
899: l_api_updating := ben_lop_shd.api_updating
900: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
901: p_effective_date => p_effective_date,
922: end if;
923: --
924: end if;
925: --
926: hr_utility.set_location('Leaving:'||l_proc,10);
927: --
928: end chk_new_crnt_enrl_cd;
929: */
930: --
963: l_api_updating boolean;
964: --
965: Begin
966: --
967: hr_utility.set_location('Entering:'||l_proc, 5);
968: --
969: l_api_updating := ben_lop_shd.api_updating
970: (p_ler_chg_oipl_enrt_id => p_ler_chg_oipl_enrt_id,
971: p_effective_date => p_effective_date,
992: end if;
993: --
994: end if;
995: --
996: hr_utility.set_location('Leaving:'||l_proc,10);
997: --
998: end chk_crnt_enrt_prclds_chg_flag;
999: --
1000: -- ----------------------------------------------------------------------------
1037: l_integrity_error Exception;
1038: l_table_name all_tables.table_name%TYPE;
1039: --
1040: Begin
1041: hr_utility.set_location('Entering:'||l_proc, 5);
1042: --
1043: -- Ensure that the p_datetrack_mode argument is not null
1044: --
1045: hr_api.mandatory_arg_error
1086: End If;
1087: --
1088: End If;
1089: --
1090: hr_utility.set_location(' Leaving:'||l_proc, 10);
1091: Exception
1092: When l_integrity_error Then
1093: --
1094: -- A referential integrity check was violated therefore
1152: l_rows_exist Exception;
1153: l_table_name all_tables.table_name%TYPE;
1154: --
1155: Begin
1156: hr_utility.set_location('Entering:'||l_proc, 5);
1157: --
1158: -- Ensure that the p_datetrack_mode argument is not null
1159: --
1160: hr_api.mandatory_arg_error
1197: End If;
1198: --
1199: End If;
1200: --
1201: hr_utility.set_location(' Leaving:'||l_proc, 10);
1202: Exception
1203: When l_rows_exist Then
1204: --
1205: -- A referential integrity check was violated therefore
1230: --
1231: l_proc varchar2(72) := g_package||'insert_validate';
1232: --
1233: Begin
1234: hr_utility.set_location('Entering:'||l_proc, 5);
1235: --
1236: -- Call all supporting business operations
1237: --
1238: --
1321: p_crnt_enrt_prclds_chg_flag => p_rec.crnt_enrt_prclds_chg_flag,
1322: p_effective_date => p_effective_date,
1323: p_object_version_number => p_rec.object_version_number);
1324: --
1325: hr_utility.set_location(' Leaving:'||l_proc, 10);
1326: End insert_validate;
1327: --
1328: -- ----------------------------------------------------------------------------
1329: -- |---------------------------< update_validate >----------------------------|
1337: --
1338: l_proc varchar2(72) := g_package||'update_validate';
1339: --
1340: Begin
1341: hr_utility.set_location('Entering:'||l_proc, 5);
1342: --
1343: -- Call all supporting business operations
1344: --
1345: --
1436: p_datetrack_mode => p_datetrack_mode,
1437: p_validation_start_date => p_validation_start_date,
1438: p_validation_end_date => p_validation_end_date);
1439: --
1440: hr_utility.set_location(' Leaving:'||l_proc, 10);
1441: End update_validate;
1442: --
1443: -- ----------------------------------------------------------------------------
1444: -- |---------------------------< delete_validate >----------------------------|
1452: --
1453: l_proc varchar2(72) := g_package||'delete_validate';
1454: --
1455: Begin
1456: hr_utility.set_location('Entering:'||l_proc, 5);
1457: --
1458: -- Call all supporting business operations
1459: --
1460: dt_delete_validate
1462: p_validation_start_date => p_validation_start_date,
1463: p_validation_end_date => p_validation_end_date,
1464: p_ler_chg_oipl_enrt_id => p_rec.ler_chg_oipl_enrt_id);
1465: --
1466: hr_utility.set_location(' Leaving:'||l_proc, 10);
1467: End delete_validate;
1468: --
1469: --
1470: -- ---------------------------------------------------------------------------
1489: l_proc varchar2(72) := g_package||'return_legislation_code';
1490: --
1491: begin
1492: --
1493: hr_utility.set_location('Entering:'|| l_proc, 10);
1494: --
1495: -- Ensure that all the mandatory parameter are not null
1496: --
1497: hr_api.mandatory_arg_error(p_api_name => l_proc,
1514: end if;
1515: --
1516: close csr_leg_code;
1517: --
1518: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1519: --
1520: return l_legislation_code;
1521: --
1522: end return_legislation_code;