[Home] [Help]
PACKAGE: APPS.BEN_PROGRAM_API
Source
1 Package ben_Program_api AUTHID CURRENT_USER as
2 /* $Header: bepgmapi.pkh 120.0.12020000.2 2012/07/03 13:10:16 amnaraya ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_Program >------------------------|
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_name Yes varchar2
18 -- p_dpnt_adrs_rqd_flag Yes varchar2
19 -- p_pgm_prvds_no_auto_enrt_flag Yes varchar2
20 -- p_dpnt_dob_rqd_flag Yes varchar2
21 -- p_pgm_prvds_no_dflt_enrt_flag Yes varchar2
22 -- p_dpnt_legv_id_rqd_flag Yes varchar2
23 -- p_dpnt_dsgn_lvl_cd No varchar2
24 -- p_pgm_stat_cd No varchar2
25 -- p_ivr_ident No varchar2
26 -- p_pgm_typ_cd No varchar2
27 -- p_elig_apls_flag Yes varchar2
28 -- p_uses_all_asmts_for_rts_flag Yes varchar2
29 -- p_url_ref_name No varchar2
30 -- p_pgm_desc No varchar2
31 -- p_prtn_elig_ovrid_alwd_flag Yes varchar2
32 -- p_pgm_use_all_asnts_elig_flag Yes varchar2
33 -- p_dpnt_dsgn_cd No varchar2
34 -- p_mx_dpnt_pct_prtt_lf_amt No number
35 -- p_mx_sps_pct_prtt_lf_amt No number
36 -- p_acty_ref_perd_cd No varchar2
37 -- p_coord_cvg_for_all_pls_flg Yes varchar2
38 -- p_enrt_cvg_end_dt_cd No varchar2
39 -- p_enrt_cvg_end_dt_rl No number
40 -- p_dpnt_cvg_end_dt_cd No varchar2
41 -- p_dpnt_cvg_end_dt_rl No number
42 -- p_dpnt_cvg_strt_dt_cd No varchar2
43 -- p_dpnt_cvg_strt_dt_rl No number
44 -- p_per_cvrd_cd No varchar2
45 -- P_vrfy_fmly_mmbr_rl No number
46 -- P_vrfy_fmly_mmbr_cd No varchar2
47 -- p_dpnt_dsgn_no_ctfn_rqd_flag Yes varchar2
48 -- p_drvbl_fctr_dpnt_elig_flag Yes varchar2
49 -- p_drvbl_fctr_prtn_elig_flag Yes varchar2
50 -- p_enrt_cvg_strt_dt_cd No varchar2
51 -- p_enrt_cvg_strt_dt_rl No number
52 -- p_enrt_info_rt_freq_cd No varchar2
53 -- p_rt_strt_dt_cd No varchar2
54 -- p_rt_strt_dt_rl No number
55 -- p_rt_end_dt_cd No varchar2
56 -- p_rt_end_dt_rl No number
57 -- p_pgm_grp_cd No varchar2
58 -- p_pgm_uom No varchar2
59 -- p_drvbl_fctr_apls_rts_flag Yes varchar2
60 -- p_alws_unrstrctd_enrt_flag Yes varchar2
61 -- p_enrt_cd No varchar2
62 -- p_enrt_mthd_cd No varchar2
63 -- p_poe_lvl_cd No varchar2
64 -- p_enrt_rl No number
65 -- p_auto_enrt_mthd_rl No number
66 -- p_trk_inelig_per_flag Yes varchar2
67 -- p_business_group_id Yes number Business Group of Record
68 -- p_short_name No varchar2 FHR
69 -- p_short_code No varchar2 FHR
70 -- p_legislation_code No varchar2 FHR
71 -- p_legislation_subgroup No varchar2 FHR
72 -- p_Dflt_pgm_flag Yes Varchar2
73 -- p_Use_prog_points_flag Yes Varchar2
74 -- p_Dflt_step_cd No Varchar2
75 -- p_Dflt_step_rl No number
76 -- p_Update_salary_cd No Varchar2
77 -- p_Use_multi_pay_rates_flag Yes Varchar2
78 -- p_dflt_element_type_id No number
79 -- p_Dflt_input_value_id No number
80 -- p_Use_scores_cd No Varchar2
81 -- p_Scores_calc_mthd_cd No Varchar2
82 -- p_Scores_calc_rl No number
83 -- p_gsp_allow_override_flag No varchar2 Descriptive Flexfield
84 -- p_use_variable_rates_flag No varchar2 Descriptive Flexfield
85 -- p_salary_calc_mthd_cd No varchar2 Descriptive Flexfield
86 -- p_salary_calc_mthd_rl No number Descriptive Flexfield
87 -- p_pgm_attribute_category No varchar2 Descriptive Flexfield
88 -- p_pgm_attribute1 No varchar2 Descriptive Flexfield
89 -- p_pgm_attribute2 No varchar2 Descriptive Flexfield
90 -- p_pgm_attribute3 No varchar2 Descriptive Flexfield
91 -- p_pgm_attribute4 No varchar2 Descriptive Flexfield
92 -- p_pgm_attribute5 No varchar2 Descriptive Flexfield
93 -- p_pgm_attribute6 No varchar2 Descriptive Flexfield
94 -- p_pgm_attribute7 No varchar2 Descriptive Flexfield
95 -- p_pgm_attribute8 No varchar2 Descriptive Flexfield
96 -- p_pgm_attribute9 No varchar2 Descriptive Flexfield
97 -- p_pgm_attribute10 No varchar2 Descriptive Flexfield
98 -- p_pgm_attribute11 No varchar2 Descriptive Flexfield
99 -- p_pgm_attribute12 No varchar2 Descriptive Flexfield
100 -- p_pgm_attribute13 No varchar2 Descriptive Flexfield
101 -- p_pgm_attribute14 No varchar2 Descriptive Flexfield
102 -- p_pgm_attribute15 No varchar2 Descriptive Flexfield
103 -- p_pgm_attribute16 No varchar2 Descriptive Flexfield
104 -- p_pgm_attribute17 No varchar2 Descriptive Flexfield
105 -- p_pgm_attribute18 No varchar2 Descriptive Flexfield
106 -- p_pgm_attribute19 No varchar2 Descriptive Flexfield
107 -- p_pgm_attribute20 No varchar2 Descriptive Flexfield
108 -- p_pgm_attribute21 No varchar2 Descriptive Flexfield
109 -- p_pgm_attribute22 No varchar2 Descriptive Flexfield
110 -- p_pgm_attribute23 No varchar2 Descriptive Flexfield
111 -- p_pgm_attribute24 No varchar2 Descriptive Flexfield
112 -- p_pgm_attribute25 No varchar2 Descriptive Flexfield
113 -- p_pgm_attribute26 No varchar2 Descriptive Flexfield
114 -- p_pgm_attribute27 No varchar2 Descriptive Flexfield
115 -- p_pgm_attribute28 No varchar2 Descriptive Flexfield
116 -- p_pgm_attribute29 No varchar2 Descriptive Flexfield
117 -- p_pgm_attribute30 No varchar2 Descriptive Flexfield
118 -- p_effective_date Yes date Session Date.
119 --
120 -- Post Success:
121 --
122 -- Out Parameters:
123 -- Name Type Description
124 -- p_pgm_id Yes number PK of record
125 -- p_effective_start_date Yes date Effective Start Date of Record
126 -- p_effective_end_date Yes date Effective End Date of Record
127 -- p_object_version_number No number OVN of record
128 --
129 -- Post Failure:
130 --
131 -- Access Status:
132 -- Public.
133 --
134 -- {End Of Comments}
135 --
136 procedure create_Program
137 (
138 p_validate in boolean default false
139 ,p_pgm_id out nocopy number
140 ,p_effective_start_date out nocopy date
141 ,p_effective_end_date out nocopy date
142 ,p_name in varchar2 default null
143 ,p_dpnt_adrs_rqd_flag in varchar2 default null
144 ,p_pgm_prvds_no_auto_enrt_flag in varchar2 default null
145 ,p_dpnt_dob_rqd_flag in varchar2 default null
146 ,p_pgm_prvds_no_dflt_enrt_flag in varchar2 default null
147 ,p_dpnt_legv_id_rqd_flag in varchar2 default null
148 ,p_dpnt_dsgn_lvl_cd in varchar2 default null
149 ,p_pgm_stat_cd in varchar2 default null
150 ,p_ivr_ident in varchar2 default null
151 ,p_pgm_typ_cd in varchar2 default null
152 ,p_elig_apls_flag in varchar2 default 'N'
153 ,p_uses_all_asmts_for_rts_flag in varchar2 default null
154 ,p_url_ref_name in varchar2 default null
155 ,p_pgm_desc in varchar2 default null
156 ,p_prtn_elig_ovrid_alwd_flag in varchar2 default null
157 ,p_pgm_use_all_asnts_elig_flag in varchar2 default null
158 ,p_dpnt_dsgn_cd in varchar2 default null
159 ,p_mx_dpnt_pct_prtt_lf_amt in number default null
160 ,p_mx_sps_pct_prtt_lf_amt in number default null
161 ,p_acty_ref_perd_cd in varchar2 default null
162 ,p_coord_cvg_for_all_pls_flg in varchar2 default null
163 ,p_enrt_cvg_end_dt_cd in varchar2 default null
164 ,p_enrt_cvg_end_dt_rl in number default null
165 ,p_dpnt_cvg_end_dt_cd in varchar2 default null
166 ,p_dpnt_cvg_end_dt_rl in number default null
167 ,p_dpnt_cvg_strt_dt_cd in varchar2 default null
168 ,p_dpnt_cvg_strt_dt_rl in number default null
169 ,p_dpnt_dsgn_no_ctfn_rqd_flag in varchar2 default null
170 ,p_drvbl_fctr_dpnt_elig_flag in varchar2 default null
171 ,p_drvbl_fctr_prtn_elig_flag in varchar2 default null
172 ,p_enrt_cvg_strt_dt_cd in varchar2 default null
173 ,p_enrt_cvg_strt_dt_rl in number default null
174 ,p_enrt_info_rt_freq_cd in varchar2 default null
175 ,p_rt_strt_dt_cd in varchar2 default null
176 ,p_rt_strt_dt_rl in number default null
177 ,p_rt_end_dt_cd in varchar2 default null
178 ,p_rt_end_dt_rl in number default null
179 ,p_pgm_grp_cd in varchar2 default null
180 ,p_pgm_uom in varchar2 default null
181 ,p_drvbl_fctr_apls_rts_flag in varchar2 default null
182 ,p_alws_unrstrctd_enrt_flag in varchar2 default null
183 ,p_enrt_cd in varchar2 default null
184 ,p_enrt_mthd_cd in varchar2 default null
185 ,p_poe_lvl_cd in varchar2 default null
186 ,p_enrt_rl in number default null
187 ,p_auto_enrt_mthd_rl in number default null
188 ,p_trk_inelig_per_flag in varchar2 default null
189 ,p_business_group_id in number default null
190 ,p_per_cvrd_cd in varchar2 default null
191 ,P_vrfy_fmly_mmbr_rl in number default null
192 ,P_vrfy_fmly_mmbr_cd in varchar2 default null
193 ,p_short_name in varchar2 default null
194 ,p_short_code in varchar2 default null
195 ,p_legislation_code in varchar2 default null
196 ,p_legislation_subgroup in varchar2 default null
197 ,p_Dflt_pgm_flag in Varchar2 default null
198 ,p_Use_prog_points_flag in Varchar2 default null
199 ,p_Dflt_step_cd in Varchar2 default null
200 ,p_Dflt_step_rl in number default null
201 ,p_Update_salary_cd in Varchar2 default null
202 ,p_Use_multi_pay_rates_flag in Varchar2 default null
203 ,p_dflt_element_type_id in number default null
204 ,p_Dflt_input_value_id in number default null
205 ,p_Use_scores_cd in Varchar2 default null
206 ,p_Scores_calc_mthd_cd in Varchar2 default null
207 ,p_Scores_calc_rl in number default null
208 ,p_gsp_allow_override_flag in varchar2 default null
209 ,p_use_variable_rates_flag in varchar2 default null
210 ,p_salary_calc_mthd_cd in varchar2 default null
211 ,p_salary_calc_mthd_rl in number default null
212 ,p_susp_if_dpnt_ssn_nt_prv_cd in varchar2 default null
213 ,p_susp_if_dpnt_dob_nt_prv_cd in varchar2 default null
214 ,p_susp_if_dpnt_adr_nt_prv_cd in varchar2 default null
215 ,p_susp_if_ctfn_not_dpnt_flag in varchar2 default 'Y'
216 ,p_dpnt_ctfn_determine_cd in varchar2 default null
217 ,p_pgm_attribute_category in varchar2 default null
218 ,p_pgm_attribute1 in varchar2 default null
219 ,p_pgm_attribute2 in varchar2 default null
220 ,p_pgm_attribute3 in varchar2 default null
221 ,p_pgm_attribute4 in varchar2 default null
222 ,p_pgm_attribute5 in varchar2 default null
223 ,p_pgm_attribute6 in varchar2 default null
224 ,p_pgm_attribute7 in varchar2 default null
225 ,p_pgm_attribute8 in varchar2 default null
226 ,p_pgm_attribute9 in varchar2 default null
227 ,p_pgm_attribute10 in varchar2 default null
228 ,p_pgm_attribute11 in varchar2 default null
229 ,p_pgm_attribute12 in varchar2 default null
230 ,p_pgm_attribute13 in varchar2 default null
231 ,p_pgm_attribute14 in varchar2 default null
232 ,p_pgm_attribute15 in varchar2 default null
233 ,p_pgm_attribute16 in varchar2 default null
234 ,p_pgm_attribute17 in varchar2 default null
235 ,p_pgm_attribute18 in varchar2 default null
236 ,p_pgm_attribute19 in varchar2 default null
237 ,p_pgm_attribute20 in varchar2 default null
238 ,p_pgm_attribute21 in varchar2 default null
239 ,p_pgm_attribute22 in varchar2 default null
240 ,p_pgm_attribute23 in varchar2 default null
241 ,p_pgm_attribute24 in varchar2 default null
242 ,p_pgm_attribute25 in varchar2 default null
243 ,p_pgm_attribute26 in varchar2 default null
244 ,p_pgm_attribute27 in varchar2 default null
245 ,p_pgm_attribute28 in varchar2 default null
246 ,p_pgm_attribute29 in varchar2 default null
247 ,p_pgm_attribute30 in varchar2 default null
248 ,p_all_inelig in varchar2 default null
249 ,p_object_version_number out nocopy number
250 ,p_effective_date in date
251 );
252 -- ----------------------------------------------------------------------------
253 -- |------------------------< update_Program >------------------------|
254 -- ----------------------------------------------------------------------------
255 -- {Start Of Comments}
256 --
257 -- Description:
258 --
259 -- Prerequisites:
260 --
261 --
262 -- In Parameters:
263 -- Name Reqd Type Description
264 -- p_validate Yes boolean Commit or Rollback.
265 -- p_pgm_id Yes number PK of record
266 -- p_name Yes varchar2
267 -- p_dpnt_adrs_rqd_flag Yes varchar2
268 -- p_pgm_prvds_no_auto_enrt_flag Yes varchar2
269 -- p_dpnt_dob_rqd_flag Yes varchar2
270 -- p_pgm_prvds_no_dflt_enrt_flag Yes varchar2
271 -- p_dpnt_legv_id_rqd_flag Yes varchar2
272 -- p_dpnt_dsgn_lvl_cd No varchar2
273 -- p_pgm_stat_cd No varchar2
274 -- p_ivr_ident No varchar2
275 -- p_pgm_typ_cd No varchar2
276 -- p_elig_apls_flag Yes varchar2
277 -- p_uses_all_asmts_for_rts_flag Yes varchar2
278 -- p_url_ref_name No varchar2
279 -- p_pgm_desc No varchar2
280 -- p_prtn_elig_ovrid_alwd_flag Yes varchar2
281 -- p_pgm_use_all_asnts_elig_flag Yes varchar2
282 -- p_dpnt_dsgn_cd No varchar2
283 -- p_mx_dpnt_pct_prtt_lf_amt No number
284 -- p_mx_sps_pct_prtt_lf_amt No number
285 -- p_acty_ref_perd_cd No varchar2
286 -- p_coord_cvg_for_all_pls_flg Yes varchar2
287 -- p_enrt_cvg_end_dt_cd No varchar2
288 -- p_enrt_cvg_end_dt_rl No number
289 -- p_dpnt_cvg_end_dt_cd No varchar2
290 -- p_dpnt_cvg_end_dt_rl No number
291 -- p_dpnt_cvg_strt_dt_cd No varchar2
292 -- p_dpnt_cvg_strt_dt_rl No number
293 -- p_dpnt_dsgn_no_ctfn_rqd_flag Yes varchar2
294 -- p_drvbl_fctr_dpnt_elig_flag Yes varchar2
295 -- p_drvbl_fctr_prtn_elig_flag Yes varchar2
296 -- p_enrt_cvg_strt_dt_cd No varchar2
297 -- p_enrt_cvg_strt_dt_rl No number
298 -- p_enrt_info_rt_freq_cd No varchar2
299 -- p_rt_strt_dt_cd No varchar2
300 -- p_rt_strt_dt_rl No number
301 -- p_rt_end_dt_cd No varchar2
302 -- p_rt_end_dt_rl No number
303 -- p_pgm_grp_cd No varchar2
304 -- p_pgm_uom No varchar2
305 -- p_drvbl_fctr_apls_rts_flag Yes varchar2
306 -- p_alws_unrstrctd_enrt_flag Yes varchar2
307 -- p_enrt_cd No varchar2
308 -- p_enrt_mthd_cd No varchar2
309 -- p_poe_lvl_cd No varchar2
310 -- p_enrt_rl No number
311 -- p_auto_enrt_mthd_rl No number
312 -- p_trk_inelig_per_flag Yes varchar2
313 -- p_business_group_id Yes number Business Group of Record
314 -- p_per_cvrd_cd No varchar2
315 -- P_vrfy_fmly_mmbr_rl No number
316 -- P_vrfy_fmly_mmbr_cd No varchar2
317 -- p_short_name No varchar2 FHR
318 -- p_short_code No varchar2 FHR
319 -- p_legislation_code No varchar2 FHR
320 -- p_legislation_subgroup No varchar2 FHR
321 -- p_Dflt_pgm_flag Yes Varchar2
322 -- p_Use_prog_points_flag Yes Varchar2
323 -- p_Dflt_step_cd No Varchar2
324 -- p_Dflt_step_rl No number
325 -- p_Update_salary_cd No Varchar2
326 -- p_Use_multi_pay_rates_flag Yes Varchar2
327 -- p_dflt_element_type_id No number
328 -- p_Dflt_input_value_id No number
329 -- p_Use_scores_cd No Varchar2
330 -- p_Scores_calc_mthd_cd No Varchar2
331 -- p_Scores_calc_rl No number
332 -- p_gsp_allow_override_flag No varchar2 Descriptive Flexfield
333 -- p_use_variable_rates_flag No varchar2 Descriptive Flexfield
334 -- p_salary_calc_mthd_cd No varchar2 Descriptive Flexfield
335 -- p_salary_calc_mthd_rl No number Descriptive Flexfield
336 -- p_pgm_attribute_category No varchar2 Descriptive Flexfield
337 -- p_pgm_attribute1 No varchar2 Descriptive Flexfield
338 -- p_pgm_attribute2 No varchar2 Descriptive Flexfield
339 -- p_pgm_attribute3 No varchar2 Descriptive Flexfield
340 -- p_pgm_attribute4 No varchar2 Descriptive Flexfield
341 -- p_pgm_attribute5 No varchar2 Descriptive Flexfield
342 -- p_pgm_attribute6 No varchar2 Descriptive Flexfield
343 -- p_pgm_attribute7 No varchar2 Descriptive Flexfield
344 -- p_pgm_attribute8 No varchar2 Descriptive Flexfield
345 -- p_pgm_attribute9 No varchar2 Descriptive Flexfield
346 -- p_pgm_attribute10 No varchar2 Descriptive Flexfield
347 -- p_pgm_attribute11 No varchar2 Descriptive Flexfield
348 -- p_pgm_attribute12 No varchar2 Descriptive Flexfield
349 -- p_pgm_attribute13 No varchar2 Descriptive Flexfield
350 -- p_pgm_attribute14 No varchar2 Descriptive Flexfield
351 -- p_pgm_attribute15 No varchar2 Descriptive Flexfield
352 -- p_pgm_attribute16 No varchar2 Descriptive Flexfield
353 -- p_pgm_attribute17 No varchar2 Descriptive Flexfield
354 -- p_pgm_attribute18 No varchar2 Descriptive Flexfield
355 -- p_pgm_attribute19 No varchar2 Descriptive Flexfield
356 -- p_pgm_attribute20 No varchar2 Descriptive Flexfield
357 -- p_pgm_attribute21 No varchar2 Descriptive Flexfield
358 -- p_pgm_attribute22 No varchar2 Descriptive Flexfield
359 -- p_pgm_attribute23 No varchar2 Descriptive Flexfield
360 -- p_pgm_attribute24 No varchar2 Descriptive Flexfield
361 -- p_pgm_attribute25 No varchar2 Descriptive Flexfield
362 -- p_pgm_attribute26 No varchar2 Descriptive Flexfield
363 -- p_pgm_attribute27 No varchar2 Descriptive Flexfield
364 -- p_pgm_attribute28 No varchar2 Descriptive Flexfield
365 -- p_pgm_attribute29 No varchar2 Descriptive Flexfield
366 -- p_pgm_attribute30 No varchar2 Descriptive Flexfield
367 -- p_effective_date Yes date Session Date.
368 -- p_datetrack_mode Yes varchar2 Datetrack mode.
369 --
370 -- Post Success:
371 --
372 -- Name Type Description
373 -- p_effective_start_date Yes date Effective Start Date of Record
374 -- p_effective_end_date Yes date Effective End Date of Record
375 -- p_object_version_number No number OVN of record
376 --
377 -- Post Failure:
378 --
379 -- Access Status:
380 -- Public.
381 --
382 -- {End Of Comments}
383 --
384 procedure update_Program
385 (
386 p_validate in boolean default false
387 ,p_pgm_id in number
388 ,p_effective_start_date out nocopy date
389 ,p_effective_end_date out nocopy date
390 ,p_name in varchar2 default hr_api.g_varchar2
391 ,p_dpnt_adrs_rqd_flag in varchar2 default hr_api.g_varchar2
392 ,p_pgm_prvds_no_auto_enrt_flag in varchar2 default hr_api.g_varchar2
393 ,p_dpnt_dob_rqd_flag in varchar2 default hr_api.g_varchar2
394 ,p_pgm_prvds_no_dflt_enrt_flag in varchar2 default hr_api.g_varchar2
395 ,p_dpnt_legv_id_rqd_flag in varchar2 default hr_api.g_varchar2
396 ,p_dpnt_dsgn_lvl_cd in varchar2 default hr_api.g_varchar2
397 ,p_pgm_stat_cd in varchar2 default hr_api.g_varchar2
398 ,p_ivr_ident in varchar2 default hr_api.g_varchar2
399 ,p_pgm_typ_cd in varchar2 default hr_api.g_varchar2
400 ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
401 ,p_uses_all_asmts_for_rts_flag in varchar2 default hr_api.g_varchar2
402 ,p_url_ref_name in varchar2 default hr_api.g_varchar2
403 ,p_pgm_desc in varchar2 default hr_api.g_varchar2
404 ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
405 ,p_pgm_use_all_asnts_elig_flag in varchar2 default hr_api.g_varchar2
406 ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
407 ,p_mx_dpnt_pct_prtt_lf_amt in number default hr_api.g_number
408 ,p_mx_sps_pct_prtt_lf_amt in number default hr_api.g_number
409 ,p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
410 ,p_coord_cvg_for_all_pls_flg in varchar2 default hr_api.g_varchar2
411 ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
412 ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
413 ,p_dpnt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
414 ,p_dpnt_cvg_end_dt_rl in number default hr_api.g_number
415 ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
416 ,p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number
417 ,p_dpnt_dsgn_no_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
418 ,p_drvbl_fctr_dpnt_elig_flag in varchar2 default hr_api.g_varchar2
419 ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
420 ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
421 ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
422 ,p_enrt_info_rt_freq_cd in varchar2 default hr_api.g_varchar2
423 ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
424 ,p_rt_strt_dt_rl in number default hr_api.g_number
425 ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
426 ,p_rt_end_dt_rl in number default hr_api.g_number
427 ,p_pgm_grp_cd in varchar2 default hr_api.g_varchar2
428 ,p_pgm_uom in varchar2 default hr_api.g_varchar2
429 ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
430 ,p_alws_unrstrctd_enrt_flag in varchar2 default hr_api.g_varchar2
431 ,p_enrt_cd in varchar2 default hr_api.g_varchar2
432 ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
433 ,p_poe_lvl_cd in varchar2 default hr_api.g_varchar2
434 ,p_enrt_rl in number default hr_api.g_number
435 ,p_auto_enrt_mthd_rl in number default hr_api.g_number
436 ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
437 ,p_business_group_id in number default hr_api.g_number
438 ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
439 ,P_vrfy_fmly_mmbr_rl in number default hr_api.g_number
440 ,P_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
441 ,P_short_name in varchar2 default hr_api.g_varchar2
442 ,P_short_code in varchar2 default hr_api.g_varchar2
443 ,P_legislation_code in varchar2 default hr_api.g_varchar2
444 ,P_legislation_subgroup in varchar2 default hr_api.g_varchar2
445 ,p_Dflt_pgm_flag in Varchar2 default hr_api.g_varchar2
446 ,p_Use_prog_points_flag in Varchar2 default hr_api.g_varchar2
447 ,p_Dflt_step_cd in Varchar2 default hr_api.g_varchar2
448 ,p_Dflt_step_rl in number default hr_api.g_number
449 ,p_Update_salary_cd in Varchar2 default hr_api.g_varchar2
450 ,p_Use_multi_pay_rates_flag in Varchar2 default hr_api.g_varchar2
451 ,p_dflt_element_type_id in number default hr_api.g_number
452 ,p_Dflt_input_value_id in number default hr_api.g_number
453 ,p_Use_scores_cd in Varchar2 default hr_api.g_varchar2
454 ,p_Scores_calc_mthd_cd in Varchar2 default hr_api.g_varchar2
455 ,p_Scores_calc_rl in number default hr_api.g_number
456 ,p_gsp_allow_override_flag in varchar2 default hr_api.g_varchar2
457 ,p_use_variable_rates_flag in varchar2 default hr_api.g_varchar2
458 ,p_salary_calc_mthd_cd in varchar2 default hr_api.g_varchar2
459 ,p_salary_calc_mthd_rl in number default hr_api.g_number
460 ,p_susp_if_dpnt_ssn_nt_prv_cd in varchar2 default hr_api.g_varchar2
461 ,p_susp_if_dpnt_dob_nt_prv_cd in varchar2 default hr_api.g_varchar2
462 ,p_susp_if_dpnt_adr_nt_prv_cd in varchar2 default hr_api.g_varchar2
463 ,p_susp_if_ctfn_not_dpnt_flag in varchar2 default hr_api.g_varchar2
464 ,p_dpnt_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
465 ,p_pgm_attribute_category in varchar2 default hr_api.g_varchar2
466 ,p_pgm_attribute1 in varchar2 default hr_api.g_varchar2
467 ,p_pgm_attribute2 in varchar2 default hr_api.g_varchar2
468 ,p_pgm_attribute3 in varchar2 default hr_api.g_varchar2
469 ,p_pgm_attribute4 in varchar2 default hr_api.g_varchar2
470 ,p_pgm_attribute5 in varchar2 default hr_api.g_varchar2
471 ,p_pgm_attribute6 in varchar2 default hr_api.g_varchar2
472 ,p_pgm_attribute7 in varchar2 default hr_api.g_varchar2
473 ,p_pgm_attribute8 in varchar2 default hr_api.g_varchar2
474 ,p_pgm_attribute9 in varchar2 default hr_api.g_varchar2
475 ,p_pgm_attribute10 in varchar2 default hr_api.g_varchar2
476 ,p_pgm_attribute11 in varchar2 default hr_api.g_varchar2
477 ,p_pgm_attribute12 in varchar2 default hr_api.g_varchar2
478 ,p_pgm_attribute13 in varchar2 default hr_api.g_varchar2
479 ,p_pgm_attribute14 in varchar2 default hr_api.g_varchar2
480 ,p_pgm_attribute15 in varchar2 default hr_api.g_varchar2
481 ,p_pgm_attribute16 in varchar2 default hr_api.g_varchar2
482 ,p_pgm_attribute17 in varchar2 default hr_api.g_varchar2
483 ,p_pgm_attribute18 in varchar2 default hr_api.g_varchar2
484 ,p_pgm_attribute19 in varchar2 default hr_api.g_varchar2
485 ,p_pgm_attribute20 in varchar2 default hr_api.g_varchar2
486 ,p_pgm_attribute21 in varchar2 default hr_api.g_varchar2
487 ,p_pgm_attribute22 in varchar2 default hr_api.g_varchar2
488 ,p_pgm_attribute23 in varchar2 default hr_api.g_varchar2
489 ,p_pgm_attribute24 in varchar2 default hr_api.g_varchar2
490 ,p_pgm_attribute25 in varchar2 default hr_api.g_varchar2
491 ,p_pgm_attribute26 in varchar2 default hr_api.g_varchar2
492 ,p_pgm_attribute27 in varchar2 default hr_api.g_varchar2
493 ,p_pgm_attribute28 in varchar2 default hr_api.g_varchar2
494 ,p_pgm_attribute29 in varchar2 default hr_api.g_varchar2
495 ,p_pgm_attribute30 in varchar2 default hr_api.g_varchar2
496 ,p_all_inelig in varchar2 default hr_api.g_varchar2
497 ,p_object_version_number in out nocopy number
498 ,p_effective_date in date
499 ,p_datetrack_mode in varchar2
500 );
501 --
502 -- ----------------------------------------------------------------------------
503 -- |------------------------< delete_Program >------------------------|
504 -- ----------------------------------------------------------------------------
505 -- {Start Of Comments}
506 --
507 -- Description:
508 --
509 -- Prerequisites:
510 --
511 --
512 -- In Parameters:
513 -- Name Reqd Type Description
514 -- p_validate Yes boolean Commit or Rollback.
515 -- p_pgm_id Yes number PK of record
516 -- p_effective_date Yes date Session Date.
517 -- p_datetrack_mode Yes varchar2 Datetrack mode.
518 --
519 -- Post Success:
520 --
521 -- Name Type Description
522 -- p_effective_start_date Yes date Effective Start Date of Record
523 -- p_effective_end_date Yes date Effective End Date of Record
524 -- p_object_version_number No number OVN of record
525 --
526 -- Post Failure:
527 --
528 -- Access Status:
529 -- Public.
530 --
531 -- {End Of Comments}
532 --
533 procedure delete_Program
534 (
535 p_validate in boolean default false
536 ,p_pgm_id in number
537 ,p_effective_start_date out nocopy date
538 ,p_effective_end_date out nocopy date
539 ,p_object_version_number in out nocopy number
540 ,p_effective_date in date
541 ,p_datetrack_mode in varchar2
542 );
543 --
544 -- ----------------------------------------------------------------------------
545 -- |----------------------------------< lck >---------------------------------|
546 -- ----------------------------------------------------------------------------
547 -- {Start Of Comments}
548 --
549 -- Description:
550 --
551 -- Prerequisites:
552 --
553 --
554 -- In Parameters:
555 -- Name Reqd Type Description
556 -- p_pgm_id Yes number PK of record
557 -- p_object_version_number Yes number OVN of record
558 -- p_effective_date Yes date Session Date.
559 -- p_datetrack_mode Yes varchar2 Datetrack mode.
560 --
561 -- Post Success:
562 --
563 -- Name Type Description
564 -- p_validation_start_date Yes Derived Effective Start Date.
565 -- p_validation_end_date Yes Derived Effective End Date.
566 --
567 -- Post Failure:
568 --
569 -- Access Status:
570 -- Public.
571 --
572 -- {End Of Comments}
573 --
574 procedure lck
575 (
576 p_pgm_id in number
577 ,p_object_version_number in number
578 ,p_effective_date in date
579 ,p_datetrack_mode in varchar2
580 ,p_validation_start_date out nocopy date
581 ,p_validation_end_date out nocopy date
582 );
583 --
584 end ben_Program_api;