344: --
345: end if;
346: --
347: --Bug 4068639 : When Creating PIL record, if some of the parameters
348: --are erroneously set to default(values from HR_API package),
349: --then pass their default value in create_Pil_Elctbl_chc_Popl procedure.
350:
351: if p_enrt_perd_id = hr_api.g_number then --p_enrt_perd_id
352: l_enrt_perd_id := null;
347: --Bug 4068639 : When Creating PIL record, if some of the parameters
348: --are erroneously set to default(values from HR_API package),
349: --then pass their default value in create_Pil_Elctbl_chc_Popl procedure.
350:
351: if p_enrt_perd_id = hr_api.g_number then --p_enrt_perd_id
352: l_enrt_perd_id := null;
353: else
354: l_enrt_perd_id := p_enrt_perd_id;
355: end if;
353: else
354: l_enrt_perd_id := p_enrt_perd_id;
355: end if;
356:
357: if l_pel_pgm_id = hr_api.g_number then --p_pgm_id
358: l_pgm_id := null;
359: else
360: l_pgm_id := l_pel_pgm_id;
361: end if;
359: else
360: l_pgm_id := l_pel_pgm_id;
361: end if;
362:
363: if l_pel_pl_id = hr_api.g_number then --p_pl_id
364: l_pl_id := null;
365: else
366: l_pl_id := l_pel_pl_id;
367: end if;
365: else
366: l_pl_id := l_pel_pl_id;
367: end if;
368:
369: if p_lee_rsn_id = hr_api.g_number then --p_lee_rsn_id
370: l_lee_rsn_id := null;
371: else
372: l_lee_rsn_id := p_lee_rsn_id;
373: end if;
371: else
372: l_lee_rsn_id := p_lee_rsn_id;
373: end if;
374:
375: if l_pel_uom = hr_api.g_varchar2 then --p_uom
376: l_uom := null;
377: else
378: l_uom := l_pel_uom;
379: end if;
377: else
378: l_uom := l_pel_uom;
379: end if;
380:
381: if p_cls_enrt_dt_to_use_cd = hr_api.g_varchar2 then --p_cls_enrt_dt_to_use_cd
382: l_cls_enrt_dt_to_use_cd := null;
383: else
384: l_cls_enrt_dt_to_use_cd := p_cls_enrt_dt_to_use_cd;
385: end if;
383: else
384: l_cls_enrt_dt_to_use_cd := p_cls_enrt_dt_to_use_cd;
385: end if;
386:
387: if l_pel_acty_ref_perd_cd = hr_api.g_varchar2 then --p_acty_ref_perd_cd
388: l_acty_ref_perd_cd := null;
389: else
390: l_acty_ref_perd_cd := l_pel_acty_ref_perd_cd;
391: end if;
389: else
390: l_acty_ref_perd_cd := l_pel_acty_ref_perd_cd;
391: end if;
392:
393: if p_dflt_enrt_dt = hr_api.g_date then --p_dflt_enrt_dt
394: l_dflt_enrt_dt := null;
395: else
396: l_dflt_enrt_dt := p_dflt_enrt_dt;
397: end if;
395: else
396: l_dflt_enrt_dt := p_dflt_enrt_dt;
397: end if;
398:
399: if p_enrt_perd_end_dt = hr_api.g_date then --p_enrt_perd_end_dt
400: l_enrt_perd_end_dt := null;
401: else
402: l_enrt_perd_end_dt := p_enrt_perd_end_dt;
403: end if;
401: else
402: l_enrt_perd_end_dt := p_enrt_perd_end_dt;
403: end if;
404:
405: if p_enrt_perd_strt_dt = hr_api.g_date then --p_enrt_perd_strt_dt
406: l_enrt_perd_strt_dt := null;
407: else
408: l_enrt_perd_strt_dt := p_enrt_perd_strt_dt;
409: end if;
407: else
408: l_enrt_perd_strt_dt := p_enrt_perd_strt_dt;
409: end if;
410:
411: if p_procg_end_dt = hr_api.g_date then --p_procg_end_dt
412: l_procg_end_dt := null;
413: else
414: l_procg_end_dt := p_procg_end_dt;
415: end if;
862: ,p_program_update_date => p_program_update_date
863: ,p_effective_date => trunc(p_effective_date)
864: );
865: exception
866: when hr_api.cannot_find_prog_unit then
867: hr_api.cannot_find_prog_unit_error
868: (
869: p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
870: ,p_hook_type => 'BP'
863: ,p_effective_date => trunc(p_effective_date)
864: );
865: exception
866: when hr_api.cannot_find_prog_unit then
867: hr_api.cannot_find_prog_unit_error
868: (
869: p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
870: ,p_hook_type => 'BP'
871: );
1083: ,p_object_version_number => l_object_version_number
1084: ,p_effective_date => trunc(p_effective_date)
1085: );
1086: exception
1087: when hr_api.cannot_find_prog_unit then
1088: hr_api.cannot_find_prog_unit_error
1089: (p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
1090: ,p_hook_type => 'AP'
1091: );
1084: ,p_effective_date => trunc(p_effective_date)
1085: );
1086: exception
1087: when hr_api.cannot_find_prog_unit then
1088: hr_api.cannot_find_prog_unit_error
1089: (p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
1090: ,p_hook_type => 'AP'
1091: );
1092: --
1100: --
1101: -- When in validation only mode raise the Validate_Enabled exception
1102: --
1103: if p_validate then
1104: raise hr_api.validate_enabled;
1105: end if;
1106: --
1107: -- Set all output arguments
1108: --
1118: end if;
1119: --
1120: exception
1121: --
1122: when hr_api.validate_enabled then
1123: --
1124: -- As the Validate_Enabled exception has been raised
1125: -- we must rollback to the savepoint
1126: --
1573: --
1574: -- When in validation only mode raise the Validate_Enabled exception
1575: --
1576: if p_validate then
1577: raise hr_api.validate_enabled;
1578: end if;
1579: --
1580: -- Set electable choice current row globals
1581: --
1587: -- Do not call the caching code if called from CWB benmngle mode
1588: --
1589: if nvl(p_mode, 'OAB') <> 'W' then
1590: --
1591: if nvl(ben_epe_cache.g_currcobjepe_row.pl_id,hr_api.g_number) = nvl(p_pl_id,hr_api.g_number)
1592: and nvl(ben_epe_cache.g_currcobjepe_row.plip_id,hr_api.g_number) = nvl(p_plip_id,hr_api.g_number)
1593: and ben_epe_cache.g_currcobjepe_row.oipl_id is not null
1594: and p_oipl_id is null
1595: then
1588: --
1589: if nvl(p_mode, 'OAB') <> 'W' then
1590: --
1591: if nvl(ben_epe_cache.g_currcobjepe_row.pl_id,hr_api.g_number) = nvl(p_pl_id,hr_api.g_number)
1592: and nvl(ben_epe_cache.g_currcobjepe_row.plip_id,hr_api.g_number) = nvl(p_plip_id,hr_api.g_number)
1593: and ben_epe_cache.g_currcobjepe_row.oipl_id is not null
1594: and p_oipl_id is null
1595: then
1596: --
1633: end if;
1634: --
1635: exception
1636: --
1637: when hr_api.validate_enabled then
1638: --
1639: -- As the Validate_Enabled exception has been raised
1640: -- we must rollback to the savepoint
1641: --
1671: --
1672: procedure update_ELIG_PER_ELC_CHC
1673: (p_validate in boolean default false
1674: ,p_elig_per_elctbl_chc_id in number
1675: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1676: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1677: ,p_enrt_perd_end_dt in date default hr_api.g_date
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1672: procedure update_ELIG_PER_ELC_CHC
1673: (p_validate in boolean default false
1674: ,p_elig_per_elctbl_chc_id in number
1675: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1676: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1677: ,p_enrt_perd_end_dt in date default hr_api.g_date
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1673: (p_validate in boolean default false
1674: ,p_elig_per_elctbl_chc_id in number
1675: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1676: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1677: ,p_enrt_perd_end_dt in date default hr_api.g_date
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1674: ,p_elig_per_elctbl_chc_id in number
1675: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1676: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1677: ,p_enrt_perd_end_dt in date default hr_api.g_date
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1675: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1676: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1677: ,p_enrt_perd_end_dt in date default hr_api.g_date
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1677: ,p_enrt_perd_end_dt in date default hr_api.g_date
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1677: ,p_enrt_perd_end_dt in date default hr_api.g_date
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1720: ,p_plip_ordr_num in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1720: ,p_plip_ordr_num in number default hr_api.g_number
1721: ,p_ptip_ordr_num in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1720: ,p_plip_ordr_num in number default hr_api.g_number
1721: ,p_ptip_ordr_num in number default hr_api.g_number
1722: ,p_oipl_ordr_num in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1720: ,p_plip_ordr_num in number default hr_api.g_number
1721: ,p_ptip_ordr_num in number default hr_api.g_number
1722: ,p_oipl_ordr_num in number default hr_api.g_number
1723: -- cwb
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1720: ,p_plip_ordr_num in number default hr_api.g_number
1721: ,p_ptip_ordr_num in number default hr_api.g_number
1722: ,p_oipl_ordr_num in number default hr_api.g_number
1723: -- cwb
1724: ,p_comments in varchar2 default hr_api.g_varchar2
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1720: ,p_plip_ordr_num in number default hr_api.g_number
1721: ,p_ptip_ordr_num in number default hr_api.g_number
1722: ,p_oipl_ordr_num in number default hr_api.g_number
1723: -- cwb
1724: ,p_comments in varchar2 default hr_api.g_varchar2
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1720: ,p_plip_ordr_num in number default hr_api.g_number
1721: ,p_ptip_ordr_num in number default hr_api.g_number
1722: ,p_oipl_ordr_num in number default hr_api.g_number
1723: -- cwb
1724: ,p_comments in varchar2 default hr_api.g_varchar2
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1720: ,p_plip_ordr_num in number default hr_api.g_number
1721: ,p_ptip_ordr_num in number default hr_api.g_number
1722: ,p_oipl_ordr_num in number default hr_api.g_number
1723: -- cwb
1724: ,p_comments in varchar2 default hr_api.g_varchar2
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1721: ,p_ptip_ordr_num in number default hr_api.g_number
1722: ,p_oipl_ordr_num in number default hr_api.g_number
1723: -- cwb
1724: ,p_comments in varchar2 default hr_api.g_varchar2
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1722: ,p_oipl_ordr_num in number default hr_api.g_number
1723: -- cwb
1724: ,p_comments in varchar2 default hr_api.g_varchar2
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1723: -- cwb
1724: ,p_comments in varchar2 default hr_api.g_varchar2
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1731: ,p_ws_mgr_id in number default hr_api.g_number
1724: ,p_comments in varchar2 default hr_api.g_varchar2
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1731: ,p_ws_mgr_id in number default hr_api.g_number
1732: -- cwb
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1731: ,p_ws_mgr_id in number default hr_api.g_number
1732: -- cwb
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1731: ,p_ws_mgr_id in number default hr_api.g_number
1732: -- cwb
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1731: ,p_ws_mgr_id in number default hr_api.g_number
1732: -- cwb
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1731: ,p_ws_mgr_id in number default hr_api.g_number
1732: -- cwb
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1731: ,p_ws_mgr_id in number default hr_api.g_number
1732: -- cwb
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1731: ,p_ws_mgr_id in number default hr_api.g_number
1732: -- cwb
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1732: -- cwb
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1768: ,p_program_application_id in number default hr_api.g_number
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1768: ,p_program_application_id in number default hr_api.g_number
1769: ,p_program_id in number default hr_api.g_number
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1768: ,p_program_application_id in number default hr_api.g_number
1769: ,p_program_id in number default hr_api.g_number
1770: ,p_program_update_date in date default hr_api.g_date
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1768: ,p_program_application_id in number default hr_api.g_number
1769: ,p_program_id in number default hr_api.g_number
1770: ,p_program_update_date in date default hr_api.g_date
1771: ,p_object_version_number in out nocopy number
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1768: ,p_program_application_id in number default hr_api.g_number
1769: ,p_program_id in number default hr_api.g_number
1770: ,p_program_update_date in date default hr_api.g_date
1771: ,p_object_version_number in out nocopy number
1772: ,p_effective_date in date
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1768: ,p_program_application_id in number default hr_api.g_number
1769: ,p_program_id in number default hr_api.g_number
1770: ,p_program_update_date in date default hr_api.g_date
1771: ,p_object_version_number in out nocopy number
1772: ,p_effective_date in date
1773: ) is
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1768: ,p_program_application_id in number default hr_api.g_number
1769: ,p_program_id in number default hr_api.g_number
1770: ,p_program_update_date in date default hr_api.g_date
1771: ,p_object_version_number in out nocopy number
1772: ,p_effective_date in date
1773: ) is
1774: --
1895: ,p_object_version_number => p_object_version_number
1896: ,p_effective_date => trunc(p_effective_date)
1897: );
1898: exception
1899: when hr_api.cannot_find_prog_unit then
1900: hr_api.cannot_find_prog_unit_error
1901: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
1902: ,p_hook_type => 'BP'
1903: );
1896: ,p_effective_date => trunc(p_effective_date)
1897: );
1898: exception
1899: when hr_api.cannot_find_prog_unit then
1900: hr_api.cannot_find_prog_unit_error
1901: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
1902: ,p_hook_type => 'BP'
1903: );
1904: --
2113: ,p_object_version_number => l_object_version_number
2114: ,p_effective_date => trunc(p_effective_date)
2115: );
2116: exception
2117: when hr_api.cannot_find_prog_unit then
2118: hr_api.cannot_find_prog_unit_error
2119: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
2120: ,p_hook_type => 'AP'
2121: );
2114: ,p_effective_date => trunc(p_effective_date)
2115: );
2116: exception
2117: when hr_api.cannot_find_prog_unit then
2118: hr_api.cannot_find_prog_unit_error
2119: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
2120: ,p_hook_type => 'AP'
2121: );
2122: --
2130: --
2131: -- When in validation only mode raise the Validate_Enabled exception
2132: --
2133: if p_validate then
2134: raise hr_api.validate_enabled;
2135: end if;
2136: --
2137: -- Set all output arguments
2138: --
2143: end if;
2144: --
2145: exception
2146: --
2147: when hr_api.validate_enabled then
2148: --
2149: -- As the Validate_Enabled exception has been raised
2150: -- we must rollback to the savepoint
2151: --
2242: --
2243: procedure update_perf_ELIG_PER_ELC_CHC
2244: (p_validate in boolean default false
2245: ,p_elig_per_elctbl_chc_id in number
2246: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2247: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2248: --,p_enrt_perd_end_dt in date default hr_api.g_date
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2243: procedure update_perf_ELIG_PER_ELC_CHC
2244: (p_validate in boolean default false
2245: ,p_elig_per_elctbl_chc_id in number
2246: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2247: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2248: --,p_enrt_perd_end_dt in date default hr_api.g_date
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2244: (p_validate in boolean default false
2245: ,p_elig_per_elctbl_chc_id in number
2246: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2247: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2248: --,p_enrt_perd_end_dt in date default hr_api.g_date
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2245: ,p_elig_per_elctbl_chc_id in number
2246: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2247: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2248: --,p_enrt_perd_end_dt in date default hr_api.g_date
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2246: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2247: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2248: --,p_enrt_perd_end_dt in date default hr_api.g_date
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2248: --,p_enrt_perd_end_dt in date default hr_api.g_date
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2248: --,p_enrt_perd_end_dt in date default hr_api.g_date
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2291: ,p_plip_ordr_num in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2291: ,p_plip_ordr_num in number default hr_api.g_number
2292: ,p_ptip_ordr_num in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2291: ,p_plip_ordr_num in number default hr_api.g_number
2292: ,p_ptip_ordr_num in number default hr_api.g_number
2293: ,p_oipl_ordr_num in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2291: ,p_plip_ordr_num in number default hr_api.g_number
2292: ,p_ptip_ordr_num in number default hr_api.g_number
2293: ,p_oipl_ordr_num in number default hr_api.g_number
2294: -- cwb
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2291: ,p_plip_ordr_num in number default hr_api.g_number
2292: ,p_ptip_ordr_num in number default hr_api.g_number
2293: ,p_oipl_ordr_num in number default hr_api.g_number
2294: -- cwb
2295: ,p_comments in varchar2 default hr_api.g_varchar2
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2291: ,p_plip_ordr_num in number default hr_api.g_number
2292: ,p_ptip_ordr_num in number default hr_api.g_number
2293: ,p_oipl_ordr_num in number default hr_api.g_number
2294: -- cwb
2295: ,p_comments in varchar2 default hr_api.g_varchar2
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2291: ,p_plip_ordr_num in number default hr_api.g_number
2292: ,p_ptip_ordr_num in number default hr_api.g_number
2293: ,p_oipl_ordr_num in number default hr_api.g_number
2294: -- cwb
2295: ,p_comments in varchar2 default hr_api.g_varchar2
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2291: ,p_plip_ordr_num in number default hr_api.g_number
2292: ,p_ptip_ordr_num in number default hr_api.g_number
2293: ,p_oipl_ordr_num in number default hr_api.g_number
2294: -- cwb
2295: ,p_comments in varchar2 default hr_api.g_varchar2
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2292: ,p_ptip_ordr_num in number default hr_api.g_number
2293: ,p_oipl_ordr_num in number default hr_api.g_number
2294: -- cwb
2295: ,p_comments in varchar2 default hr_api.g_varchar2
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2293: ,p_oipl_ordr_num in number default hr_api.g_number
2294: -- cwb
2295: ,p_comments in varchar2 default hr_api.g_varchar2
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2294: -- cwb
2295: ,p_comments in varchar2 default hr_api.g_varchar2
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2302: ,p_ws_mgr_id in number default hr_api.g_number
2295: ,p_comments in varchar2 default hr_api.g_varchar2
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2302: ,p_ws_mgr_id in number default hr_api.g_number
2303: -- cwb
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2302: ,p_ws_mgr_id in number default hr_api.g_number
2303: -- cwb
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2302: ,p_ws_mgr_id in number default hr_api.g_number
2303: -- cwb
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2302: ,p_ws_mgr_id in number default hr_api.g_number
2303: -- cwb
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2302: ,p_ws_mgr_id in number default hr_api.g_number
2303: -- cwb
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2302: ,p_ws_mgr_id in number default hr_api.g_number
2303: -- cwb
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2302: ,p_ws_mgr_id in number default hr_api.g_number
2303: -- cwb
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2303: -- cwb
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2339: ,p_program_application_id in number default hr_api.g_number
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2339: ,p_program_application_id in number default hr_api.g_number
2340: ,p_program_id in number default hr_api.g_number
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2339: ,p_program_application_id in number default hr_api.g_number
2340: ,p_program_id in number default hr_api.g_number
2341: ,p_program_update_date in date default hr_api.g_date
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2339: ,p_program_application_id in number default hr_api.g_number
2340: ,p_program_id in number default hr_api.g_number
2341: ,p_program_update_date in date default hr_api.g_date
2342: ,p_object_version_number in out nocopy number
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2339: ,p_program_application_id in number default hr_api.g_number
2340: ,p_program_id in number default hr_api.g_number
2341: ,p_program_update_date in date default hr_api.g_date
2342: ,p_object_version_number in out nocopy number
2343: ,p_effective_date in date
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2339: ,p_program_application_id in number default hr_api.g_number
2340: ,p_program_id in number default hr_api.g_number
2341: ,p_program_update_date in date default hr_api.g_date
2342: ,p_object_version_number in out nocopy number
2343: ,p_effective_date in date
2344: )
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2339: ,p_program_application_id in number default hr_api.g_number
2340: ,p_program_id in number default hr_api.g_number
2341: ,p_program_update_date in date default hr_api.g_date
2342: ,p_object_version_number in out nocopy number
2343: ,p_effective_date in date
2344: )
2345: is
2502: --
2503: --CWB
2504: -- Check only if the new manager is not null or defaulted.
2505: --
2506: if (nvl(p_ws_mgr_id, hr_api.g_number) <> hr_api.g_number) and
2507: (nvl(ben_epe_shd.g_old_rec.ws_mgr_id,-1) <> nvl(p_ws_mgr_id,-1))
2508: then
2509: chk_valid_mgr(p_elig_per_elctbl_chc_id,p_ws_mgr_id,p_effective_date);
2510: end if;
2634: --
2635: -- When in validation only mode raise the Validate_Enabled exception
2636: --
2637: if p_validate then
2638: raise hr_api.validate_enabled;
2639: end if;
2640: --
2641: -- Set EPE comp object context values
2642: --
2671: end if;
2672: --
2673: exception
2674: --
2675: when hr_api.validate_enabled then
2676: --
2677: -- As the Validate_Enabled exception has been raised
2678: -- we must rollback to the savepoint
2679: --
2818: ,p_object_version_number => p_object_version_number
2819: ,p_effective_date => trunc(p_effective_date)
2820: );
2821: exception
2822: when hr_api.cannot_find_prog_unit then
2823: hr_api.cannot_find_prog_unit_error
2824: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2825: ,p_hook_type => 'BP'
2826: );
2819: ,p_effective_date => trunc(p_effective_date)
2820: );
2821: exception
2822: when hr_api.cannot_find_prog_unit then
2823: hr_api.cannot_find_prog_unit_error
2824: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2825: ,p_hook_type => 'BP'
2826: );
2827: --
2878: ,p_object_version_number => l_object_version_number
2879: ,p_effective_date => trunc(p_effective_date)
2880: );
2881: exception
2882: when hr_api.cannot_find_prog_unit then
2883: hr_api.cannot_find_prog_unit_error
2884: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2885: ,p_hook_type => 'AP'
2886: );
2879: ,p_effective_date => trunc(p_effective_date)
2880: );
2881: exception
2882: when hr_api.cannot_find_prog_unit then
2883: hr_api.cannot_find_prog_unit_error
2884: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2885: ,p_hook_type => 'AP'
2886: );
2887: --
2895: --
2896: -- When in validation only mode raise the Validate_Enabled exception
2897: --
2898: if p_validate then
2899: raise hr_api.validate_enabled;
2900: end if;
2901: --
2902: if g_debug then
2903: hr_utility.set_location(' Leaving:'||l_proc, 70);
2904: end if;
2905: --
2906: exception
2907: --
2908: when hr_api.validate_enabled then
2909: --
2910: -- As the Validate_Enabled exception has been raised
2911: -- we must rollback to the savepoint
2912: --