340: --
341: end if;
342: --
343: --Bug 4068639 : When Creating PIL record, if some of the parameters
344: --are erroneously set to default(values from HR_API package),
345: --then pass their default value in create_Pil_Elctbl_chc_Popl procedure.
346:
347: if p_enrt_perd_id = hr_api.g_number then --p_enrt_perd_id
348: l_enrt_perd_id := null;
343: --Bug 4068639 : When Creating PIL record, if some of the parameters
344: --are erroneously set to default(values from HR_API package),
345: --then pass their default value in create_Pil_Elctbl_chc_Popl procedure.
346:
347: if p_enrt_perd_id = hr_api.g_number then --p_enrt_perd_id
348: l_enrt_perd_id := null;
349: else
350: l_enrt_perd_id := p_enrt_perd_id;
351: end if;
349: else
350: l_enrt_perd_id := p_enrt_perd_id;
351: end if;
352:
353: if l_pel_pgm_id = hr_api.g_number then --p_pgm_id
354: l_pgm_id := null;
355: else
356: l_pgm_id := l_pel_pgm_id;
357: end if;
355: else
356: l_pgm_id := l_pel_pgm_id;
357: end if;
358:
359: if l_pel_pl_id = hr_api.g_number then --p_pl_id
360: l_pl_id := null;
361: else
362: l_pl_id := l_pel_pl_id;
363: end if;
361: else
362: l_pl_id := l_pel_pl_id;
363: end if;
364:
365: if p_lee_rsn_id = hr_api.g_number then --p_lee_rsn_id
366: l_lee_rsn_id := null;
367: else
368: l_lee_rsn_id := p_lee_rsn_id;
369: end if;
367: else
368: l_lee_rsn_id := p_lee_rsn_id;
369: end if;
370:
371: if l_pel_uom = hr_api.g_varchar2 then --p_uom
372: l_uom := null;
373: else
374: l_uom := l_pel_uom;
375: end if;
373: else
374: l_uom := l_pel_uom;
375: end if;
376:
377: if p_cls_enrt_dt_to_use_cd = hr_api.g_varchar2 then --p_cls_enrt_dt_to_use_cd
378: l_cls_enrt_dt_to_use_cd := null;
379: else
380: l_cls_enrt_dt_to_use_cd := p_cls_enrt_dt_to_use_cd;
381: end if;
379: else
380: l_cls_enrt_dt_to_use_cd := p_cls_enrt_dt_to_use_cd;
381: end if;
382:
383: if l_pel_acty_ref_perd_cd = hr_api.g_varchar2 then --p_acty_ref_perd_cd
384: l_acty_ref_perd_cd := null;
385: else
386: l_acty_ref_perd_cd := l_pel_acty_ref_perd_cd;
387: end if;
385: else
386: l_acty_ref_perd_cd := l_pel_acty_ref_perd_cd;
387: end if;
388:
389: if p_dflt_enrt_dt = hr_api.g_date then --p_dflt_enrt_dt
390: l_dflt_enrt_dt := null;
391: else
392: l_dflt_enrt_dt := p_dflt_enrt_dt;
393: end if;
391: else
392: l_dflt_enrt_dt := p_dflt_enrt_dt;
393: end if;
394:
395: if p_enrt_perd_end_dt = hr_api.g_date then --p_enrt_perd_end_dt
396: l_enrt_perd_end_dt := null;
397: else
398: l_enrt_perd_end_dt := p_enrt_perd_end_dt;
399: end if;
397: else
398: l_enrt_perd_end_dt := p_enrt_perd_end_dt;
399: end if;
400:
401: if p_enrt_perd_strt_dt = hr_api.g_date then --p_enrt_perd_strt_dt
402: l_enrt_perd_strt_dt := null;
403: else
404: l_enrt_perd_strt_dt := p_enrt_perd_strt_dt;
405: end if;
403: else
404: l_enrt_perd_strt_dt := p_enrt_perd_strt_dt;
405: end if;
406:
407: if p_procg_end_dt = hr_api.g_date then --p_procg_end_dt
408: l_procg_end_dt := null;
409: else
410: l_procg_end_dt := p_procg_end_dt;
411: end if;
857: ,p_program_update_date => p_program_update_date
858: ,p_effective_date => trunc(p_effective_date)
859: );
860: exception
861: when hr_api.cannot_find_prog_unit then
862: hr_api.cannot_find_prog_unit_error
863: (
864: p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
865: ,p_hook_type => 'BP'
858: ,p_effective_date => trunc(p_effective_date)
859: );
860: exception
861: when hr_api.cannot_find_prog_unit then
862: hr_api.cannot_find_prog_unit_error
863: (
864: p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
865: ,p_hook_type => 'BP'
866: );
1078: ,p_object_version_number => l_object_version_number
1079: ,p_effective_date => trunc(p_effective_date)
1080: );
1081: exception
1082: when hr_api.cannot_find_prog_unit then
1083: hr_api.cannot_find_prog_unit_error
1084: (p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
1085: ,p_hook_type => 'AP'
1086: );
1079: ,p_effective_date => trunc(p_effective_date)
1080: );
1081: exception
1082: when hr_api.cannot_find_prog_unit then
1083: hr_api.cannot_find_prog_unit_error
1084: (p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
1085: ,p_hook_type => 'AP'
1086: );
1087: --
1095: --
1096: -- When in validation only mode raise the Validate_Enabled exception
1097: --
1098: if p_validate then
1099: raise hr_api.validate_enabled;
1100: end if;
1101: --
1102: -- Set all output arguments
1103: --
1113: end if;
1114: --
1115: exception
1116: --
1117: when hr_api.validate_enabled then
1118: --
1119: -- As the Validate_Enabled exception has been raised
1120: -- we must rollback to the savepoint
1121: --
1568: --
1569: -- When in validation only mode raise the Validate_Enabled exception
1570: --
1571: if p_validate then
1572: raise hr_api.validate_enabled;
1573: end if;
1574: --
1575: -- Set electable choice current row globals
1576: --
1582: -- Do not call the caching code if called from CWB benmngle mode
1583: --
1584: if nvl(p_mode, 'OAB') <> 'W' then
1585: --
1586: if nvl(ben_epe_cache.g_currcobjepe_row.pl_id,hr_api.g_number) = nvl(p_pl_id,hr_api.g_number)
1587: and nvl(ben_epe_cache.g_currcobjepe_row.plip_id,hr_api.g_number) = nvl(p_plip_id,hr_api.g_number)
1588: and ben_epe_cache.g_currcobjepe_row.oipl_id is not null
1589: and p_oipl_id is null
1590: then
1583: --
1584: if nvl(p_mode, 'OAB') <> 'W' then
1585: --
1586: if nvl(ben_epe_cache.g_currcobjepe_row.pl_id,hr_api.g_number) = nvl(p_pl_id,hr_api.g_number)
1587: and nvl(ben_epe_cache.g_currcobjepe_row.plip_id,hr_api.g_number) = nvl(p_plip_id,hr_api.g_number)
1588: and ben_epe_cache.g_currcobjepe_row.oipl_id is not null
1589: and p_oipl_id is null
1590: then
1591: --
1628: end if;
1629: --
1630: exception
1631: --
1632: when hr_api.validate_enabled then
1633: --
1634: -- As the Validate_Enabled exception has been raised
1635: -- we must rollback to the savepoint
1636: --
1666: --
1667: procedure update_ELIG_PER_ELC_CHC
1668: (p_validate in boolean default false
1669: ,p_elig_per_elctbl_chc_id in number
1670: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1671: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1672: ,p_enrt_perd_end_dt in date default hr_api.g_date
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1667: procedure update_ELIG_PER_ELC_CHC
1668: (p_validate in boolean default false
1669: ,p_elig_per_elctbl_chc_id in number
1670: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1671: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1672: ,p_enrt_perd_end_dt in date default hr_api.g_date
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1668: (p_validate in boolean default false
1669: ,p_elig_per_elctbl_chc_id in number
1670: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1671: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1672: ,p_enrt_perd_end_dt in date default hr_api.g_date
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1669: ,p_elig_per_elctbl_chc_id in number
1670: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1671: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1672: ,p_enrt_perd_end_dt in date default hr_api.g_date
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1670: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1671: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1672: ,p_enrt_perd_end_dt in date default hr_api.g_date
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1671: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1672: ,p_enrt_perd_end_dt in date default hr_api.g_date
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1672: ,p_enrt_perd_end_dt in date default hr_api.g_date
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1715: ,p_plip_ordr_num in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1715: ,p_plip_ordr_num in number default hr_api.g_number
1716: ,p_ptip_ordr_num in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1715: ,p_plip_ordr_num in number default hr_api.g_number
1716: ,p_ptip_ordr_num in number default hr_api.g_number
1717: ,p_oipl_ordr_num in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1715: ,p_plip_ordr_num in number default hr_api.g_number
1716: ,p_ptip_ordr_num in number default hr_api.g_number
1717: ,p_oipl_ordr_num in number default hr_api.g_number
1718: -- cwb
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1715: ,p_plip_ordr_num in number default hr_api.g_number
1716: ,p_ptip_ordr_num in number default hr_api.g_number
1717: ,p_oipl_ordr_num in number default hr_api.g_number
1718: -- cwb
1719: ,p_comments in varchar2 default hr_api.g_varchar2
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1715: ,p_plip_ordr_num in number default hr_api.g_number
1716: ,p_ptip_ordr_num in number default hr_api.g_number
1717: ,p_oipl_ordr_num in number default hr_api.g_number
1718: -- cwb
1719: ,p_comments in varchar2 default hr_api.g_varchar2
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1715: ,p_plip_ordr_num in number default hr_api.g_number
1716: ,p_ptip_ordr_num in number default hr_api.g_number
1717: ,p_oipl_ordr_num in number default hr_api.g_number
1718: -- cwb
1719: ,p_comments in varchar2 default hr_api.g_varchar2
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1715: ,p_plip_ordr_num in number default hr_api.g_number
1716: ,p_ptip_ordr_num in number default hr_api.g_number
1717: ,p_oipl_ordr_num in number default hr_api.g_number
1718: -- cwb
1719: ,p_comments in varchar2 default hr_api.g_varchar2
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1716: ,p_ptip_ordr_num in number default hr_api.g_number
1717: ,p_oipl_ordr_num in number default hr_api.g_number
1718: -- cwb
1719: ,p_comments in varchar2 default hr_api.g_varchar2
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1717: ,p_oipl_ordr_num in number default hr_api.g_number
1718: -- cwb
1719: ,p_comments in varchar2 default hr_api.g_varchar2
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1718: -- cwb
1719: ,p_comments in varchar2 default hr_api.g_varchar2
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1726: ,p_ws_mgr_id in number default hr_api.g_number
1719: ,p_comments in varchar2 default hr_api.g_varchar2
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1726: ,p_ws_mgr_id in number default hr_api.g_number
1727: -- cwb
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1726: ,p_ws_mgr_id in number default hr_api.g_number
1727: -- cwb
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1726: ,p_ws_mgr_id in number default hr_api.g_number
1727: -- cwb
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1726: ,p_ws_mgr_id in number default hr_api.g_number
1727: -- cwb
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1726: ,p_ws_mgr_id in number default hr_api.g_number
1727: -- cwb
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1726: ,p_ws_mgr_id in number default hr_api.g_number
1727: -- cwb
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1726: ,p_ws_mgr_id in number default hr_api.g_number
1727: -- cwb
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1727: -- cwb
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1763: ,p_program_application_id in number default hr_api.g_number
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1763: ,p_program_application_id in number default hr_api.g_number
1764: ,p_program_id in number default hr_api.g_number
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1763: ,p_program_application_id in number default hr_api.g_number
1764: ,p_program_id in number default hr_api.g_number
1765: ,p_program_update_date in date default hr_api.g_date
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1763: ,p_program_application_id in number default hr_api.g_number
1764: ,p_program_id in number default hr_api.g_number
1765: ,p_program_update_date in date default hr_api.g_date
1766: ,p_object_version_number in out nocopy number
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1763: ,p_program_application_id in number default hr_api.g_number
1764: ,p_program_id in number default hr_api.g_number
1765: ,p_program_update_date in date default hr_api.g_date
1766: ,p_object_version_number in out nocopy number
1767: ,p_effective_date in date
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1763: ,p_program_application_id in number default hr_api.g_number
1764: ,p_program_id in number default hr_api.g_number
1765: ,p_program_update_date in date default hr_api.g_date
1766: ,p_object_version_number in out nocopy number
1767: ,p_effective_date in date
1768: ) is
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1763: ,p_program_application_id in number default hr_api.g_number
1764: ,p_program_id in number default hr_api.g_number
1765: ,p_program_update_date in date default hr_api.g_date
1766: ,p_object_version_number in out nocopy number
1767: ,p_effective_date in date
1768: ) is
1769: --
1890: ,p_object_version_number => p_object_version_number
1891: ,p_effective_date => trunc(p_effective_date)
1892: );
1893: exception
1894: when hr_api.cannot_find_prog_unit then
1895: hr_api.cannot_find_prog_unit_error
1896: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
1897: ,p_hook_type => 'BP'
1898: );
1891: ,p_effective_date => trunc(p_effective_date)
1892: );
1893: exception
1894: when hr_api.cannot_find_prog_unit then
1895: hr_api.cannot_find_prog_unit_error
1896: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
1897: ,p_hook_type => 'BP'
1898: );
1899: --
2108: ,p_object_version_number => l_object_version_number
2109: ,p_effective_date => trunc(p_effective_date)
2110: );
2111: exception
2112: when hr_api.cannot_find_prog_unit then
2113: hr_api.cannot_find_prog_unit_error
2114: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
2115: ,p_hook_type => 'AP'
2116: );
2109: ,p_effective_date => trunc(p_effective_date)
2110: );
2111: exception
2112: when hr_api.cannot_find_prog_unit then
2113: hr_api.cannot_find_prog_unit_error
2114: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
2115: ,p_hook_type => 'AP'
2116: );
2117: --
2125: --
2126: -- When in validation only mode raise the Validate_Enabled exception
2127: --
2128: if p_validate then
2129: raise hr_api.validate_enabled;
2130: end if;
2131: --
2132: -- Set all output arguments
2133: --
2138: end if;
2139: --
2140: exception
2141: --
2142: when hr_api.validate_enabled then
2143: --
2144: -- As the Validate_Enabled exception has been raised
2145: -- we must rollback to the savepoint
2146: --
2237: --
2238: procedure update_perf_ELIG_PER_ELC_CHC
2239: (p_validate in boolean default false
2240: ,p_elig_per_elctbl_chc_id in number
2241: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2242: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2243: --,p_enrt_perd_end_dt in date default hr_api.g_date
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2238: procedure update_perf_ELIG_PER_ELC_CHC
2239: (p_validate in boolean default false
2240: ,p_elig_per_elctbl_chc_id in number
2241: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2242: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2243: --,p_enrt_perd_end_dt in date default hr_api.g_date
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2239: (p_validate in boolean default false
2240: ,p_elig_per_elctbl_chc_id in number
2241: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2242: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2243: --,p_enrt_perd_end_dt in date default hr_api.g_date
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2240: ,p_elig_per_elctbl_chc_id in number
2241: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2242: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2243: --,p_enrt_perd_end_dt in date default hr_api.g_date
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2241: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2242: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2243: --,p_enrt_perd_end_dt in date default hr_api.g_date
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2242: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2243: --,p_enrt_perd_end_dt in date default hr_api.g_date
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2243: --,p_enrt_perd_end_dt in date default hr_api.g_date
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2286: ,p_plip_ordr_num in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2286: ,p_plip_ordr_num in number default hr_api.g_number
2287: ,p_ptip_ordr_num in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2286: ,p_plip_ordr_num in number default hr_api.g_number
2287: ,p_ptip_ordr_num in number default hr_api.g_number
2288: ,p_oipl_ordr_num in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2286: ,p_plip_ordr_num in number default hr_api.g_number
2287: ,p_ptip_ordr_num in number default hr_api.g_number
2288: ,p_oipl_ordr_num in number default hr_api.g_number
2289: -- cwb
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2286: ,p_plip_ordr_num in number default hr_api.g_number
2287: ,p_ptip_ordr_num in number default hr_api.g_number
2288: ,p_oipl_ordr_num in number default hr_api.g_number
2289: -- cwb
2290: ,p_comments in varchar2 default hr_api.g_varchar2
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2286: ,p_plip_ordr_num in number default hr_api.g_number
2287: ,p_ptip_ordr_num in number default hr_api.g_number
2288: ,p_oipl_ordr_num in number default hr_api.g_number
2289: -- cwb
2290: ,p_comments in varchar2 default hr_api.g_varchar2
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2286: ,p_plip_ordr_num in number default hr_api.g_number
2287: ,p_ptip_ordr_num in number default hr_api.g_number
2288: ,p_oipl_ordr_num in number default hr_api.g_number
2289: -- cwb
2290: ,p_comments in varchar2 default hr_api.g_varchar2
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2286: ,p_plip_ordr_num in number default hr_api.g_number
2287: ,p_ptip_ordr_num in number default hr_api.g_number
2288: ,p_oipl_ordr_num in number default hr_api.g_number
2289: -- cwb
2290: ,p_comments in varchar2 default hr_api.g_varchar2
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2287: ,p_ptip_ordr_num in number default hr_api.g_number
2288: ,p_oipl_ordr_num in number default hr_api.g_number
2289: -- cwb
2290: ,p_comments in varchar2 default hr_api.g_varchar2
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2288: ,p_oipl_ordr_num in number default hr_api.g_number
2289: -- cwb
2290: ,p_comments in varchar2 default hr_api.g_varchar2
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2289: -- cwb
2290: ,p_comments in varchar2 default hr_api.g_varchar2
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2297: ,p_ws_mgr_id in number default hr_api.g_number
2290: ,p_comments in varchar2 default hr_api.g_varchar2
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2297: ,p_ws_mgr_id in number default hr_api.g_number
2298: -- cwb
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2297: ,p_ws_mgr_id in number default hr_api.g_number
2298: -- cwb
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2297: ,p_ws_mgr_id in number default hr_api.g_number
2298: -- cwb
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2297: ,p_ws_mgr_id in number default hr_api.g_number
2298: -- cwb
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2297: ,p_ws_mgr_id in number default hr_api.g_number
2298: -- cwb
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2297: ,p_ws_mgr_id in number default hr_api.g_number
2298: -- cwb
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2297: ,p_ws_mgr_id in number default hr_api.g_number
2298: -- cwb
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2298: -- cwb
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2334: ,p_program_application_id in number default hr_api.g_number
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2334: ,p_program_application_id in number default hr_api.g_number
2335: ,p_program_id in number default hr_api.g_number
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2334: ,p_program_application_id in number default hr_api.g_number
2335: ,p_program_id in number default hr_api.g_number
2336: ,p_program_update_date in date default hr_api.g_date
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2334: ,p_program_application_id in number default hr_api.g_number
2335: ,p_program_id in number default hr_api.g_number
2336: ,p_program_update_date in date default hr_api.g_date
2337: ,p_object_version_number in out nocopy number
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2334: ,p_program_application_id in number default hr_api.g_number
2335: ,p_program_id in number default hr_api.g_number
2336: ,p_program_update_date in date default hr_api.g_date
2337: ,p_object_version_number in out nocopy number
2338: ,p_effective_date in date
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2334: ,p_program_application_id in number default hr_api.g_number
2335: ,p_program_id in number default hr_api.g_number
2336: ,p_program_update_date in date default hr_api.g_date
2337: ,p_object_version_number in out nocopy number
2338: ,p_effective_date in date
2339: )
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2334: ,p_program_application_id in number default hr_api.g_number
2335: ,p_program_id in number default hr_api.g_number
2336: ,p_program_update_date in date default hr_api.g_date
2337: ,p_object_version_number in out nocopy number
2338: ,p_effective_date in date
2339: )
2340: is
2497: --
2498: --CWB
2499: -- Check only if the new manager is not null or defaulted.
2500: --
2501: if (nvl(p_ws_mgr_id, hr_api.g_number) <> hr_api.g_number) and
2502: (nvl(ben_epe_shd.g_old_rec.ws_mgr_id,-1) <> nvl(p_ws_mgr_id,-1))
2503: then
2504: chk_valid_mgr(p_elig_per_elctbl_chc_id,p_ws_mgr_id,p_effective_date);
2505: end if;
2629: --
2630: -- When in validation only mode raise the Validate_Enabled exception
2631: --
2632: if p_validate then
2633: raise hr_api.validate_enabled;
2634: end if;
2635: --
2636: -- Set EPE comp object context values
2637: --
2666: end if;
2667: --
2668: exception
2669: --
2670: when hr_api.validate_enabled then
2671: --
2672: -- As the Validate_Enabled exception has been raised
2673: -- we must rollback to the savepoint
2674: --
2813: ,p_object_version_number => p_object_version_number
2814: ,p_effective_date => trunc(p_effective_date)
2815: );
2816: exception
2817: when hr_api.cannot_find_prog_unit then
2818: hr_api.cannot_find_prog_unit_error
2819: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2820: ,p_hook_type => 'BP'
2821: );
2814: ,p_effective_date => trunc(p_effective_date)
2815: );
2816: exception
2817: when hr_api.cannot_find_prog_unit then
2818: hr_api.cannot_find_prog_unit_error
2819: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2820: ,p_hook_type => 'BP'
2821: );
2822: --
2873: ,p_object_version_number => l_object_version_number
2874: ,p_effective_date => trunc(p_effective_date)
2875: );
2876: exception
2877: when hr_api.cannot_find_prog_unit then
2878: hr_api.cannot_find_prog_unit_error
2879: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2880: ,p_hook_type => 'AP'
2881: );
2874: ,p_effective_date => trunc(p_effective_date)
2875: );
2876: exception
2877: when hr_api.cannot_find_prog_unit then
2878: hr_api.cannot_find_prog_unit_error
2879: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2880: ,p_hook_type => 'AP'
2881: );
2882: --
2890: --
2891: -- When in validation only mode raise the Validate_Enabled exception
2892: --
2893: if p_validate then
2894: raise hr_api.validate_enabled;
2895: end if;
2896: --
2897: if g_debug then
2898: hr_utility.set_location(' Leaving:'||l_proc, 70);
2899: end if;
2900: --
2901: exception
2902: --
2903: when hr_api.validate_enabled then
2904: --
2905: -- As the Validate_Enabled exception has been raised
2906: -- we must rollback to the savepoint
2907: --