DBA Data[Home] [Help]

APPS.BEN_ELIG_PER_ELC_CHC_API dependencies on HR_API

Line 348: --are erroneously set to default(values from HR_API package),

344: --
345: end if;
346: --
347: --Bug 4068639 : When Creating PIL record, if some of the parameters
348: --are erroneously set to default(values from HR_API package),
349: --then pass their default value in create_Pil_Elctbl_chc_Popl procedure.
350:
351: if p_enrt_perd_id = hr_api.g_number then --p_enrt_perd_id
352: l_enrt_perd_id := null;

Line 351: if p_enrt_perd_id = hr_api.g_number then --p_enrt_perd_id

347: --Bug 4068639 : When Creating PIL record, if some of the parameters
348: --are erroneously set to default(values from HR_API package),
349: --then pass their default value in create_Pil_Elctbl_chc_Popl procedure.
350:
351: if p_enrt_perd_id = hr_api.g_number then --p_enrt_perd_id
352: l_enrt_perd_id := null;
353: else
354: l_enrt_perd_id := p_enrt_perd_id;
355: end if;

Line 357: if l_pel_pgm_id = hr_api.g_number then --p_pgm_id

353: else
354: l_enrt_perd_id := p_enrt_perd_id;
355: end if;
356:
357: if l_pel_pgm_id = hr_api.g_number then --p_pgm_id
358: l_pgm_id := null;
359: else
360: l_pgm_id := l_pel_pgm_id;
361: end if;

Line 363: if l_pel_pl_id = hr_api.g_number then --p_pl_id

359: else
360: l_pgm_id := l_pel_pgm_id;
361: end if;
362:
363: if l_pel_pl_id = hr_api.g_number then --p_pl_id
364: l_pl_id := null;
365: else
366: l_pl_id := l_pel_pl_id;
367: end if;

Line 369: if p_lee_rsn_id = hr_api.g_number then --p_lee_rsn_id

365: else
366: l_pl_id := l_pel_pl_id;
367: end if;
368:
369: if p_lee_rsn_id = hr_api.g_number then --p_lee_rsn_id
370: l_lee_rsn_id := null;
371: else
372: l_lee_rsn_id := p_lee_rsn_id;
373: end if;

Line 375: if l_pel_uom = hr_api.g_varchar2 then --p_uom

371: else
372: l_lee_rsn_id := p_lee_rsn_id;
373: end if;
374:
375: if l_pel_uom = hr_api.g_varchar2 then --p_uom
376: l_uom := null;
377: else
378: l_uom := l_pel_uom;
379: end if;

Line 381: if p_cls_enrt_dt_to_use_cd = hr_api.g_varchar2 then --p_cls_enrt_dt_to_use_cd

377: else
378: l_uom := l_pel_uom;
379: end if;
380:
381: if p_cls_enrt_dt_to_use_cd = hr_api.g_varchar2 then --p_cls_enrt_dt_to_use_cd
382: l_cls_enrt_dt_to_use_cd := null;
383: else
384: l_cls_enrt_dt_to_use_cd := p_cls_enrt_dt_to_use_cd;
385: end if;

Line 387: if l_pel_acty_ref_perd_cd = hr_api.g_varchar2 then --p_acty_ref_perd_cd

383: else
384: l_cls_enrt_dt_to_use_cd := p_cls_enrt_dt_to_use_cd;
385: end if;
386:
387: if l_pel_acty_ref_perd_cd = hr_api.g_varchar2 then --p_acty_ref_perd_cd
388: l_acty_ref_perd_cd := null;
389: else
390: l_acty_ref_perd_cd := l_pel_acty_ref_perd_cd;
391: end if;

Line 393: if p_dflt_enrt_dt = hr_api.g_date then --p_dflt_enrt_dt

389: else
390: l_acty_ref_perd_cd := l_pel_acty_ref_perd_cd;
391: end if;
392:
393: if p_dflt_enrt_dt = hr_api.g_date then --p_dflt_enrt_dt
394: l_dflt_enrt_dt := null;
395: else
396: l_dflt_enrt_dt := p_dflt_enrt_dt;
397: end if;

Line 399: if p_enrt_perd_end_dt = hr_api.g_date then --p_enrt_perd_end_dt

395: else
396: l_dflt_enrt_dt := p_dflt_enrt_dt;
397: end if;
398:
399: if p_enrt_perd_end_dt = hr_api.g_date then --p_enrt_perd_end_dt
400: l_enrt_perd_end_dt := null;
401: else
402: l_enrt_perd_end_dt := p_enrt_perd_end_dt;
403: end if;

Line 405: if p_enrt_perd_strt_dt = hr_api.g_date then --p_enrt_perd_strt_dt

