DBA Data[Home] [Help]

APPS.BEN_ELIG_PER_ELC_CHC_API dependencies on HR_API

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

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

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

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

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

349: else
350: l_enrt_perd_id := p_enrt_perd_id;
351: end if;
352:
353: if l_pel_pgm_id = hr_api.g_number then --p_pgm_id
354: l_pgm_id := null;
355: else
356: l_pgm_id := l_pel_pgm_id;
357: end if;

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

355: else
356: l_pgm_id := l_pel_pgm_id;
357: end if;
358:
359: if l_pel_pl_id = hr_api.g_number then --p_pl_id
360: l_pl_id := null;
361: else
362: l_pl_id := l_pel_pl_id;
363: end if;

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

361: else
362: l_pl_id := l_pel_pl_id;
363: end if;
364:
365: if p_lee_rsn_id = hr_api.g_number then --p_lee_rsn_id
366: l_lee_rsn_id := null;
367: else
368: l_lee_rsn_id := p_lee_rsn_id;
369: end if;

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

367: else
368: l_lee_rsn_id := p_lee_rsn_id;
369: end if;
370:
371: if l_pel_uom = hr_api.g_varchar2 then --p_uom
372: l_uom := null;
373: else
374: l_uom := l_pel_uom;
375: end if;

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

373: else
374: l_uom := l_pel_uom;
375: end if;
376:
377: if p_cls_enrt_dt_to_use_cd = hr_api.g_varchar2 then --p_cls_enrt_dt_to_use_cd
378: l_cls_enrt_dt_to_use_cd := null;
379: else
380: l_cls_enrt_dt_to_use_cd := p_cls_enrt_dt_to_use_cd;
381: end if;

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

379: else
380: l_cls_enrt_dt_to_use_cd := p_cls_enrt_dt_to_use_cd;
381: end if;
382:
383: if l_pel_acty_ref_perd_cd = hr_api.g_varchar2 then --p_acty_ref_perd_cd
384: l_acty_ref_perd_cd := null;
385: else
386: l_acty_ref_perd_cd := l_pel_acty_ref_perd_cd;
387: end if;

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

385: else
386: l_acty_ref_perd_cd := l_pel_acty_ref_perd_cd;
387: end if;
388:
389: if p_dflt_enrt_dt = hr_api.g_date then --p_dflt_enrt_dt
390: l_dflt_enrt_dt := null;
391: else
392: l_dflt_enrt_dt := p_dflt_enrt_dt;
393: end if;

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

391: else
392: l_dflt_enrt_dt := p_dflt_enrt_dt;
393: end if;
394:
395: if p_enrt_perd_end_dt = hr_api.g_date then --p_enrt_perd_end_dt
396: l_enrt_perd_end_dt := null;
397: else
398: l_enrt_perd_end_dt := p_enrt_perd_end_dt;
399: end if;

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

397: else
398: l_enrt_perd_end_dt := p_enrt_perd_end_dt;
399: end if;
400:
401: if p_enrt_perd_strt_dt = hr_api.g_date then --p_enrt_perd_strt_dt
402: l_enrt_perd_strt_dt := null;
403: else
404: l_enrt_perd_strt_dt := p_enrt_perd_strt_dt;
405: end if;

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

403: else
404: l_enrt_perd_strt_dt := p_enrt_perd_strt_dt;
405: end if;
406:
407: if p_procg_end_dt = hr_api.g_date then --p_procg_end_dt
408: l_procg_end_dt := null;
409: else
410: l_procg_end_dt := p_procg_end_dt;
411: end if;

Line 861: when hr_api.cannot_find_prog_unit then

857: ,p_program_update_date => p_program_update_date
858: ,p_effective_date => trunc(p_effective_date)
859: );
860: exception
861: when hr_api.cannot_find_prog_unit then
862: hr_api.cannot_find_prog_unit_error
863: (
864: p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
865: ,p_hook_type => 'BP'

Line 862: hr_api.cannot_find_prog_unit_error

858: ,p_effective_date => trunc(p_effective_date)
859: );
860: exception
861: when hr_api.cannot_find_prog_unit then
862: hr_api.cannot_find_prog_unit_error
863: (
864: p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
865: ,p_hook_type => 'BP'
866: );

Line 1082: when hr_api.cannot_find_prog_unit then

1078: ,p_object_version_number => l_object_version_number
1079: ,p_effective_date => trunc(p_effective_date)
1080: );
1081: exception
1082: when hr_api.cannot_find_prog_unit then
1083: hr_api.cannot_find_prog_unit_error
1084: (p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
1085: ,p_hook_type => 'AP'
1086: );

