DBA Data[Home] [Help]

APPS.BEN_PEO_BUS dependencies on HR_API

Line 54: and nvl(p_elig_to_prte_rsn_id,hr_api.g_number)

50: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_elig_to_prte_rsn_id,hr_api.g_number)
55: <> ben_peo_shd.g_old_rec.elig_to_prte_rsn_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 124: <> nvl(ben_peo_shd.g_old_rec.ignr_prtn_ovrid_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_ignr_prtn_ovrid_flag
124: <> nvl(ben_peo_shd.g_old_rec.ignr_prtn_ovrid_flag,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_ignr_prtn_ovrid_flag is not null then
127: --
128: -- check if value of lookup falls within lookup type.

Line 130: if hr_api.not_exists_in_hr_lookups

126: and p_ignr_prtn_ovrid_flag is not null then
127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_ignr_prtn_ovrid_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 195: <> nvl(ben_peo_shd.g_old_rec.prtn_ovridbl_flag,hr_api.g_varchar2)

191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating
194: and p_prtn_ovridbl_flag
195: <> nvl(ben_peo_shd.g_old_rec.prtn_ovridbl_flag,hr_api.g_varchar2)
196: or not l_api_updating)
197: and p_prtn_ovridbl_flag is not null then
198: --
199: -- check if value of lookup falls within lookup type.

Line 201: if hr_api.not_exists_in_hr_lookups

197: and p_prtn_ovridbl_flag is not null then
198: --
199: -- check if value of lookup falls within lookup type.
200: --
201: if hr_api.not_exists_in_hr_lookups
202: (p_lookup_type => 'YES_NO',
203: p_lookup_code => p_prtn_ovridbl_flag,
204: p_effective_date => p_effective_date) then
205: --

Line 266: <> nvl(ben_peo_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)

262: p_object_version_number => p_object_version_number);
263: --
264: if (l_api_updating
265: and p_vrfy_fmly_mmbr_cd
266: <> nvl(ben_peo_shd.g_old_rec.vrfy_fmly_mmbr_cd,hr_api.g_varchar2)
267: or not l_api_updating)
268: and p_vrfy_fmly_mmbr_cd is not null
269: then
270: --

Line 274: if hr_api.not_exists_in_hr_lookups

270: --
271: -- check if value of lookup falls within lookup type.
272: --
273:
274: if hr_api.not_exists_in_hr_lookups
275: (p_lookup_type => 'BEN_FMLY_MMBR',
276: p_lookup_code => p_vrfy_fmly_mmbr_cd,
277: p_effective_date => p_effective_date) then
278: --

Line 339: <> nvl(ben_peo_shd.g_old_rec.elig_inelig_cd,hr_api.g_varchar2)

335: p_object_version_number => p_object_version_number);
336: --
337: if (l_api_updating
338: and p_elig_inelig_cd
339: <> nvl(ben_peo_shd.g_old_rec.elig_inelig_cd,hr_api.g_varchar2)
340: or not l_api_updating)
341: and p_elig_inelig_cd is not null
342: then
343: --

Line 347: if hr_api.not_exists_in_hr_lookups

343: --
344: -- check if value of lookup falls within lookup type.
345: --
346:
347: if hr_api.not_exists_in_hr_lookups
348: (p_lookup_type => 'BEN_ELIG_INELIG',
349: p_lookup_code => p_elig_inelig_cd,
350: p_effective_date => p_effective_date) then
351: --

Line 412: <> nvl(ben_peo_shd.g_old_rec.prtn_eff_strt_dt_cd,hr_api.g_varchar2)

408: p_object_version_number => p_object_version_number);
409: --
410: if (l_api_updating
411: and p_prtn_eff_strt_dt_cd
412: <> nvl(ben_peo_shd.g_old_rec.prtn_eff_strt_dt_cd,hr_api.g_varchar2)
413: or not l_api_updating)
414: and p_prtn_eff_strt_dt_cd is not null
415: then
416: --

Line 420: if hr_api.not_exists_in_hr_lookups

416: --
417: -- check if value of lookup falls within lookup type.
418: --
419:
420: if hr_api.not_exists_in_hr_lookups
421: (p_lookup_type => 'BEN_PRTN_ELIG_STRT',
422: p_lookup_code => p_prtn_eff_strt_dt_cd,
423: p_effective_date => p_effective_date) then
424: --

Line 487: and nvl(p_vrfy_fmly_mmbr_rl,hr_api.g_number)

