1 package ben_enrolment_requirements1 as
2 /* $Header: bendenr1.pkh 120.2.12010000.2 2008/08/05 14:38:45 ubhat ship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1998 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 --
11 History
12 Date Who Version What?
13 ---- --- ------- -----
14 24 Jan 06 mhoyes 115.0 Created.
15 13-Feb-05 mhoyes 115.2 - bug5031107. Moved locally defined procedures
16 to ben_enrolment_requirements1.
17 28-Apr-05 mhoyes 115.3 - bug5152911. Added GetPenPerIDMxESD.
18 */
19 -----------------------------------------------------------------------------
20 --
21 g_debug boolean := hr_utility.debug_enabled;
22 --
23 PROCEDURE determine_ben_settings(
24 p_pl_id IN ben_ler_chg_pl_nip_enrt_f.pl_id%TYPE,
25 p_ler_id IN ben_ler_chg_pl_nip_enrt_f.ler_id%TYPE,
26 p_lf_evt_ocrd_dt IN DATE,
27 p_ptip_id IN ben_ler_chg_ptip_enrt_f.ptip_id%TYPE,
28 p_pgm_id IN ben_ler_chg_pgm_enrt_f.pgm_id%TYPE,
29 p_plip_id IN ben_ler_chg_plip_enrt_f.plip_id%TYPE,
30 p_oipl_id IN ben_ler_chg_oipl_enrt_f.oipl_id%TYPE,
31 p_just_prclds_chg_flag IN BOOLEAN DEFAULT FALSE,
32 p_enrt_cd OUT NOCOPY ben_ler_chg_oipl_enrt_f.enrt_cd%TYPE,
33 p_enrt_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.enrt_rl%TYPE,
34 p_auto_enrt_mthd_rl OUT NOCOPY ben_ler_chg_oipl_enrt_f.auto_enrt_mthd_rl%TYPE,
35 p_crnt_enrt_prclds_chg_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.crnt_enrt_prclds_chg_flag%TYPE,
36 p_dflt_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.dflt_flag%TYPE,
37 p_enrt_mthd_cd OUT NOCOPY ben_ler_chg_pgm_enrt_f.enrt_mthd_cd%TYPE,
38 p_stl_elig_cant_chg_flag OUT NOCOPY ben_ler_chg_oipl_enrt_f.stl_elig_cant_chg_flag%TYPE,
39 p_tco_chg_enrt_cd OUT NOCOPY ben_ler_chg_ptip_enrt_f.tco_chg_enrt_cd%TYPE,
40 p_ler_chg_oipl_found_flag OUT NOCOPY VARCHAR2,
41 p_ler_chg_found_flag OUT NOCOPY VARCHAR2,
42 p_enrt_cd_level OUT NOCOPY VARCHAR2
43 );
44 --
45 procedure GetPenPerIDMxESD
46 (p_person_id in number
47 ,p_business_group_id in number
48 --
49 ,p_penmxesd out nocopy date
50 );
51 --
52 procedure enrt_perd_strt_dt
53 (p_person_id in number
54 ,p_lf_evt_ocrd_dt in date
55 ,p_enrt_perd_det_ovrlp_bckdt_cd in varchar2
56 ,p_business_group_id in number
57 ,p_ler_id in number
58 ,p_effective_date in date
59 ,p_rec_enrt_perd_strt_dt in out nocopy date
60 );
61 --
62 end ben_enrolment_requirements1;