401: else
402: l_enrt_perd_end_dt := p_enrt_perd_end_dt;
403: end if;
404:
405: if p_enrt_perd_strt_dt = hr_api.g_date then --p_enrt_perd_strt_dt
406: l_enrt_perd_strt_dt := null;
407: else
408: l_enrt_perd_strt_dt := p_enrt_perd_strt_dt;
409: end if;

Line 411: if p_procg_end_dt = hr_api.g_date then --p_procg_end_dt

407: else
408: l_enrt_perd_strt_dt := p_enrt_perd_strt_dt;
409: end if;
410:
411: if p_procg_end_dt = hr_api.g_date then --p_procg_end_dt
412: l_procg_end_dt := null;
413: else
414: l_procg_end_dt := p_procg_end_dt;
415: end if;

Line 866: when hr_api.cannot_find_prog_unit then

862: ,p_program_update_date => p_program_update_date
863: ,p_effective_date => trunc(p_effective_date)
864: );
865: exception
866: when hr_api.cannot_find_prog_unit then
867: hr_api.cannot_find_prog_unit_error
868: (
869: p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
870: ,p_hook_type => 'BP'

Line 867: hr_api.cannot_find_prog_unit_error

863: ,p_effective_date => trunc(p_effective_date)
864: );
865: exception
866: when hr_api.cannot_find_prog_unit then
867: hr_api.cannot_find_prog_unit_error
868: (
869: p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
870: ,p_hook_type => 'BP'
871: );

Line 1087: when hr_api.cannot_find_prog_unit then

1083: ,p_object_version_number => l_object_version_number
1084: ,p_effective_date => trunc(p_effective_date)
1085: );
1086: exception
1087: when hr_api.cannot_find_prog_unit then
1088: hr_api.cannot_find_prog_unit_error
1089: (p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
1090: ,p_hook_type => 'AP'
1091: );

Line 1088: hr_api.cannot_find_prog_unit_error

1084: ,p_effective_date => trunc(p_effective_date)
1085: );
1086: exception
1087: when hr_api.cannot_find_prog_unit then
1088: hr_api.cannot_find_prog_unit_error
1089: (p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
1090: ,p_hook_type => 'AP'
1091: );
1092: --

Line 1104: raise hr_api.validate_enabled;

1100: --
1101: -- When in validation only mode raise the Validate_Enabled exception
1102: --
1103: if p_validate then
1104: raise hr_api.validate_enabled;
1105: end if;
1106: --
1107: -- Set all output arguments
1108: --

Line 1122: when hr_api.validate_enabled then

1118: end if;
1119: --
1120: exception
1121: --
1122: when hr_api.validate_enabled then
1123: --
1124: -- As the Validate_Enabled exception has been raised
1125: -- we must rollback to the savepoint
1126: --

Line 1577: raise hr_api.validate_enabled;

1573: --
1574: -- When in validation only mode raise the Validate_Enabled exception
1575: --
1576: if p_validate then
1577: raise hr_api.validate_enabled;
1578: end if;
1579: --
1580: -- Set electable choice current row globals
1581: --

Line 1591: if nvl(ben_epe_cache.g_currcobjepe_row.pl_id,hr_api.g_number) = nvl(p_pl_id,hr_api.g_number)

1587: -- Do not call the caching code if called from CWB benmngle mode
1588: --
1589: if nvl(p_mode, 'OAB') <> 'W' then
1590: --
1591: if nvl(ben_epe_cache.g_currcobjepe_row.pl_id,hr_api.g_number) = nvl(p_pl_id,hr_api.g_number)
1592: and nvl(ben_epe_cache.g_currcobjepe_row.plip_id,hr_api.g_number) = nvl(p_plip_id,hr_api.g_number)
1593: and ben_epe_cache.g_currcobjepe_row.oipl_id is not null
1594: and p_oipl_id is null
1595: then

Line 1592: and nvl(ben_epe_cache.g_currcobjepe_row.plip_id,hr_api.g_number) = nvl(p_plip_id,hr_api.g_number)

1588: --
1589: if nvl(p_mode, 'OAB') <> 'W' then
1590: --
1591: if nvl(ben_epe_cache.g_currcobjepe_row.pl_id,hr_api.g_number) = nvl(p_pl_id,hr_api.g_number)
1592: and nvl(ben_epe_cache.g_currcobjepe_row.plip_id,hr_api.g_number) = nvl(p_plip_id,hr_api.g_number)
1593: and ben_epe_cache.g_currcobjepe_row.oipl_id is not null
1594: and p_oipl_id is null
1595: then
1596: --

Line 1637: when hr_api.validate_enabled then

1633: end if;
1634: --
1635: exception
1636: --
1637: when hr_api.validate_enabled then
1638: --
1639: -- As the Validate_Enabled exception has been raised
1640: -- we must rollback to the savepoint
1641: --

