DBA Data[Home] [Help]

PACKAGE: APPS.BEN_ELIG_PER_ELC_CHC_BK2

Source


1 Package ben_ELIG_PER_ELC_CHC_bk2 as
2 /* $Header: beepeapi.pkh 120.0 2005/05/28 02:36:42 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< update_ELIG_PER_ELC_CHC_b >-----------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure update_ELIG_PER_ELC_CHC_b
9   (
10    p_elig_per_elctbl_chc_id         in  number
11 --*  ,p_enrt_typ_cycl_cd               in  varchar2
12   ,p_enrt_cvg_strt_dt_cd            in  varchar2
13 --*  ,p_enrt_perd_end_dt               in  date
14 --*  ,p_enrt_perd_strt_dt              in  date
15   ,p_enrt_cvg_strt_dt_rl            in  varchar2
16 --  ,p_rt_strt_dt                     in  date
17 --  ,p_rt_strt_dt_rl                  in  varchar2
18 --  ,p_rt_strt_dt_cd                  in  varchar2
19  ,p_ctfn_rqd_flag                  in varchar2
20  ,p_pil_elctbl_chc_popl_id         in number
21   ,p_roll_crs_flag                  in  varchar2
22   ,p_crntly_enrd_flag               in  varchar2
23   ,p_dflt_flag                      in  varchar2
24   ,p_elctbl_flag                    in  varchar2
25   ,p_mndtry_flag                    in  varchar2
26   ,p_in_pndg_wkflow_flag            in  varchar2
27 --*  ,p_dflt_enrt_dt                   in  date
28   ,p_dpnt_cvg_strt_dt_cd            in  varchar2
29   ,p_dpnt_cvg_strt_dt_rl            in  varchar2
30   ,p_enrt_cvg_strt_dt               in  date
31   ,p_alws_dpnt_dsgn_flag            in  varchar2
32   ,p_dpnt_dsgn_cd                   in  varchar2
33   ,p_ler_chg_dpnt_cvg_cd            in  varchar2
34   ,p_erlst_deenrt_dt                in  date
35   ,p_procg_end_dt                   in  date
36   ,p_comp_lvl_cd                    in  varchar2
37   ,p_pl_id                          in  number
38   ,p_oipl_id                        in  number
39   ,p_pgm_id                         in  number
40   ,p_plip_id                        in  number
41   ,p_ptip_id                        in  number
42   ,p_pl_typ_id                      in  number
43   ,p_oiplip_id                      in  number
44   ,p_cmbn_plip_id                   in  number
45   ,p_cmbn_ptip_id                   in  number
46   ,p_cmbn_ptip_opt_id               in  number
47   ,p_assignment_id                  in  number
48   ,p_spcl_rt_pl_id                  in  number
49   ,p_spcl_rt_oipl_id                in  number
50   ,p_must_enrl_anthr_pl_id          in  number
51   ,p_int_elig_per_elctbl_chc_id          in  number
52   ,p_prtt_enrt_rslt_id              in  number
53   ,p_bnft_prvdr_pool_id             in  number
54   ,p_per_in_ler_id                  in  number
55   ,p_yr_perd_id                     in  number
56   ,p_auto_enrt_flag                 in  varchar2
57   ,p_business_group_id              in  number
58   ,p_pl_ordr_num                    in  number
59   ,p_plip_ordr_num                    in  number
60   ,p_ptip_ordr_num                    in  number
61   ,p_oipl_ordr_num                    in  number
62  -- cwb
63  ,p_comments                        in  varchar2
64  ,p_elig_flag                       in  varchar2
65  ,p_elig_ovrid_dt                   in  date
66  ,p_elig_ovrid_person_id            in  number
67  ,p_inelig_rsn_cd                   in  varchar2
68  ,p_mgr_ovrid_dt                    in  date
69  ,p_mgr_ovrid_person_id             in  number
70  ,p_ws_mgr_id                       in  number
71  -- cwb
72   ,p_epe_attribute_category         in  varchar2
73   ,p_epe_attribute1                 in  varchar2
74   ,p_epe_attribute2                 in  varchar2
75   ,p_epe_attribute3                 in  varchar2
76   ,p_epe_attribute4                 in  varchar2
77   ,p_epe_attribute5                 in  varchar2
78   ,p_epe_attribute6                 in  varchar2
79   ,p_epe_attribute7                 in  varchar2
80   ,p_epe_attribute8                 in  varchar2
81   ,p_epe_attribute9                 in  varchar2
82   ,p_epe_attribute10                in  varchar2
83   ,p_epe_attribute11                in  varchar2
84   ,p_epe_attribute12                in  varchar2
85   ,p_epe_attribute13                in  varchar2
86   ,p_epe_attribute14                in  varchar2
87   ,p_epe_attribute15                in  varchar2
88   ,p_epe_attribute16                in  varchar2
89   ,p_epe_attribute17                in  varchar2
90   ,p_epe_attribute18                in  varchar2
91   ,p_epe_attribute19                in  varchar2
92   ,p_epe_attribute20                in  varchar2
93   ,p_epe_attribute21                in  varchar2
94   ,p_epe_attribute22                in  varchar2
95   ,p_epe_attribute23                in  varchar2
96   ,p_epe_attribute24                in  varchar2
97   ,p_epe_attribute25                in  varchar2
98   ,p_epe_attribute26                in  varchar2
99   ,p_epe_attribute27                in  varchar2
100   ,p_epe_attribute28                in  varchar2
101   ,p_epe_attribute29                in  varchar2
102   ,p_epe_attribute30                in  varchar2
103   ,p_approval_status_cd             in  varchar2
104   ,p_fonm_cvg_strt_dt               in  date
105   ,p_cryfwd_elig_dpnt_cd            in  varchar2
106   ,p_request_id                     in  number
107   ,p_program_application_id         in  number
108   ,p_program_id                     in  number
109   ,p_program_update_date            in  date
110   ,p_object_version_number          in  number
111   ,p_effective_date                 in  date
112   );
113 --
114 -- ----------------------------------------------------------------------------
115 -- |---------------------------< update_ELIG_PER_ELC_CHC_a >-----------------|
116 -- ----------------------------------------------------------------------------
117 --
118 procedure update_ELIG_PER_ELC_CHC_a
119   (
120    p_elig_per_elctbl_chc_id         in  number
121 --*  ,p_enrt_typ_cycl_cd               in  varchar2
122   ,p_enrt_cvg_strt_dt_cd            in  varchar2
123 --*  ,p_enrt_perd_end_dt               in  date
124 --*  ,p_enrt_perd_strt_dt              in  date
125   ,p_enrt_cvg_strt_dt_rl            in  varchar2
126 --  ,p_rt_strt_dt                     in  date
127 --  ,p_rt_strt_dt_rl                  in  varchar2
128 --  ,p_rt_strt_dt_cd                  in  varchar2
129  ,p_ctfn_rqd_flag                  in varchar2
130  ,p_pil_elctbl_chc_popl_id         in number
131   ,p_roll_crs_flag             in  varchar2
132   ,p_crntly_enrd_flag               in  varchar2
133   ,p_dflt_flag                      in  varchar2
134   ,p_elctbl_flag                    in  varchar2
135   ,p_mndtry_flag                    in  varchar2
136   ,p_in_pndg_wkflow_flag            in  varchar2
137 --*  ,p_dflt_enrt_dt                   in  date
138   ,p_dpnt_cvg_strt_dt_cd            in  varchar2
139   ,p_dpnt_cvg_strt_dt_rl            in  varchar2
140   ,p_enrt_cvg_strt_dt               in  date
141   ,p_alws_dpnt_dsgn_flag            in  varchar2
142   ,p_dpnt_dsgn_cd                   in  varchar2
143   ,p_ler_chg_dpnt_cvg_cd            in  varchar2
144   ,p_erlst_deenrt_dt                in  date
145   ,p_procg_end_dt                   in  date
146   ,p_comp_lvl_cd                    in  varchar2
147   ,p_pl_id                          in  number
148   ,p_oipl_id                        in  number
149   ,p_pgm_id                         in  number
150   ,p_plip_id                        in  number
151   ,p_ptip_id                        in  number
152   ,p_pl_typ_id                      in  number
153   ,p_oiplip_id                      in  number
154   ,p_cmbn_plip_id                   in  number
155   ,p_cmbn_ptip_id                   in  number
156   ,p_cmbn_ptip_opt_id               in  number
157   ,p_assignment_id                  in  number
158   ,p_spcl_rt_pl_id                  in  number
159   ,p_spcl_rt_oipl_id                in  number
160   ,p_must_enrl_anthr_pl_id          in  number
161   ,p_int_elig_per_elctbl_chc_id          in  number
162   ,p_prtt_enrt_rslt_id              in  number
163   ,p_bnft_prvdr_pool_id             in  number
164   ,p_per_in_ler_id                  in  number
165   ,p_yr_perd_id                     in  number
166   ,p_auto_enrt_flag                 in  varchar2
167   ,p_business_group_id              in  number
168   ,p_pl_ordr_num                    in  number
169   ,p_plip_ordr_num                    in  number
170   ,p_ptip_ordr_num                    in  number
171   ,p_oipl_ordr_num                    in  number
172  -- cwb
173  ,p_comments                        in  varchar2
174  ,p_elig_flag                       in  varchar2
175  ,p_elig_ovrid_dt                   in  date
176  ,p_elig_ovrid_person_id            in  number
177  ,p_inelig_rsn_cd                   in  varchar2
178  ,p_mgr_ovrid_dt                    in  date
179  ,p_mgr_ovrid_person_id             in  number
180  ,p_ws_mgr_id                       in  number
181  -- cwb
182   ,p_epe_attribute_category         in  varchar2
183   ,p_epe_attribute1                 in  varchar2
184   ,p_epe_attribute2                 in  varchar2
185   ,p_epe_attribute3                 in  varchar2
186   ,p_epe_attribute4                 in  varchar2
187   ,p_epe_attribute5                 in  varchar2
188   ,p_epe_attribute6                 in  varchar2
189   ,p_epe_attribute7                 in  varchar2
190   ,p_epe_attribute8                 in  varchar2
191   ,p_epe_attribute9                 in  varchar2
192   ,p_epe_attribute10                in  varchar2
193   ,p_epe_attribute11                in  varchar2
194   ,p_epe_attribute12                in  varchar2
195   ,p_epe_attribute13                in  varchar2
196   ,p_epe_attribute14                in  varchar2
197   ,p_epe_attribute15                in  varchar2
198   ,p_epe_attribute16                in  varchar2
199   ,p_epe_attribute17                in  varchar2
200   ,p_epe_attribute18                in  varchar2
201   ,p_epe_attribute19                in  varchar2
202   ,p_epe_attribute20                in  varchar2
203   ,p_epe_attribute21                in  varchar2
204   ,p_epe_attribute22                in  varchar2
205   ,p_epe_attribute23                in  varchar2
206   ,p_epe_attribute24                in  varchar2
207   ,p_epe_attribute25                in  varchar2
208   ,p_epe_attribute26                in  varchar2
209   ,p_epe_attribute27                in  varchar2
210   ,p_epe_attribute28                in  varchar2
211   ,p_epe_attribute29                in  varchar2
212   ,p_epe_attribute30                in  varchar2
213   ,p_approval_status_cd             in  varchar2
214   ,p_fonm_cvg_strt_dt               in  date
215   ,p_cryfwd_elig_dpnt_cd            in  varchar2
216   ,p_request_id                     in  number
217   ,p_program_application_id         in  number
218   ,p_program_id                     in  number
219   ,p_program_update_date            in  date
220   ,p_object_version_number          in  number
221   ,p_effective_date                 in  date
222   );
223 --
224 end ben_ELIG_PER_ELC_CHC_bk2;