Line 1083: hr_api.cannot_find_prog_unit_error

1079: ,p_effective_date => trunc(p_effective_date)
1080: );
1081: exception
1082: when hr_api.cannot_find_prog_unit then
1083: hr_api.cannot_find_prog_unit_error
1084: (p_module_name => 'CREATE_ELIG_PER_ELC_CHC'
1085: ,p_hook_type => 'AP'
1086: );
1087: --

Line 1099: raise hr_api.validate_enabled;

1095: --
1096: -- When in validation only mode raise the Validate_Enabled exception
1097: --
1098: if p_validate then
1099: raise hr_api.validate_enabled;
1100: end if;
1101: --
1102: -- Set all output arguments
1103: --

Line 1117: when hr_api.validate_enabled then

1113: end if;
1114: --
1115: exception
1116: --
1117: when hr_api.validate_enabled then
1118: --
1119: -- As the Validate_Enabled exception has been raised
1120: -- we must rollback to the savepoint
1121: --

Line 1572: raise hr_api.validate_enabled;

1568: --
1569: -- When in validation only mode raise the Validate_Enabled exception
1570: --
1571: if p_validate then
1572: raise hr_api.validate_enabled;
1573: end if;
1574: --
1575: -- Set electable choice current row globals
1576: --

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

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

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

1583: --
1584: if nvl(p_mode, 'OAB') <> 'W' then
1585: --
1586: if nvl(ben_epe_cache.g_currcobjepe_row.pl_id,hr_api.g_number) = nvl(p_pl_id,hr_api.g_number)
1587: and nvl(ben_epe_cache.g_currcobjepe_row.plip_id,hr_api.g_number) = nvl(p_plip_id,hr_api.g_number)
1588: and ben_epe_cache.g_currcobjepe_row.oipl_id is not null
1589: and p_oipl_id is null
1590: then
1591: --

Line 1632: when hr_api.validate_enabled then

1628: end if;
1629: --
1630: exception
1631: --
1632: when hr_api.validate_enabled then
1633: --
1634: -- As the Validate_Enabled exception has been raised
1635: -- we must rollback to the savepoint
1636: --

Line 1670: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2