Line 1675: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2

1671: --
1672: procedure update_ELIG_PER_ELC_CHC
1673: (p_validate in boolean default false
1674: ,p_elig_per_elctbl_chc_id in number
1675: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1676: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1677: ,p_enrt_perd_end_dt in date default hr_api.g_date
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

Line 1676: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

1672: procedure update_ELIG_PER_ELC_CHC
1673: (p_validate in boolean default false
1674: ,p_elig_per_elctbl_chc_id in number
1675: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1676: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1677: ,p_enrt_perd_end_dt in date default hr_api.g_date
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

Line 1677: ,p_enrt_perd_end_dt in date default hr_api.g_date

1673: (p_validate in boolean default false
1674: ,p_elig_per_elctbl_chc_id in number
1675: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1676: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1677: ,p_enrt_perd_end_dt in date default hr_api.g_date
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number

Line 1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date

1674: ,p_elig_per_elctbl_chc_id in number
1675: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1676: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1677: ,p_enrt_perd_end_dt in date default hr_api.g_date
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2

Line 1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

1675: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1676: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1677: ,p_enrt_perd_end_dt in date default hr_api.g_date
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2

Line 1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

1676: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1677: ,p_enrt_perd_end_dt in date default hr_api.g_date
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

Line 1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number

1677: ,p_enrt_perd_end_dt in date default hr_api.g_date
1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2

Line 1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2

1678: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2

Line 1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2

1679: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2

Line 1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

1680: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date

Line 1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2

1681: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

Line 1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2

1682: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

Line 1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2

1683: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

Line 1688: ,p_dflt_enrt_dt in date default hr_api.g_date

1684: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2

Line 1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

1685: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2

Line 1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

1686: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2

Line 1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

1687: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date

Line 1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2

1688: ,p_dflt_enrt_dt in date default hr_api.g_date
1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date

Line 1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2

1689: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2

Line 1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2

1690: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number

Line 1695: ,p_erlst_deenrt_dt in date default hr_api.g_date

1691: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number

Line 1696: ,p_procg_end_dt in date default hr_api.g_date

1692: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number

Line 1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2

1693: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number

Line 1698: ,p_pl_id in number default hr_api.g_number

1694: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number

Line 1699: ,p_oipl_id in number default hr_api.g_number

1695: ,p_erlst_deenrt_dt in date default hr_api.g_date
1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number

Line 1700: ,p_pgm_id in number default hr_api.g_number

1696: ,p_procg_end_dt in date default hr_api.g_date
1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number

Line 1701: ,p_plip_id in number default hr_api.g_number

1697: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number

Line 1702: ,p_ptip_id in number default hr_api.g_number

1698: ,p_pl_id in number default hr_api.g_number
1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number

Line 1703: ,p_pl_typ_id in number default hr_api.g_number

1699: ,p_oipl_id in number default hr_api.g_number
1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

Line 1704: ,p_oiplip_id in number default hr_api.g_number

1700: ,p_pgm_id in number default hr_api.g_number
1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number

Line 1705: ,p_cmbn_plip_id in number default hr_api.g_number

1701: ,p_plip_id in number default hr_api.g_number
1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number

Line 1706: ,p_cmbn_ptip_id in number default hr_api.g_number

1702: ,p_ptip_id in number default hr_api.g_number
1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number

Line 1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

1703: ,p_pl_typ_id in number default hr_api.g_number
1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number

Line 1708: ,p_assignment_id in number default hr_api.g_number

1704: ,p_oiplip_id in number default hr_api.g_number
1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number

Line 1709: ,p_spcl_rt_pl_id in number default hr_api.g_number

1705: ,p_cmbn_plip_id in number default hr_api.g_number
1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

Line 1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number

1706: ,p_cmbn_ptip_id in number default hr_api.g_number
1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

Line 1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number

1707: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number

Line 1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number

1708: ,p_assignment_id in number default hr_api.g_number
1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number

Line 1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

1709: ,p_spcl_rt_pl_id in number default hr_api.g_number
1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2

Line 1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

1710: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number

Line 1715: ,p_per_in_ler_id in number default hr_api.g_number

1711: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number

Line 1716: ,p_yr_perd_id in number default hr_api.g_number

1712: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1720: ,p_plip_ordr_num in number default hr_api.g_number

Line 1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2

1713: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1720: ,p_plip_ordr_num in number default hr_api.g_number
1721: ,p_ptip_ordr_num in number default hr_api.g_number

Line 1718: ,p_business_group_id in number default hr_api.g_number

1714: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1720: ,p_plip_ordr_num in number default hr_api.g_number
1721: ,p_ptip_ordr_num in number default hr_api.g_number
1722: ,p_oipl_ordr_num in number default hr_api.g_number

Line 1719: ,p_pl_ordr_num in number default hr_api.g_number

1715: ,p_per_in_ler_id in number default hr_api.g_number
1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1720: ,p_plip_ordr_num in number default hr_api.g_number
1721: ,p_ptip_ordr_num in number default hr_api.g_number
1722: ,p_oipl_ordr_num in number default hr_api.g_number
1723: -- cwb

Line 1720: ,p_plip_ordr_num in number default hr_api.g_number

1716: ,p_yr_perd_id in number default hr_api.g_number
1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1720: ,p_plip_ordr_num in number default hr_api.g_number
1721: ,p_ptip_ordr_num in number default hr_api.g_number
1722: ,p_oipl_ordr_num in number default hr_api.g_number
1723: -- cwb
1724: ,p_comments in varchar2 default hr_api.g_varchar2

Line 1721: ,p_ptip_ordr_num in number default hr_api.g_number

1717: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1720: ,p_plip_ordr_num in number default hr_api.g_number
1721: ,p_ptip_ordr_num in number default hr_api.g_number
1722: ,p_oipl_ordr_num in number default hr_api.g_number
1723: -- cwb
1724: ,p_comments in varchar2 default hr_api.g_varchar2
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2

Line 1722: ,p_oipl_ordr_num in number default hr_api.g_number

1718: ,p_business_group_id in number default hr_api.g_number
1719: ,p_pl_ordr_num in number default hr_api.g_number
1720: ,p_plip_ordr_num in number default hr_api.g_number
1721: ,p_ptip_ordr_num in number default hr_api.g_number
1722: ,p_oipl_ordr_num in number default hr_api.g_number
1723: -- cwb
1724: ,p_comments in varchar2 default hr_api.g_varchar2
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date

Line 1724: ,p_comments in varchar2 default hr_api.g_varchar2

1720: ,p_plip_ordr_num in number default hr_api.g_number
1721: ,p_ptip_ordr_num in number default hr_api.g_number
1722: ,p_oipl_ordr_num in number default hr_api.g_number
1723: -- cwb
1724: ,p_comments in varchar2 default hr_api.g_varchar2
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2

Line 1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2

1721: ,p_ptip_ordr_num in number default hr_api.g_number
1722: ,p_oipl_ordr_num in number default hr_api.g_number
1723: -- cwb
1724: ,p_comments in varchar2 default hr_api.g_varchar2
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date

Line 1726: ,p_elig_ovrid_dt in date default hr_api.g_date

1722: ,p_oipl_ordr_num in number default hr_api.g_number
1723: -- cwb
1724: ,p_comments in varchar2 default hr_api.g_varchar2
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number

Line 1727: ,p_elig_ovrid_person_id in number default hr_api.g_number

1723: -- cwb
1724: ,p_comments in varchar2 default hr_api.g_varchar2
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1731: ,p_ws_mgr_id in number default hr_api.g_number

Line 1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2

1724: ,p_comments in varchar2 default hr_api.g_varchar2
1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1731: ,p_ws_mgr_id in number default hr_api.g_number
1732: -- cwb

Line 1729: ,p_mgr_ovrid_dt in date default hr_api.g_date

1725: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1731: ,p_ws_mgr_id in number default hr_api.g_number
1732: -- cwb
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2

Line 1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number

1726: ,p_elig_ovrid_dt in date default hr_api.g_date
1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1731: ,p_ws_mgr_id in number default hr_api.g_number
1732: -- cwb
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2

Line 1731: ,p_ws_mgr_id in number default hr_api.g_number

1727: ,p_elig_ovrid_person_id in number default hr_api.g_number
1728: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1731: ,p_ws_mgr_id in number default hr_api.g_number
1732: -- cwb
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2

Line 1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2

1729: ,p_mgr_ovrid_dt in date default hr_api.g_date
1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1731: ,p_ws_mgr_id in number default hr_api.g_number
1732: -- cwb
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2

Line 1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2

1730: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1731: ,p_ws_mgr_id in number default hr_api.g_number
1732: -- cwb
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2

Line 1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2

1731: ,p_ws_mgr_id in number default hr_api.g_number
1732: -- cwb
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2

Line 1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2

1732: -- cwb
1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2

Line 1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2

1733: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2

Line 1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2

1734: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2

Line 1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2

1735: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2

Line 1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2

1736: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2

Line 1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2

1737: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2

Line 1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2

1738: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2

Line 1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2

1739: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2

Line 1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2

1740: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2

Line 1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2

1741: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2

Line 1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2

1742: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2

Line 1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2

1743: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2

Line 1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2

1744: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2

Line 1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2

1745: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2

Line 1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2

1746: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2

Line 1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2

1747: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2

Line 1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2

1748: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2

Line 1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2

1749: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2

Line 1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2

1750: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2

Line 1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2

1751: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2

Line 1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2

1752: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2

Line 1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2

1753: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2

Line 1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2

1754: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2

Line 1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2

1755: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2

Line 1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2

1756: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2

Line 1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2

1757: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date

Line 1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2

1758: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2

Line 1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2

1759: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number

Line 1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2

1760: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1768: ,p_program_application_id in number default hr_api.g_number

Line 1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date

1761: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1768: ,p_program_application_id in number default hr_api.g_number
1769: ,p_program_id in number default hr_api.g_number

Line 1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2

1762: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1768: ,p_program_application_id in number default hr_api.g_number
1769: ,p_program_id in number default hr_api.g_number
1770: ,p_program_update_date in date default hr_api.g_date

Line 1767: ,p_request_id in number default hr_api.g_number

1763: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1768: ,p_program_application_id in number default hr_api.g_number
1769: ,p_program_id in number default hr_api.g_number
1770: ,p_program_update_date in date default hr_api.g_date
1771: ,p_object_version_number in out nocopy number

Line 1768: ,p_program_application_id in number default hr_api.g_number

1764: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1768: ,p_program_application_id in number default hr_api.g_number
1769: ,p_program_id in number default hr_api.g_number
1770: ,p_program_update_date in date default hr_api.g_date
1771: ,p_object_version_number in out nocopy number
1772: ,p_effective_date in date

Line 1769: ,p_program_id in number default hr_api.g_number

1765: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1768: ,p_program_application_id in number default hr_api.g_number
1769: ,p_program_id in number default hr_api.g_number
1770: ,p_program_update_date in date default hr_api.g_date
1771: ,p_object_version_number in out nocopy number
1772: ,p_effective_date in date
1773: ) is

Line 1770: ,p_program_update_date in date default hr_api.g_date

1766: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1767: ,p_request_id in number default hr_api.g_number
1768: ,p_program_application_id in number default hr_api.g_number
1769: ,p_program_id in number default hr_api.g_number
1770: ,p_program_update_date in date default hr_api.g_date
1771: ,p_object_version_number in out nocopy number
1772: ,p_effective_date in date
1773: ) is
1774: --

Line 1899: when hr_api.cannot_find_prog_unit then

1895: ,p_object_version_number => p_object_version_number
1896: ,p_effective_date => trunc(p_effective_date)
1897: );
1898: exception
1899: when hr_api.cannot_find_prog_unit then
1900: hr_api.cannot_find_prog_unit_error
1901: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
1902: ,p_hook_type => 'BP'
1903: );