483: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
484: p_object_version_number => p_object_version_number);
485: --
486: if (l_api_updating
487: and nvl(p_vrfy_fmly_mmbr_rl,hr_api.g_number)
488: <> ben_peo_shd.g_old_rec.vrfy_fmly_mmbr_rl
489: or not l_api_updating)
490: and p_vrfy_fmly_mmbr_rl is not null then
491: --

Line 562: and nvl(p_prtn_eff_strt_dt_rl,hr_api.g_number)

558: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
559: p_object_version_number => p_object_version_number);
560: --
561: if (l_api_updating
562: and nvl(p_prtn_eff_strt_dt_rl,hr_api.g_number)
563: <> ben_peo_shd.g_old_rec.prtn_eff_strt_dt_rl
564: or not l_api_updating)
565: and p_prtn_eff_strt_dt_rl is not null then
566: --

Line 635: <> nvl(ben_peo_shd.g_old_rec.prtn_eff_end_dt_cd,hr_api.g_varchar2)

631: p_object_version_number => p_object_version_number);
632: --
633: if (l_api_updating
634: and p_prtn_eff_end_dt_cd
635: <> nvl(ben_peo_shd.g_old_rec.prtn_eff_end_dt_cd,hr_api.g_varchar2)
636: or not l_api_updating)
637: and p_prtn_eff_end_dt_cd is not null
638: then
639: --

Line 643: if hr_api.not_exists_in_hr_lookups

639: --
640: -- check if value of lookup falls within lookup type.
641: --
642:
643: if hr_api.not_exists_in_hr_lookups
644: (p_lookup_type => 'BEN_PRTN_ELIG_END',
645: p_lookup_code => p_prtn_eff_end_dt_cd,
646: p_effective_date => p_effective_date) then
647: --

Line 708: and nvl(p_prtn_eff_end_dt_rl,hr_api.g_number)

704: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
705: p_object_version_number => p_object_version_number);
706: --
707: if (l_api_updating
708: and nvl(p_prtn_eff_end_dt_rl,hr_api.g_number)
709: <> ben_peo_shd.g_old_rec.prtn_eff_end_dt_rl
710: or not l_api_updating)
711: and p_prtn_eff_end_dt_rl is not null then
712: --

Line 783: <> nvl(ben_peo_shd.g_old_rec.wait_perd_dt_to_use_cd,hr_api.g_varchar2)

779: p_object_version_number => p_object_version_number);
780: --
781: if (l_api_updating
782: and p_wait_perd_dt_to_use_cd
783: <> nvl(ben_peo_shd.g_old_rec.wait_perd_dt_to_use_cd,hr_api.g_varchar2)
784: or not l_api_updating)
785: and p_wait_perd_dt_to_use_cd is not null
786: then
787: --

Line 791: if hr_api.not_exists_in_hr_lookups

787: --
788: -- check if value of lookup falls within lookup type.
789: --
790:
791: if hr_api.not_exists_in_hr_lookups
792: (p_lookup_type => 'BEN_MX_WTG_DT_TO_USE'
793: ,p_lookup_code => p_wait_perd_dt_to_use_cd
794: ,p_effective_date => p_effective_date)
795: then

Line 911: and nvl(p_wait_perd_dt_to_use_rl,hr_api.g_number)

907: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
908: p_object_version_number => p_object_version_number);
909: --
910: if (l_api_updating
911: and nvl(p_wait_perd_dt_to_use_rl,hr_api.g_number)
912: <> ben_peo_shd.g_old_rec.wait_perd_dt_to_use_rl
913: or not l_api_updating)
914: and p_wait_perd_dt_to_use_rl is not null then
915: --

Line 984: <> nvl(ben_peo_shd.g_old_rec.wait_perd_uom,hr_api.g_varchar2)

980: p_object_version_number => p_object_version_number);
981: --
982: if (l_api_updating
983: and p_wait_perd_uom
984: <> nvl(ben_peo_shd.g_old_rec.wait_perd_uom,hr_api.g_varchar2)
985: or not l_api_updating)
986: and p_wait_perd_uom is not null then
987: --
988: -- check if value of lookup falls within lookup type.

Line 990: if hr_api.not_exists_in_hr_lookups

986: and p_wait_perd_uom is not null then
987: --
988: -- check if value of lookup falls within lookup type.
989: --
990: if hr_api.not_exists_in_hr_lookups
991: (p_lookup_type => 'BEN_TM_UOM',
992: p_lookup_code => p_wait_perd_uom,
993: p_effective_date => p_effective_date) then
994: --

Line 1057: and nvl(p_wait_perd_rl,hr_api.g_number)