1666: --
1667: procedure update_ELIG_PER_ELC_CHC
1668: (p_validate in boolean default false
1669: ,p_elig_per_elctbl_chc_id in number
1670: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1671: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1672: ,p_enrt_perd_end_dt in date default hr_api.g_date
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

Line 1671: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

1667: procedure update_ELIG_PER_ELC_CHC
1668: (p_validate in boolean default false
1669: ,p_elig_per_elctbl_chc_id in number
1670: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1671: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1672: ,p_enrt_perd_end_dt in date default hr_api.g_date
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

Line 1672: ,p_enrt_perd_end_dt in date default hr_api.g_date

1668: (p_validate in boolean default false
1669: ,p_elig_per_elctbl_chc_id in number
1670: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1671: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1672: ,p_enrt_perd_end_dt in date default hr_api.g_date
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number

Line 1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date

1669: ,p_elig_per_elctbl_chc_id in number
1670: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1671: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1672: ,p_enrt_perd_end_dt in date default hr_api.g_date
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2

Line 1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

1670: ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
1671: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1672: ,p_enrt_perd_end_dt in date default hr_api.g_date
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2

Line 1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

1671: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1672: ,p_enrt_perd_end_dt in date default hr_api.g_date
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

Line 1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number

1672: ,p_enrt_perd_end_dt in date default hr_api.g_date
1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2

Line 1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2

1673: ,p_enrt_perd_strt_dt in date default hr_api.g_date
1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2

Line 1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2

1674: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2

Line 1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

1675: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date

Line 1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2

1676: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

Line 1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2

1677: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

Line 1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2

1678: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

Line 1683: ,p_dflt_enrt_dt in date default hr_api.g_date

1679: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2

Line 1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

1680: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2

Line 1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

1681: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2

Line 1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

1682: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date

Line 1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2

1683: ,p_dflt_enrt_dt in date default hr_api.g_date
1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date

Line 1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2

1684: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2

Line 1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2

1685: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number

Line 1690: ,p_erlst_deenrt_dt in date default hr_api.g_date

1686: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number

Line 1691: ,p_procg_end_dt in date default hr_api.g_date

1687: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number

Line 1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2

1688: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number

Line 1693: ,p_pl_id in number default hr_api.g_number

1689: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number

Line 1694: ,p_oipl_id in number default hr_api.g_number

1690: ,p_erlst_deenrt_dt in date default hr_api.g_date
1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number

Line 1695: ,p_pgm_id in number default hr_api.g_number

1691: ,p_procg_end_dt in date default hr_api.g_date
1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number

Line 1696: ,p_plip_id in number default hr_api.g_number

1692: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number

Line 1697: ,p_ptip_id in number default hr_api.g_number

1693: ,p_pl_id in number default hr_api.g_number
1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number

Line 1698: ,p_pl_typ_id in number default hr_api.g_number

1694: ,p_oipl_id in number default hr_api.g_number
1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

Line 1699: ,p_oiplip_id in number default hr_api.g_number

1695: ,p_pgm_id in number default hr_api.g_number
1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number

Line 1700: ,p_cmbn_plip_id in number default hr_api.g_number

1696: ,p_plip_id in number default hr_api.g_number
1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number

Line 1701: ,p_cmbn_ptip_id in number default hr_api.g_number

1697: ,p_ptip_id in number default hr_api.g_number
1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number

Line 1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

1698: ,p_pl_typ_id in number default hr_api.g_number
1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number

Line 1703: ,p_assignment_id in number default hr_api.g_number

1699: ,p_oiplip_id in number default hr_api.g_number
1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number

Line 1704: ,p_spcl_rt_pl_id in number default hr_api.g_number

1700: ,p_cmbn_plip_id in number default hr_api.g_number
1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

Line 1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number

1701: ,p_cmbn_ptip_id in number default hr_api.g_number
1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

Line 1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number

1702: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number

Line 1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number

1703: ,p_assignment_id in number default hr_api.g_number
1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number

Line 1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

1704: ,p_spcl_rt_pl_id in number default hr_api.g_number
1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2

Line 1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

1705: ,p_spcl_rt_oipl_id in number default hr_api.g_number
1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number

Line 1710: ,p_per_in_ler_id in number default hr_api.g_number

1706: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number

Line 1711: ,p_yr_perd_id in number default hr_api.g_number

1707: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1715: ,p_plip_ordr_num in number default hr_api.g_number

Line 1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2

1708: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1715: ,p_plip_ordr_num in number default hr_api.g_number
1716: ,p_ptip_ordr_num in number default hr_api.g_number

Line 1713: ,p_business_group_id in number default hr_api.g_number

1709: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1715: ,p_plip_ordr_num in number default hr_api.g_number
1716: ,p_ptip_ordr_num in number default hr_api.g_number
1717: ,p_oipl_ordr_num in number default hr_api.g_number

Line 1714: ,p_pl_ordr_num in number default hr_api.g_number

1710: ,p_per_in_ler_id in number default hr_api.g_number
1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1715: ,p_plip_ordr_num in number default hr_api.g_number
1716: ,p_ptip_ordr_num in number default hr_api.g_number
1717: ,p_oipl_ordr_num in number default hr_api.g_number
1718: -- cwb

Line 1715: ,p_plip_ordr_num in number default hr_api.g_number

1711: ,p_yr_perd_id in number default hr_api.g_number
1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1715: ,p_plip_ordr_num in number default hr_api.g_number
1716: ,p_ptip_ordr_num in number default hr_api.g_number
1717: ,p_oipl_ordr_num in number default hr_api.g_number
1718: -- cwb
1719: ,p_comments in varchar2 default hr_api.g_varchar2

Line 1716: ,p_ptip_ordr_num in number default hr_api.g_number

1712: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1715: ,p_plip_ordr_num in number default hr_api.g_number
1716: ,p_ptip_ordr_num in number default hr_api.g_number
1717: ,p_oipl_ordr_num in number default hr_api.g_number
1718: -- cwb
1719: ,p_comments in varchar2 default hr_api.g_varchar2
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2

Line 1717: ,p_oipl_ordr_num in number default hr_api.g_number

1713: ,p_business_group_id in number default hr_api.g_number
1714: ,p_pl_ordr_num in number default hr_api.g_number
1715: ,p_plip_ordr_num in number default hr_api.g_number
1716: ,p_ptip_ordr_num in number default hr_api.g_number
1717: ,p_oipl_ordr_num in number default hr_api.g_number
1718: -- cwb
1719: ,p_comments in varchar2 default hr_api.g_varchar2
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date

Line 1719: ,p_comments in varchar2 default hr_api.g_varchar2

1715: ,p_plip_ordr_num in number default hr_api.g_number
1716: ,p_ptip_ordr_num in number default hr_api.g_number
1717: ,p_oipl_ordr_num in number default hr_api.g_number
1718: -- cwb
1719: ,p_comments in varchar2 default hr_api.g_varchar2
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2

Line 1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2

1716: ,p_ptip_ordr_num in number default hr_api.g_number
1717: ,p_oipl_ordr_num in number default hr_api.g_number
1718: -- cwb
1719: ,p_comments in varchar2 default hr_api.g_varchar2
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date

Line 1721: ,p_elig_ovrid_dt in date default hr_api.g_date

1717: ,p_oipl_ordr_num in number default hr_api.g_number
1718: -- cwb
1719: ,p_comments in varchar2 default hr_api.g_varchar2
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number

Line 1722: ,p_elig_ovrid_person_id in number default hr_api.g_number

1718: -- cwb
1719: ,p_comments in varchar2 default hr_api.g_varchar2
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1726: ,p_ws_mgr_id in number default hr_api.g_number

Line 1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2

1719: ,p_comments in varchar2 default hr_api.g_varchar2
1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1726: ,p_ws_mgr_id in number default hr_api.g_number
1727: -- cwb

Line 1724: ,p_mgr_ovrid_dt in date default hr_api.g_date

1720: ,p_elig_flag in varchar2 default hr_api.g_varchar2
1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1726: ,p_ws_mgr_id in number default hr_api.g_number
1727: -- cwb
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2

Line 1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number

1721: ,p_elig_ovrid_dt in date default hr_api.g_date
1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1726: ,p_ws_mgr_id in number default hr_api.g_number
1727: -- cwb
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2

Line 1726: ,p_ws_mgr_id in number default hr_api.g_number

1722: ,p_elig_ovrid_person_id in number default hr_api.g_number
1723: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1726: ,p_ws_mgr_id in number default hr_api.g_number
1727: -- cwb
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2

Line 1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2

1724: ,p_mgr_ovrid_dt in date default hr_api.g_date
1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1726: ,p_ws_mgr_id in number default hr_api.g_number
1727: -- cwb
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2

Line 1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2

1725: ,p_mgr_ovrid_person_id in number default hr_api.g_number
1726: ,p_ws_mgr_id in number default hr_api.g_number
1727: -- cwb
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2

Line 1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2

1726: ,p_ws_mgr_id in number default hr_api.g_number
1727: -- cwb
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2

Line 1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2

1727: -- cwb
1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2

Line 1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2

1728: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2

Line 1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2

1729: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2

Line 1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2

1730: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2

Line 1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2

1731: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2

Line 1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2

1732: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2

Line 1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2

1733: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2

Line 1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2

1734: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2

Line 1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2

1735: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2

Line 1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2

1736: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2

Line 1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2

1737: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2

Line 1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2

1738: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2

Line 1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2

1739: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2

Line 1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2

1740: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2

Line 1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2

1741: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2

Line 1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2

1742: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2

Line 1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2

1743: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2

Line 1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2

1744: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2

Line 1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2

1745: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2

Line 1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2

1746: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2

Line 1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2

1747: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2

Line 1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2

1748: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2

Line 1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2

1749: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2

Line 1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2

1750: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2

Line 1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2

1751: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2

Line 1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2

1752: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date

Line 1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2

1753: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2

Line 1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2

1754: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number

Line 1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2

1755: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1763: ,p_program_application_id in number default hr_api.g_number

Line 1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date

1756: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1763: ,p_program_application_id in number default hr_api.g_number
1764: ,p_program_id in number default hr_api.g_number

Line 1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2

1757: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1763: ,p_program_application_id in number default hr_api.g_number
1764: ,p_program_id in number default hr_api.g_number
1765: ,p_program_update_date in date default hr_api.g_date

Line 1762: ,p_request_id in number default hr_api.g_number

1758: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1763: ,p_program_application_id in number default hr_api.g_number
1764: ,p_program_id in number default hr_api.g_number
1765: ,p_program_update_date in date default hr_api.g_date
1766: ,p_object_version_number in out nocopy number

Line 1763: ,p_program_application_id in number default hr_api.g_number

1759: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1763: ,p_program_application_id in number default hr_api.g_number
1764: ,p_program_id in number default hr_api.g_number
1765: ,p_program_update_date in date default hr_api.g_date
1766: ,p_object_version_number in out nocopy number
1767: ,p_effective_date in date

Line 1764: ,p_program_id in number default hr_api.g_number

1760: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1763: ,p_program_application_id in number default hr_api.g_number
1764: ,p_program_id in number default hr_api.g_number
1765: ,p_program_update_date in date default hr_api.g_date
1766: ,p_object_version_number in out nocopy number
1767: ,p_effective_date in date
1768: ) is

Line 1765: ,p_program_update_date in date default hr_api.g_date

1761: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
1762: ,p_request_id in number default hr_api.g_number
1763: ,p_program_application_id in number default hr_api.g_number
1764: ,p_program_id in number default hr_api.g_number
1765: ,p_program_update_date in date default hr_api.g_date
1766: ,p_object_version_number in out nocopy number
1767: ,p_effective_date in date
1768: ) is
1769: --

Line 1894: when hr_api.cannot_find_prog_unit then

1890: ,p_object_version_number => p_object_version_number
1891: ,p_effective_date => trunc(p_effective_date)
1892: );
1893: exception
1894: when hr_api.cannot_find_prog_unit then
1895: hr_api.cannot_find_prog_unit_error
1896: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
1897: ,p_hook_type => 'BP'
1898: );

