1 package ben_enrolment_requirements2 as
2 /* $Header: bendenr2.pkh 120.0 2006/02/16 12:19:41 kmahendr noship $ */
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 */
16 -----------------------------------------------------------------------------
17 --
18 g_debug boolean := hr_utility.debug_enabled;
19 --
20 PROCEDURE get_asg_dets
21 (p_person_id IN number
22 ,p_run_mode IN varchar2
23 ,p_leodt IN date
24 ,p_effdt IN date
25 --
26 ,p_asg_id out nocopy number
27 ,p_org_id out nocopy number
28 );
29 --
30 PROCEDURE get_perpiller_dets
31 (p_person_id IN number
32 ,p_bgp_id IN number
33 ,p_ler_id IN number
34 ,p_run_mode IN varchar2
35 ,p_effdt IN date
36 ,p_irecasg_id IN number
37 --
38 ,p_pil_id out nocopy number
39 ,p_lertyp_cd out nocopy varchar2
40 ,p_lernm out nocopy varchar2
41 ,p_pil_leodt out nocopy date
42 ,p_ler_esd out nocopy date
43 ,p_ler_eed out nocopy date
44 );
45 --
46 PROCEDURE get_latest_enrtdt
47 (p_person_id IN number
48 ,p_bgp_id IN number
49 --
50 ,p_pen_mxesd out nocopy date
51 );
52 --
53 PROCEDURE bckdout_ler
54 (p_person_id IN number
55 ,p_effdt IN date
56 ,p_bgp_id IN number
57 ,p_ler_id IN number
58 ,p_leodt IN date
59 --
60 ,p_pil_bcktdt out nocopy date
61 );
62 --
63 PROCEDURE ptipenrt_info
64 (p_person_id IN number
65 ,p_effdt IN date
66 ,p_bgp_id IN number
67 ,p_ptip_id IN number
68 ,p_cvgthrudt IN date
69 --
70 ,p_pen_pl_id out nocopy number
71 ,p_pen_oipl_id out nocopy number
72 ,p_pen_plip_id out nocopy number
73 );
74 --
75 PROCEDURE get_lerplipdfltcd
76 (p_plip_id IN number
77 ,p_ler_id IN number
78 ,p_effdt IN date
79 --
80 ,p_lep_dflt_enrt_cd out nocopy varchar2
81 ,p_lep_dflt_enrt_rl out nocopy varchar2
82 );
83 --
84 end ben_enrolment_requirements2;