Line 1900: hr_api.cannot_find_prog_unit_error

1896: ,p_effective_date => trunc(p_effective_date)
1897: );
1898: exception
1899: when hr_api.cannot_find_prog_unit then
1900: hr_api.cannot_find_prog_unit_error
1901: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
1902: ,p_hook_type => 'BP'
1903: );
1904: --

Line 2117: when hr_api.cannot_find_prog_unit then

2113: ,p_object_version_number => l_object_version_number
2114: ,p_effective_date => trunc(p_effective_date)
2115: );
2116: exception
2117: when hr_api.cannot_find_prog_unit then
2118: hr_api.cannot_find_prog_unit_error
2119: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
2120: ,p_hook_type => 'AP'
2121: );

Line 2118: hr_api.cannot_find_prog_unit_error

2114: ,p_effective_date => trunc(p_effective_date)
2115: );
2116: exception
2117: when hr_api.cannot_find_prog_unit then
2118: hr_api.cannot_find_prog_unit_error
2119: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
2120: ,p_hook_type => 'AP'
2121: );
2122: --

Line 2134: raise hr_api.validate_enabled;

2130: --
2131: -- When in validation only mode raise the Validate_Enabled exception
2132: --
2133: if p_validate then
2134: raise hr_api.validate_enabled;
2135: end if;
2136: --
2137: -- Set all output arguments
2138: --