Line 1895: hr_api.cannot_find_prog_unit_error

1891: ,p_effective_date => trunc(p_effective_date)
1892: );
1893: exception
1894: when hr_api.cannot_find_prog_unit then
1895: hr_api.cannot_find_prog_unit_error
1896: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
1897: ,p_hook_type => 'BP'
1898: );
1899: --

Line 2112: when hr_api.cannot_find_prog_unit then

2108: ,p_object_version_number => l_object_version_number
2109: ,p_effective_date => trunc(p_effective_date)
2110: );
2111: exception
2112: when hr_api.cannot_find_prog_unit then
2113: hr_api.cannot_find_prog_unit_error
2114: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
2115: ,p_hook_type => 'AP'
2116: );

Line 2113: hr_api.cannot_find_prog_unit_error

2109: ,p_effective_date => trunc(p_effective_date)
2110: );
2111: exception
2112: when hr_api.cannot_find_prog_unit then
2113: hr_api.cannot_find_prog_unit_error
2114: (p_module_name => 'UPDATE_ELIG_PER_ELC_CHC'
2115: ,p_hook_type => 'AP'
2116: );
2117: --

Line 2129: raise hr_api.validate_enabled;

2125: --
2126: -- When in validation only mode raise the Validate_Enabled exception
2127: --
2128: if p_validate then
2129: raise hr_api.validate_enabled;
2130: end if;
2131: --
2132: -- Set all output arguments
2133: --

