1 Package ben_batch_elctbl_chc_api as
2 /* $Header: bebecapi.pkh 120.0 2005/05/28 00:37:14 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_batch_elctbl_chc >-----------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_benefit_action_id Yes number
18 -- p_person_id Yes number
19 -- p_pgm_id No number
20 -- p_pl_id No number
21 -- p_oipl_id No number
22 -- p_enrt_cvg_strt_dt No date
23 -- p_enrt_perd_strt_dt No date
24 -- p_enrt_perd_end_dt No date
25 -- p_erlst_deenrt_dt No date
26 -- p_dflt_enrt_dt No date
27 -- p_enrt_typ_cycl_cd No varchar2
28 -- p_comp_lvl_cd No varchar2
29 -- p_mndtry_flag Yes varchar2
30 -- p_dflt_flag Yes varchar2
31 -- p_business_group_id Yes number Business Group of Record
32 -- p_effective_date Yes date Session Date.
33 --
34 -- Post Success:
35 --
36 -- Out Parameters:
37 -- Name Type Description
38 -- p_batch_elctbl_id Yes number PK of record
39 -- p_object_version_number Yes number OVN of record
40 --
41 -- Post Failure:
42 --
43 -- Access Status:
44 -- Public.
45 --
46 -- {End Of Comments}
47 --
48 procedure create_batch_elctbl_chc
49 (p_validate in boolean default false
50 ,p_batch_elctbl_id out nocopy number
51 ,p_benefit_action_id in number default null
52 ,p_person_id in number default null
53 ,p_pgm_id in number default null
54 ,p_pl_id in number default null
55 ,p_oipl_id in number default null
56 ,p_enrt_cvg_strt_dt in date default null
57 ,p_enrt_perd_strt_dt in date default null
58 ,p_enrt_perd_end_dt in date default null
59 ,p_erlst_deenrt_dt in date default null
60 ,p_dflt_enrt_dt in date default null
61 ,p_enrt_typ_cycl_cd in varchar2 default null
62 ,p_comp_lvl_cd in varchar2 default null
63 ,p_mndtry_flag in varchar2 default null
64 ,p_dflt_flag in varchar2 default null
65 ,p_business_group_id in number default null
66 ,p_object_version_number out nocopy number
67 ,p_effective_date in date);
68 -- ----------------------------------------------------------------------------
69 -- |------------------------< update_batch_elctbl_chc >-----------------------|
70 -- ----------------------------------------------------------------------------
71 -- {Start Of Comments}
72 --
73 -- Description:
74 --
75 -- Prerequisites:
76 --
77 --
78 -- In Parameters:
79 -- Name Reqd Type Description
80 -- p_validate Yes boolean Commit or Rollback.
81 -- p_batch_elctbl_id Yes number PK of record
82 -- p_benefit_action_id Yes number
83 -- p_person_id Yes number
84 -- p_pgm_id No number
85 -- p_pl_id No number
86 -- p_oipl_id No number
87 -- p_enrt_cvg_strt_dt No date
88 -- p_enrt_perd_strt_dt No date
89 -- p_enrt_perd_end_dt No date
90 -- p_erlst_deenrt_dt No date
91 -- p_dflt_enrt_dt No date
92 -- p_enrt_typ_cycl_cd No varchar2
93 -- p_comp_lvl_cd No varchar2
94 -- p_mndtry_flag Yes varchar2
95 -- p_dflt_flag Yes varchar2
96 -- p_business_group_id Yes number Business Group of Record
97 -- p_effective_date Yes date Session Date.
98 --
99 -- Post Success:
100 --
101 -- Name Type Description
102 -- p_object_version_number Yes number OVN of record
103 --
104 -- Post Failure:
105 --
106 -- Access Status:
107 -- Public.
108 --
109 -- {End Of Comments}
110 --
111 procedure update_batch_elctbl_chc
112 (p_validate in boolean default false
113 ,p_batch_elctbl_id in number
114 ,p_benefit_action_id in number default hr_api.g_number
115 ,p_person_id in number default hr_api.g_number
116 ,p_pgm_id in number default hr_api.g_number
117 ,p_pl_id in number default hr_api.g_number
118 ,p_oipl_id in number default hr_api.g_number
119 ,p_enrt_cvg_strt_dt in date default hr_api.g_date
120 ,p_enrt_perd_strt_dt in date default hr_api.g_date
121 ,p_enrt_perd_end_dt in date default hr_api.g_date
122 ,p_erlst_deenrt_dt in date default hr_api.g_date
123 ,p_dflt_enrt_dt in date default hr_api.g_date
124 ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
125 ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
126 ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
127 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
128 ,p_business_group_id in number default hr_api.g_number
129 ,p_object_version_number in out nocopy number
130 ,p_effective_date in date);
131 --
132 -- ----------------------------------------------------------------------------
133 -- |------------------------< delete_batch_elctbl_chc >-----------------------|
134 -- ----------------------------------------------------------------------------
135 -- {Start Of Comments}
136 --
137 -- Description:
138 --
139 -- Prerequisites:
140 --
141 --
142 -- In Parameters:
143 -- Name Reqd Type Description
144 -- p_validate Yes boolean Commit or Rollback.
145 -- p_batch_elctbl_id Yes number PK of record
146 -- p_effective_date Yes date Session Date.
147 --
148 -- Post Success:
149 --
150 -- Name Type Description
151 -- p_object_version_number Yes number OVN of record
152 --
153 -- Post Failure:
154 --
155 -- Access Status:
156 -- Public.
157 --
158 -- {End Of Comments}
159 --
160 procedure delete_batch_elctbl_chc
161 (p_validate in boolean default false
162 ,p_batch_elctbl_id in number
163 ,p_object_version_number in out nocopy number
164 ,p_effective_date in date);
165 --
166 -- ----------------------------------------------------------------------------
167 -- |----------------------------------< lck >---------------------------------|
168 -- ----------------------------------------------------------------------------
169 -- {Start Of Comments}
170 --
171 -- Description:
172 --
173 -- Prerequisites:
174 --
175 --
176 -- In Parameters:
177 -- Name Reqd Type Description
178 -- p_batch_elctbl_id Yes number PK of record
179 -- p_object_version_number Yes number OVN of record
180 --
181 -- Post Success:
182 --
183 -- Name Type Description
184 --
185 -- Post Failure:
186 --
187 -- Access Status:
188 -- Public.
189 --
190 -- {End Of Comments}
191 --
192 procedure lck
193 (p_batch_elctbl_id in number
194 ,p_object_version_number in number);
195 --
196 end ben_batch_elctbl_chc_api;