1053: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
1054: p_object_version_number => p_object_version_number);
1055: --
1056: if (l_api_updating
1057: and nvl(p_wait_perd_rl,hr_api.g_number)
1058: <> ben_peo_shd.g_old_rec.wait_perd_rl
1059: or not l_api_updating)
1060: and p_wait_perd_rl is not null then
1061: --

Line 1132: <> nvl(ben_peo_shd.g_old_rec.mx_poe_uom,hr_api.g_varchar2)

1128: p_object_version_number => p_object_version_number);
1129: --
1130: if (l_api_updating
1131: and p_mx_poe_uom
1132: <> nvl(ben_peo_shd.g_old_rec.mx_poe_uom,hr_api.g_varchar2)
1133: or not l_api_updating)
1134: and p_mx_poe_uom is not null then
1135: --
1136: -- check if value of lookup falls within lookup type.

Line 1138: if hr_api.not_exists_in_hr_lookups

1134: and p_mx_poe_uom is not null then
1135: --
1136: -- check if value of lookup falls within lookup type.
1137: --
1138: if hr_api.not_exists_in_hr_lookups
1139: (p_lookup_type => 'BEN_RQD_PERD_ENRT_NENRT_TM_UOM',
1140: p_lookup_code => p_mx_poe_uom,
1141: p_effective_date => p_effective_date) then
1142: --

Line 1205: and nvl(p_mx_poe_det_dt_rl,hr_api.g_number)

1201: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
1202: p_object_version_number => p_object_version_number);
1203: --
1204: if (l_api_updating
1205: and nvl(p_mx_poe_det_dt_rl,hr_api.g_number)
1206: <> ben_peo_shd.g_old_rec.mx_poe_det_dt_rl
1207: or not l_api_updating)
1208: and p_mx_poe_det_dt_rl is not null then
1209: --

Line 1280: and nvl(p_mx_poe_rl,hr_api.g_number)

1276: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
1277: p_object_version_number => p_object_version_number);
1278: --
1279: if (l_api_updating
1280: and nvl(p_mx_poe_rl,hr_api.g_number)
1281: <> ben_peo_shd.g_old_rec.mx_poe_rl
1282: or not l_api_updating)
1283: and p_mx_poe_rl is not null then
1284: --

Line 1356: <> nvl(ben_peo_shd.g_old_rec.mx_poe_det_dt_cd,hr_api.g_varchar2)

1352: p_object_version_number => p_object_version_number);
1353: --
1354: if (l_api_updating
1355: and p_mx_poe_det_dt_cd
1356: <> nvl(ben_peo_shd.g_old_rec.mx_poe_det_dt_cd,hr_api.g_varchar2)
1357: or not l_api_updating)
1358: and p_mx_poe_det_dt_cd is not null then
1359: --
1360: -- check if value of lookup falls within lookup type.

Line 1362: if hr_api.not_exists_in_hr_lookups

1358: and p_mx_poe_det_dt_cd is not null then
1359: --
1360: -- check if value of lookup falls within lookup type.
1361: --
1362: if hr_api.not_exists_in_hr_lookups
1363: (p_lookup_type => 'BEN_MX_POE_DET_DT',
1364: p_lookup_code => p_mx_poe_det_dt_cd,
1365: p_effective_date => p_effective_date) then
1366: --

Line 1429: <> nvl(ben_peo_shd.g_old_rec.mx_poe_apls_cd,hr_api.g_varchar2)

1425: p_object_version_number => p_object_version_number);
1426: --
1427: if (l_api_updating
1428: and p_mx_poe_apls_cd
1429: <> nvl(ben_peo_shd.g_old_rec.mx_poe_apls_cd,hr_api.g_varchar2)
1430: or not l_api_updating)
1431: and p_mx_poe_apls_cd is not null then
1432: --
1433: -- check if value of lookup falls within lookup type.

Line 1435: if hr_api.not_exists_in_hr_lookups

1431: and p_mx_poe_apls_cd is not null then
1432: --
1433: -- check if value of lookup falls within lookup type.
1434: --
1435: if hr_api.not_exists_in_hr_lookups
1436: (p_lookup_type => 'BEN_MX_POE_APLS',
1437: p_lookup_code => p_mx_poe_apls_cd,
1438: p_effective_date => p_effective_date) then
1439: --