Line 2142: when hr_api.validate_enabled then

2138: end if;
2139: --
2140: exception
2141: --
2142: when hr_api.validate_enabled then
2143: --
2144: -- As the Validate_Enabled exception has been raised
2145: -- we must rollback to the savepoint
2146: --

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

2237: --
2238: procedure update_perf_ELIG_PER_ELC_CHC
2239: (p_validate in boolean default false
2240: ,p_elig_per_elctbl_chc_id in number
2241: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2242: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2243: --,p_enrt_perd_end_dt in date default hr_api.g_date
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

Line 2242: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

2238: procedure update_perf_ELIG_PER_ELC_CHC
2239: (p_validate in boolean default false
2240: ,p_elig_per_elctbl_chc_id in number
2241: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2242: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2243: --,p_enrt_perd_end_dt in date default hr_api.g_date
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

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

2239: (p_validate in boolean default false
2240: ,p_elig_per_elctbl_chc_id in number
2241: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2242: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2243: --,p_enrt_perd_end_dt in date default hr_api.g_date
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number

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

2240: ,p_elig_per_elctbl_chc_id in number
2241: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2242: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2243: --,p_enrt_perd_end_dt in date default hr_api.g_date
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2

Line 2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

2241: -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
2242: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2243: --,p_enrt_perd_end_dt in date default hr_api.g_date
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2

Line 2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2

2242: ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2243: --,p_enrt_perd_end_dt in date default hr_api.g_date
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

Line 2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number

2243: --,p_enrt_perd_end_dt in date default hr_api.g_date
2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2

Line 2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2

2244: --,p_enrt_perd_strt_dt in date default hr_api.g_date
2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2

Line 2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2

2245: ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2

Line 2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2

2246: ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date

Line 2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2

2247: ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

Line 2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2

2248: ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

Line 2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2

2249: ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

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

2250: ,p_dflt_flag in varchar2 default hr_api.g_varchar2
2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2

Line 2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2

2251: ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2

Line 2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2

2252: ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2

Line 2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date

2253: ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date

Line 2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2

2254: -- ,p_dflt_enrt_dt in date default hr_api.g_date
2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date

Line 2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2

2255: ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2

Line 2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2

2256: ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number

Line 2261: ,p_erlst_deenrt_dt in date default hr_api.g_date

2257: ,p_enrt_cvg_strt_dt in date default hr_api.g_date
2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number

Line 2262: ,p_procg_end_dt in date default hr_api.g_date

2258: ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number

Line 2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2

2259: ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number

Line 2264: ,p_pl_id in number default hr_api.g_number

2260: ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number

Line 2265: ,p_oipl_id in number default hr_api.g_number

2261: ,p_erlst_deenrt_dt in date default hr_api.g_date
2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number

Line 2266: ,p_pgm_id in number default hr_api.g_number

2262: ,p_procg_end_dt in date default hr_api.g_date
2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number

Line 2267: ,p_plip_id in number default hr_api.g_number

2263: ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number

Line 2268: ,p_ptip_id in number default hr_api.g_number

2264: ,p_pl_id in number default hr_api.g_number
2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number

Line 2269: ,p_pl_typ_id in number default hr_api.g_number

2265: ,p_oipl_id in number default hr_api.g_number
2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

Line 2270: ,p_oiplip_id in number default hr_api.g_number

2266: ,p_pgm_id in number default hr_api.g_number
2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number

Line 2271: ,p_cmbn_plip_id in number default hr_api.g_number

2267: ,p_plip_id in number default hr_api.g_number
2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number

Line 2272: ,p_cmbn_ptip_id in number default hr_api.g_number

2268: ,p_ptip_id in number default hr_api.g_number
2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number

Line 2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number

2269: ,p_pl_typ_id in number default hr_api.g_number
2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number

Line 2274: ,p_assignment_id in number default hr_api.g_number

2270: ,p_oiplip_id in number default hr_api.g_number
2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number

Line 2275: ,p_spcl_rt_pl_id in number default hr_api.g_number

2271: ,p_cmbn_plip_id in number default hr_api.g_number
2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

Line 2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number

2272: ,p_cmbn_ptip_id in number default hr_api.g_number
2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

Line 2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number

2273: ,p_cmbn_ptip_opt_id in number default hr_api.g_number
2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number

Line 2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number

2274: ,p_assignment_id in number default hr_api.g_number
2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number

Line 2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

2275: ,p_spcl_rt_pl_id in number default hr_api.g_number
2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2

Line 2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number

2276: ,p_spcl_rt_oipl_id in number default hr_api.g_number
2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number

Line 2281: ,p_per_in_ler_id in number default hr_api.g_number

2277: ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number

Line 2282: ,p_yr_perd_id in number default hr_api.g_number

2278: ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2286: ,p_plip_ordr_num in number default hr_api.g_number

Line 2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2

2279: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2286: ,p_plip_ordr_num in number default hr_api.g_number
2287: ,p_ptip_ordr_num in number default hr_api.g_number

Line 2284: ,p_business_group_id in number default hr_api.g_number

2280: ,p_bnft_prvdr_pool_id in number default hr_api.g_number
2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2286: ,p_plip_ordr_num in number default hr_api.g_number
2287: ,p_ptip_ordr_num in number default hr_api.g_number
2288: ,p_oipl_ordr_num in number default hr_api.g_number

Line 2285: ,p_pl_ordr_num in number default hr_api.g_number

2281: ,p_per_in_ler_id in number default hr_api.g_number
2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2286: ,p_plip_ordr_num in number default hr_api.g_number
2287: ,p_ptip_ordr_num in number default hr_api.g_number
2288: ,p_oipl_ordr_num in number default hr_api.g_number
2289: -- cwb

Line 2286: ,p_plip_ordr_num in number default hr_api.g_number

2282: ,p_yr_perd_id in number default hr_api.g_number
2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2286: ,p_plip_ordr_num in number default hr_api.g_number
2287: ,p_ptip_ordr_num in number default hr_api.g_number
2288: ,p_oipl_ordr_num in number default hr_api.g_number
2289: -- cwb
2290: ,p_comments in varchar2 default hr_api.g_varchar2

Line 2287: ,p_ptip_ordr_num in number default hr_api.g_number

2283: ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2286: ,p_plip_ordr_num in number default hr_api.g_number
2287: ,p_ptip_ordr_num in number default hr_api.g_number
2288: ,p_oipl_ordr_num in number default hr_api.g_number
2289: -- cwb
2290: ,p_comments in varchar2 default hr_api.g_varchar2
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2

Line 2288: ,p_oipl_ordr_num in number default hr_api.g_number

2284: ,p_business_group_id in number default hr_api.g_number
2285: ,p_pl_ordr_num in number default hr_api.g_number
2286: ,p_plip_ordr_num in number default hr_api.g_number
2287: ,p_ptip_ordr_num in number default hr_api.g_number
2288: ,p_oipl_ordr_num in number default hr_api.g_number
2289: -- cwb
2290: ,p_comments in varchar2 default hr_api.g_varchar2
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date

Line 2290: ,p_comments in varchar2 default hr_api.g_varchar2

2286: ,p_plip_ordr_num in number default hr_api.g_number
2287: ,p_ptip_ordr_num in number default hr_api.g_number
2288: ,p_oipl_ordr_num in number default hr_api.g_number
2289: -- cwb
2290: ,p_comments in varchar2 default hr_api.g_varchar2
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2

Line 2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2

2287: ,p_ptip_ordr_num in number default hr_api.g_number
2288: ,p_oipl_ordr_num in number default hr_api.g_number
2289: -- cwb
2290: ,p_comments in varchar2 default hr_api.g_varchar2
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date

Line 2292: ,p_elig_ovrid_dt in date default hr_api.g_date

2288: ,p_oipl_ordr_num in number default hr_api.g_number
2289: -- cwb
2290: ,p_comments in varchar2 default hr_api.g_varchar2
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number

Line 2293: ,p_elig_ovrid_person_id in number default hr_api.g_number

2289: -- cwb
2290: ,p_comments in varchar2 default hr_api.g_varchar2
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2297: ,p_ws_mgr_id in number default hr_api.g_number

Line 2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2

2290: ,p_comments in varchar2 default hr_api.g_varchar2
2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2297: ,p_ws_mgr_id in number default hr_api.g_number
2298: -- cwb

Line 2295: ,p_mgr_ovrid_dt in date default hr_api.g_date

2291: ,p_elig_flag in varchar2 default hr_api.g_varchar2
2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2297: ,p_ws_mgr_id in number default hr_api.g_number
2298: -- cwb
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2

Line 2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number

2292: ,p_elig_ovrid_dt in date default hr_api.g_date
2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2297: ,p_ws_mgr_id in number default hr_api.g_number
2298: -- cwb
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2

Line 2297: ,p_ws_mgr_id in number default hr_api.g_number

2293: ,p_elig_ovrid_person_id in number default hr_api.g_number
2294: ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2297: ,p_ws_mgr_id in number default hr_api.g_number
2298: -- cwb
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2

Line 2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2

2295: ,p_mgr_ovrid_dt in date default hr_api.g_date
2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2297: ,p_ws_mgr_id in number default hr_api.g_number
2298: -- cwb
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2

Line 2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2

2296: ,p_mgr_ovrid_person_id in number default hr_api.g_number
2297: ,p_ws_mgr_id in number default hr_api.g_number
2298: -- cwb
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2

Line 2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2

2297: ,p_ws_mgr_id in number default hr_api.g_number
2298: -- cwb
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2

Line 2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2

2298: -- cwb
2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2

Line 2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2

2299: ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2

Line 2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2

2300: ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2

Line 2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2

2301: ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2

Line 2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2

2302: ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2

Line 2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2

2303: ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2

Line 2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2

2304: ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2

Line 2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2

2305: ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2

Line 2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2

2306: ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2

Line 2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2

2307: ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2

Line 2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2

2308: ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2

Line 2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2

2309: ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2

Line 2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2

2310: ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2

Line 2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2

2311: ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2

Line 2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2

2312: ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2

Line 2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2

2313: ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2

Line 2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2

2314: ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2

Line 2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2

2315: ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2

Line 2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2

2316: ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2

Line 2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2

2317: ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2

Line 2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2

2318: ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2

Line 2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2

2319: ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2

Line 2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2

2320: ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2

Line 2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2

2321: ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2

Line 2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2

2322: ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2

Line 2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2

2323: ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date

Line 2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2

2324: ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2

Line 2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2

2325: ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number

Line 2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2

2326: ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2334: ,p_program_application_id in number default hr_api.g_number

Line 2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date

2327: ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2334: ,p_program_application_id in number default hr_api.g_number
2335: ,p_program_id in number default hr_api.g_number

Line 2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2

2328: ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2334: ,p_program_application_id in number default hr_api.g_number
2335: ,p_program_id in number default hr_api.g_number
2336: ,p_program_update_date in date default hr_api.g_date

Line 2333: ,p_request_id in number default hr_api.g_number

2329: ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2334: ,p_program_application_id in number default hr_api.g_number
2335: ,p_program_id in number default hr_api.g_number
2336: ,p_program_update_date in date default hr_api.g_date
2337: ,p_object_version_number in out nocopy number

Line 2334: ,p_program_application_id in number default hr_api.g_number

2330: ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2334: ,p_program_application_id in number default hr_api.g_number
2335: ,p_program_id in number default hr_api.g_number
2336: ,p_program_update_date in date default hr_api.g_date
2337: ,p_object_version_number in out nocopy number
2338: ,p_effective_date in date

Line 2335: ,p_program_id in number default hr_api.g_number

2331: ,p_fonm_cvg_strt_dt in date default hr_api.g_date
2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2334: ,p_program_application_id in number default hr_api.g_number
2335: ,p_program_id in number default hr_api.g_number
2336: ,p_program_update_date in date default hr_api.g_date
2337: ,p_object_version_number in out nocopy number
2338: ,p_effective_date in date
2339: )

Line 2336: ,p_program_update_date in date default hr_api.g_date

2332: ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
2333: ,p_request_id in number default hr_api.g_number
2334: ,p_program_application_id in number default hr_api.g_number
2335: ,p_program_id in number default hr_api.g_number
2336: ,p_program_update_date in date default hr_api.g_date
2337: ,p_object_version_number in out nocopy number
2338: ,p_effective_date in date
2339: )
2340: is

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

2497: --
2498: --CWB
2499: -- Check only if the new manager is not null or defaulted.
2500: --
2501: if (nvl(p_ws_mgr_id, hr_api.g_number) <> hr_api.g_number) and
2502: (nvl(ben_epe_shd.g_old_rec.ws_mgr_id,-1) <> nvl(p_ws_mgr_id,-1))
2503: then
2504: chk_valid_mgr(p_elig_per_elctbl_chc_id,p_ws_mgr_id,p_effective_date);
2505: end if;

Line 2633: raise hr_api.validate_enabled;

2629: --
2630: -- When in validation only mode raise the Validate_Enabled exception
2631: --
2632: if p_validate then
2633: raise hr_api.validate_enabled;
2634: end if;
2635: --
2636: -- Set EPE comp object context values
2637: --

Line 2670: when hr_api.validate_enabled then

2666: end if;
2667: --
2668: exception
2669: --
2670: when hr_api.validate_enabled then
2671: --
2672: -- As the Validate_Enabled exception has been raised
2673: -- we must rollback to the savepoint
2674: --

Line 2817: when hr_api.cannot_find_prog_unit then

2813: ,p_object_version_number => p_object_version_number
2814: ,p_effective_date => trunc(p_effective_date)
2815: );
2816: exception
2817: when hr_api.cannot_find_prog_unit then
2818: hr_api.cannot_find_prog_unit_error
2819: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2820: ,p_hook_type => 'BP'
2821: );

