[Home] [Help]
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_enp_shd.api_updating
47: (p_enrt_perd_id => p_enrt_perd_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_enrt_perd_id,hr_api.g_number)
52: <> ben_enp_shd.g_old_rec.enrt_perd_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_enp_shd.constraint_error('BEN_ENRT_PERD_PK');
52: <> ben_enp_shd.g_old_rec.enrt_perd_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_enp_shd.constraint_error('BEN_ENRT_PERD_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null
62: if p_enrt_perd_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_enp_shd.constraint_error('BEN_ENRT_PERD_PK');
67: --
68: end if;
69: --
70: end if;
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_enp_shd.api_updating
124: (p_enrt_perd_id => p_enrt_perd_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_popl_enrt_typ_cycl_id,hr_api.g_number)
129: <> nvl(ben_enp_shd.g_old_rec.popl_enrt_typ_cycl_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if popl_enrt_typ_cycl_id value exists in ben_popl_enrt_typ_cycl_f table
133: --
140: --
141: -- raise error as FK does not relate to PK in ben_popl_enrt_typ_cycl_f
142: -- table.
143: --
144: ben_enp_shd.constraint_error('BEN_ENRT_PERD_DT1');
145: --
146: end if;
147: --
148: close c1;
210: Begin
211: --
212: hr_utility.set_location('Entering:'||l_proc,5);
213: --
214: l_api_updating := ben_enp_shd.api_updating
215: (p_enrt_perd_id => p_enrt_perd_id,
216: p_object_version_number => p_object_version_number);
217: --
218: if (l_api_updating
216: p_object_version_number => p_object_version_number);
217: --
218: if (l_api_updating
219: and nvl(p_yr_perd_id,hr_api.g_number)
220: <> nvl(ben_enp_shd.g_old_rec.yr_perd_id,hr_api.g_number)
221: or not l_api_updating) then
222: --
223: -- check if yr_perd_id value exists in ben_yr_perd table
224: --
231: --
232: -- raise error as FK does not relate to PK in ben_yr_perd
233: -- table.
234: --
235: ben_enp_shd.constraint_error('BEN_ENRT_PERD_FK1');
236: --
237: end if;
238: --
239: close c1;
312: p_argument => 'asnd_lf_evt_dt',
313: p_argument_value => p_asnd_lf_evt_dt);
314:
315: ---
316: l_api_updating := ben_enp_shd.api_updating
317: (p_enrt_perd_id => p_enrt_perd_id,
318: p_object_version_number => p_object_version_number);
319: --
320: -- check it if changing either start or end date.
319: --
320: -- check it if changing either start or end date.
321: --
322: if (l_api_updating
323: and (p_strt_dt <> nvl(ben_enp_shd.g_old_rec.strt_dt,hr_api.g_date) or
324: p_end_dt <> nvl(ben_enp_shd.g_old_rec.end_dt,hr_api.g_date)
325: /* or p_asnd_lf_evt_Dt <> nvl(ben_enp_shd.g_old_rec.asnd_lf_Evt_dt ,hr_api.g_date) */
326: )
327: or not l_api_updating)
320: -- check it if changing either start or end date.
321: --
322: if (l_api_updating
323: and (p_strt_dt <> nvl(ben_enp_shd.g_old_rec.strt_dt,hr_api.g_date) or
324: p_end_dt <> nvl(ben_enp_shd.g_old_rec.end_dt,hr_api.g_date)
325: /* or p_asnd_lf_evt_Dt <> nvl(ben_enp_shd.g_old_rec.asnd_lf_Evt_dt ,hr_api.g_date) */
326: )
327: or not l_api_updating)
328: then
321: --
322: if (l_api_updating
323: and (p_strt_dt <> nvl(ben_enp_shd.g_old_rec.strt_dt,hr_api.g_date) or
324: p_end_dt <> nvl(ben_enp_shd.g_old_rec.end_dt,hr_api.g_date)
325: /* or p_asnd_lf_evt_Dt <> nvl(ben_enp_shd.g_old_rec.asnd_lf_Evt_dt ,hr_api.g_date) */
326: )
327: or not l_api_updating)
328: then
329: --
398: p_argument => 'asnd_lf_evt_dt',
399: p_argument_value => p_asnd_lf_evt_dt);
400:
401: ---
402: l_api_updating := ben_enp_shd.api_updating
403: (p_enrt_perd_id => p_enrt_perd_id,
404: p_object_version_number => p_object_version_number);
405: --
406: -- check it if changing assigned life event date.
405: --
406: -- check it if changing assigned life event date.
407: --
408: if (l_api_updating
409: and (p_asnd_lf_evt_dt <> nvl(ben_enp_shd.g_old_rec.asnd_lf_evt_dt,hr_api.g_date) )
410: or not l_api_updating)
411: then
412: --
413: -- check if there is another enrollment period record with same assigned life event date
476: hr_api.mandatory_arg_error(p_api_name => l_proc,
477: p_argument => 'end_dt',
478: p_argument_value => p_end_dt);
479: --
480: l_api_updating := ben_enp_shd.api_updating
481: (p_enrt_perd_id => p_enrt_perd_id,
482: p_object_version_number => p_object_version_number);
483: --
484: -- check it if changing either default enrollment date or end date.
483: --
484: -- check it if changing either default enrollment date or end date.
485: --
486: if (l_api_updating
487: and (p_dflt_enrt_dt <> nvl(ben_enp_shd.g_old_rec.dflt_enrt_dt,hr_api.g_date) or
488: p_end_dt <> nvl(ben_enp_shd.g_old_rec.end_dt,hr_api.g_date)
489: )
490: or not l_api_updating)
491: then
484: -- check it if changing either default enrollment date or end date.
485: --
486: if (l_api_updating
487: and (p_dflt_enrt_dt <> nvl(ben_enp_shd.g_old_rec.dflt_enrt_dt,hr_api.g_date) or
488: p_end_dt <> nvl(ben_enp_shd.g_old_rec.end_dt,hr_api.g_date)
489: )
490: or not l_api_updating)
491: then
492: --
561: Begin
562: --
563: hr_utility.set_location('Entering:'||l_proc, 5);
564: --
565: l_api_updating := ben_enp_shd.api_updating
566: (p_enrt_perd_id => p_enrt_perd_id,
567: p_object_version_number => p_object_version_number);
568: --
569: if (l_api_updating
567: p_object_version_number => p_object_version_number);
568: --
569: if (l_api_updating
570: and nvl(p_rt_end_dt_rl,hr_api.g_number)
571: <> ben_enp_shd.g_old_rec.rt_end_dt_rl
572: or not l_api_updating)
573: and p_rt_end_dt_rl is not null then
574: --
575: -- check if value of formula rule is valid.
637: Begin
638: --
639: hr_utility.set_location('Entering:'||l_proc, 5);
640: --
641: l_api_updating := ben_enp_shd.api_updating
642: (p_enrt_perd_id => p_enrt_perd_id,
643: p_object_version_number => p_object_version_number);
644: --
645: if (l_api_updating
643: p_object_version_number => p_object_version_number);
644: --
645: if (l_api_updating
646: and p_rt_end_dt_cd
647: <> nvl(ben_enp_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2)
648: or not l_api_updating)
649: and p_rt_end_dt_cd is not null then
650: --
651: -- check if value of lookup falls within lookup type.
709: Begin
710: --
711: hr_utility.set_location('Entering:'||l_proc, 5);
712: --
713: l_api_updating := ben_enp_shd.api_updating
714: (p_enrt_perd_id => p_enrt_perd_id,
715: p_object_version_number => p_object_version_number);
716: --
717: if (l_api_updating
715: p_object_version_number => p_object_version_number);
716: --
717: if (l_api_updating
718: and p_reinstate_ovrdn_cd
719: <> nvl(ben_enp_shd.g_old_rec.reinstate_ovrdn_cd,hr_api.g_varchar2)
720: or not l_api_updating)
721: and p_reinstate_ovrdn_cd is not null then
722: --
723: -- check if value of lookup falls within lookup type.
782: Begin
783: --
784: hr_utility.set_location('Entering:'||l_proc, 5);
785: --
786: l_api_updating := ben_enp_shd.api_updating
787: (p_enrt_perd_id => p_enrt_perd_id,
788: p_object_version_number => p_object_version_number);
789: --
790: if (l_api_updating
788: p_object_version_number => p_object_version_number);
789: --
790: if (l_api_updating
791: and p_reinstate_cd
792: <> nvl(ben_enp_shd.g_old_rec.reinstate_cd,hr_api.g_varchar2)
793: or not l_api_updating)
794: and p_reinstate_cd is not null then
795: --
796: -- check if value of lookup falls within lookup type.
856: Begin
857: --
858: hr_utility.set_location('Entering:'||l_proc, 5);
859: --
860: l_api_updating := ben_enp_shd.api_updating
861: (p_enrt_perd_id => p_enrt_perd_id,
862: p_object_version_number => p_object_version_number);
863: --
864: if (l_api_updating
862: p_object_version_number => p_object_version_number);
863: --
864: if (l_api_updating
865: and p_rt_strt_dt_cd
866: <> nvl(ben_enp_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2)
867: or not l_api_updating)
868: and p_rt_strt_dt_cd is not null then
869: --
870: -- check if value of lookup falls within lookup type.
941: Begin
942: --
943: hr_utility.set_location('Entering:'||l_proc, 5);
944: --
945: l_api_updating := ben_enp_shd.api_updating
946: (p_enrt_perd_id => p_enrt_perd_id,
947: p_object_version_number => p_object_version_number);
948: --
949: if (l_api_updating
947: p_object_version_number => p_object_version_number);
948: --
949: if (l_api_updating
950: and nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
951: <> ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl
952: or not l_api_updating)
953: and p_enrt_cvg_end_dt_rl is not null then
954: --
955: -- check if value of formula rule is valid.
1035: Begin
1036: --
1037: hr_utility.set_location('Entering:'||l_proc, 5);
1038: --
1039: l_api_updating := ben_enp_shd.api_updating
1040: (p_enrt_perd_id => p_enrt_perd_id,
1041: p_object_version_number => p_object_version_number);
1042: --
1043: if (l_api_updating
1041: p_object_version_number => p_object_version_number);
1042: --
1043: if (l_api_updating
1044: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
1045: <> ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl
1046: or not l_api_updating)
1047: and p_enrt_cvg_strt_dt_rl is not null then
1048: --
1049: -- check if value of formula rule is valid.
1112: Begin
1113: --
1114: hr_utility.set_location('Entering:'||l_proc, 5);
1115: --
1116: l_api_updating := ben_enp_shd.api_updating
1117: (p_enrt_perd_id => p_enrt_perd_id,
1118: p_object_version_number => p_object_version_number);
1119: --
1120: if (l_api_updating
1118: p_object_version_number => p_object_version_number);
1119: --
1120: if (l_api_updating
1121: and p_enrt_cvg_end_dt_cd
1122: <> nvl(ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)
1123: or not l_api_updating)
1124: and p_enrt_cvg_end_dt_cd is not null then
1125: --
1126: -- check if value of lookup falls within lookup type.
1197: Begin
1198: --
1199: hr_utility.set_location('Entering:'||l_proc, 5);
1200: --
1201: l_api_updating := ben_enp_shd.api_updating
1202: (p_enrt_perd_id => p_enrt_perd_id,
1203: p_object_version_number => p_object_version_number);
1204: --
1205: if (l_api_updating
1203: p_object_version_number => p_object_version_number);
1204: --
1205: if (l_api_updating
1206: and nvl(p_rt_strt_dt_rl,hr_api.g_number)
1207: <> ben_enp_shd.g_old_rec.rt_strt_dt_rl
1208: or not l_api_updating)
1209: and p_rt_strt_dt_rl is not null then
1210: --
1211: -- check if value of formula rule is valid.
1274: Begin
1275: --
1276: hr_utility.set_location('Entering:'||l_proc, 5);
1277: --
1278: l_api_updating := ben_enp_shd.api_updating
1279: (p_enrt_perd_id => p_enrt_perd_id,
1280: p_object_version_number => p_object_version_number);
1281: --
1282: if (l_api_updating
1280: p_object_version_number => p_object_version_number);
1281: --
1282: if (l_api_updating
1283: and p_enrt_cvg_strt_dt_cd
1284: <> nvl(ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
1285: or not l_api_updating)
1286: and p_enrt_cvg_strt_dt_cd is not null then
1287: --
1288: -- check if value of lookup falls within lookup type.
1342: Begin
1343: --
1344: hr_utility.set_location('Entering:'||l_proc, 5);
1345: --
1346: l_api_updating := ben_enp_shd.api_updating
1347: (p_enrt_perd_id => p_enrt_perd_id,
1348: p_object_version_number => p_object_version_number);
1349: --
1350: if (l_api_updating
1348: p_object_version_number => p_object_version_number);
1349: --
1350: if (l_api_updating
1351: and p_cls_enrt_dt_to_use_cd
1352: <> nvl(ben_enp_shd.g_old_rec.cls_enrt_dt_to_use_cd,hr_api.g_varchar2)
1353: or not l_api_updating)
1354: and p_cls_enrt_dt_to_use_cd is not null then
1355: --
1356: -- check if value of lookup falls within lookup type.
1415: Begin
1416: --
1417: hr_utility.set_location('Entering:'||l_proc, 5);
1418: --
1419: l_api_updating := ben_enp_shd.api_updating
1420: (p_enrt_perd_id => p_enrt_perd_id,
1421: p_object_version_number => p_object_version_number);
1422: --
1423: if (l_api_updating
1421: p_object_version_number => p_object_version_number);
1422: --
1423: if (l_api_updating
1424: and (nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
1425: <> nvl(ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2) or
1426: nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
1427: <> nvl(ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl,hr_api.g_number))
1428: or not l_api_updating) then
1429: --
1423: if (l_api_updating
1424: and (nvl(p_enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
1425: <> nvl(ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2) or
1426: nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
1427: <> nvl(ben_enp_shd.g_old_rec.enrt_cvg_strt_dt_rl,hr_api.g_number))
1428: or not l_api_updating) then
1429: --
1430: if (p_enrt_cvg_strt_dt_cd = 'RL' and p_enrt_cvg_strt_dt_rl is null) then
1431: --
1495: Begin
1496:
1497: hr_utility.set_location('Entering:'||l_proc, 5);
1498: --
1499: l_api_updating := ben_enp_shd.api_updating
1500: (p_enrt_perd_id => p_enrt_perd_id,
1501: p_object_version_number => p_object_version_number);
1502:
1503:
1503:
1504: if (l_api_updating
1505: and
1506: ( nvl(p_Sal_chg_reason_cd,hr_api.g_varchar2)
1507: <> nvl(ben_enp_shd.g_old_rec.Sal_chg_reason_cd,hr_api.g_varchar2)
1508: )
1509: or not l_api_updating)
1510: and p_Sal_chg_reason_cd is not null then
1511:
1526:
1527: if (l_api_updating
1528: and (
1529: nvl( p_Approval_mode_cd,hr_api.g_varchar2) <>
1530: nvl(ben_enp_shd.g_old_rec.Approval_mode_cd,hr_api.g_varchar2)
1531: )
1532: or not l_api_updating)
1533: and p_Approval_mode_cd is not null then
1534:
1551:
1552: if (l_api_updating
1553: and
1554: ( nvl( p_hrchy_ame_trn_cd,hr_api.g_varchar2) <>
1555: nvl(ben_enp_shd.g_old_rec.hrchy_ame_trn_cd,hr_api.g_varchar2)
1556: or nvl(p_hrchy_ame_app_id,hr_api.g_number) <>
1557: nvl(ben_enp_shd.g_old_rec.hrchy_ame_app_id,hr_api.g_number)
1558: --Bug 4083891 : Perform validation for change in Assingned Life Event Date also
1559: or nvl(p_effective_date,hr_api.g_date) <>
1553: and
1554: ( nvl( p_hrchy_ame_trn_cd,hr_api.g_varchar2) <>
1555: nvl(ben_enp_shd.g_old_rec.hrchy_ame_trn_cd,hr_api.g_varchar2)
1556: or nvl(p_hrchy_ame_app_id,hr_api.g_number) <>
1557: nvl(ben_enp_shd.g_old_rec.hrchy_ame_app_id,hr_api.g_number)
1558: --Bug 4083891 : Perform validation for change in Assingned Life Event Date also
1559: or nvl(p_effective_date,hr_api.g_date) <>
1560: nvl(ben_enp_shd.g_old_rec.asnd_lf_evt_dt,hr_api.g_date)
1561: )
1556: or nvl(p_hrchy_ame_app_id,hr_api.g_number) <>
1557: nvl(ben_enp_shd.g_old_rec.hrchy_ame_app_id,hr_api.g_number)
1558: --Bug 4083891 : Perform validation for change in Assingned Life Event Date also
1559: or nvl(p_effective_date,hr_api.g_date) <>
1560: nvl(ben_enp_shd.g_old_rec.asnd_lf_evt_dt,hr_api.g_date)
1561: )
1562: or not l_api_updating)
1563: and p_hrchy_ame_trn_cd is not null then
1564:
1582:
1583: if (l_api_updating
1584: and
1585: ( nvl( p_hrchy_rl,hr_api.g_number) <>
1586: nvl(ben_enp_shd.g_old_rec.hrchy_rl,hr_api.g_number)
1587: )
1588: or not l_api_updating)
1589: and p_hrchy_rl is not null then
1590:
1610:
1611: if (l_api_updating
1612: and
1613: ( nvl( p_hrchy_to_use_cd,hr_api.g_varchar2) <>
1614: nvl(ben_enp_shd.g_old_rec.hrchy_to_use_cd,hr_api.g_varchar2)
1615: )
1616: or not l_api_updating) then
1617: hr_utility.set_location('validating hrchy_to_use_cd:'||p_hrchy_to_use_cd, 5);
1618: if p_hrchy_to_use_cd is not null then
1709: Begin
1710: --
1711: hr_utility.set_location('Entering:'||l_proc, 5);
1712: --
1713: l_api_updating := ben_enp_shd.api_updating
1714: (p_enrt_perd_id => p_enrt_perd_id,
1715: p_object_version_number => p_object_version_number);
1716: --
1717: if (l_api_updating
1716: --
1717: if (l_api_updating
1718: and
1719: (nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2)
1720: <> nvl(ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2) or
1721: nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
1722: <> nvl(ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl,hr_api.g_number))
1723: or not l_api_updating) then
1724: --
1718: and
1719: (nvl(p_enrt_cvg_end_dt_cd,hr_api.g_varchar2)
1720: <> nvl(ben_enp_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2) or
1721: nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
1722: <> nvl(ben_enp_shd.g_old_rec.enrt_cvg_end_dt_rl,hr_api.g_number))
1723: or not l_api_updating) then
1724: --
1725: if (p_enrt_cvg_end_dt_cd = 'RL' and p_enrt_cvg_end_dt_rl is null) then
1726: --
1785: Begin
1786: --
1787: hr_utility.set_location('Entering:'||l_proc, 5);
1788: --
1789: l_api_updating := ben_enp_shd.api_updating
1790: (p_enrt_perd_id => p_enrt_perd_id,
1791: p_object_version_number => p_object_version_number);
1792: --
1793: if (l_api_updating
1791: p_object_version_number => p_object_version_number);
1792: --
1793: if (l_api_updating
1794: and (nvl(p_rt_strt_dt_cd,hr_api.g_varchar2)
1795: <> nvl(ben_enp_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2) or
1796: nvl(p_rt_strt_dt_rl,hr_api.g_number)
1797: <> nvl(ben_enp_shd.g_old_rec.rt_strt_dt_rl,hr_api.g_number))
1798: or not l_api_updating) then
1799: --
1793: if (l_api_updating
1794: and (nvl(p_rt_strt_dt_cd,hr_api.g_varchar2)
1795: <> nvl(ben_enp_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2) or
1796: nvl(p_rt_strt_dt_rl,hr_api.g_number)
1797: <> nvl(ben_enp_shd.g_old_rec.rt_strt_dt_rl,hr_api.g_number))
1798: or not l_api_updating) then
1799: --
1800: if (p_rt_strt_dt_cd = 'RL' and p_rt_strt_dt_rl is null) then
1801: --
1860: Begin
1861: --
1862: hr_utility.set_location('Entering:'||l_proc, 5);
1863: --
1864: l_api_updating := ben_enp_shd.api_updating
1865: (p_enrt_perd_id => p_enrt_perd_id,
1866: p_object_version_number => p_object_version_number);
1867: --
1868: if (l_api_updating
1867: --
1868: if (l_api_updating
1869: and
1870: (nvl(p_rt_end_dt_cd,hr_api.g_varchar2)
1871: <> nvl(ben_enp_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2) or
1872: nvl(p_rt_end_dt_rl,hr_api.g_number)
1873: <> nvl(ben_enp_shd.g_old_rec.rt_end_dt_rl,hr_api.g_number))
1874: or not l_api_updating) then
1875: --
1869: and
1870: (nvl(p_rt_end_dt_cd,hr_api.g_varchar2)
1871: <> nvl(ben_enp_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2) or
1872: nvl(p_rt_end_dt_rl,hr_api.g_number)
1873: <> nvl(ben_enp_shd.g_old_rec.rt_end_dt_rl,hr_api.g_number))
1874: or not l_api_updating) then
1875: --
1876: if (p_rt_end_dt_cd = 'RL' and p_rt_end_dt_rl is null) then
1877: --
1932: --
1933: hr_utility.set_location('Entering:'||l_proc, 5);
1934: --
1935:
1936: l_api_updating := ben_enp_shd.api_updating
1937: (p_enrt_perd_id => p_enrt_perd_id,
1938: p_object_version_number => p_object_version_number);
1939: --
1940: -- check it if changing either start or end date.
1941: --
1942: if (p_bdgt_upd_strt_dt is not null and p_bdgt_upd_end_dt is not null)
1943: and
1944: ((l_api_updating
1945: and (p_bdgt_upd_strt_dt <> nvl(ben_enp_shd.g_old_rec.bdgt_upd_strt_dt,hr_api.g_date) or
1946: p_bdgt_upd_end_dt <> nvl(ben_enp_shd.g_old_rec.bdgt_upd_end_dt,hr_api.g_date)
1947: )
1948: )
1949: or not l_api_updating)
1942: if (p_bdgt_upd_strt_dt is not null and p_bdgt_upd_end_dt is not null)
1943: and
1944: ((l_api_updating
1945: and (p_bdgt_upd_strt_dt <> nvl(ben_enp_shd.g_old_rec.bdgt_upd_strt_dt,hr_api.g_date) or
1946: p_bdgt_upd_end_dt <> nvl(ben_enp_shd.g_old_rec.bdgt_upd_end_dt,hr_api.g_date)
1947: )
1948: )
1949: or not l_api_updating)
1950: then
2004: --
2005: hr_utility.set_location('Entering:'||l_proc, 5);
2006: --
2007:
2008: l_api_updating := ben_enp_shd.api_updating
2009: (p_enrt_perd_id => p_enrt_perd_id,
2010: p_object_version_number => p_object_version_number);
2011: --
2012: -- check it if changing either start or end date.
2013: --
2014: if (p_ws_upd_strt_dt is not null and p_ws_upd_end_dt is not null)
2015: and
2016: ((l_api_updating
2017: and (p_ws_upd_strt_dt <> nvl(ben_enp_shd.g_old_rec.ws_upd_strt_dt,hr_api.g_date) or
2018: p_ws_upd_end_dt <> nvl(ben_enp_shd.g_old_rec.ws_upd_end_dt,hr_api.g_date)
2019: )
2020: )
2021: or not l_api_updating)
2014: if (p_ws_upd_strt_dt is not null and p_ws_upd_end_dt is not null)
2015: and
2016: ((l_api_updating
2017: and (p_ws_upd_strt_dt <> nvl(ben_enp_shd.g_old_rec.ws_upd_strt_dt,hr_api.g_date) or
2018: p_ws_upd_end_dt <> nvl(ben_enp_shd.g_old_rec.ws_upd_end_dt,hr_api.g_date)
2019: )
2020: )
2021: or not l_api_updating)
2022: then
2090: p_argument => 'end_dt',
2091: p_argument_value => p_end_dt);
2092: --
2093:
2094: l_api_updating := ben_enp_shd.api_updating
2095: (p_enrt_perd_id => p_enrt_perd_id,
2096: p_object_version_number => p_object_version_number);
2097: --
2098: -- check it if changing either start or end date.
2097: --
2098: -- check it if changing either start or end date.
2099: --
2100: if (l_api_updating
2101: and (nvl(p_bdgt_upd_strt_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.bdgt_upd_strt_dt,hr_api.g_date) or
2102: nvl(p_bdgt_upd_end_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.bdgt_upd_end_dt,hr_api.g_date) or
2103: p_strt_dt <> nvl(ben_enp_shd.g_old_rec.strt_dt,hr_api.g_date) or
2104: p_end_dt <> nvl(ben_enp_shd.g_old_rec.end_dt,hr_api.g_date)
2105: )
2098: -- check it if changing either start or end date.
2099: --
2100: if (l_api_updating
2101: and (nvl(p_bdgt_upd_strt_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.bdgt_upd_strt_dt,hr_api.g_date) or
2102: nvl(p_bdgt_upd_end_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.bdgt_upd_end_dt,hr_api.g_date) or
2103: p_strt_dt <> nvl(ben_enp_shd.g_old_rec.strt_dt,hr_api.g_date) or
2104: p_end_dt <> nvl(ben_enp_shd.g_old_rec.end_dt,hr_api.g_date)
2105: )
2106: or not l_api_updating)
2099: --
2100: if (l_api_updating
2101: and (nvl(p_bdgt_upd_strt_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.bdgt_upd_strt_dt,hr_api.g_date) or
2102: nvl(p_bdgt_upd_end_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.bdgt_upd_end_dt,hr_api.g_date) or
2103: p_strt_dt <> nvl(ben_enp_shd.g_old_rec.strt_dt,hr_api.g_date) or
2104: p_end_dt <> nvl(ben_enp_shd.g_old_rec.end_dt,hr_api.g_date)
2105: )
2106: or not l_api_updating)
2107: then
2100: if (l_api_updating
2101: and (nvl(p_bdgt_upd_strt_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.bdgt_upd_strt_dt,hr_api.g_date) or
2102: nvl(p_bdgt_upd_end_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.bdgt_upd_end_dt,hr_api.g_date) or
2103: p_strt_dt <> nvl(ben_enp_shd.g_old_rec.strt_dt,hr_api.g_date) or
2104: p_end_dt <> nvl(ben_enp_shd.g_old_rec.end_dt,hr_api.g_date)
2105: )
2106: or not l_api_updating)
2107: then
2108: --
2184: p_argument => 'end_dt',
2185: p_argument_value => p_end_dt);
2186: --
2187:
2188: l_api_updating := ben_enp_shd.api_updating
2189: (p_enrt_perd_id => p_enrt_perd_id,
2190: p_object_version_number => p_object_version_number);
2191: --
2192: -- check it if changing either start or end date.
2191: --
2192: -- check it if changing either start or end date.
2193: --
2194: if (l_api_updating
2195: and (nvl(p_ws_upd_strt_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.ws_upd_strt_dt,hr_api.g_date) or
2196: nvl(p_ws_upd_end_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.ws_upd_end_dt,hr_api.g_date)or
2197: p_strt_dt <> nvl(ben_enp_shd.g_old_rec.strt_dt,hr_api.g_date) or
2198: p_end_dt <> nvl(ben_enp_shd.g_old_rec.end_dt,hr_api.g_date)
2199: )
2192: -- check it if changing either start or end date.
2193: --
2194: if (l_api_updating
2195: and (nvl(p_ws_upd_strt_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.ws_upd_strt_dt,hr_api.g_date) or
2196: nvl(p_ws_upd_end_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.ws_upd_end_dt,hr_api.g_date)or
2197: p_strt_dt <> nvl(ben_enp_shd.g_old_rec.strt_dt,hr_api.g_date) or
2198: p_end_dt <> nvl(ben_enp_shd.g_old_rec.end_dt,hr_api.g_date)
2199: )
2200: or not l_api_updating)
2193: --
2194: if (l_api_updating
2195: and (nvl(p_ws_upd_strt_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.ws_upd_strt_dt,hr_api.g_date) or
2196: nvl(p_ws_upd_end_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.ws_upd_end_dt,hr_api.g_date)or
2197: p_strt_dt <> nvl(ben_enp_shd.g_old_rec.strt_dt,hr_api.g_date) or
2198: p_end_dt <> nvl(ben_enp_shd.g_old_rec.end_dt,hr_api.g_date)
2199: )
2200: or not l_api_updating)
2201: then
2194: if (l_api_updating
2195: and (nvl(p_ws_upd_strt_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.ws_upd_strt_dt,hr_api.g_date) or
2196: nvl(p_ws_upd_end_dt,hr_api.g_date) <> nvl(ben_enp_shd.g_old_rec.ws_upd_end_dt,hr_api.g_date)or
2197: p_strt_dt <> nvl(ben_enp_shd.g_old_rec.strt_dt,hr_api.g_date) or
2198: p_end_dt <> nvl(ben_enp_shd.g_old_rec.end_dt,hr_api.g_date)
2199: )
2200: or not l_api_updating)
2201: then
2202: --
2278: begin
2279: --
2280: hr_utility.set_location('Entering:'|| l_proc, 9653);
2281: --
2282: l_api_updating := ben_enp_shd.api_updating
2283: (p_enrt_perd_id => p_enrt_perd_id,
2284: p_object_version_number => p_object_version_number);
2285: --
2286: if (l_api_updating
2283: (p_enrt_perd_id => p_enrt_perd_id,
2284: p_object_version_number => p_object_version_number);
2285: --
2286: if (l_api_updating
2287: and p_defer_deenrol_flag <> nvl(ben_enp_shd.g_old_rec.defer_deenrol_flag,hr_api.g_number)
2288: or not l_api_updating) and p_defer_deenrol_flag is not null then
2289: --
2290: open c_pl_cd;
2291: fetch c_pl_cd into l_pl_cd;
2344: begin
2345: --
2346: hr_utility.set_location('Entering:'|| l_proc, 9653);
2347: --
2348: l_api_updating := ben_enp_shd.api_updating
2349: (p_enrt_perd_id => p_enrt_perd_id,
2350: p_object_version_number => p_object_version_number);
2351: --
2352: if (l_api_updating
2349: (p_enrt_perd_id => p_enrt_perd_id,
2350: p_object_version_number => p_object_version_number);
2351: --
2352: if (l_api_updating
2353: and p_defer_deenrol_flag <> nvl(ben_enp_shd.g_old_rec.defer_deenrol_flag,hr_api.g_varchar2)
2354: or not l_api_updating)
2355: and p_defer_deenrol_flag is not null then
2356: --
2357: if hr_api.not_exists_in_hr_lookups
2375: --
2376: -- ----------------------------------------------------------------------------
2377: -- |-----------------------< insert_validate >-------------------------------|
2378: -- ----------------------------------------------------------------------------
2379: Procedure insert_validate(p_rec in ben_enp_shd.g_rec_type
2380: ,p_effective_date in date) is
2381: --
2382: l_proc varchar2(72) := g_package||'insert_validate';
2383: --
2587: end insert_validate;
2588: -- ----------------------------------------------------------------------------
2589: -- |---------------------------< update_validate >----------------------------|
2590: -- ----------------------------------------------------------------------------
2591: Procedure update_validate(p_rec in ben_enp_shd.g_rec_type
2592: ,p_effective_date in date) is
2593: --
2594: l_proc varchar2(72) := g_package||'update_validate';
2595: --
2800: --
2801: -- ----------------------------------------------------------------------------
2802: -- |---------------------------< delete_validate >----------------------------|
2803: -- ----------------------------------------------------------------------------
2804: Procedure delete_validate(p_rec in ben_enp_shd.g_rec_type
2805: ,p_effective_date in date) is
2806: --
2807: l_proc varchar2(72) := g_package||'delete_validate';
2808: --