Line 1555: (p_oipl_id in number default hr_api.g_number,

1551: --
1552: -- {End Of Comments}
1553: -- ----------------------------------------------------------------------------
1554: Procedure dt_update_validate
1555: (p_oipl_id in number default hr_api.g_number,
1556: p_ler_id in number default hr_api.g_number,
1557: p_pl_id in number default hr_api.g_number,
1558: p_pgm_id in number default hr_api.g_number,
1559: p_ptip_id in number default hr_api.g_number,

Line 1556: p_ler_id in number default hr_api.g_number,

1552: -- {End Of Comments}
1553: -- ----------------------------------------------------------------------------
1554: Procedure dt_update_validate
1555: (p_oipl_id in number default hr_api.g_number,
1556: p_ler_id in number default hr_api.g_number,
1557: p_pl_id in number default hr_api.g_number,
1558: p_pgm_id in number default hr_api.g_number,
1559: p_ptip_id in number default hr_api.g_number,
1560: p_plip_id in number default hr_api.g_number,

Line 1557: p_pl_id in number default hr_api.g_number,

1553: -- ----------------------------------------------------------------------------
1554: Procedure dt_update_validate
1555: (p_oipl_id in number default hr_api.g_number,
1556: p_ler_id in number default hr_api.g_number,
1557: p_pl_id in number default hr_api.g_number,
1558: p_pgm_id in number default hr_api.g_number,
1559: p_ptip_id in number default hr_api.g_number,
1560: p_plip_id in number default hr_api.g_number,
1561: p_datetrack_mode in varchar2,

Line 1558: p_pgm_id in number default hr_api.g_number,

1554: Procedure dt_update_validate
1555: (p_oipl_id in number default hr_api.g_number,
1556: p_ler_id in number default hr_api.g_number,
1557: p_pl_id in number default hr_api.g_number,
1558: p_pgm_id in number default hr_api.g_number,
1559: p_ptip_id in number default hr_api.g_number,
1560: p_plip_id in number default hr_api.g_number,
1561: p_datetrack_mode in varchar2,
1562: p_validation_start_date in date,

Line 1559: p_ptip_id in number default hr_api.g_number,

1555: (p_oipl_id in number default hr_api.g_number,
1556: p_ler_id in number default hr_api.g_number,
1557: p_pl_id in number default hr_api.g_number,
1558: p_pgm_id in number default hr_api.g_number,
1559: p_ptip_id in number default hr_api.g_number,
1560: p_plip_id in number default hr_api.g_number,
1561: p_datetrack_mode in varchar2,
1562: p_validation_start_date in date,
1563: p_validation_end_date in date) Is

Line 1560: p_plip_id in number default hr_api.g_number,

1556: p_ler_id in number default hr_api.g_number,
1557: p_pl_id in number default hr_api.g_number,
1558: p_pgm_id in number default hr_api.g_number,
1559: p_ptip_id in number default hr_api.g_number,
1560: p_plip_id in number default hr_api.g_number,
1561: p_datetrack_mode in varchar2,
1562: p_validation_start_date in date,
1563: p_validation_end_date in date) Is
1564: --

Line 1574: hr_api.mandatory_arg_error

1570: hr_utility.set_location('Entering:'||l_proc, 5);
1571: --
1572: -- Ensure that the p_datetrack_mode argument is not null
1573: --
1574: hr_api.mandatory_arg_error
1575: (p_api_name => l_proc,
1576: p_argument => 'datetrack_mode',
1577: p_argument_value => p_datetrack_mode);
1578: --

Line 1586: hr_api.mandatory_arg_error

1582: --
1583: --
1584: -- Ensure the arguments are not null
1585: --
1586: hr_api.mandatory_arg_error
1587: (p_api_name => l_proc,
1588: p_argument => 'validation_start_date',
1589: p_argument_value => p_validation_start_date);
1590: --

Line 1591: hr_api.mandatory_arg_error

1587: (p_api_name => l_proc,
1588: p_argument => 'validation_start_date',
1589: p_argument_value => p_validation_start_date);
1590: --
1591: hr_api.mandatory_arg_error
1592: (p_api_name => l_proc,
1593: p_argument => 'validation_end_date',
1594: p_argument_value => p_validation_end_date);
1595: --

Line 1596: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and

1592: (p_api_name => l_proc,
1593: p_argument => 'validation_end_date',
1594: p_argument_value => p_validation_end_date);
1595: --
1596: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
1597: NOT (dt_api.check_min_max_dates
1598: (p_base_table_name => 'ben_oipl_f',
1599: p_base_key_column => 'oipl_id',
1600: p_base_key_value => p_oipl_id,

Line 1606: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and

1602: p_to_date => p_validation_end_date))) Then
1603: l_table_name := 'ben_oipl_f';
1604: Raise l_integrity_error;
1605: End If;
1606: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and
1607: NOT (dt_api.check_min_max_dates
1608: (p_base_table_name => 'ben_ler_f',
1609: p_base_key_column => 'ler_id',
1610: p_base_key_value => p_ler_id,

Line 1616: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

1612: p_to_date => p_validation_end_date))) Then
1613: l_table_name := 'ben_ler_f';
1614: Raise l_integrity_error;
1615: End If;
1616: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
1617: NOT (dt_api.check_min_max_dates
1618: (p_base_table_name => 'ben_pl_f',
1619: p_base_key_column => 'pl_id',
1620: p_base_key_value => p_pl_id,

Line 1626: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

1622: p_to_date => p_validation_end_date))) Then
1623: l_table_name := 'ben_pl_f';
1624: Raise l_integrity_error;
1625: End If;
1626: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
1627: NOT (dt_api.check_min_max_dates
1628: (p_base_table_name => 'ben_pgm_f',
1629: p_base_key_column => 'pgm_id',
1630: p_base_key_value => p_pgm_id,

Line 1636: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and

1632: p_to_date => p_validation_end_date))) Then
1633: l_table_name := 'ben_pgm_f';
1634: Raise l_integrity_error;
1635: End If;
1636: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
1637: NOT (dt_api.check_min_max_dates
1638: (p_base_table_name => 'ben_ptip_f',
1639: p_base_key_column => 'ptip_id',
1640: p_base_key_value => p_ptip_id,

Line 1646: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and

1642: p_to_date => p_validation_end_date))) Then
1643: l_table_name := 'ben_ptip_f';
1644: Raise l_integrity_error;
1645: End If;
1646: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
1647: NOT (dt_api.check_min_max_dates
1648: (p_base_table_name => 'ben_plip_f',
1649: p_base_key_column => 'plip_id',
1650: p_base_key_value => p_plip_id,

Line 1730: hr_api.mandatory_arg_error

1726: hr_utility.set_location('Entering:'||l_proc, 5);
1727: --
1728: -- Ensure that the p_datetrack_mode argument is not null
1729: --
1730: hr_api.mandatory_arg_error
1731: (p_api_name => l_proc,
1732: p_argument => 'datetrack_mode',
1733: p_argument_value => p_datetrack_mode);
1734: --

Line 1744: hr_api.mandatory_arg_error

1740: --
1741: --
1742: -- Ensure the arguments are not null
1743: --
1744: hr_api.mandatory_arg_error
1745: (p_api_name => l_proc,
1746: p_argument => 'validation_start_date',
1747: p_argument_value => p_validation_start_date);
1748: --

Line 1749: hr_api.mandatory_arg_error

1745: (p_api_name => l_proc,
1746: p_argument => 'validation_start_date',
1747: p_argument_value => p_validation_start_date);
1748: --
1749: hr_api.mandatory_arg_error
1750: (p_api_name => l_proc,
1751: p_argument => 'validation_end_date',
1752: p_argument_value => p_validation_end_date);
1753: --

Line 1754: hr_api.mandatory_arg_error

1750: (p_api_name => l_proc,
1751: p_argument => 'validation_end_date',
1752: p_argument_value => p_validation_end_date);
1753: --
1754: hr_api.mandatory_arg_error
1755: (p_api_name => l_proc,
1756: p_argument => 'elig_to_prte_rsn_id',
1757: p_argument_value => p_elig_to_prte_rsn_id);
1758: --

Line 1802: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1798: --
1799: -- Call all supporting business operations
1800: --
1801: --
1802: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1803: --
1804: chk_elig_to_prte_rsn_id
1805: (p_elig_to_prte_rsn_id => p_rec.elig_to_prte_rsn_id,
1806: p_effective_date => p_effective_date,

Line 1961: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1957: --
1958: -- Call all supporting business operations
1959: --
1960: --
1961: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1962: --
1963: chk_elig_to_prte_rsn_id
1964: (p_elig_to_prte_rsn_id => p_rec.elig_to_prte_rsn_id,
1965: p_effective_date => p_effective_date,

Line 2160: hr_api.mandatory_arg_error(p_api_name => l_proc,

2156: hr_utility.set_location('Entering:'|| l_proc, 10);
2157: --
2158: -- Ensure that all the mandatory parameter are not null
2159: --
2160: hr_api.mandatory_arg_error(p_api_name => l_proc,
2161: p_argument => 'elig_to_prte_rsn_id',
2162: p_argument_value => p_elig_to_prte_rsn_id);
2163: --
2164: open csr_leg_code;