Line 2818: hr_api.cannot_find_prog_unit_error

2814: ,p_effective_date => trunc(p_effective_date)
2815: );
2816: exception
2817: when hr_api.cannot_find_prog_unit then
2818: hr_api.cannot_find_prog_unit_error
2819: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2820: ,p_hook_type => 'BP'
2821: );
2822: --

Line 2877: when hr_api.cannot_find_prog_unit then

2873: ,p_object_version_number => l_object_version_number
2874: ,p_effective_date => trunc(p_effective_date)
2875: );
2876: exception
2877: when hr_api.cannot_find_prog_unit then
2878: hr_api.cannot_find_prog_unit_error
2879: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2880: ,p_hook_type => 'AP'
2881: );

Line 2878: hr_api.cannot_find_prog_unit_error

2874: ,p_effective_date => trunc(p_effective_date)
2875: );
2876: exception
2877: when hr_api.cannot_find_prog_unit then
2878: hr_api.cannot_find_prog_unit_error
2879: (p_module_name => 'DELETE_ELIG_PER_ELC_CHC'
2880: ,p_hook_type => 'AP'
2881: );
2882: --

Line 2894: raise hr_api.validate_enabled;

2890: --
2891: -- When in validation only mode raise the Validate_Enabled exception
2892: --
2893: if p_validate then
2894: raise hr_api.validate_enabled;
2895: end if;
2896: --
2897: if g_debug then
2898: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 2903: when hr_api.validate_enabled then

2899: end if;
2900: --
2901: exception
2902: --
2903: when hr_api.validate_enabled then
2904: --
2905: -- As the Validate_Enabled exception has been raised
2906: -- we must rollback to the savepoint
2907: --