Line 2147: when hr_api.validate_enabled then

2143: end if;
2144: --
2145: exception
2146: --
2147: when hr_api.validate_enabled then
2148: --
2149: -- As the Validate_Enabled exception has been raised
2150: -- we must rollback to the savepoint
2151: --

Line 2246: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2

2242: --
2243: procedure update_perf_ELIG_PER_ELC_CHC
2244: (p_validate in boolean default false
2245: ,p_elig_per_elctbl_chc_id in number
2246: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2247: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2248: --,p_enrt_perd_end_dt in date default hr_api.g_date
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

Line 2247: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

2243: procedure update_perf_ELIG_PER_ELC_CHC
2244: (p_validate in boolean default false
2245: ,p_elig_per_elctbl_chc_id in number
2246: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2247: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2248: --,p_enrt_perd_end_dt in date default hr_api.g_date
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

Line 2248: --,p_enrt_perd_end_dt in date default hr_api.g_date

2244: (p_validate in boolean default false
2245: ,p_elig_per_elctbl_chc_id in number
2246: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2247: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2248: --,p_enrt_perd_end_dt in date default hr_api.g_date
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number

Line 2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date

2245: ,p_elig_per_elctbl_chc_id in number
2246: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2247: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2248: --,p_enrt_perd_end_dt in date default hr_api.g_date
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2

Line 2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

2246: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2247: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2248: --,p_enrt_perd_end_dt in date default hr_api.g_date
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2

Line 2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

2247: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2248: --,p_enrt_perd_end_dt in date default hr_api.g_date
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

Line 2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number

2248: --,p_enrt_perd_end_dt in date default hr_api.g_date
2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2

Line 2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2

2249: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2

Line 2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2

2250: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2

Line 2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

2251: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date

Line 2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2

2252: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

Line 2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2

2253: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

Line 2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2

2254: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

Line 2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date

2255: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2

Line 2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

2256: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2

Line 2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

2257: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2

Line 2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

2258: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date

Line 2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2

2259: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date

Line 2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2

2260: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2

Line 2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2

2261: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number

Line 2266: ,p_erlst_deenrt_dt in date default hr_api.g_date

2262: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number

Line 2267: ,p_procg_end_dt in date default hr_api.g_date

2263: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number

Line 2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2

2264: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number

Line 2269: ,p_pl_id in number default hr_api.g_number

2265: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number

Line 2270: ,p_oipl_id in number default hr_api.g_number

2266: ,p_erlst_deenrt_dt in date default hr_api.g_date
2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number

Line 2271: ,p_pgm_id in number default hr_api.g_number

2267: ,p_procg_end_dt in date default hr_api.g_date
2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number

Line 2272: ,p_plip_id in number default hr_api.g_number

2268: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number

Line 2273: ,p_ptip_id in number default hr_api.g_number

2269: ,p_pl_id in number default hr_api.g_number
2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number

Line 2274: ,p_pl_typ_id in number default hr_api.g_number

2270: ,p_oipl_id in number default hr_api.g_number
2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

Line 2275: ,p_oiplip_id in number default hr_api.g_number

2271: ,p_pgm_id in number default hr_api.g_number
2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number

Line 2276: ,p_cmbn_plip_id in number default hr_api.g_number

2272: ,p_plip_id in number default hr_api.g_number
2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number

Line 2277: ,p_cmbn_ptip_id in number default hr_api.g_number

2273: ,p_ptip_id in number default hr_api.g_number
2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number

Line 2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

2274: ,p_pl_typ_id in number default hr_api.g_number
2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number

Line 2279: ,p_assignment_id in number default hr_api.g_number

2275: ,p_oiplip_id in number default hr_api.g_number
2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number

Line 2280: ,p_spcl_rt_pl_id in number default hr_api.g_number

2276: ,p_cmbn_plip_id in number default hr_api.g_number
2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

Line 2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number

2277: ,p_cmbn_ptip_id in number default hr_api.g_number
2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

Line 2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number

2278: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number

Line 2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number

2279: ,p_assignment_id in number default hr_api.g_number
2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number

Line 2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

2280: ,p_spcl_rt_pl_id in number default hr_api.g_number
2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2

Line 2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

2281: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number

Line 2286: ,p_per_in_ler_id in number default hr_api.g_number

2282: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number

Line 2287: ,p_yr_perd_id in number default hr_api.g_number

2283: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2291: ,p_plip_ordr_num in number default hr_api.g_number

Line 2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2

2284: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2291: ,p_plip_ordr_num in number default hr_api.g_number
2292: ,p_ptip_ordr_num in number default hr_api.g_number

Line 2289: ,p_business_group_id in number default hr_api.g_number

2285: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2291: ,p_plip_ordr_num in number default hr_api.g_number
2292: ,p_ptip_ordr_num in number default hr_api.g_number
2293: ,p_oipl_ordr_num in number default hr_api.g_number

Line 2290: ,p_pl_ordr_num in number default hr_api.g_number

2286: ,p_per_in_ler_id in number default hr_api.g_number
2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2291: ,p_plip_ordr_num in number default hr_api.g_number
2292: ,p_ptip_ordr_num in number default hr_api.g_number
2293: ,p_oipl_ordr_num in number default hr_api.g_number
2294: -- cwb

Line 2291: ,p_plip_ordr_num in number default hr_api.g_number

2287: ,p_yr_perd_id in number default hr_api.g_number
2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2291: ,p_plip_ordr_num in number default hr_api.g_number
2292: ,p_ptip_ordr_num in number default hr_api.g_number
2293: ,p_oipl_ordr_num in number default hr_api.g_number
2294: -- cwb
2295: ,p_comments in varchar2 default hr_api.g_varchar2

Line 2292: ,p_ptip_ordr_num in number default hr_api.g_number

2288: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2291: ,p_plip_ordr_num in number default hr_api.g_number
2292: ,p_ptip_ordr_num in number default hr_api.g_number
2293: ,p_oipl_ordr_num in number default hr_api.g_number
2294: -- cwb
2295: ,p_comments in varchar2 default hr_api.g_varchar2
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2

Line 2293: ,p_oipl_ordr_num in number default hr_api.g_number

2289: ,p_business_group_id in number default hr_api.g_number
2290: ,p_pl_ordr_num in number default hr_api.g_number
2291: ,p_plip_ordr_num in number default hr_api.g_number
2292: ,p_ptip_ordr_num in number default hr_api.g_number
2293: ,p_oipl_ordr_num in number default hr_api.g_number
2294: -- cwb
2295: ,p_comments in varchar2 default hr_api.g_varchar2
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date

Line 2295: ,p_comments in varchar2 default hr_api.g_varchar2

2291: ,p_plip_ordr_num in number default hr_api.g_number
2292: ,p_ptip_ordr_num in number default hr_api.g_number
2293: ,p_oipl_ordr_num in number default hr_api.g_number
2294: -- cwb
2295: ,p_comments in varchar2 default hr_api.g_varchar2
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2

Line 2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2

2292: ,p_ptip_ordr_num in number default hr_api.g_number
2293: ,p_oipl_ordr_num in number default hr_api.g_number
2294: -- cwb
2295: ,p_comments in varchar2 default hr_api.g_varchar2
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date

Line 2297: ,p_elig_ovrid_dt in date default hr_api.g_date

2293: ,p_oipl_ordr_num in number default hr_api.g_number
2294: -- cwb
2295: ,p_comments in varchar2 default hr_api.g_varchar2
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number

Line 2298: ,p_elig_ovrid_person_id in number default hr_api.g_number

2294: -- cwb
2295: ,p_comments in varchar2 default hr_api.g_varchar2
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2302: ,p_ws_mgr_id in number default hr_api.g_number

Line 2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2

2295: ,p_comments in varchar2 default hr_api.g_varchar2
2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2302: ,p_ws_mgr_id in number default hr_api.g_number
2303: -- cwb

Line 2300: ,p_mgr_ovrid_dt in date default hr_api.g_date

2296: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2302: ,p_ws_mgr_id in number default hr_api.g_number
2303: -- cwb
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2

Line 2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number

2297: ,p_elig_ovrid_dt in date default hr_api.g_date
2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2302: ,p_ws_mgr_id in number default hr_api.g_number
2303: -- cwb
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2

Line 2302: ,p_ws_mgr_id in number default hr_api.g_number

2298: ,p_elig_ovrid_person_id in number default hr_api.g_number
2299: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2302: ,p_ws_mgr_id in number default hr_api.g_number
2303: -- cwb
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2

Line 2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2

2300: ,p_mgr_ovrid_dt in date default hr_api.g_date
2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2302: ,p_ws_mgr_id in number default hr_api.g_number
2303: -- cwb
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2

Line 2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2

2301: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2302: ,p_ws_mgr_id in number default hr_api.g_number
2303: -- cwb
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2

Line 2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2

2302: ,p_ws_mgr_id in number default hr_api.g_number
2303: -- cwb
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2

Line 2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2

2303: -- cwb
2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2

Line 2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2

2304: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2

Line 2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2

2305: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2

Line 2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2

2306: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2

Line 2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2

2307: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2

Line 2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2

2308: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2

Line 2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2

2309: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2

Line 2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2

2310: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2

Line 2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2

2311: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2

Line 2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2

2312: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2

Line 2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2

2313: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2

Line 2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2

2314: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2

Line 2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2

2315: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2

Line 2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2

2316: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2

Line 2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2

2317: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2

Line 2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2

2318: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2

Line 2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2

2319: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2

Line 2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2

2320: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2

Line 2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2

2321: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2

Line 2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2

2322: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2

Line 2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2

2323: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2

Line 2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2

2324: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2

Line 2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2

2325: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2

Line 2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2

2326: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2

Line 2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2

2327: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2

Line 2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2

2328: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date

Line 2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2

2329: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2

Line 2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2

2330: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number

Line 2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2

2331: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2339: ,p_program_application_id in number default hr_api.g_number

Line 2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date

2332: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2339: ,p_program_application_id in number default hr_api.g_number
2340: ,p_program_id in number default hr_api.g_number

Line 2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2

2333: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2339: ,p_program_application_id in number default hr_api.g_number
2340: ,p_program_id in number default hr_api.g_number
2341: ,p_program_update_date in date default hr_api.g_date

Line 2338: ,p_request_id in number default hr_api.g_number

2334: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2339: ,p_program_application_id in number default hr_api.g_number
2340: ,p_program_id in number default hr_api.g_number
2341: ,p_program_update_date in date default hr_api.g_date
2342: ,p_object_version_number in out nocopy number

Line 2339: ,p_program_application_id in number default hr_api.g_number

2335: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2339: ,p_program_application_id in number default hr_api.g_number
2340: ,p_program_id in number default hr_api.g_number
2341: ,p_program_update_date in date default hr_api.g_date
2342: ,p_object_version_number in out nocopy number
2343: ,p_effective_date in date

Line 2340: ,p_program_id in number default hr_api.g_number

2336: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2339: ,p_program_application_id in number default hr_api.g_number
2340: ,p_program_id in number default hr_api.g_number
2341: ,p_program_update_date in date default hr_api.g_date
2342: ,p_object_version_number in out nocopy number
2343: ,p_effective_date in date
2344: )

Line 2341: ,p_program_update_date in date default hr_api.g_date

2337: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2338: ,p_request_id in number default hr_api.g_number
2339: ,p_program_application_id in number default hr_api.g_number
2340: ,p_program_id in number default hr_api.g_number
2341: ,p_program_update_date in date default hr_api.g_date
2342: ,p_object_version_number in out nocopy number
2343: ,p_effective_date in date
2344: )
2345: is

Line 2506: if (nvl(p_ws_mgr_id, hr_api.g_number) <> hr_api.g_number) and

2502: --
2503: --CWB
2504: -- Check only if the new manager is not null or defaulted.
2505: --
2506: if (nvl(p_ws_mgr_id, hr_api.g_number) <> hr_api.g_number) and
2507: (nvl(ben_epe_shd.g_old_rec.ws_mgr_id,-1) <> nvl(p_ws_mgr_id,-1))
2508: then
2509: chk_valid_mgr(p_elig_per_elctbl_chc_id,p_ws_mgr_id,p_effective_date);
2510: end if;

Line 2638: raise hr_api.validate_enabled;

2634: --
2635: -- When in validation only mode raise the Validate_Enabled exception
2636: --
2637: if p_validate then
2638: raise hr_api.validate_enabled;
2639: end if;
2640: --
2641: -- Set EPE comp object context values
2642: --

Line 2675: when hr_api.validate_enabled then

2671: end if;
2672: --
2673: exception
2674: --
2675: when hr_api.validate_enabled then
2676: --
2677: -- As the Validate_Enabled exception has been raised
2678: -- we must rollback to the savepoint
2679: --

Line 2822: when hr_api.cannot_find_prog_unit then

2818: ,p_object_version_number => p_object_version_number
2819: ,p_effective_date => trunc(p_effective_date)
2820: );
2821: exception
2822: when hr_api.cannot_find_prog_unit then
2823: hr_api.cannot_find_prog_unit_error
2824: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2825: ,p_hook_type => 'BP'
2826: );

