[Home] [Help]
PACKAGE: APPS.BEN_GLOBAL_ENRT
Source
1 package ben_global_enrt AUTHID CURRENT_USER as
2 /* $Header: bengenrt.pkh 120.1 2010/12/23 19:25:38 stee ship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10
11 Name
12 Enrollment Globals Package
13 Purpose
14 This package is used to load and return globals used in the enrollment
15 save processes.
16 History
17 Date Who Version What?
18 --------- --------- ------- --------------------------------------------
19 03 Apr 2000 lmcdonal 115.0 Created
20 07 Apr 2000 lmcdonal 115.1 Added more procedures.
21 17 May 2001 maagrawa 115.2 Changed the procedure and record
22 definitions.
23 13-Dec-2002 kmahendr 115.4 Nocopy Changes
24 10-feb-2005 mmudigon 115.5 Bug 4157759. Added field "typ_cd" to
25 g_global_pil_rec_type
26 11-Nov-2010 stee 115.6 Bug 9401100. Added ctfn_rqd_flag to
27 g_global_epe_rec_type.
28 ------------------------------------------------------------------------------
29 */
30 --
31 type g_global_epe_rec_type is record
32 (per_in_ler_id ben_elig_per_elctbl_chc.per_in_ler_id%type
33 ,pil_elctbl_chc_popl_id ben_elig_per_elctbl_chc.pil_elctbl_chc_popl_id%type
34 ,prtt_enrt_rslt_id ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type
35 ,pgm_id ben_elig_per_elctbl_chc.pgm_id%type
36 ,pl_id ben_elig_per_elctbl_chc.pl_id%type
37 ,pl_typ_id ben_elig_per_elctbl_chc.pl_typ_id%type
38 ,plip_id ben_elig_per_elctbl_chc.plip_id%type
39 ,ptip_id ben_elig_per_elctbl_chc.ptip_id%type
40 ,oipl_id ben_elig_per_elctbl_chc.oipl_id%type
41 ,business_group_id ben_elig_per_elctbl_chc.business_group_id%type
42 ,object_version_number ben_elig_per_elctbl_chc.object_version_number%type
43 ,comp_lvl_cd ben_elig_per_elctbl_chc.comp_lvl_cd%type
44 ,crntly_enrd_flag ben_elig_per_elctbl_chc.crntly_enrd_flag%type
45 ,alws_dpnt_dsgn_flag ben_elig_per_elctbl_chc.alws_dpnt_dsgn_flag%type
46 ,ctfn_rqd_flag ben_elig_per_elctbl_chc.ctfn_rqd_flag%type -- 9401100
47 ,dpnt_cvg_strt_dt_cd ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_cd%type
48 ,dpnt_cvg_strt_dt_rl ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_rl%type
49 ,enrt_cvg_strt_dt ben_elig_per_elctbl_chc.enrt_cvg_strt_dt%type
50 ,erlst_deenrt_dt ben_elig_per_elctbl_chc.erlst_deenrt_dt%type
51 ,enrt_cvg_strt_dt_cd ben_elig_per_elctbl_chc.enrt_cvg_strt_dt_cd%type
52 ,enrt_cvg_strt_dt_rl ben_elig_per_elctbl_chc.enrt_cvg_strt_dt_rl%type);
53 g_global_epe_rec g_global_epe_rec_type;
54
55 type g_global_pel_rec_type is record
56 (per_in_ler_id ben_pil_elctbl_chc_popl.per_in_ler_id%type
57 ,pgm_id ben_pil_elctbl_chc_popl.pgm_id%type
58 ,pl_id ben_pil_elctbl_chc_popl.pl_id%type
59 ,lee_rsn_id ben_pil_elctbl_chc_popl.lee_rsn_id%type
60 ,enrt_perd_id ben_pil_elctbl_chc_popl.enrt_perd_id%type
61 ,uom ben_pil_elctbl_chc_popl.uom%type
62 ,acty_ref_perd_cd ben_pil_elctbl_chc_popl.acty_ref_perd_cd%type);
63 --
64 g_global_pel_rec g_global_pel_rec_type;
65 g_global_pel_id ben_pil_elctbl_chc_popl.pil_elctbl_chc_popl_id%type;
66
67 type g_global_pil_rec_type is record
68 (person_id ben_per_in_ler.person_id%type
69 ,ler_id ben_per_in_ler.ler_id%type
70 ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
71 ,typ_cd ben_ler_f.typ_cd%type);
72 g_global_pil_rec g_global_pil_rec_type;
73 g_global_pil_id ben_per_in_ler.per_in_ler_id%type;
74
75 type g_global_enb_rec_type is record
76 (ordr_num ben_enrt_bnft.ordr_num%type
77 ,val ben_enrt_bnft.val%type
78 ,bnft_typ_cd ben_enrt_bnft.bnft_typ_cd%type
79 ,cvg_mlt_cd ben_enrt_bnft.cvg_mlt_cd%type
80 ,nnmntry_uom ben_enrt_bnft.nnmntry_uom%type
81 ,object_version_number ben_enrt_bnft.object_version_number%type);
82 g_global_enb_rec g_global_enb_rec_type;
83
84 type g_global_asg_rec_type is record
85 (payroll_id per_all_assignments_f.payroll_id%type);
86 g_global_asg_rec g_global_asg_rec_type;
87 g_global_asg_person_id per_all_people_f.person_id%type;
88
89 g_global_pen_rec ben_prtt_enrt_rslt_f%rowtype;
90 ------------------------------------------------------------------------------
91
92 procedure get_epe
93 (p_elig_per_elctbl_chc_id in number
94 ,p_global_epe_rec out nocopy g_global_epe_rec_type);
95
96 procedure reload_epe
97 (p_elig_per_elctbl_chc_id in number
98 ,p_global_epe_rec out nocopy g_global_epe_rec_type);
99
100 ------------------------------------------------------------------------------
101
102 procedure get_pel
103 (p_pil_elctbl_chc_popl_id in number
104 ,p_global_pel_rec out nocopy g_global_pel_rec_type);
105 ------------------------------------------------------------------------------
106 procedure get_pil
107 (p_per_in_ler_id in number
108 ,p_global_pil_rec out nocopy g_global_pil_rec_type);
109 ------------------------------------------------------------------------------
110 procedure clear_enb
111 (p_global_enb_rec out nocopy g_global_enb_rec_type);
112
113 procedure get_enb
114 (p_enrt_bnft_id in number
115 ,p_global_enb_rec out nocopy g_global_enb_rec_type);
116 ------------------------------------------------------------------------------
117 procedure get_asg
118 (p_person_id in number
119 ,p_effective_date in date
120 ,p_global_asg_rec out nocopy g_global_asg_rec_type);
121 ------------------------------------------------------------------------------
122 procedure clear_pen
123 (p_global_pen_rec out nocopy ben_prtt_enrt_rslt_f%rowtype);
124
125 procedure get_pen
126 (p_prtt_enrt_rslt_id in number
127 ,p_effective_date in date
128 ,p_global_pen_rec out nocopy ben_prtt_enrt_rslt_f%rowtype);
129
130 procedure get_pen
131 (p_per_in_ler_id in number
132 ,p_pgm_id in number
133 ,p_pl_id in number
134 ,p_oipl_id in number
135 ,p_effective_date in date
136 ,p_global_pen_rec out nocopy ben_prtt_enrt_rslt_f%rowtype) ;
137
138 procedure reload_pen
139 (p_prtt_enrt_rslt_id in number
140 ,p_effective_date in date
141 ,p_global_pen_rec out nocopy ben_prtt_enrt_rslt_f%rowtype);
142 ------------------------------------------------------------------------------
143
144 end ben_global_enrt;