Line 2823: hr_api.cannot_find_prog_unit_error

2819: ,p_effective_date => trunc(p_effective_date)
2820: );
2821: exception
2822: when hr_api.cannot_find_prog_unit then
2823: hr_api.cannot_find_prog_unit_error
2824: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2825: ,p_hook_type => 'BP'
2826: );
2827: --

Line 2882: when hr_api.cannot_find_prog_unit then

2878: ,p_object_version_number => l_object_version_number
2879: ,p_effective_date => trunc(p_effective_date)
2880: );
2881: exception
2882: when hr_api.cannot_find_prog_unit then
2883: hr_api.cannot_find_prog_unit_error
2884: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2885: ,p_hook_type => 'AP'
2886: );

Line 2883: hr_api.cannot_find_prog_unit_error

2879: ,p_effective_date => trunc(p_effective_date)
2880: );
2881: exception
2882: when hr_api.cannot_find_prog_unit then
2883: hr_api.cannot_find_prog_unit_error
2884: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2885: ,p_hook_type => 'AP'
2886: );
2887: --

Line 2899: raise hr_api.validate_enabled;

2895: --
2896: -- When in validation only mode raise the Validate_Enabled exception
2897: --
2898: if p_validate then
2899: raise hr_api.validate_enabled;
2900: end if;
2901: --
2902: if g_debug then
2903: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 2908: when hr_api.validate_enabled then

2904: end if;
2905: --
2906: exception
2907: --
2908: when hr_api.validate_enabled then
2909: --
2910: -- As the Validate_Enabled exception has been raised
2911: -- we must rollback to the savepoint
2912: --