[Home] [Help]
PACKAGE BODY: APPS.BEN_PLAN_DESIGN_DELETE_API
Source
1 package body ben_plan_design_delete_api as
2 /* $Header: bepdwdel.pkb 120.1 2005/06/14 02:41 sparimi noship $ */
3 g_package varchar2(30) :='BEN_PLAN_DESIGN_DELETE_API';
4
5 procedure call_delete_api
6 ( p_process_validate in Number
7 ,p_pk_id in Number
8 ,p_table_alias in varchar2
9 ,p_effective_date in Date
10 ,p_effective_start_date out nocopy Date
11 ,p_effective_end_date out nocopy Date
12 ,p_object_version_number in out nocopy Number
13 ,p_datetrack_mode in varchar2
14 ,p_parent_entity_name in varchar2
15 ,p_entity_name in varchar2
16 ,p_delete_failed out nocopy varchar2
17 )as
18
19 -- we need to keep this false as even for validating we are to validate the whole submit process together.
20 -- therefore we will not commit if the p_process_validate is true.
21 p_validate boolean := false;
22 l_encoded_message varchar2(2000);
23 l_proc varchar2(72) := g_package||'call_delete_api';
24 begin
25 hr_utility.set_location('Entering: '||l_proc || ' for ' || p_table_alias || ' p_pk_id: ' ||p_pk_id ,20);
26 -- set the validate mode
27 if(p_process_validate = 1) then
28 p_validate:=true;
29 end if ;
30
31 if p_table_alias = 'EAT' then
32 ben_ACTION_TYPE_api.delete_ACTION_TYPE
33 (p_validate => p_validate
34 ,p_actn_typ_id => p_pk_id
35 ,p_object_version_number => p_object_version_number
36 ,p_effective_date => p_effective_date
37 );
38 elsif p_table_alias = 'SVA' then
39 BEN_SERVICE_AREA_API.delete_SERVICE_AREA
40 (p_validate => p_validate
41 ,p_svc_area_id => p_pk_id
42 ,p_effective_start_date => p_effective_start_date
43 ,p_effective_end_date => p_effective_end_date
44 ,p_object_version_number => p_object_version_number
45 ,p_effective_date => p_effective_date
46 ,p_datetrack_mode => p_datetrack_mode
47 );
48 elsif p_table_alias = 'BNB' then
49 BEN_BENEFITS_BALANCE_API.delete_benefits_balance
50 (p_validate => p_validate
51 ,p_bnfts_bal_id => p_pk_id
52 ,p_effective_start_date => p_effective_start_date
53 ,p_effective_end_date => p_effective_end_date
54 ,p_object_version_number => p_object_version_number
55 ,p_effective_date => p_effective_date
56 ,p_datetrack_mode => p_datetrack_mode
57 );
58 elsif p_table_alias = 'CLF' then
59 BEN_CMBN_AGE_LOS_FCTR_API.delete_cmbn_age_los_fctr
60 (p_validate => p_validate
61 ,p_cmbn_age_los_fctr_id => p_pk_id
62 ,p_object_version_number => p_object_version_number
63 );
64 elsif p_table_alias = 'HWF' then
65 BEN_HRS_WKD_IN_PERD_FCTR_API.delete_hrs_wkd_in_perd_fctr
66 (p_validate => p_validate
67 ,p_hrs_wkd_in_perd_fctr_id => p_pk_id
68 ,p_object_version_number => p_object_version_number
69 ,p_effective_date => p_effective_date
70 );
71 elsif p_table_alias = 'AGF' then
72 BEN_AGE_FACTOR_API.delete_age_factor
73 (p_validate => p_validate
74 ,p_age_fctr_id => p_pk_id
75 ,p_object_version_number => p_object_version_number
76 ,p_effective_date => p_effective_date
77 );
78 elsif p_table_alias = 'LSF' then
79 BEN_LOS_FACTORS_API.delete_LOS_FACTORS
80 (p_validate => p_validate
81 ,p_los_fctr_id => p_pk_id
82 ,p_object_version_number => p_object_version_number
83 ,p_effective_date => p_effective_date
84 );
85 elsif p_table_alias = 'PFF' then
86 BEN_PERCENT_FT_FACTORS_API.delete_percent_ft_factors
87 (p_validate => p_validate
88 ,p_pct_fl_tm_fctr_id => p_pk_id
89 ,p_object_version_number => p_object_version_number
90 ,p_effective_date => p_effective_date
91 );
92 elsif p_table_alias = 'CLA' then
93 BEN_CMBN_AGE_LOS_FCTR_API.delete_cmbn_age_los_fctr
94 (p_validate => p_validate
95 ,p_cmbn_age_los_fctr_id => p_pk_id
96 ,p_object_version_number => p_object_version_number
97 );
98 elsif p_table_alias = 'PTP' then
99 BEN_PLAN_TYPE_API.delete_PLAN_TYPE
100 (p_validate => p_validate
101 ,p_pl_typ_id => p_pk_id
102 ,p_effective_start_date => p_effective_start_date
103 ,p_effective_end_date => p_effective_end_date
104 ,p_object_version_number => p_object_version_number
105 ,p_effective_date => p_effective_date
106 ,p_datetrack_mode => p_datetrack_mode
107 );
108 elsif p_table_alias = 'PLN' then
109 BEN_PLAN_API.delete_Plan
110 (p_validate => p_validate
111 ,p_pl_id => p_pk_id
112 ,p_effective_start_date => p_effective_start_date
113 ,p_effective_end_date => p_effective_end_date
114 ,p_object_version_number => p_object_version_number
115 ,p_effective_date => p_effective_date
116 ,p_datetrack_mode => p_datetrack_mode
117 );
118 elsif p_table_alias = 'BNR' then
119 BEN_REPORTING_GROUP_API.delete_Reporting_Group
120 (p_validate => p_validate
121 ,p_rptg_grp_id => p_pk_id
122 ,p_object_version_number => p_object_version_number
123 ,p_effective_date => p_effective_date
124 );
125 elsif p_table_alias = 'REG' then
126 BEN_REGULATIONS_API.delete_Regulations
127 (p_validate => p_validate
128 ,p_regn_id => p_pk_id
129 ,p_effective_start_date => p_effective_start_date
130 ,p_effective_end_date => p_effective_end_date
131 ,p_object_version_number => p_object_version_number
132 ,p_effective_date => p_effective_date
133 ,p_datetrack_mode => p_datetrack_mode
134 );
135 elsif p_table_alias = 'OPT' then
136 BEN_OPTION_DEFINITION_API.delete_option_definition
137 (p_validate => p_validate
138 ,p_opt_id => p_pk_id
139 ,p_effective_start_date => p_effective_start_date
140 ,p_effective_end_date => p_effective_end_date
141 ,p_object_version_number => p_object_version_number
142 ,p_effective_date => p_effective_date
143 ,p_datetrack_mode => p_datetrack_mode
144 );
145 elsif p_table_alias = 'PON' then
146 BEN_PLAN_TYPE_OPTION_TYPE_API.delete_plan_type_option_type
147 (p_validate => p_validate
148 ,p_pl_typ_opt_typ_id => p_pk_id
149 ,p_effective_start_date => p_effective_start_date
150 ,p_effective_end_date => p_effective_end_date
151 ,p_object_version_number => p_object_version_number
152 ,p_effective_date => p_effective_date
153 ,p_datetrack_mode => p_datetrack_mode
154 );
155 elsif p_table_alias = 'RZR' then
156 BEN_POSTAL_ZIP_RANGE_API.delete_postal_zip_range
157 (p_validate => p_validate
158 ,p_pstl_zip_rng_id => p_pk_id
159 ,p_effective_start_date => p_effective_start_date
160 ,p_effective_end_date => p_effective_end_date
161 ,p_object_version_number => p_object_version_number
162 ,p_effective_date => p_effective_date
163 ,p_datetrack_mode => p_datetrack_mode
164 );
165 elsif p_table_alias = 'RCL' then
166 BEN_RLTD_PER_CHG_CS_LER_API.delete_Rltd_Per_Chg_Cs_Ler
167 (p_validate => p_validate
168 ,p_rltd_per_chg_cs_ler_id => p_pk_id
169 ,p_effective_start_date => p_effective_start_date
170 ,p_effective_end_date => p_effective_end_date
171 ,p_object_version_number => p_object_version_number
172 ,p_effective_date => p_effective_date
173 ,p_datetrack_mode => p_datetrack_mode
174 );
175 elsif p_table_alias = 'PGM' then
176 BEN_PROGRAM_API.delete_Program
177 (p_validate => p_validate
178 ,p_pgm_id => p_pk_id
179 ,p_effective_start_date => p_effective_start_date
180 ,p_effective_end_date => p_effective_end_date
181 ,p_object_version_number => p_object_version_number
182 ,p_effective_date => p_effective_date
183 ,p_datetrack_mode => p_datetrack_mode
184 );
185 elsif p_table_alias = 'CPL' then
186 BEN_CMBN_PLIP_API.delete_CMBN_PLIP
187 (p_validate => p_validate
188 ,p_cmbn_plip_id => p_pk_id
189 ,p_effective_start_date => p_effective_start_date
190 ,p_effective_end_date => p_effective_end_date
191 ,p_object_version_number => p_object_version_number
192 ,p_effective_date => p_effective_date
193 ,p_datetrack_mode => p_datetrack_mode
194 );
195 elsif p_table_alias = 'CBP' then
196 BEN_CMBN_PTIP_API.delete_CMBN_PTIP
197 (p_validate => p_validate
198 ,p_cmbn_ptip_id => p_pk_id
199 ,p_effective_start_date => p_effective_start_date
200 ,p_effective_end_date => p_effective_end_date
201 ,p_object_version_number => p_object_version_number
202 ,p_effective_date => p_effective_date
203 ,p_datetrack_mode => p_datetrack_mode
204 );
205 elsif p_table_alias = 'CPT' then
206 BEN_CMBN_PTIP_OPT_API.delete_CMBN_PTIP_OPT
207 (p_validate => p_validate
208 ,p_cmbn_ptip_opt_id => p_pk_id
209 ,p_effective_start_date => p_effective_start_date
210 ,p_effective_end_date => p_effective_end_date
211 ,p_object_version_number => p_object_version_number
212 ,p_effective_date => p_effective_date
213 ,p_datetrack_mode => p_datetrack_mode
214 );
215 elsif p_table_alias = 'LER' then
216 BEN_LIFE_EVENT_REASON_API.delete_Life_Event_Reason
217 (p_validate => p_validate
218 ,p_ler_id => p_pk_id
219 ,p_effective_start_date => p_effective_start_date
220 ,p_effective_end_date => p_effective_end_date
221 ,p_object_version_number => p_object_version_number
222 ,p_effective_date => p_effective_date
223 ,p_datetrack_mode => p_datetrack_mode
224 );
225 elsif p_table_alias = 'ELP' then
226 BEN_ELIGY_PROFILE_API.delete_ELIGY_PROFILE
227 (p_validate => p_validate
228 ,p_eligy_prfl_id => p_pk_id
229 ,p_effective_start_date => p_effective_start_date
230 ,p_effective_end_date => p_effective_end_date
231 ,p_object_version_number => p_object_version_number
232 ,p_effective_date => p_effective_date
233 ,p_datetrack_mode => p_datetrack_mode
234 );
235 elsif p_table_alias = 'DCE' then
236 BEN_DPNT_CVG_ELIG_PRFL_API.delete_DPNT_CVG_ELIG_PRFL
237 (p_validate => p_validate
238 ,p_dpnt_cvg_eligy_prfl_id => p_pk_id
239 ,p_effective_end_date => p_effective_end_date
240 ,p_effective_start_date => p_effective_start_date
241 ,p_object_version_number => p_object_version_number
242 ,p_effective_date => p_effective_date
243 ,p_datetrack_mode => p_datetrack_mode
244 );
245 elsif p_table_alias = 'GOS' then
246 BEN_GOOD_SVC_TYPE_API.delete_GOOD_SVC_TYPE
247 (p_validate => p_validate
248 ,p_gd_or_svc_typ_id => p_pk_id
249 ,p_object_version_number => p_object_version_number
250 ,p_effective_date => p_effective_date
251 );
252 elsif p_table_alias = 'BNG' then
253 BEN_BENEFITS_GROUP_API.delete_Benefits_Group
254 (p_validate => p_validate
255 ,p_benfts_grp_id => p_pk_id
256 ,p_object_version_number => p_object_version_number
257 );
258 elsif p_table_alias = 'PSL' then
259 BEN_PERSON_CHANGE_CS_LER_API.delete_Person_Change_Cs_Ler
260 (p_validate => p_validate
261 ,p_per_info_chg_cs_ler_id => p_pk_id
262 ,p_effective_start_date => p_effective_start_date
263 ,p_effective_end_date => p_effective_end_date
264 ,p_object_version_number => p_object_version_number
265 ,p_effective_date => p_effective_date
266 ,p_datetrack_mode => p_datetrack_mode
267 );
268 elsif p_table_alias = 'LPL' then
269 BEN_LER_PER_INFO_CS_LER_API.delete_Ler_Per_Info_Cs_Ler
270 (p_validate => p_validate
271 ,p_ler_per_info_cs_ler_id => p_pk_id
272 ,p_effective_start_date => p_effective_start_date
273 ,p_effective_end_date => p_effective_end_date
274 ,p_object_version_number => p_object_version_number
275 ,p_effective_date => p_effective_date
276 ,p_datetrack_mode => p_datetrack_mode
277 );
278 elsif p_table_alias = 'CCT' then
279 BEN_COMP_COMM_TYPES_API.delete_comp_comm_types
280 (p_validate => p_validate
281 ,p_cm_typ_id => p_pk_id
282 ,p_effective_start_date => p_effective_start_date
283 ,p_effective_end_date => p_effective_end_date
284 ,p_object_version_number => p_object_version_number
285 ,p_effective_date => p_effective_date
286 ,p_datetrack_mode => p_datetrack_mode
287 );
288 elsif p_table_alias = 'PDL' then
289 BEN_PERIOD_LIMIT_API.delete_period_limit
290 (p_validate => p_validate
291 ,p_ptd_lmt_id => p_pk_id
292 ,p_effective_start_date => p_effective_start_date
293 ,p_effective_end_date => p_effective_end_date
294 ,p_object_version_number => p_object_version_number
295 ,p_effective_date => p_effective_date
296 ,p_datetrack_mode => p_datetrack_mode
297 );
298 elsif p_table_alias = 'YRP' then
299 BEN_PGM_OR_PL_YR_PERD_API.delete_pgm_or_pl_yr_perd
300 (p_validate => p_validate
301 ,p_yr_perd_id => p_pk_id
302 ,p_object_version_number => p_object_version_number
303 ,p_effective_date => p_effective_date
304 );
305 elsif p_table_alias = 'WYP' then
306 BEN_WITHIN_YEAR_PERD_API.delete_WITHIN_YEAR_PERD
307 (p_validate => p_validate
308 ,p_wthn_yr_perd_id => p_pk_id
309 ,p_object_version_number => p_object_version_number
310 ,p_effective_date => p_effective_date
311 );
312 elsif p_table_alias = 'SAZ' then
313 BEN_SVC_AREA_PSTL_ZIP_RNG_API.delete_SVC_AREA_PSTL_ZIP_RNG
314 (p_validate => p_validate
315 ,p_svc_area_pstl_zip_rng_id => p_pk_id
316 ,p_effective_start_date => p_effective_start_date
317 ,p_effective_end_date => p_effective_end_date
318 ,p_object_version_number => p_object_version_number
319 ,p_effective_date => p_effective_date
320 ,p_datetrack_mode => p_datetrack_mode
321 );
322 elsif p_table_alias = 'COP' then
323 BEN_OPTION_IN_PLAN_API.delete_Option_in_Plan
324 (p_validate => p_validate
325 ,p_oipl_id => p_pk_id
326 ,p_effective_start_date => p_effective_start_date
327 ,p_effective_end_date => p_effective_end_date
328 ,p_object_version_number => p_object_version_number
329 ,p_effective_date => p_effective_date
330 ,p_datetrack_mode => p_datetrack_mode
331 );
332 elsif p_table_alias = 'DDR' then
333 BEN_DESIGN_RQMT_API.delete_design_rqmt
334 (p_validate => p_validate
335 ,p_dsgn_rqmt_id => p_pk_id
336 ,p_effective_start_date => p_effective_start_date
337 ,p_effective_end_date => p_effective_end_date
338 ,p_object_version_number => p_object_version_number
339 ,p_effective_date => p_effective_date
340 ,p_datetrack_mode => p_datetrack_mode
341 );
342 elsif p_table_alias = 'DRR' then
343 BEN_DSGN_RQMT_RLSHP_TYP_API.delete_DSGN_RQMT_RLSHP_TYP
344 (p_validate => p_validate
345 ,p_dsgn_rqmt_rlshp_typ_id => p_pk_id
346 ,p_object_version_number => p_object_version_number
347 ,p_effective_date => p_effective_date
348 );
349 elsif p_table_alias = 'CPY' then
350 BEN_POPL_YR_PERD_API.delete_POPL_YR_PERD
351 (p_validate => p_validate
352 ,p_popl_yr_perd_id => p_pk_id
353 ,p_object_version_number => p_object_version_number
354 );
355 elsif p_table_alias = 'CWG' then
356 BEN_CWB_WKSHT_GRP_API.delete_cwb_wksht_grp
357 (p_validate => p_validate
358 ,p_cwb_wksht_grp_id => p_pk_id
359 ,p_object_version_number => p_object_version_number
360 ,p_effective_date => p_effective_date
361 );
362 elsif p_table_alias = 'PAT' then
363 BEN_POPL_ACTION_TYPE_API.delete_POPL_ACTION_TYPE
364 (p_validate => p_validate
365 ,p_popl_actn_typ_id => p_pk_id
366 ,p_effective_start_date => p_effective_start_date
367 ,p_effective_end_date => p_effective_end_date
368 ,p_object_version_number => p_object_version_number
369 ,p_effective_date => p_effective_date
370 ,p_datetrack_mode => p_datetrack_mode
371 );
372 elsif p_table_alias = 'PET' then
373 BEN_POPL_ENRT_TYP_CYCL_API.delete_Popl_Enrt_Typ_Cycl
374 (p_validate => p_validate
375 ,p_popl_enrt_typ_cycl_id => p_pk_id
376 ,p_effective_start_date => p_effective_start_date
377 ,p_effective_end_date => p_effective_end_date
378 ,p_object_version_number => p_object_version_number
379 ,p_effective_date => p_effective_date
380 ,p_datetrack_mode => p_datetrack_mode
381 );
382 elsif p_table_alias = 'ENP' then
383 BEN_ENROLLMENT_PERIOD_API.delete_Enrollment_Period
384 (p_validate => p_validate
385 ,p_enrt_perd_id => p_pk_id
386 ,p_object_version_number => p_object_version_number
387 ,p_effective_date => p_effective_date
388 );
389 elsif p_table_alias = 'LEN' then
390 BEN_LIFE_EVENT_ENROLL_RSN_API.delete_Life_Event_Enroll_Rsn
391 (p_validate => p_validate
392 ,p_lee_rsn_id => p_pk_id
393 ,p_effective_start_date => p_effective_start_date
394 ,p_effective_end_date => p_effective_end_date
395 ,p_object_version_number => p_object_version_number
396 ,p_effective_date => p_effective_date
397 ,p_datetrack_mode => p_datetrack_mode
398 );
399 elsif p_table_alias = 'LOP' then
400 BEN_LER_CHG_OIPL_ENRT_API.delete_Ler_Chg_Oipl_Enrt
401 (p_validate => p_validate
402 ,p_ler_chg_oipl_enrt_id => p_pk_id
403 ,p_effective_start_date => p_effective_start_date
404 ,p_effective_end_date => p_effective_end_date
405 ,p_object_version_number => p_object_version_number
406 ,p_effective_date => p_effective_date
407 ,p_datetrack_mode => p_datetrack_mode
408 );
409 elsif p_table_alias = 'ERP' then
410 BEN_ENRT_PERD_FOR_PL_API.delete_enrt_perd_for_pl
411 (p_validate => p_validate
412 ,p_enrt_perd_for_pl_id => p_pk_id
413 ,p_effective_start_date => p_effective_start_date
414 ,p_effective_end_date => p_effective_end_date
415 ,p_object_version_number => p_object_version_number
416 ,p_effective_date => p_effective_date
417 ,p_datetrack_mode => p_datetrack_mode
418 );
419 elsif p_table_alias = 'SER' then
420 BEN_SCHEDD_ENROLLMENT_RL_API.delete_Schedd_Enrollment_Rl
421 (p_validate => p_validate
422 ,p_schedd_enrt_rl_id => p_pk_id
423 ,p_effective_start_date => p_effective_start_date
424 ,p_effective_end_date => p_effective_end_date
425 ,p_object_version_number => p_object_version_number
426 ,p_effective_date => p_effective_date
427 ,p_datetrack_mode => p_datetrack_mode
428 );
429 elsif p_table_alias = 'ECF' then
430 BEN_ENRT_CTFN_API.delete_Enrt_Ctfn
431 (p_validate => p_validate
432 ,p_enrt_ctfn_id => p_pk_id
433 ,p_effective_start_date => p_effective_start_date
434 ,p_effective_end_date => p_effective_end_date
435 ,p_object_version_number => p_object_version_number
436 ,p_effective_date => p_effective_date
437 ,p_datetrack_mode => p_datetrack_mode
438 );
439 elsif p_table_alias = 'CPO' then
440 BEN_POPL_ORG_API.delete_POPL_ORG
441 (p_validate => p_validate
442 ,p_popl_org_id => p_pk_id
443 ,p_effective_start_date => p_effective_start_date
444 ,p_effective_end_date => p_effective_end_date
445 ,p_object_version_number => p_object_version_number
446 ,p_effective_date => p_effective_date
447 ,p_datetrack_mode => p_datetrack_mode
448 );
449 elsif p_table_alias = 'CPR' then
450 BEN_POPL_ORG_ROLE_API.delete_POPL_ORG_ROLE
451 (p_validate => p_validate
452 ,p_popl_org_role_id => p_pk_id
453 ,p_effective_start_date => p_effective_start_date
454 ,p_effective_end_date => p_effective_end_date
455 ,p_object_version_number => p_object_version_number
456 ,p_effective_date => p_effective_date
457 ,p_datetrack_mode => p_datetrack_mode
458 );
459 elsif p_table_alias = 'RGR' then
460 BEN_POPL_RPTG_GRP_API.delete_POPL_RPTG_GRP
461 (p_validate => p_validate
462 ,p_popl_rptg_grp_id => p_pk_id
463 ,p_effective_start_date => p_effective_start_date
464 ,p_effective_end_date => p_effective_end_date
465 ,p_object_version_number => p_object_version_number
466 ,p_effective_date => p_effective_date
467 ,p_datetrack_mode => p_datetrack_mode
468 );
469 elsif p_table_alias = 'PRG' then
470 BEN_PLAN_REGULATION_API.delete_Plan_regulation
471 (p_validate => p_validate
472 ,p_pl_regn_id => p_pk_id
473 ,p_effective_end_date => p_effective_end_date
474 ,p_effective_start_date => p_effective_start_date
475 ,p_object_version_number => p_object_version_number
476 ,p_effective_date => p_effective_date
477 ,p_datetrack_mode => p_datetrack_mode
478 );
479 elsif p_table_alias = 'ACP' then
480 BEN_ACRS_PTIP_CVG_API.delete_acrs_ptip_cvg
481 (p_validate => p_validate
482 ,p_acrs_ptip_cvg_id => p_pk_id
483 ,p_effective_start_date => p_effective_start_date
484 ,p_effective_end_date => p_effective_end_date
485 ,p_object_version_number => p_object_version_number
486 ,p_effective_date => p_effective_date
487 ,p_datetrack_mode => p_datetrack_mode
488 );
489 elsif p_table_alias = 'CTP' then
490 BEN_PLAN_TYPE_IN_PROGRAM_API.delete_Plan_Type_In_Program
491 (p_validate => p_validate
492 ,p_ptip_id => p_pk_id
493 ,p_effective_start_date => p_effective_start_date
494 ,p_effective_end_date => p_effective_end_date
495 ,p_object_version_number => p_object_version_number
496 ,p_effective_date => p_effective_date
497 ,p_datetrack_mode => p_datetrack_mode
498 );
499 elsif p_table_alias = 'ADE' then
500 BEN_APLD_DPNT_CVG_PRFL_API.delete_Apld_Dpnt_Cvg_Prfl
501 (p_validate => p_validate
502 ,p_apld_dpnt_cvg_elig_prfl_id => p_pk_id
503 ,p_effective_start_date => p_effective_start_date
504 ,p_effective_end_date => p_effective_end_date
505 ,p_object_version_number => p_object_version_number
506 ,p_effective_date => p_effective_date
507 ,p_datetrack_mode => p_datetrack_mode
508 );
509 elsif p_table_alias = 'LDC' then
510 BEN_LER_CHG_DEPENDENT_CVG_API.delete_Ler_Chg_Dependent_Cvg
511 (p_validate => p_validate
512 ,p_ler_chg_dpnt_cvg_id => p_pk_id
513 ,p_effective_start_date => p_effective_start_date
514 ,p_effective_end_date => p_effective_end_date
515 ,p_object_version_number => p_object_version_number
516 ,p_effective_date => p_effective_date
517 ,p_datetrack_mode => p_datetrack_mode
518 );
519 elsif p_table_alias = 'LCC' then
520 BEN_LER_CHG_DPNT_CVG_CTF_API.delete_Ler_Chg_Dpnt_Cvg_Ctf
521 (p_validate => p_validate
522 ,p_ler_chg_dpnt_cvg_ctfn_id => p_pk_id
523 ,p_effective_start_date => p_effective_start_date
524 ,p_effective_end_date => p_effective_end_date
525 ,p_object_version_number => p_object_version_number
526 ,p_effective_date => p_effective_date
527 ,p_datetrack_mode => p_datetrack_mode
528 );
529 elsif p_table_alias = 'WPT' then
530 BEN_WV_PRTN_RSN_PTIP_API.delete_WV_PRTN_RSN_PTIP
531 (p_validate => p_validate
532 ,p_wv_prtn_rsn_ptip_id => p_pk_id
533 ,p_effective_start_date => p_effective_start_date
534 ,p_effective_end_date => p_effective_end_date
535 ,p_object_version_number => p_object_version_number
536 ,p_effective_date => p_effective_date
537 ,p_datetrack_mode => p_datetrack_mode
538 );
539 elsif p_table_alias = 'WCT' then
540 BEN_WV_PRTN_RSN_CTFN_PTIP_API.delete_wv_prtn_rsn_ctfn_ptip
541 (p_validate => p_validate
542 ,p_wv_prtn_rsn_ctfn_ptip_id => p_pk_id
543 ,p_effective_start_date => p_effective_start_date
544 ,p_effective_end_date => p_effective_end_date
545 ,p_object_version_number => p_object_version_number
546 ,p_effective_date => p_effective_date
547 ,p_datetrack_mode => p_datetrack_mode
548 );
549 elsif p_table_alias = 'LCT' then
550 BEN_LER_CHG_PTIP_ENRT_API.delete_ler_chg_ptip_enrt
551 (p_validate => p_validate
552 ,p_ler_chg_ptip_enrt_id => p_pk_id
553 ,p_effective_start_date => p_effective_start_date
554 ,p_effective_end_date => p_effective_end_date
555 ,p_object_version_number => p_object_version_number
556 ,p_effective_date => p_effective_date
557 ,p_datetrack_mode => p_datetrack_mode
558 );
559 elsif p_table_alias = 'PYD' then
560 BEN_PTIP_DPNT_CVG_CTFN_API.delete_Ptip_Dpnt_Cvg_Ctfn
561 (p_validate => p_validate
562 ,p_ptip_dpnt_cvg_ctfn_id => p_pk_id
563 ,p_effective_start_date => p_effective_start_date
564 ,p_effective_end_date => p_effective_end_date
565 ,p_object_version_number => p_object_version_number
566 ,p_effective_date => p_effective_date
567 ,p_datetrack_mode => p_datetrack_mode
568 );
569 elsif p_table_alias = 'CPP' then
570 BEN_PLAN_IN_PROGRAM_API.delete_Plan_in_Program
571 (p_validate => p_validate
572 ,p_plip_id => p_pk_id
573 ,p_effective_start_date => p_effective_start_date
574 ,p_effective_end_date => p_effective_end_date
575 ,p_object_version_number => p_object_version_number
576 ,p_effective_date => p_effective_date
577 ,p_datetrack_mode => p_datetrack_mode
578 );
579
580 -- this is deleted by delete oipl call
581 --elsif p_table_alias = 'OPP' then
582 -- BEN_OPTION_IN_PLAN_IN_PGM_API.delete_option_in_plan_in_pgm
583 -- (p_validate => p_validate
584 -- ,p_oiplip_id => p_pk_id
585 -- ,p_effective_start_date => p_effective_start_date
586 -- ,p_effective_end_date => p_effective_end_date
587 -- ,p_object_version_number => p_object_version_number
588 -- ,p_effective_date => p_effective_date
589 -- ,p_datetrack_mode => p_datetrack_mode
590 -- );
591 --
592 elsif p_table_alias = 'BPP' then
593 BEN_BENEFIT_PRVDR_POOL_API.delete_Benefit_Prvdr_Pool
594 (p_validate => p_validate
595 ,p_bnft_prvdr_pool_id => p_pk_id
596 ,p_effective_start_date => p_effective_start_date
597 ,p_effective_end_date => p_effective_end_date
598 ,p_object_version_number => p_object_version_number
599 ,p_effective_date => p_effective_date
600 ,p_datetrack_mode => p_datetrack_mode
601 );
602 elsif p_table_alias = 'LBR' then
603 BEN_LER_BNFT_RSTRN_API.delete_LER_BNFT_RSTRN
604 (p_validate => p_validate
605 ,p_ler_bnft_rstrn_id => p_pk_id
606 ,p_effective_start_date => p_effective_start_date
607 ,p_effective_end_date => p_effective_end_date
608 ,p_object_version_number => p_object_version_number
609 ,p_effective_date => p_effective_date
610 ,p_datetrack_mode => p_datetrack_mode
611 );
612 elsif p_table_alias = 'LPR1' then
613 BEN_LER_CHG_PLAN_ENRT_API.delete_ler_chg_plan_enrt
614 (p_validate => p_validate
615 ,p_ler_chg_plip_enrt_id => p_pk_id
616 ,p_effective_start_date => p_effective_start_date
617 ,p_effective_end_date => p_effective_end_date
618 ,p_object_version_number => p_object_version_number
619 ,p_effective_date => p_effective_date
620 ,p_datetrack_mode => p_datetrack_mode
621 );
622 elsif p_table_alias = 'VGS' then
623 BEN_PLAN_GOODS_SERVICES_API.delete_Plan_goods_services
624 (p_validate => p_validate
625 ,p_pl_gd_or_svc_id => p_pk_id
626 ,p_effective_start_date => p_effective_start_date
627 ,p_effective_end_date => p_effective_end_date
628 ,p_object_version_number => p_object_version_number
629 ,p_effective_date => p_effective_date
630 ,p_datetrack_mode => p_datetrack_mode
631 );
632 elsif p_table_alias = 'PCT' then
633 BEN_PLAN_GOODS_SERV_CERT_API.delete_plan_goods_serv_cert
634 (p_validate => p_validate
635 ,p_pl_gd_r_svc_ctfn_id => p_pk_id
636 ,p_effective_start_date => p_effective_start_date
637 ,p_effective_end_date => p_effective_end_date
638 ,p_object_version_number => p_object_version_number
639 ,p_effective_date => p_effective_date
640 ,p_datetrack_mode => p_datetrack_mode
641 );
642 elsif p_table_alias = 'VRP' then
643 BEN_VALD_RLSHP_FOR_REIMB_API.delete_Vald_Rlshp_For_Reimb
644 (p_validate => p_validate
645 ,p_vald_rlshp_for_reimb_id => p_pk_id
646 ,p_effective_start_date => p_effective_start_date
647 ,p_effective_end_date => p_effective_end_date
648 ,p_object_version_number => p_object_version_number
649 ,p_effective_date => p_effective_date
650 ,p_datetrack_mode => p_datetrack_mode
651 );
652 elsif p_table_alias = 'WPN' then
653 BEN_WV_PRTN_REASON_PL_API.delete_WV_PRTN_REASON_PL
654 (p_validate => p_validate
655 ,p_wv_prtn_rsn_pl_id => p_pk_id
656 ,p_effective_start_date => p_effective_start_date
657 ,p_effective_end_date => p_effective_end_date
658 ,p_object_version_number => p_object_version_number
659 ,p_effective_date => p_effective_date
660 ,p_datetrack_mode => p_datetrack_mode
661 );
662 elsif p_table_alias = 'WCN' then
663 BEN_WV_PRTN_RSN_CTFN_PL_API.delete_WV_PRTN_RSN_CTFN_PL
664 (p_validate => p_validate
665 ,p_wv_prtn_rsn_ctfn_pl_id => p_pk_id
666 ,p_effective_start_date => p_effective_start_date
667 ,p_effective_end_date => p_effective_end_date
668 ,p_object_version_number => p_object_version_number
669 ,p_effective_date => p_effective_date
670 ,p_datetrack_mode => p_datetrack_mode
671 );
672 elsif p_table_alias = 'BRC' then
673 BEN_BNFT_RSTRN_CTFN_API.delete_BNFT_RSTRN_CTFN
674 (p_validate => p_validate
675 ,p_bnft_rstrn_ctfn_id => p_pk_id
676 ,p_effective_start_date => p_effective_start_date
677 ,p_effective_end_date => p_effective_end_date
678 ,p_object_version_number => p_object_version_number
679 ,p_effective_date => p_effective_date
680 ,p_datetrack_mode => p_datetrack_mode
681 );
682 elsif p_table_alias = 'LBC' then
683 BEN_LER_BNFT_RSTRN_CTFN_API.delete_LER_BNFT_RSTRN_CTFN
684 (p_validate => p_validate
685 ,p_ler_bnft_rstrn_ctfn_id => p_pk_id
686 ,p_effective_start_date => p_effective_start_date
687 ,p_effective_end_date => p_effective_end_date
688 ,p_object_version_number => p_object_version_number
689 ,p_effective_date => p_effective_date
690 ,p_datetrack_mode => p_datetrack_mode
691 );
692 elsif p_table_alias = 'LRE' then
693 BEN_LER_RQRS_ENRT_CTFN_API.delete_ler_rqrs_enrt_ctfn
694 (p_validate => p_validate
695 ,p_ler_rqrs_enrt_ctfn_id => p_pk_id
696 ,p_effective_start_date => p_effective_start_date
697 ,p_effective_end_date => p_effective_end_date
698 ,p_object_version_number => p_object_version_number
699 ,p_effective_date => p_effective_date
700 ,p_datetrack_mode => p_datetrack_mode
701 );
702 elsif p_table_alias = 'LNC' then
703 BEN_LER_ENRT_CTFN_API.delete_ler_enrt_ctfn
704 (p_validate => p_validate
705 ,p_ler_enrt_ctfn_id => p_pk_id
706 ,p_effective_start_date => p_effective_start_date
707 ,p_effective_end_date => p_effective_end_date
708 ,p_object_version_number => p_object_version_number
709 ,p_effective_date => p_effective_date
710 ,p_datetrack_mode => p_datetrack_mode
711 );
712 elsif p_table_alias = 'LPE' then
713 BEN_LER_CHG_PL_NIP_ENRT_API.delete_Ler_Chg_Pl_Nip_Enrt
714 (p_validate => p_validate
715 ,p_ler_chg_pl_nip_enrt_id => p_pk_id
716 ,p_effective_start_date => p_effective_start_date
717 ,p_effective_end_date => p_effective_end_date
718 ,p_object_version_number => p_object_version_number
719 ,p_effective_date => p_effective_date
720 ,p_datetrack_mode => p_datetrack_mode
721 );
722 elsif p_table_alias = 'PND' then
723 BEN_PLAN_DPNT_CVG_CTFN_API.delete_Plan_Dpnt_Cvg_Ctfn
724 (p_validate => p_validate
725 ,p_pl_dpnt_cvg_ctfn_id => p_pk_id
726 ,p_effective_start_date => p_effective_start_date
727 ,p_effective_end_date => p_effective_end_date
728 ,p_object_version_number => p_object_version_number
729 ,p_effective_date => p_effective_date
730 ,p_datetrack_mode => p_datetrack_mode
731 );
732 elsif p_table_alias = 'PEO' then
733 BEN_ELIG_TO_PRTE_REASON_API.delete_ELIG_TO_PRTE_REASON
734 (p_validate => p_validate
735 ,p_elig_to_prte_rsn_id => p_pk_id
736 ,p_effective_start_date => p_effective_start_date
737 ,p_effective_end_date => p_effective_end_date
738 ,p_object_version_number => p_object_version_number
739 ,p_effective_date => p_effective_date
740 ,p_datetrack_mode => p_datetrack_mode
741 );
742 elsif p_table_alias = 'EPA' then
743 BEN_PARTICIPATION_ELIG_API.delete_Participation_Elig
744 (p_validate => p_validate
745 ,p_prtn_elig_id => p_pk_id
746 ,p_effective_start_date => p_effective_start_date
747 ,p_effective_end_date => p_effective_end_date
748 ,p_object_version_number => p_object_version_number
749 ,p_effective_date => p_effective_date
750 ,p_datetrack_mode => p_datetrack_mode
751 );
752 elsif p_table_alias = 'CEP' then
753 BEN_PRTN_ELIG_PRFL_API.delete_PRTN_ELIG_PRFL
754 (p_validate => p_validate
755 ,p_prtn_elig_prfl_id => p_pk_id
756 ,p_effective_start_date => p_effective_start_date
757 ,p_effective_end_date => p_effective_end_date
758 ,p_object_version_number => p_object_version_number
759 ,p_effective_date => p_effective_date
760 ,p_datetrack_mode => p_datetrack_mode
761 );
762 elsif p_table_alias = 'CER' then
763 BEN_ELIGIBILITY_RULE_API.delete_ELIGIBILITY_RULE
764 (p_validate => p_validate
765 ,p_prtn_eligy_rl_id => p_pk_id
766 ,p_effective_start_date => p_effective_start_date
767 ,p_effective_end_date => p_effective_end_date
768 ,p_object_version_number => p_object_version_number
769 ,p_effective_date => p_effective_date
770 ,p_datetrack_mode => p_datetrack_mode
771 );
772 elsif p_table_alias = 'PCX' then
773 BEN_PLAN_BENEFICIARY_CTFN_API.delete_Plan_Beneficiary_Ctfn
774 (p_validate => p_validate
775 ,p_pl_bnf_ctfn_id => p_pk_id
776 ,p_effective_start_date => p_effective_start_date
777 ,p_effective_end_date => p_effective_end_date
778 ,p_object_version_number => p_object_version_number
779 ,p_effective_date => p_effective_date
780 ,p_datetrack_mode => p_datetrack_mode
781 );
782 elsif p_table_alias = 'PCP' then
783 BEN_PL_PRMRY_CARE_PRVDR_API.delete_pl_prmry_care_prvdr
784 (p_validate => p_validate
785 ,p_pl_pcp_id => p_pk_id
786 ,p_object_version_number => p_object_version_number
787 ,p_effective_date => p_effective_date
788 );
789 elsif p_table_alias = 'PTY' then
790 BEN_PL_CARE_PRVDR_TYP_API.delete_pl_care_prvdr_typ
791 (p_validate => p_validate
792 ,p_pl_pcp_typ_id => p_pk_id
793 ,p_object_version_number => p_object_version_number
794 ,p_effective_date => p_effective_date
795 );
796 elsif p_table_alias = 'PRB' then
797 BEN_PLAN_REGULATORY_BODY_API.delete_Plan_Regulatory_body
798 (p_validate => p_validate
799 ,p_pl_regy_bod_id => p_pk_id
800 ,p_effective_start_date => p_effective_start_date
801 ,p_effective_end_date => p_effective_end_date
802 ,p_object_version_number => p_object_version_number
803 ,p_effective_date => p_effective_date
804 ,p_datetrack_mode => p_datetrack_mode
805 );
806 elsif p_table_alias = 'PRP' then
807 BEN_REGULATORY_PURPOSE_API.delete_regulatory_purpose
808 (p_validate => p_validate
809 ,p_pl_regy_prps_id => p_pk_id
810 ,p_effective_start_date => p_effective_start_date
811 ,p_effective_end_date => p_effective_end_date
812 ,p_object_version_number => p_object_version_number
813 ,p_effective_date => p_effective_date
814 ,p_datetrack_mode => p_datetrack_mode
815 );
816 elsif p_table_alias = 'LGE' then
817 BEN_LER_CHG_PGM_ENRT_API.delete_Ler_Chg_Pgm_Enrt
818 (p_validate => p_validate
819 ,p_ler_chg_pgm_enrt_id => p_pk_id
820 ,p_effective_start_date => p_effective_start_date
821 ,p_effective_end_date => p_effective_end_date
822 ,p_object_version_number => p_object_version_number
823 ,p_effective_date => p_effective_date
824 ,p_datetrack_mode => p_datetrack_mode
825 );
826 elsif p_table_alias = 'PGC' then
827 BEN_PROGRAM_DPNT_CVG_CTFN_API.delete_Program_Dpnt_Cvg_Ctfn
828 (p_validate => p_validate
829 ,p_pgm_dpnt_cvg_ctfn_id => p_pk_id
830 ,p_effective_start_date => p_effective_start_date
831 ,p_effective_end_date => p_effective_end_date
832 ,p_object_version_number => p_object_version_number
833 ,p_effective_date => p_effective_date
834 ,p_datetrack_mode => p_datetrack_mode
835 );
836 elsif p_table_alias = 'EAN' then
837 BEN_ELIG_ASNT_SET_PRTE_API.delete_ELIG_ASNT_SET_PRTE
838 (p_validate => p_validate
839 ,p_elig_asnt_set_prte_id => p_pk_id
840 ,p_effective_start_date => p_effective_start_date
841 ,p_effective_end_date => p_effective_end_date
842 ,p_object_version_number => p_object_version_number
843 ,p_effective_date => p_effective_date
844 ,p_datetrack_mode => p_datetrack_mode
845 );
846 elsif p_table_alias = 'CGP' then
847 BEN_CNTNG_PRTN_ELIG_PRFL_API.delete_CNTNG_PRTN_ELIG_PRFL
848 (p_validate => p_validate
849 ,p_cntng_prtn_elig_prfl_id => p_pk_id
850 ,p_effective_start_date => p_effective_start_date
851 ,p_effective_end_date => p_effective_end_date
852 ,p_object_version_number => p_object_version_number
853 ,p_effective_date => p_effective_date
854 ,p_datetrack_mode => p_datetrack_mode
855 );
856 elsif p_table_alias = 'EAP' then
857 BEN_ELIG_AGE_PRTE_API.delete_ELIG_AGE_PRTE
858 (p_validate => p_validate
859 ,p_elig_age_prte_id => p_pk_id
860 ,p_effective_start_date => p_effective_start_date
861 ,p_effective_end_date => p_effective_end_date
862 ,p_object_version_number => p_object_version_number
863 ,p_effective_date => p_effective_date
864 ,p_datetrack_mode => p_datetrack_mode
865 );
866 elsif p_table_alias = 'EBN' then
867 BEN_ELIG_BENFTS_GRP_PRTE_API.delete_ELIG_BENFTS_GRP_PRTE
868 (p_validate => p_validate
869 ,p_elig_benfts_grp_prte_id => p_pk_id
870 ,p_effective_start_date => p_effective_start_date
871 ,p_effective_end_date => p_effective_end_date
872 ,p_object_version_number => p_object_version_number
873 ,p_effective_date => p_effective_date
874 ,p_datetrack_mode => p_datetrack_mode
875 );
876 elsif p_table_alias = 'EBU' then
877 BEN_ELIG_BRGNG_UNIT_PRTE_API.delete_ELIG_BRGNG_UNIT_PRTE
878 (p_validate => p_validate
879 ,p_elig_brgng_unit_prte_id => p_pk_id
880 ,p_effective_start_date => p_effective_start_date
881 ,p_effective_end_date => p_effective_end_date
882 ,p_object_version_number => p_object_version_number
883 ,p_effective_date => p_effective_date
884 ,p_datetrack_mode => p_datetrack_mode
885 );
886 elsif p_table_alias = 'ECL' then
887 BEN_ELIG_COMP_LVL_PRTE_API.delete_ELIG_COMP_LVL_PRTE
888 (p_validate => p_validate
889 ,p_elig_comp_lvl_prte_id => p_pk_id
890 ,p_effective_start_date => p_effective_start_date
891 ,p_effective_end_date => p_effective_end_date
892 ,p_object_version_number => p_object_version_number
893 ,p_effective_date => p_effective_date
894 ,p_datetrack_mode => p_datetrack_mode
895 );
896 elsif p_table_alias = 'ECP' then
897 BEN_ELIG_CMBN_AGE_LOS_API.delete_ELIG_CMBN_AGE_LOS
898 (p_validate => p_validate
899 ,p_elig_cmbn_age_los_prte_id => p_pk_id
900 ,p_effective_start_date => p_effective_start_date
901 ,p_effective_end_date => p_effective_end_date
902 ,p_object_version_number => p_object_version_number
903 ,p_effective_date => p_effective_date
904 ,p_datetrack_mode => p_datetrack_mode
905 );
906 elsif p_table_alias = 'ECV' then
907 BEN_ELIGY_CRIT_VALUES_API.delete_eligy_crit_values
908 (p_validate => p_validate
909 ,p_eligy_crit_values_id => p_pk_id
910 ,p_effective_start_date => p_effective_start_date
911 ,p_effective_end_date => p_effective_end_date
912 ,p_object_version_number => p_object_version_number
913 ,p_effective_date => p_effective_date
914 ,p_datetrack_mode => p_datetrack_mode
915 );
916 elsif p_table_alias = 'ECY' then
917 BEN_ELIG_COMPTNCY_PRTE_API.delete_ELIG_COMPTNCY_PRTE
918 (p_validate => p_validate
919 ,p_ELIG_COMPTNCY_PRTE_id => p_pk_id
920 ,p_effective_start_date => p_effective_start_date
921 ,p_effective_end_date => p_effective_end_date
922 ,p_object_version_number => p_object_version_number
923 ,p_effective_date => p_effective_date
924 ,p_datetrack_mode => p_datetrack_mode
925 );
926 elsif p_table_alias = 'ERL' then
927 BEN_ELIGY_PROFILE_RULE_API.delete_ELIGY_PROFILE_RULE
928 (p_validate => p_validate
929 ,p_eligy_prfl_rl_id => p_pk_id
930 ,p_effective_start_date => p_effective_start_date
931 ,p_effective_end_date => p_effective_end_date
932 ,p_object_version_number => p_object_version_number
933 ,p_effective_date => p_effective_date
934 ,p_datetrack_mode => p_datetrack_mode
935 );
936 elsif p_table_alias = 'EHW' then
937 BEN_ELIG_HRS_WKD_PRTE_API.delete_ELIG_HRS_WKD_PRTE
938 (p_validate => p_validate
939 ,p_elig_hrs_wkd_prte_id => p_pk_id
940 ,p_effective_start_date => p_effective_start_date
941 ,p_effective_end_date => p_effective_end_date
942 ,p_object_version_number => p_object_version_number
943 ,p_effective_date => p_effective_date
944 ,p_datetrack_mode => p_datetrack_mode
945 );
946 elsif p_table_alias = 'EJP' then
947 BEN_ELIGY_JOB_PRTE_API.delete_ELIGY_JOB_PRTE
948 (p_validate => p_validate
949 ,p_elig_job_prte_id => p_pk_id
950 ,p_effective_start_date => p_effective_start_date
951 ,p_effective_end_date => p_effective_end_date
952 ,p_object_version_number => p_object_version_number
953 ,p_effective_date => p_effective_date
954 ,p_datetrack_mode => p_datetrack_mode
955 );
956 elsif p_table_alias = 'ELU' then
957 BEN_ELIG_LBR_MMBR_PRTE_API.delete_ELIG_LBR_MMBR_PRTE
958 (p_validate => p_validate
959 ,p_elig_lbr_mmbr_prte_id => p_pk_id
960 ,p_effective_start_date => p_effective_start_date
961 ,p_effective_end_date => p_effective_end_date
962 ,p_object_version_number => p_object_version_number
963 ,p_effective_date => p_effective_date
964 ,p_datetrack_mode => p_datetrack_mode
965 );
966 elsif p_table_alias = 'ELN' then
967 BEN_ELIG_LGL_ENTY_PRTE_API.delete_ELIG_LGL_ENTY_PRTE
968 (p_validate => p_validate
969 ,p_elig_lgl_enty_prte_id => p_pk_id
970 ,p_effective_start_date => p_effective_start_date
971 ,p_effective_end_date => p_effective_end_date
972 ,p_object_version_number => p_object_version_number
973 ,p_effective_date => p_effective_date
974 ,p_datetrack_mode => p_datetrack_mode
975 );
976 elsif p_table_alias = 'ELR' then
977 BEN_ELIG_LOA_RSN_PRTE_API.delete_ELIG_LOA_RSN_PRTE
978 (p_validate => p_validate
979 ,p_elig_loa_rsn_prte_id => p_pk_id
980 ,p_effective_start_date => p_effective_start_date
981 ,p_effective_end_date => p_effective_end_date
982 ,p_object_version_number => p_object_version_number
983 ,p_effective_date => p_effective_date
984 ,p_datetrack_mode => p_datetrack_mode
985 );
986 elsif p_table_alias = 'ELS' then
987 BEN_ELIG_LOS_PRTE_API.delete_ELIG_LOS_PRTE
988 (p_validate => p_validate
989 ,p_elig_los_prte_id => p_pk_id
990 ,p_effective_start_date => p_effective_start_date
991 ,p_effective_end_date => p_effective_end_date
992 ,p_object_version_number => p_object_version_number
993 ,p_effective_date => p_effective_date
994 ,p_datetrack_mode => p_datetrack_mode
995 );
996 elsif p_table_alias = 'ELV' then
997 BEN_ELIG_LVG_RSN_PRTE_API.delete_ELIG_LVG_RSN_PRTE
998 (p_validate => p_validate
999 ,p_elig_lvg_rsn_prte_id => p_pk_id
1000 ,p_effective_start_date => p_effective_start_date
1001 ,p_effective_end_date => p_effective_end_date
1002 ,p_object_version_number => p_object_version_number
1003 ,p_effective_date => p_effective_date
1004 ,p_datetrack_mode => p_datetrack_mode
1005 );
1006 elsif p_table_alias = 'EMP' then
1007 BEN_ELIG_MRTL_STS_PRTE_API.delete_elig_mrtl_sts_prte
1008 (p_validate => p_validate
1009 ,p_elig_mrtl_sts_prte_id => p_pk_id
1010 ,p_effective_start_date => p_effective_start_date
1011 ,p_effective_end_date => p_effective_end_date
1012 ,p_object_version_number => p_object_version_number
1013 ,p_effective_date => p_effective_date
1014 ,p_datetrack_mode => p_datetrack_mode
1015 );
1016 elsif p_table_alias = 'ENO' then
1017 BEN_ELIG_NO_OTHR_CVG_PRTE_API.delete_ELIG_NO_OTHR_CVG_PRTE
1018 (p_validate => p_validate
1019 ,p_elig_no_othr_cvg_prte_id => p_pk_id
1020 ,p_effective_start_date => p_effective_start_date
1021 ,p_effective_end_date => p_effective_end_date
1022 ,p_object_version_number => p_object_version_number
1023 ,p_effective_date => p_effective_date
1024 ,p_datetrack_mode => p_datetrack_mode
1025 );
1026 elsif p_table_alias = 'EOM' then
1027 BEN_ELIG_OPTD_MDCR_PRTE_API.delete_ELIG_OPTD_MDCR_PRTE
1028 (p_validate => p_validate
1029 ,p_elig_optd_mdcr_prte_id => p_pk_id
1030 ,p_effective_start_date => p_effective_start_date
1031 ,p_effective_end_date => p_effective_end_date
1032 ,p_object_version_number => p_object_version_number
1033 ,p_effective_date => p_effective_date
1034 ,p_datetrack_mode => p_datetrack_mode
1035 );
1036 elsif p_table_alias = 'EOU' then
1037 BEN_ELIG_ORG_UNIT_PRTE_API.delete_ELIG_ORG_UNIT_PRTE
1038 (p_validate => p_validate
1039 ,p_elig_org_unit_prte_id => p_pk_id
1040 ,p_effective_start_date => p_effective_start_date
1041 ,p_effective_end_date => p_effective_end_date
1042 ,p_object_version_number => p_object_version_number
1043 ,p_effective_date => p_effective_date
1044 ,p_datetrack_mode => p_datetrack_mode
1045 );
1046 elsif p_table_alias = 'EPF' then
1047 BEN_ELIG_PCT_FL_TM_PRTE_API.delete_ELIG_PCT_FL_TM_PRTE
1048 (p_validate => p_validate
1049 ,p_elig_pct_fl_tm_prte_id => p_pk_id
1050 ,p_effective_start_date => p_effective_start_date
1051 ,p_effective_end_date => p_effective_end_date
1052 ,p_object_version_number => p_object_version_number
1053 ,p_effective_date => p_effective_date
1054 ,p_datetrack_mode => p_datetrack_mode
1055 );
1056 elsif p_table_alias = 'EPT' then
1057 BEN_ELIG_PER_TYP_PRTE_API.delete_ELIG_PER_TYP_PRTE
1058 (p_validate => p_validate
1059 ,p_elig_per_typ_prte_id => p_pk_id
1060 ,p_effective_start_date => p_effective_start_date
1061 ,p_effective_end_date => p_effective_end_date
1062 ,p_object_version_number => p_object_version_number
1063 ,p_effective_date => p_effective_date
1064 ,p_datetrack_mode => p_datetrack_mode
1065 );
1066 elsif p_table_alias = 'EPB' then
1067 BEN_ELIG_PY_BSS_PRTE_API.delete_ELIG_PY_BSS_PRTE
1068 (p_validate => p_validate
1069 ,p_elig_py_bss_prte_id => p_pk_id
1070 ,p_effective_start_date => p_effective_start_date
1071 ,p_effective_end_date => p_effective_end_date
1072 ,p_object_version_number => p_object_version_number
1073 ,p_effective_date => p_effective_date
1074 ,p_datetrack_mode => p_datetrack_mode
1075 );
1076 elsif p_table_alias = 'EPN' then
1077 BEN_ELIG_PRBTN_PERD_PRTE_API.delete_ELIG_PRBTN_PERD_PRTE
1078 (p_validate => p_validate
1079 ,p_ELIG_PRBTN_PERD_PRTE_id => p_pk_id
1080 ,p_effective_start_date => p_effective_start_date
1081 ,p_effective_end_date => p_effective_end_date
1082 ,p_object_version_number => p_object_version_number
1083 ,p_effective_date => p_effective_date
1084 ,p_datetrack_mode => p_datetrack_mode
1085 );
1086 elsif p_table_alias = 'EPS' then
1087 BEN_ELIG_PSTN_PRTE_API.delete_ELIG_PSTN_PRTE
1088 (p_validate => p_validate
1089 ,p_ELIG_PSTN_PRTE_id => p_pk_id
1090 ,p_effective_start_date => p_effective_start_date
1091 ,p_effective_end_date => p_effective_end_date
1092 ,p_object_version_number => p_object_version_number
1093 ,p_effective_date => p_effective_date
1094 ,p_datetrack_mode => p_datetrack_mode
1095 );
1096 elsif p_table_alias = 'EPY' then
1097 BEN_ELIG_PYRL_PRTE_API.delete_ELIG_PYRL_PRTE
1098 (p_validate => p_validate
1099 ,p_elig_pyrl_prte_id => p_pk_id
1100 ,p_effective_start_date => p_effective_start_date
1101 ,p_effective_end_date => p_effective_end_date
1102 ,p_object_version_number => p_object_version_number
1103 ,p_effective_date => p_effective_date
1104 ,p_datetrack_mode => p_datetrack_mode
1105 );
1106 elsif p_table_alias = 'EPZ' then
1107 BEN_ELIG_PSTL_CD_RNG_PRTE_API.delete_ELIG_PSTL_CD_RNG_PRTE
1108 (p_validate => p_validate
1109 ,p_elig_pstl_cd_r_rng_prte_id => p_pk_id
1110 ,p_effective_start_date => p_effective_start_date
1111 ,p_effective_end_date => p_effective_end_date
1112 ,p_object_version_number => p_object_version_number
1113 ,p_effective_date => p_effective_date
1114 ,p_datetrack_mode => p_datetrack_mode
1115 );
1116 elsif p_table_alias = 'EQT' then
1117 BEN_ELIG_QUAL_TITL_PRTE_API.delete_elig_qual_titl_prte
1118 (p_validate => p_validate
1119 ,p_elig_qual_titl_prte_id => p_pk_id
1120 ,p_effective_start_date => p_effective_start_date
1121 ,p_effective_end_date => p_effective_end_date
1122 ,p_object_version_number => p_object_version_number
1123 ,p_effective_date => p_effective_date
1124 ,p_datetrack_mode => p_datetrack_mode
1125 );
1126 elsif p_table_alias = 'ESA' then
1127 BEN_ELIG_SVC_AREA_PRTE_API.delete_elig_svc_area_prte
1128 (p_validate => p_validate
1129 ,p_elig_svc_area_prte_id => p_pk_id
1130 ,p_effective_start_date => p_effective_start_date
1131 ,p_effective_end_date => p_effective_end_date
1132 ,p_object_version_number => p_object_version_number
1133 ,p_effective_date => p_effective_date
1134 ,p_datetrack_mode => p_datetrack_mode
1135 );
1136 elsif p_table_alias = 'ESH' then
1137 BEN_ELIG_SCHEDD_HRS_PRTE_API.delete_ELIG_SCHEDD_HRS_PRTE
1138 (p_validate => p_validate
1139 ,p_elig_schedd_hrs_prte_id => p_pk_id
1140 ,p_effective_start_date => p_effective_start_date
1141 ,p_effective_end_date => p_effective_end_date
1142 ,p_object_version_number => p_object_version_number
1143 ,p_effective_date => p_effective_date
1144 ,p_datetrack_mode => p_datetrack_mode
1145 );
1146 elsif p_table_alias = 'ESP' then
1147 BEN_ELIG_SP_CLNG_PRG_PRTE_API.delete_elig_sp_clng_prg_prte
1148 (p_validate => p_validate
1149 ,p_elig_sp_clng_prg_prte_id => p_pk_id
1150 ,p_effective_start_date => p_effective_start_date
1151 ,p_effective_end_date => p_effective_end_date
1152 ,p_object_version_number => p_object_version_number
1153 ,p_effective_date => p_effective_date
1154 ,p_datetrack_mode => p_datetrack_mode
1155 );
1156 elsif p_table_alias = 'EST' then
1157 BEN_ELIG_SUPPL_ROLE_PRTE_API.delete_elig_suppl_role_prte
1158 (p_validate => p_validate
1159 ,p_elig_suppl_role_prte_id => p_pk_id
1160 ,p_effective_start_date => p_effective_start_date
1161 ,p_effective_end_date => p_effective_end_date
1162 ,p_object_version_number => p_object_version_number
1163 ,p_effective_date => p_effective_date
1164 ,p_datetrack_mode => p_datetrack_mode
1165 );
1166 elsif p_table_alias = 'EWL' then
1167 BEN_ELIG_WK_LOC_PRTE_API.delete_ELIG_WK_LOC_PRTE
1168 (p_validate => p_validate
1169 ,p_elig_wk_loc_prte_id => p_pk_id
1170 ,p_effective_start_date => p_effective_start_date
1171 ,p_effective_end_date => p_effective_end_date
1172 ,p_object_version_number => p_object_version_number
1173 ,p_effective_date => p_effective_date
1174 ,p_datetrack_mode => p_datetrack_mode
1175 );
1176 elsif p_table_alias = 'ECT' then
1177 BEN_ELIG_DSBLTY_CTG_PRTE_API.delete_ELIG_dsblty_ctg_PRTE
1178 (p_validate => p_validate
1179 ,p_elig_dsblty_ctg_prte_id => p_pk_id
1180 ,p_effective_start_date => p_effective_start_date
1181 ,p_effective_end_date => p_effective_end_date
1182 ,p_object_version_number => p_object_version_number
1183 ,p_effective_date => p_effective_date
1184 ,p_datetrack_mode => p_datetrack_mode
1185 );
1186 elsif p_table_alias = 'EDD' then
1187 BEN_ELIG_DSBLTY_DGR_PRTE_API.delete_ELIG_dsblty_dgr_PRTE
1188 (p_validate => p_validate
1189 ,p_elig_dsblty_dgr_prte_id => p_pk_id
1190 ,p_effective_start_date => p_effective_start_date
1191 ,p_effective_end_date => p_effective_end_date
1192 ,p_object_version_number => p_object_version_number
1193 ,p_effective_date => p_effective_date
1194 ,p_datetrack_mode => p_datetrack_mode
1195 );
1196 elsif p_table_alias = 'EDR' then
1197 BEN_ELIG_DSBLTY_RSN_PRTE_API.delete_elig_dsblty_rsn_prte
1198 (p_validate => p_validate
1199 ,p_elig_dsblty_rsn_prte_id => p_pk_id
1200 ,p_effective_start_date => p_effective_start_date
1201 ,p_effective_end_date => p_effective_end_date
1202 ,p_object_version_number => p_object_version_number
1203 ,p_effective_date => p_effective_date
1204 ,p_datetrack_mode => p_datetrack_mode
1205 );
1206 elsif p_table_alias = 'EES' then
1207 BEN_ELIG_EE_STAT_PRTE_API.delete_ELIG_EE_STAT_PRTE
1208 (p_validate => p_validate
1209 ,p_elig_ee_stat_prte_id => p_pk_id
1210 ,p_effective_start_date => p_effective_start_date
1211 ,p_effective_end_date => p_effective_end_date
1212 ,p_object_version_number => p_object_version_number
1213 ,p_effective_date => p_effective_date
1214 ,p_datetrack_mode => p_datetrack_mode
1215 );
1216 elsif p_table_alias = 'EFP' then
1217 BEN_ELIG_FL_TM_PT_TM_PRTE_API.delete_ELIG_FL_TM_PT_TM_PRTE
1218 (p_validate => p_validate
1219 ,p_elig_fl_tm_pt_tm_prte_id => p_pk_id
1220 ,p_effective_start_date => p_effective_start_date
1221 ,p_effective_end_date => p_effective_end_date
1222 ,p_object_version_number => p_object_version_number
1223 ,p_effective_date => p_effective_date
1224 ,p_datetrack_mode => p_datetrack_mode
1225 );
1226 elsif p_table_alias = 'EGR' then
1227 BEN_ELIG_GRD_PRTE_API.delete_ELIG_GRD_PRTE
1228 (p_validate => p_validate
1229 ,p_elig_grd_prte_id => p_pk_id
1230 ,p_effective_start_date => p_effective_start_date
1231 ,p_effective_end_date => p_effective_end_date
1232 ,p_object_version_number => p_object_version_number
1233 ,p_effective_date => p_effective_date
1234 ,p_datetrack_mode => p_datetrack_mode
1235 );
1236 elsif p_table_alias = 'EHS' then
1237 BEN_ELIG_HRLY_SLRD_PRTE_API.delete_ELIG_HRLY_SLRD_PRTE
1238 (p_validate => p_validate
1239 ,p_elig_hrly_slrd_prte_id => p_pk_id
1240 ,p_effective_start_date => p_effective_start_date
1241 ,p_effective_end_date => p_effective_end_date
1242 ,p_object_version_number => p_object_version_number
1243 ,p_effective_date => p_effective_date
1244 ,p_datetrack_mode => p_datetrack_mode
1245 );
1246 elsif p_table_alias = 'ERG' then
1247 BEN_ELIG_PERF_RTNG_PRTE_API.delete_ELIG_PERF_RTNG_PRTE
1248 (p_validate => p_validate
1249 ,p_ELIG_PERF_RTNG_PRTE_id => p_pk_id
1250 ,p_effective_start_date => p_effective_start_date
1251 ,p_effective_end_date => p_effective_end_date
1252 ,p_object_version_number => p_object_version_number
1253 ,p_effective_date => p_effective_date
1254 ,p_datetrack_mode => p_datetrack_mode
1255 );
1256 elsif p_table_alias = 'EQG' then
1257 BEN_ELIG_QUA_IN_GR_PRTE_API.delete_ELIG_QUA_IN_GR_PRTE
1258 (p_validate => p_validate
1259 ,p_ELIG_QUA_IN_GR_PRTE_id => p_pk_id
1260 ,p_effective_start_date => p_effective_start_date
1261 ,p_effective_end_date => p_effective_end_date
1262 ,p_object_version_number => p_object_version_number
1263 ,p_effective_date => p_effective_date
1264 ,p_datetrack_mode => p_datetrack_mode
1265 );
1266 elsif p_table_alias = 'EGN' then
1267 BEN_ELIG_GNDR_PRTE_API.delete_elig_gndr_prte
1268 (p_validate => p_validate
1269 ,p_elig_gndr_prte_id => p_pk_id
1270 ,p_effective_start_date => p_effective_start_date
1271 ,p_effective_end_date => p_effective_end_date
1272 ,p_object_version_number => p_object_version_number
1273 ,p_effective_date => p_effective_date
1274 ,p_datetrack_mode => p_datetrack_mode
1275 );
1276 elsif p_table_alias = 'ETU' then
1277 BEN_ELIG_TBCO_USE_PRTE_API.delete_ELIG_TBCO_USE_PRTE
1278 (p_validate => p_validate
1279 ,p_elig_tbco_use_prte_id => p_pk_id
1280 ,p_effective_start_date => p_effective_start_date
1281 ,p_effective_end_date => p_effective_end_date
1282 ,p_object_version_number => p_object_version_number
1283 ,p_effective_date => p_effective_date
1284 ,p_datetrack_mode => p_datetrack_mode
1285 );
1286 elsif p_table_alias = 'EDB' then
1287 BEN_ELIG_DSBLD_PRTE_API.delete_ELIG_DSBLD_PRTE
1288 (p_validate => p_validate
1289 ,p_elig_dsbld_prte_id => p_pk_id
1290 ,p_effective_start_date => p_effective_start_date
1291 ,p_effective_end_date => p_effective_end_date
1292 ,p_object_version_number => p_object_version_number
1293 ,p_effective_date => p_effective_date
1294 ,p_datetrack_mode => p_datetrack_mode
1295 );
1296 elsif p_table_alias = 'ETP' then
1297 BEN_ELIG_TTL_PRTT_PRTE_API.delete_ELIG_TTL_PRTT_PRTE
1298 (p_validate => p_validate
1299 ,p_ELIG_TTL_PRTT_PRTE_id => p_pk_id
1300 ,p_effective_start_date => p_effective_start_date
1301 ,p_effective_end_date => p_effective_end_date
1302 ,p_object_version_number => p_object_version_number
1303 ,p_effective_date => p_effective_date
1304 ,p_datetrack_mode => p_datetrack_mode
1305 );
1306 elsif p_table_alias = 'ETC' then
1307 BEN_ELIG_TTL_CVG_VOL_PRTE_API.delete_elig_ttl_cvg_vol_prte
1308 (p_validate => p_validate
1309 ,p_elig_ttl_cvg_vol_prte_id => p_pk_id
1310 ,p_effective_start_date => p_effective_start_date
1311 ,p_effective_end_date => p_effective_end_date
1312 ,p_object_version_number => p_object_version_number
1313 ,p_effective_date => p_effective_date
1314 ,p_datetrack_mode => p_datetrack_mode
1315 );
1316 elsif p_table_alias = 'ECQ' then
1317 BEN_ELIG_CBR_QUALD_BNF_API.delete_ELIG_CBR_QUALD_BNF
1318 (p_validate => p_validate
1319 ,p_elig_cbr_quald_bnf_id => p_pk_id
1320 ,p_effective_start_date => p_effective_start_date
1321 ,p_effective_end_date => p_effective_end_date
1322 ,p_object_version_number => p_object_version_number
1323 ,p_effective_date => p_effective_date
1324 ,p_datetrack_mode => p_datetrack_mode
1325 );
1326 elsif p_table_alias = 'EDG' then
1327 BEN_ELIG_DPNT_CVRD_O_PGM_API.delete_ELIG_DPNT_CVRD_O_PGM
1328 (p_validate => p_validate
1329 ,p_elig_dpnt_cvrd_othr_pgm_id => p_pk_id
1330 ,p_effective_start_date => p_effective_start_date
1331 ,p_effective_end_date => p_effective_end_date
1332 ,p_object_version_number => p_object_version_number
1333 ,p_effective_date => p_effective_date
1334 ,p_datetrack_mode => p_datetrack_mode
1335 );
1336 elsif p_table_alias = 'EDI' then
1337 BEN_ELIG_DPNT_CVRD_PLIP_API.delete_ELIG_DPNT_CVRD_PLIP
1338 (p_validate => p_validate
1339 ,p_elig_dpnt_cvrd_plip_id => p_pk_id
1340 ,p_effective_start_date => p_effective_start_date
1341 ,p_effective_end_date => p_effective_end_date
1342 ,p_object_version_number => p_object_version_number
1343 ,p_effective_date => p_effective_date
1344 ,p_datetrack_mode => p_datetrack_mode
1345 );
1346 elsif p_table_alias = 'EDP' then
1347 BEN_ELIG_DPNT_CVD_OTHR_PL_API.delete_ELIG_DPNT_CVD_OTHR_PL
1348 (p_validate => p_validate
1349 ,p_elig_dpnt_cvrd_othr_pl_id => p_pk_id
1350 ,p_effective_start_date => p_effective_start_date
1351 ,p_effective_end_date => p_effective_end_date
1352 ,p_object_version_number => p_object_version_number
1353 ,p_effective_date => p_effective_date
1354 ,p_datetrack_mode => p_datetrack_mode
1355 );
1356 elsif p_table_alias = 'EDT' then
1357 BEN_ELIG_DPNT_CVRD_O_PTIP_API.delete_ELIG_DPNT_CVRD_O_PTIP
1358 (p_validate => p_validate
1359 ,p_elig_dpnt_cvrd_othr_ptip_id => p_pk_id
1360 ,p_effective_start_date => p_effective_start_date
1361 ,p_effective_end_date => p_effective_end_date
1362 ,p_object_version_number => p_object_version_number
1363 ,p_effective_date => p_effective_date
1364 ,p_datetrack_mode => p_datetrack_mode
1365 );
1366 elsif p_table_alias = 'EOY' then
1367 BEN_ELIG_OTHR_PTIP_PRTE_API.delete_ELIG_OTHR_PTIP_PRTE
1368 (p_validate => p_validate
1369 ,p_elig_othr_ptip_prte_id => p_pk_id
1370 ,p_effective_start_date => p_effective_start_date
1371 ,p_effective_end_date => p_effective_end_date
1372 ,p_object_version_number => p_object_version_number
1373 ,p_effective_date => p_effective_date
1374 ,p_datetrack_mode => p_datetrack_mode
1375 );
1376 elsif p_table_alias = 'EPG' then
1377 BEN_ELIG_PPL_GRP_PRTE_API.delete_ELIG_PPL_GRP_PRTE
1378 (p_validate => p_validate
1379 ,p_elig_ppl_grp_prte_id => p_pk_id
1380 ,p_effective_start_date => p_effective_start_date
1381 ,p_effective_end_date => p_effective_end_date
1382 ,p_object_version_number => p_object_version_number
1383 ,p_effective_date => p_effective_date
1384 ,p_datetrack_mode => p_datetrack_mode
1385 );
1386 elsif p_table_alias = 'EPP' then
1387 BEN_ELG_PRT_ANTHR_PL_PT_API.delete_ELG_PRT_ANTHR_PL_PT
1388 (p_validate => p_validate
1389 ,p_elig_prtt_anthr_pl_prte_id => p_pk_id
1390 ,p_effective_start_date => p_effective_start_date
1391 ,p_effective_end_date => p_effective_end_date
1392 ,p_object_version_number => p_object_version_number
1393 ,p_effective_date => p_effective_date
1394 ,p_datetrack_mode => p_datetrack_mode
1395 );
1396 elsif p_table_alias = 'ETD' then
1397 BEN_ELIG_DPNT_OTHR_PTIP_API.delete_ELIG_DPNT_OTHR_PTIP
1398 (p_validate => p_validate
1399 ,p_elig_dpnt_othr_ptip_id => p_pk_id
1400 ,p_effective_start_date => p_effective_start_date
1401 ,p_effective_end_date => p_effective_end_date
1402 ,p_object_version_number => p_object_version_number
1403 ,p_effective_date => p_effective_date
1404 ,p_datetrack_mode => p_datetrack_mode
1405 );
1406 elsif p_table_alias = 'EEI' then
1407 BEN_ELIG_ENRLD_ANTHR_OIPL_API.delete_ELIG_ENRLD_ANTHR_OIPL
1408 (p_validate => p_validate
1409 ,p_elig_enrld_anthr_oipl_id => p_pk_id
1410 ,p_effective_start_date => p_effective_start_date
1411 ,p_effective_end_date => p_effective_end_date
1412 ,p_object_version_number => p_object_version_number
1413 ,p_effective_date => p_effective_date
1414 ,p_datetrack_mode => p_datetrack_mode
1415 );
1416 elsif p_table_alias = 'EEG' then
1417 BEN_ELIG_ENRLD_ANTHR_PGM_API.delete_ELIG_ENRLD_ANTHR_PGM
1418 (p_validate => p_validate
1419 ,p_elig_enrld_anthr_pgm_id => p_pk_id
1420 ,p_effective_start_date => p_effective_start_date
1421 ,p_effective_end_date => p_effective_end_date
1422 ,p_object_version_number => p_object_version_number
1423 ,p_effective_date => p_effective_date
1424 ,p_datetrack_mode => p_datetrack_mode
1425 );
1426 elsif p_table_alias = 'EAI' then
1427 BEN_ELIG_ENRLD_ANTHR_PLIP_API.delete_ELIG_ENRLD_ANTHR_PLIP
1428 (p_validate => p_validate
1429 ,p_elig_enrld_anthr_plip_id => p_pk_id
1430 ,p_effective_start_date => p_effective_start_date
1431 ,p_effective_end_date => p_effective_end_date
1432 ,p_object_version_number => p_object_version_number
1433 ,p_effective_date => p_effective_date
1434 ,p_datetrack_mode => p_datetrack_mode
1435 );
1436 elsif p_table_alias = 'EEP' then
1437 BEN_ELIG_ENRLD_ANTHR_PL_API.delete_ELIG_ENRLD_ANTHR_PL
1438 (p_validate => p_validate
1439 ,p_elig_enrld_anthr_pl_id => p_pk_id
1440 ,p_effective_start_date => p_effective_start_date
1441 ,p_effective_end_date => p_effective_end_date
1442 ,p_object_version_number => p_object_version_number
1443 ,p_effective_date => p_effective_date
1444 ,p_datetrack_mode => p_datetrack_mode
1445 );
1446 elsif p_table_alias = 'EET' then
1447 BEN_ELIG_ENRLD_ANTHR_PTIP_API.delete_ELIG_ENRLD_ANTHR_PTIP
1448 (p_validate => p_validate
1449 ,p_elig_enrld_anthr_ptip_id => p_pk_id
1450 ,p_effective_start_date => p_effective_start_date
1451 ,p_effective_end_date => p_effective_end_date
1452 ,p_object_version_number => p_object_version_number
1453 ,p_effective_date => p_effective_date
1454 ,p_datetrack_mode => p_datetrack_mode
1455 );
1456 elsif p_table_alias = 'EHC' then
1457 BEN_ELIG_HLTH_CVG_PRTE_API.delete_ELIG_HLTH_CVG_PRTE
1458 (p_validate => p_validate
1459 ,p_ELIG_HLTH_CVG_PRTE_id => p_pk_id
1460 ,p_effective_start_date => p_effective_start_date
1461 ,p_effective_end_date => p_effective_end_date
1462 ,p_object_version_number => p_object_version_number
1463 ,p_effective_date => p_effective_date
1464 ,p_datetrack_mode => p_datetrack_mode
1465 );
1466 elsif p_table_alias = 'EOP' then
1467 BEN_ELIG_ANTHR_PL_PRTE_API.delete_ELIG_ANTHR_PL_PRTE
1468 (p_validate => p_validate
1469 ,p_ELIG_ANTHR_PL_PRTE_id => p_pk_id
1470 ,p_effective_start_date => p_effective_start_date
1471 ,p_effective_end_date => p_effective_end_date
1472 ,p_object_version_number => p_object_version_number
1473 ,p_effective_date => p_effective_date
1474 ,p_datetrack_mode => p_datetrack_mode
1475 );
1476 elsif p_table_alias = 'CTU' then
1477 BEN_CM_TYP_USG_API.delete_cm_typ_usg
1478 (p_validate => p_validate
1479 ,p_cm_typ_usg_id => p_pk_id
1480 ,p_effective_start_date => p_effective_start_date
1481 ,p_effective_end_date => p_effective_end_date
1482 ,p_object_version_number => p_object_version_number
1483 ,p_effective_date => p_effective_date
1484 ,p_datetrack_mode => p_datetrack_mode
1485 );
1486 elsif p_table_alias = 'CTT' then
1487 BEN_CM_TYP_TRGR_API.delete_cm_typ_trgr
1488 (p_validate => p_validate
1489 ,p_cm_typ_trgr_id => p_pk_id
1490 ,p_effective_start_date => p_effective_start_date
1491 ,p_effective_end_date => p_effective_end_date
1492 ,p_object_version_number => p_object_version_number
1493 ,p_effective_date => p_effective_date
1494 ,p_datetrack_mode => p_datetrack_mode
1495 );
1496 elsif p_table_alias = 'CMT' then
1497 BEN_COMM_DLVRY_MTHDS_API.delete_Comm_Dlvry_Mthds
1498 (p_validate => p_validate
1499 ,p_cm_dlvry_mthd_typ_id => p_pk_id
1500 ,p_object_version_number => p_object_version_number
1501 ,p_effective_date => p_effective_date
1502 );
1503 elsif p_table_alias = 'CMD' then
1504 BEN_COMM_DLVRY_MEDIA_API.delete_Comm_Dlvry_Media
1505 (p_validate => p_validate
1506 ,p_cm_dlvry_med_typ_id => p_pk_id
1507 ,p_object_version_number => p_object_version_number
1508 ,p_effective_date => p_effective_date
1509 );
1510 elsif p_table_alias = 'CCM' then
1511 BEN_CVG_AMT_CALC_API.delete_Cvg_Amt_Calc
1512 (p_validate => p_validate
1513 ,p_cvg_amt_calc_mthd_id => p_pk_id
1514 ,p_effective_start_date => p_effective_start_date
1515 ,p_effective_end_date => p_effective_end_date
1516 ,p_object_version_number => p_object_version_number
1517 ,p_effective_date => p_effective_date
1518 ,p_datetrack_mode => p_datetrack_mode
1519 );
1520 elsif p_table_alias = 'APR' then
1521 BEN_ACTUAL_PREMIUM_API.delete_actual_premium
1522 (p_validate => p_validate
1523 ,p_actl_prem_id => p_pk_id
1524 ,p_effective_start_date => p_effective_start_date
1525 ,p_effective_end_date => p_effective_end_date
1526 ,p_object_version_number => p_object_version_number
1527 ,p_effective_date => p_effective_date
1528 ,p_datetrack_mode => p_datetrack_mode
1529 );
1530 elsif p_table_alias = 'ABR' then
1531 BEN_ACTY_BASE_RATE_API.delete_acty_base_rate
1532 (p_validate => p_validate
1533 ,p_acty_base_rt_id => p_pk_id
1534 ,p_effective_start_date => p_effective_start_date
1535 ,p_effective_end_date => p_effective_end_date
1536 ,p_object_version_number => p_object_version_number
1537 ,p_effective_date => p_effective_date
1538 ,p_datetrack_mode => p_datetrack_mode
1539 );
1540 elsif p_table_alias = 'EIV' then
1541 BEN_EXTRA_INPUT_VALUE_API.delete_extra_input_value
1542 (p_validate => p_validate
1543 ,p_extra_input_value_id => p_pk_id
1544 ,p_object_version_number => p_object_version_number
1545 ,p_effective_date => p_effective_date
1546 );
1547 elsif p_table_alias = 'APF' then
1548 BEN_ACTY_RT_PYMT_SCHED_API.delete_acty_rt_pymt_sched
1549 (p_validate => p_validate
1550 ,p_acty_rt_pymt_sched_id => p_pk_id
1551 ,p_effective_start_date => p_effective_start_date
1552 ,p_effective_end_date => p_effective_end_date
1553 ,p_object_version_number => p_object_version_number
1554 ,p_effective_date => p_effective_date
1555 ,p_datetrack_mode => p_datetrack_mode
1556 );
1557 elsif p_table_alias = 'PSQ' then
1558 BEN_PYMT_SCHED_PY_FREQ_API.delete_pymt_sched_py_freq
1559 (p_validate => p_validate
1560 ,p_pymt_sched_py_freq_id => p_pk_id
1561 ,p_object_version_number => p_object_version_number
1562 ,p_effective_date => p_effective_date
1563 );
1564 elsif p_table_alias = 'ABC' then
1565 BEN_ACTY_BASE_RT_CTFN_API.delete_Acty_Base_Rt_Ctfn
1566 (p_validate => p_validate
1567 ,p_acty_base_rt_ctfn_id => p_pk_id
1568 ,p_effective_start_date => p_effective_start_date
1569 ,p_effective_end_date => p_effective_end_date
1570 ,p_object_version_number => p_object_version_number
1571 ,p_effective_date => p_effective_date
1572 ,p_datetrack_mode => p_datetrack_mode
1573 );
1574 elsif p_table_alias = 'MTR' then
1575 BEN_MATCHING_RATES_API.delete_MATCHING_RATES
1576 (p_validate => p_validate
1577 ,p_mtchg_rt_id => p_pk_id
1578 ,p_effective_start_date => p_effective_start_date
1579 ,p_effective_end_date => p_effective_end_date
1580 ,p_object_version_number => p_object_version_number
1581 ,p_effective_date => p_effective_date
1582 ,p_datetrack_mode => p_datetrack_mode
1583 );
1584 elsif p_table_alias = 'APL1' then
1585 BEN_ACTY_RT_PTD_LMT_API.delete_ACTY_RT_PTD_LMT
1586 (p_validate => p_validate
1587 ,p_acty_rt_ptd_lmt_id => p_pk_id
1588 ,p_effective_start_date => p_effective_start_date
1589 ,p_effective_end_date => p_effective_end_date
1590 ,p_object_version_number => p_object_version_number
1591 ,p_effective_date => p_effective_date
1592 ,p_datetrack_mode => p_datetrack_mode
1593 );
1594 elsif p_table_alias = 'VPF' then
1595 BEN_VRBL_RATE_PROFILE_API.delete_vrbl_rate_profile
1596 (p_validate => p_validate
1597 ,p_vrbl_rt_prfl_id => p_pk_id
1598 ,p_effective_start_date => p_effective_start_date
1599 ,p_effective_end_date => p_effective_end_date
1600 ,p_object_version_number => p_object_version_number
1601 ,p_effective_date => p_effective_date
1602 ,p_datetrack_mode => p_datetrack_mode
1603 );
1604 elsif p_table_alias = 'AVR' then
1605 BEN_ACTY_VRBL_RATE_API.delete_acty_vrbl_rate
1606 (p_validate => p_validate
1607 ,p_acty_vrbl_rt_id => p_pk_id
1608 ,p_effective_start_date => p_effective_start_date
1609 ,p_effective_end_date => p_effective_end_date
1610 ,p_object_version_number => p_object_version_number
1611 ,p_effective_date => p_effective_date
1612 ,p_datetrack_mode => p_datetrack_mode
1613 );
1614 elsif p_table_alias = 'PMRPV' then
1615 BEN_PRTL_MO_RT_PRTN_VAL_API.delete_Prtl_Mo_Rt_Prtn_Val
1616 (p_validate => p_validate
1617 ,p_prtl_mo_rt_prtn_val_id => p_pk_id
1618 ,p_effective_end_date => p_effective_end_date
1619 ,p_effective_start_date => p_effective_start_date
1620 ,p_object_version_number => p_object_version_number
1621 ,p_effective_date => p_effective_date
1622 ,p_datetrack_mode => p_datetrack_mode
1623 );
1624 elsif p_table_alias = 'BVR1' then
1625 BEN_BNFT_VRBL_RT_API.delete_bnft_vrbl_rt
1626 (p_validate => p_validate
1627 ,p_bnft_vrbl_rt_id => p_pk_id
1628 ,p_effective_start_date => p_effective_start_date
1629 ,p_effective_end_date => p_effective_end_date
1630 ,p_object_version_number => p_object_version_number
1631 ,p_effective_date => p_effective_date
1632 ,p_datetrack_mode => p_datetrack_mode
1633 );
1634 elsif p_table_alias = 'BRR' then
1635 BEN_BNFT_VRBL_RT_RL_API.delete_bnft_vrbl_rt_rl
1636 (p_validate => p_validate
1637 ,p_bnft_vrbl_rt_rl_id => p_pk_id
1638 ,p_effective_start_date => p_effective_start_date
1639 ,p_effective_end_date => p_effective_end_date
1640 ,p_object_version_number => p_object_version_number
1641 ,p_effective_date => p_effective_date
1642 ,p_datetrack_mode => p_datetrack_mode
1643 );
1644 elsif p_table_alias = 'APV' then
1645 BEN_ACTUAL_PREMIUM_RATE_API.delete_actual_premium_rate
1646 (p_validate => p_validate
1647 ,p_actl_prem_vrbl_rt_id => p_pk_id
1648 ,p_effective_start_date => p_effective_start_date
1649 ,p_effective_end_date => p_effective_end_date
1650 ,p_object_version_number => p_object_version_number
1651 ,p_effective_date => p_effective_date
1652 ,p_datetrack_mode => p_datetrack_mode
1653 );
1654 elsif p_table_alias = 'AVA' then
1655 BEN_ACTUAL_PREMIUM_RULE_API.delete_actual_premium_rule
1656 (p_validate => p_validate
1657 ,p_actl_prem_vrbl_rt_rl_id => p_pk_id
1658 ,p_effective_start_date => p_effective_start_date
1659 ,p_effective_end_date => p_effective_end_date
1660 ,p_object_version_number => p_object_version_number
1661 ,p_effective_date => p_effective_date
1662 ,p_datetrack_mode => p_datetrack_mode
1663 );
1664 elsif p_table_alias = 'DCR' then
1665 BEN_DPNT_CVG_RQD_RLSHP_API.delete_DPNT_CVG_RQD_RLSHP
1666 (p_validate => p_validate
1667 ,p_dpnt_cvg_rqd_rlshp_id => p_pk_id
1668 ,p_effective_start_date => p_effective_start_date
1669 ,p_effective_end_date => p_effective_end_date
1670 ,p_object_version_number => p_object_version_number
1671 ,p_effective_date => p_effective_date
1672 ,p_datetrack_mode => p_datetrack_mode
1673 );
1674 elsif p_table_alias = 'DEC' then
1675 BEN_DSGNTR_ENRLD_CVG_API.delete_DSGNTR_ENRLD_CVG
1676 (p_validate => p_validate
1677 ,p_dsgntr_enrld_cvg_id => p_pk_id
1678 ,p_effective_start_date => p_effective_start_date
1679 ,p_effective_end_date => p_effective_end_date
1680 ,p_object_version_number => p_object_version_number
1681 ,p_effective_date => p_effective_date
1682 ,p_datetrack_mode => p_datetrack_mode
1683 );
1684 elsif p_table_alias = 'EAC' then
1685 BEN_ELIG_AGE_CVG_API.delete_ELIG_AGE_CVG
1686 (p_validate => p_validate
1687 ,p_elig_age_cvg_id => p_pk_id
1688 ,p_effective_start_date => p_effective_start_date
1689 ,p_effective_end_date => p_effective_end_date
1690 ,p_object_version_number => p_object_version_number
1691 ,p_effective_date => p_effective_date
1692 ,p_datetrack_mode => p_datetrack_mode
1693 );
1694 elsif p_table_alias = 'EDC' then
1695 BEN_ELIG_DSBLD_STAT_CVG_API.delete_ELIG_DSBLD_STAT_CVG
1696 (p_validate => p_validate
1697 ,p_elig_dsbld_stat_cvg_id => p_pk_id
1698 ,p_effective_start_date => p_effective_start_date
1699 ,p_effective_end_date => p_effective_end_date
1700 ,p_object_version_number => p_object_version_number
1701 ,p_effective_date => p_effective_date
1702 ,p_datetrack_mode => p_datetrack_mode
1703 );
1704 elsif p_table_alias = 'EMC' then
1705 BEN_ELIG_MLTRY_STAT_CVG_API.delete_Elig_Mltry_Stat_Cvg
1706 (p_validate => p_validate
1707 ,p_elig_mltry_stat_cvg_id => p_pk_id
1708 ,p_effective_start_date => p_effective_start_date
1709 ,p_effective_end_date => p_effective_end_date
1710 ,p_object_version_number => p_object_version_number
1711 ,p_effective_date => p_effective_date
1712 ,p_datetrack_mode => p_datetrack_mode
1713 );
1714 elsif p_table_alias = 'EMS' then
1715 BEN_ELIG_MRTL_STAT_CVG_API.delete_Elig_Mrtl_Stat_Cvg
1716 (p_validate => p_validate
1717 ,p_elig_mrtl_stat_cvg_id => p_pk_id
1718 ,p_effective_start_date => p_effective_start_date
1719 ,p_effective_end_date => p_effective_end_date
1720 ,p_object_version_number => p_object_version_number
1721 ,p_effective_date => p_effective_date
1722 ,p_datetrack_mode => p_datetrack_mode
1723 );
1724 elsif p_table_alias = 'EPL' then
1725 BEN_ELIG_PSTL_CD_CVG_API.delete_ELIG_PSTL_CD_CVG
1726 (p_validate => p_validate
1727 ,p_elig_pstl_cd_r_rng_cvg_id => p_pk_id
1728 ,p_effective_start_date => p_effective_start_date
1729 ,p_effective_end_date => p_effective_end_date
1730 ,p_object_version_number => p_object_version_number
1731 ,p_effective_date => p_effective_date
1732 ,p_datetrack_mode => p_datetrack_mode
1733 );
1734 elsif p_table_alias = 'ESC' then
1735 BEN_ELIG_STDNT_STAT_CVG_API.delete_ELIG_STDNT_STAT_CVG
1736 (p_validate => p_validate
1737 ,p_elig_stdnt_stat_cvg_id => p_pk_id
1738 ,p_effective_start_date => p_effective_start_date
1739 ,p_effective_end_date => p_effective_end_date
1740 ,p_object_version_number => p_object_version_number
1741 ,p_effective_date => p_effective_date
1742 ,p_datetrack_mode => p_datetrack_mode
1743 );
1744 elsif p_table_alias = 'VEP' then
1745 BEN_VRBL_RT_ELIG_PRFL_API.delete_vrbl_rt_elig_prfl
1746 (p_validate => p_validate
1747 ,p_vrbl_rt_elig_prfl_id => p_pk_id
1748 ,p_vrbl_rt_prfl_id => p_pk_id
1749 ,p_effective_start_date => p_effective_start_date
1750 ,p_effective_end_date => p_effective_end_date
1751 ,p_object_version_number => p_object_version_number
1752 ,p_effective_date => p_effective_date
1753 ,p_datetrack_mode => p_datetrack_mode
1754 );
1755 elsif p_table_alias = 'ABP' then
1756 BEN_APLCN_TO_BENEFIT_POOL_API.delete_Aplcn_To_Benefit_Pool
1757 (p_validate => p_validate
1758 ,p_aplcn_to_bnft_pool_id => p_pk_id
1759 ,p_effective_start_date => p_effective_start_date
1760 ,p_effective_end_date => p_effective_end_date
1761 ,p_object_version_number => p_object_version_number
1762 ,p_effective_date => p_effective_date
1763 ,p_datetrack_mode => p_datetrack_mode
1764 );
1765 elsif p_table_alias = 'BPR1' then
1766 BEN_BNFT_POOL_RLOVR_RQMT_API.delete_Bnft_Pool_Rlovr_Rqmt
1767 (p_validate => p_validate
1768 ,p_bnft_pool_rlovr_rqmt_id => p_pk_id
1769 ,p_effective_start_date => p_effective_start_date
1770 ,p_effective_end_date => p_effective_end_date
1771 ,p_object_version_number => p_object_version_number
1772 ,p_effective_date => p_effective_date
1773 ,p_datetrack_mode => p_datetrack_mode
1774 );
1775 elsif p_table_alias = 'DPC' then
1776 BEN_DPNT_CVD_ANTHR_PL_CVG_API.delete_DPNT_CVD_ANTHR_PL_CVG
1777 (p_validate => p_validate
1778 ,p_dpnt_cvrd_anthr_pl_cvg_id => p_pk_id
1779 ,p_effective_start_date => p_effective_start_date
1780 ,p_effective_end_date => p_effective_end_date
1781 ,p_object_version_number => p_object_version_number
1782 ,p_effective_date => p_effective_date
1783 ,p_datetrack_mode => p_datetrack_mode
1784 );
1785 elsif p_table_alias = 'CTY' then
1786 BEN_COMPTNCY_RT_API.delete_comptncy_rt
1787 (p_validate => p_validate
1788 ,p_comptncy_rt_id => p_pk_id
1789 ,p_effective_start_date => p_effective_start_date
1790 ,p_effective_end_date => p_effective_end_date
1791 ,p_object_version_number => p_object_version_number
1792 ,p_effective_date => p_effective_date
1793 ,p_datetrack_mode => p_datetrack_mode
1794 );
1795 elsif p_table_alias = 'JRT' then
1796 BEN_JOB_RT_API.delete_JOB_RT
1797 (p_validate => p_validate
1798 ,p_job_rt_id => p_pk_id
1799 ,p_effective_start_date => p_effective_start_date
1800 ,p_effective_end_date => p_effective_end_date
1801 ,p_object_version_number => p_object_version_number
1802 ,p_effective_date => p_effective_date
1803 ,p_datetrack_mode => p_datetrack_mode
1804 );
1805 elsif p_table_alias = 'HSR' then
1806 BEN_HRLY_SALARY_RATE_API.delete_HRLY_SALARY_RATE
1807 (p_validate => p_validate
1808 ,p_hrly_slrd_rt_id => p_pk_id
1809 ,p_effective_start_date => p_effective_start_date
1810 ,p_effective_end_date => p_effective_end_date
1811 ,p_object_version_number => p_object_version_number
1812 ,p_effective_date => p_effective_date
1813 ,p_datetrack_mode => p_datetrack_mode
1814 );
1815 elsif p_table_alias = 'GRR' then
1816 BEN_GRADE_RATE_API.delete_GRADE_RATE
1817 (p_validate => p_validate
1818 ,p_grade_rt_id => p_pk_id
1819 ,p_effective_start_date => p_effective_start_date
1820 ,p_effective_end_date => p_effective_end_date
1821 ,p_object_version_number => p_object_version_number
1822 ,p_effective_date => p_effective_date
1823 ,p_datetrack_mode => p_datetrack_mode
1824 );
1825 elsif p_table_alias = 'FTR' then
1826 BEN_FULL_PRT_TIME_RATE_API.delete_FULL_PRT_TIME_RATE
1827 (p_validate => p_validate
1828 ,p_fl_tm_pt_tm_rt_id => p_pk_id
1829 ,p_effective_start_date => p_effective_start_date
1830 ,p_effective_end_date => p_effective_end_date
1831 ,p_object_version_number => p_object_version_number
1832 ,p_effective_date => p_effective_date
1833 ,p_datetrack_mode => p_datetrack_mode
1834 );
1835 elsif p_table_alias = 'BUR' then
1836 BEN_BARGAINING_UNIT_RT_API.delete_BARGAINING_UNIT_RT
1837 (p_validate => p_validate
1838 ,p_brgng_unit_rt_id => p_pk_id
1839 ,p_effective_start_date => p_effective_start_date
1840 ,p_effective_end_date => p_effective_end_date
1841 ,p_object_version_number => p_object_version_number
1842 ,p_effective_date => p_effective_date
1843 ,p_datetrack_mode => p_datetrack_mode
1844 );
1845 elsif p_table_alias = 'ESR' then
1846 BEN_EMPLOYEE_STATUS_RT_API.delete_EMPLOYEE_STATUS_RT
1847 (p_validate => p_validate
1848 ,p_ee_stat_rt_id => p_pk_id
1849 ,p_effective_start_date => p_effective_start_date
1850 ,p_effective_end_date => p_effective_end_date
1851 ,p_object_version_number => p_object_version_number
1852 ,p_effective_date => p_effective_date
1853 ,p_datetrack_mode => p_datetrack_mode
1854 );
1855 elsif p_table_alias = 'ASR' then
1856 BEN_ASSIGNMENT_SET_RATE_API.delete_ASSIGNMENT_SET_RATE
1857 (p_validate => p_validate
1858 ,p_asnt_set_rt_id => p_pk_id
1859 ,p_effective_start_date => p_effective_start_date
1860 ,p_effective_end_date => p_effective_end_date
1861 ,p_object_version_number => p_object_version_number
1862 ,p_effective_date => p_effective_date
1863 ,p_datetrack_mode => p_datetrack_mode
1864 );
1865 elsif p_table_alias = 'TUR' then
1866 BEN_TOBACCO_USE_RATE_API.delete_TOBACCO_USE_RATE
1867 (p_validate => p_validate
1868 ,p_tbco_use_rt_id => p_pk_id
1869 ,p_effective_start_date => p_effective_start_date
1870 ,p_effective_end_date => p_effective_end_date
1871 ,p_object_version_number => p_object_version_number
1872 ,p_effective_date => p_effective_date
1873 ,p_datetrack_mode => p_datetrack_mode
1874 );
1875 elsif p_table_alias = 'SAR' then
1876 BEN_SERVICE_AREA_RATE_API.delete_service_area_rate
1877 (p_validate => p_validate
1878 ,p_svc_area_rt_id => p_pk_id
1879 ,p_effective_start_date => p_effective_start_date
1880 ,p_effective_end_date => p_effective_end_date
1881 ,p_object_version_number => p_object_version_number
1882 ,p_effective_date => p_effective_date
1883 ,p_datetrack_mode => p_datetrack_mode
1884 );
1885 elsif p_table_alias = 'QTR' then
1886 BEN_QUAL_TITL_RT_API.delete_qual_titl_rt
1887 (p_validate => p_validate
1888 ,p_qual_titl_rt_id => p_pk_id
1889 ,p_effective_start_date => p_effective_start_date
1890 ,p_effective_end_date => p_effective_end_date
1891 ,p_object_version_number => p_object_version_number
1892 ,p_effective_date => p_effective_date
1893 ,p_datetrack_mode => p_datetrack_mode
1894 );
1895 elsif p_table_alias = 'PZR' then
1896 BEN_POSTAL_ZIP_RATE_API.delete_POSTAL_ZIP_RATE
1897 (p_validate => p_validate
1898 ,p_pstl_zip_rt_id => p_pk_id
1899 ,p_effective_start_date => p_effective_start_date
1900 ,p_effective_end_date => p_effective_end_date
1901 ,p_object_version_number => p_object_version_number
1902 ,p_effective_date => p_effective_date
1903 ,p_datetrack_mode => p_datetrack_mode
1904 );
1905 elsif p_table_alias = 'PTR' then
1906 BEN_PERSON_TYPE_RATE_API.delete_PERSON_TYPE_RATE
1907 (p_validate => p_validate
1908 ,p_per_typ_rt_id => p_pk_id
1909 ,p_effective_start_date => p_effective_start_date
1910 ,p_effective_end_date => p_effective_end_date
1911 ,p_object_version_number => p_object_version_number
1912 ,p_effective_date => p_effective_date
1913 ,p_datetrack_mode => p_datetrack_mode
1914 );
1915 elsif p_table_alias = 'GNR' then
1916 BEN_GENDER_RATE_API.delete_GENDER_RATE
1917 (p_validate => p_validate
1918 ,p_gndr_rt_id => p_pk_id
1919 ,p_effective_start_date => p_effective_start_date
1920 ,p_effective_end_date => p_effective_end_date
1921 ,p_object_version_number => p_object_version_number
1922 ,p_effective_date => p_effective_date
1923 ,p_datetrack_mode => p_datetrack_mode
1924 );
1925 elsif p_table_alias = 'DBR' then
1926 BEN_DSBLD_RT_API.delete_DSBLD_RT
1927 (p_validate => p_validate
1928 ,p_dsbld_rt_id => p_pk_id
1929 ,p_effective_start_date => p_effective_start_date
1930 ,p_effective_end_date => p_effective_end_date
1931 ,p_object_version_number => p_object_version_number
1932 ,p_effective_date => p_effective_date
1933 ,p_datetrack_mode => p_datetrack_mode
1934 );
1935 elsif p_table_alias = 'LMM' then
1936 BEN_LABOR_MEMBER_RATE_API.delete_LABOR_MEMBER_RATE
1937 (p_validate => p_validate
1938 ,p_lbr_mmbr_rt_id => p_pk_id
1939 ,p_effective_start_date => p_effective_start_date
1940 ,p_effective_end_date => p_effective_end_date
1941 ,p_object_version_number => p_object_version_number
1942 ,p_effective_date => p_effective_date
1943 ,p_datetrack_mode => p_datetrack_mode
1944 );
1945 elsif p_table_alias = 'LAR' then
1946 BEN_LOA_REASON_RATE_API.delete_LOA_REASON_RATE
1947 (p_validate => p_validate
1948 ,p_loa_rsn_rt_id => p_pk_id
1949 ,p_effective_start_date => p_effective_start_date
1950 ,p_effective_end_date => p_effective_end_date
1951 ,p_object_version_number => p_object_version_number
1952 ,p_effective_date => p_effective_date
1953 ,p_datetrack_mode => p_datetrack_mode
1954 );
1955 elsif p_table_alias = 'OUR' then
1956 BEN_ORG_UNIT_RATE_API.delete_ORG_UNIT_RATE
1957 (p_validate => p_validate
1958 ,p_org_unit_rt_id => p_pk_id
1959 ,p_effective_start_date => p_effective_start_date
1960 ,p_effective_end_date => p_effective_end_date
1961 ,p_object_version_number => p_object_version_number
1962 ,p_effective_date => p_effective_date
1963 ,p_datetrack_mode => p_datetrack_mode
1964 );
1965 elsif p_table_alias = 'LER1' then
1966 BEN_LEGAL_ENTITY_RATE_API.delete_LEGAL_ENTITY_RATE
1967 (p_validate => p_validate
1968 ,p_lgl_enty_rt_id => p_pk_id
1969 ,p_effective_start_date => p_effective_start_date
1970 ,p_effective_end_date => p_effective_end_date
1971 ,p_object_version_number => p_object_version_number
1972 ,p_effective_date => p_effective_date
1973 ,p_datetrack_mode => p_datetrack_mode
1974 );
1975 elsif p_table_alias = 'PR_' then
1976 BEN_PAYROLL_RATE_API.delete_PAYROLL_RATE
1977 (p_validate => p_validate
1978 ,p_pyrl_rt_id => p_pk_id
1979 ,p_effective_start_date => p_effective_start_date
1980 ,p_effective_end_date => p_effective_end_date
1981 ,p_object_version_number => p_object_version_number
1982 ,p_effective_date => p_effective_date
1983 ,p_datetrack_mode => p_datetrack_mode
1984 );
1985 elsif p_table_alias = 'PBR' then
1986 BEN_PAY_BASIS_RATE_API.delete_PAY_BASIS_RATE
1987 (p_validate => p_validate
1988 ,p_py_bss_rt_id => p_pk_id
1989 ,p_effective_start_date => p_effective_start_date
1990 ,p_effective_end_date => p_effective_end_date
1991 ,p_object_version_number => p_object_version_number
1992 ,p_effective_date => p_effective_date
1993 ,p_datetrack_mode => p_datetrack_mode
1994 );
1995 elsif p_table_alias = 'BRG' then
1996 BEN_BENEFIT_GRP_RATE_API.delete_BENEFIT_GRP_RATE
1997 (p_validate => p_validate
1998 ,p_benfts_grp_rt_id => p_pk_id
1999 ,p_effective_start_date => p_effective_start_date
2000 ,p_effective_end_date => p_effective_end_date
2001 ,p_object_version_number => p_object_version_number
2002 ,p_effective_date => p_effective_date
2003 ,p_datetrack_mode => p_datetrack_mode
2004 );
2005 elsif p_table_alias = 'CMR' then
2006 BEN_CMBN_AGE_LOS_RT_API.delete_CMBN_AGE_LOS_RT
2007 (p_validate => p_validate
2008 ,p_cmbn_age_los_rt_id => p_pk_id
2009 ,p_effective_start_date => p_effective_start_date
2010 ,p_effective_end_date => p_effective_end_date
2011 ,p_object_version_number => p_object_version_number
2012 ,p_effective_date => p_effective_date
2013 ,p_datetrack_mode => p_datetrack_mode
2014 );
2015 elsif p_table_alias = 'VMR' then
2016 BEN_VRBL_MATCHING_RATE_API.delete_VRBL_MATCHING_RATE
2017 (p_validate => p_validate
2018 ,p_vrbl_mtchg_rt_id => p_pk_id
2019 ,p_effective_end_date => p_effective_end_date
2020 ,p_effective_start_date => p_effective_start_date
2021 ,p_object_version_number => p_object_version_number
2022 ,p_effective_date => p_effective_date
2023 ,p_datetrack_mode => p_datetrack_mode
2024 );
2025 elsif p_table_alias = 'NOC' then
2026 BEN_NO_OTHR_CVG_RT_API.delete_NO_OTHR_CVG_RT
2027 (p_validate => p_validate
2028 ,p_no_othr_cvg_rt_id => p_pk_id
2029 ,p_effective_start_date => p_effective_start_date
2030 ,p_effective_end_date => p_effective_end_date
2031 ,p_object_version_number => p_object_version_number
2032 ,p_effective_date => p_effective_date
2033 ,p_datetrack_mode => p_datetrack_mode
2034 );
2035 elsif p_table_alias = 'OMR' then
2036 BEN_OPTD_MDCR_RT_API.delete_OPTD_MDCR_RT
2037 (p_validate => p_validate
2038 ,p_OPTD_MDCR_RT_id => p_pk_id
2039 ,p_effective_start_date => p_effective_start_date
2040 ,p_effective_end_date => p_effective_end_date
2041 ,p_object_version_number => p_object_version_number
2042 ,p_effective_date => p_effective_date
2043 ,p_datetrack_mode => p_datetrack_mode
2044 );
2045 elsif p_table_alias = 'TTP' then
2046 BEN_TTL_PRTT_RT_API.delete_ttl_prtt_rt
2047 (p_validate => p_validate
2048 ,p_ttl_prtt_rt_id => p_pk_id
2049 ,p_effective_start_date => p_effective_start_date
2050 ,p_effective_end_date => p_effective_end_date
2051 ,p_object_version_number => p_object_version_number
2052 ,p_effective_date => p_effective_date
2053 ,p_datetrack_mode => p_datetrack_mode
2054 );
2055 elsif p_table_alias = 'TCV' then
2056 BEN_TTL_CVG_VOL_RT_API.delete_ttl_cvg_vol_rt
2057 (p_validate => p_validate
2058 ,p_ttl_cvg_vol_rt_id => p_pk_id
2059 ,p_effective_start_date => p_effective_start_date
2060 ,p_effective_end_date => p_effective_end_date
2061 ,p_object_version_number => p_object_version_number
2062 ,p_effective_date => p_effective_date
2063 ,p_datetrack_mode => p_datetrack_mode
2064 );
2065 elsif p_table_alias = 'VPR' then
2066 BEN_VRBL_RT_PRFL_RULE_API.delete_VRBL_RT_PRFL_RULE
2067 (p_validate => p_validate
2068 ,p_vrbl_rt_prfl_rl_id => p_pk_id
2069 ,p_effective_start_date => p_effective_start_date
2070 ,p_effective_end_date => p_effective_end_date
2071 ,p_object_version_number => p_object_version_number
2072 ,p_effective_date => p_effective_date
2073 ,p_datetrack_mode => p_datetrack_mode
2074 );
2075 elsif p_table_alias = 'PRT' then
2076 BEN_POE_RT_API.delete_POE_RT
2077 (p_validate => p_validate
2078 ,p_poe_rt_id => p_pk_id
2079 ,p_effective_start_date => p_effective_start_date
2080 ,p_effective_end_date => p_effective_end_date
2081 ,p_object_version_number => p_object_version_number
2082 ,p_effective_date => p_effective_date
2083 ,p_datetrack_mode => p_datetrack_mode
2084 );
2085 elsif p_table_alias = 'CPN' then
2086 BEN_CNTNG_PRTN_PRFL_RT_API.delete_cntng_prtn_prfl_rt
2087 (p_validate => p_validate
2088 ,p_cntng_prtn_prfl_rt_id => p_pk_id
2089 ,p_effective_start_date => p_effective_start_date
2090 ,p_effective_end_date => p_effective_end_date
2091 ,p_object_version_number => p_object_version_number
2092 ,p_effective_date => p_effective_date
2093 ,p_datetrack_mode => p_datetrack_mode
2094 );
2095 elsif p_table_alias = 'PST' then
2096 BEN_PSTN_RT_API.delete_PSTN_RT
2097 (p_validate => p_validate
2098 ,p_PSTN_RT_id => p_pk_id
2099 ,p_effective_start_date => p_effective_start_date
2100 ,p_effective_end_date => p_effective_end_date
2101 ,p_object_version_number => p_object_version_number
2102 ,p_effective_date => p_effective_date
2103 ,p_datetrack_mode => p_datetrack_mode
2104 );
2105 elsif p_table_alias = 'WLR' then
2106 BEN_WORK_LOC_RATE_API.delete_WORK_LOC_RATE
2107 (p_validate => p_validate
2108 ,p_wk_loc_rt_id => p_pk_id
2109 ,p_effective_start_date => p_effective_start_date
2110 ,p_effective_end_date => p_effective_end_date
2111 ,p_object_version_number => p_object_version_number
2112 ,p_effective_date => p_effective_date
2113 ,p_datetrack_mode => p_datetrack_mode
2114 );
2115 elsif p_table_alias = 'PFR' then
2116 BEN_PCT_FULL_TIME_RATE_API.delete_PCT_FULL_TIME_RATE
2117 (p_validate => p_validate
2118 ,p_pct_fl_tm_rt_id => p_pk_id
2119 ,p_effective_start_date => p_effective_start_date
2120 ,p_effective_end_date => p_effective_end_date
2121 ,p_object_version_number => p_object_version_number
2122 ,p_effective_date => p_effective_date
2123 ,p_datetrack_mode => p_datetrack_mode
2124 );
2125 elsif p_table_alias = 'HWR' then
2126 BEN_HRS_WKD_IN_PERIOD_RT_API.delete_HRS_WKD_IN_PERIOD_RT
2127 (p_validate => p_validate
2128 ,p_hrs_wkd_in_perd_rt_id => p_pk_id
2129 ,p_effective_start_date => p_effective_start_date
2130 ,p_effective_end_date => p_effective_end_date
2131 ,p_object_version_number => p_object_version_number
2132 ,p_effective_date => p_effective_date
2133 ,p_datetrack_mode => p_datetrack_mode
2134 );
2135 elsif p_table_alias = 'CLR' then
2136 BEN_COMP_LEVEL_RATE_API.delete_COMP_LEVEL_RATE
2137 (p_validate => p_validate
2138 ,p_comp_lvl_rt_id => p_pk_id
2139 ,p_effective_start_date => p_effective_start_date
2140 ,p_effective_end_date => p_effective_end_date
2141 ,p_object_version_number => p_object_version_number
2142 ,p_effective_date => p_effective_date
2143 ,p_datetrack_mode => p_datetrack_mode
2144 );
2145 elsif p_table_alias = 'LSR' then
2146 BEN_LENGTH_OF_SVC_RATE_API.delete_LENGTH_OF_SVC_RATE
2147 (p_validate => p_validate
2148 ,p_los_rt_id => p_pk_id
2149 ,p_effective_start_date => p_effective_start_date
2150 ,p_effective_end_date => p_effective_end_date
2151 ,p_object_version_number => p_object_version_number
2152 ,p_effective_date => p_effective_date
2153 ,p_datetrack_mode => p_datetrack_mode
2154 );
2155 elsif p_table_alias = 'LRN' then
2156 BEN_LVG_RSN_RT_API.delete_lvg_rsn_rt
2157 (p_validate => p_validate
2158 ,p_lvg_rsn_rt_id => p_pk_id
2159 ,p_effective_start_date => p_effective_start_date
2160 ,p_effective_end_date => p_effective_end_date
2161 ,p_object_version_number => p_object_version_number
2162 ,p_effective_date => p_effective_date
2163 ,p_datetrack_mode => p_datetrack_mode
2164 );
2165 elsif p_table_alias = 'ART' then
2166 BEN_AGE_RATES_API.delete_age_rates
2167 (p_validate => p_validate
2168 ,p_age_rt_id => p_pk_id
2169 ,p_effective_start_date => p_effective_start_date
2170 ,p_effective_end_date => p_effective_end_date
2171 ,p_object_version_number => p_object_version_number
2172 ,p_effective_date => p_effective_date
2173 ,p_datetrack_mode => p_datetrack_mode
2174 );
2175 elsif p_table_alias = 'SHR' then
2176 BEN_SCHEDD_HRS_RATE_API.delete_SCHEDD_HRS_RATE
2177 (p_validate => p_validate
2178 ,p_schedd_hrs_rt_id => p_pk_id
2179 ,p_effective_start_date => p_effective_start_date
2180 ,p_effective_end_date => p_effective_end_date
2181 ,p_object_version_number => p_object_version_number
2182 ,p_effective_date => p_effective_date
2183 ,p_datetrack_mode => p_datetrack_mode
2184 );
2185 elsif p_table_alias = 'QIG' then
2186 BEN_QUA_IN_GR_RT_API.delete_QUA_IN_GR_RT
2187 (p_validate => p_validate
2188 ,p_qua_in_gr_rt_id => p_pk_id
2189 ,p_effective_start_date => p_effective_start_date
2190 ,p_effective_end_date => p_effective_end_date
2191 ,p_object_version_number => p_object_version_number
2192 ,p_effective_date => p_effective_date
2193 ,p_datetrack_mode => p_datetrack_mode
2194 );
2195 elsif p_table_alias = 'PRR' then
2196 BEN_PERF_RTNG_RT_API.delete_perf_rtng_rt
2197 (p_validate => p_validate
2198 ,p_perf_rtng_rt_id => p_pk_id
2199 ,p_effective_start_date => p_effective_start_date
2200 ,p_effective_end_date => p_effective_end_date
2201 ,p_object_version_number => p_object_version_number
2202 ,p_effective_date => p_effective_date
2203 ,p_datetrack_mode => p_datetrack_mode
2204 );
2205 elsif p_table_alias = 'CQR' then
2206 BEN_CBR_QUALD_BNF_RT_API.delete_cbr_quald_bnf_rt
2207 (p_validate => p_validate
2208 ,p_cbr_quald_bnf_rt_id => p_pk_id
2209 ,p_effective_start_date => p_effective_start_date
2210 ,p_effective_end_date => p_effective_end_date
2211 ,p_object_version_number => p_object_version_number
2212 ,p_effective_date => p_effective_date
2213 ,p_datetrack_mode => p_datetrack_mode
2214 );
2215 elsif p_table_alias = 'PAP' then
2216 BEN_PRTT_ANTHR_PL_RT_API.delete_PRTT_ANTHR_PL_RT
2217 (p_validate => p_validate
2218 ,p_prtt_anthr_pl_rt_id => p_pk_id
2219 ,p_effective_start_date => p_effective_start_date
2220 ,p_effective_end_date => p_effective_end_date
2221 ,p_object_version_number => p_object_version_number
2222 ,p_effective_date => p_effective_date
2223 ,p_datetrack_mode => p_datetrack_mode
2224 );
2225 elsif p_table_alias = 'OPR' then
2226 BEN_OTHR_PTIP_RT_API.delete_OTHR_PTIP_RT
2227 (p_validate => p_validate
2228 ,p_othr_ptip_rt_id => p_pk_id
2229 ,p_effective_start_date => p_effective_start_date
2230 ,p_effective_end_date => p_effective_end_date
2231 ,p_object_version_number => p_object_version_number
2232 ,p_effective_date => p_effective_date
2233 ,p_datetrack_mode => p_datetrack_mode
2234 );
2235 elsif p_table_alias = 'ENT' then
2236 BEN_ENRLD_ANTHR_PTIP_RT_API.delete_ENRLD_ANTHR_PTIP_RT
2237 (p_validate => p_validate
2238 ,p_enrld_anthr_ptip_rt_id => p_pk_id
2239 ,p_effective_start_date => p_effective_start_date
2240 ,p_effective_end_date => p_effective_end_date
2241 ,p_object_version_number => p_object_version_number
2242 ,p_effective_date => p_effective_date
2243 ,p_datetrack_mode => p_datetrack_mode
2244 );
2245 elsif p_table_alias = 'ENL' then
2246 BEN_ENRLD_ANTHR_PL_RT_API.delete_ENRLD_ANTHR_PL_RT
2247 (p_validate => p_validate
2248 ,p_enrld_anthr_pl_rt_id => p_pk_id
2249 ,p_effective_start_date => p_effective_start_date
2250 ,p_effective_end_date => p_effective_end_date
2251 ,p_object_version_number => p_object_version_number
2252 ,p_effective_date => p_effective_date
2253 ,p_datetrack_mode => p_datetrack_mode
2254 );
2255 elsif p_table_alias = 'EAR' then
2256 BEN_ENRLD_ANTHR_PLIP_RT_API.delete_ENRLD_ANTHR_PLIP_RT
2257 (p_validate => p_validate
2258 ,p_enrld_anthr_plip_rt_id => p_pk_id
2259 ,p_effective_start_date => p_effective_start_date
2260 ,p_effective_end_date => p_effective_end_date
2261 ,p_object_version_number => p_object_version_number
2262 ,p_effective_date => p_effective_date
2263 ,p_datetrack_mode => p_datetrack_mode
2264 );
2265 elsif p_table_alias = 'EAO' then
2266 BEN_ENRLD_ANTHR_OIPL_RT_API.delete_ENRLD_ANTHR_OIPL_RT
2267 (p_validate => p_validate
2268 ,p_enrld_anthr_oipl_rt_id => p_pk_id
2269 ,p_effective_start_date => p_effective_start_date
2270 ,p_effective_end_date => p_effective_end_date
2271 ,p_object_version_number => p_object_version_number
2272 ,p_effective_date => p_effective_date
2273 ,p_datetrack_mode => p_datetrack_mode
2274 );
2275 elsif p_table_alias = 'DOT' then
2276 BEN_DPNT_OTHR_PTIP_RT_API.delete_DPNT_OTHR_PTIP_RT
2277 (p_validate => p_validate
2278 ,p_dpnt_othr_ptip_rt_id => p_pk_id
2279 ,p_effective_start_date => p_effective_start_date
2280 ,p_effective_end_date => p_effective_end_date
2281 ,p_object_version_number => p_object_version_number
2282 ,p_effective_date => p_effective_date
2283 ,p_datetrack_mode => p_datetrack_mode
2284 );
2285 elsif p_table_alias = 'DOP' then
2286 BEN_DPNT_CVRD_OTHR_PGM_RT_API.delete_DPNT_CVRD_OTHR_PGM_RT
2287 (p_validate => p_validate
2288 ,p_dpnt_cvrd_othr_pgm_rt_id => p_pk_id
2289 ,p_effective_start_date => p_effective_start_date
2290 ,p_effective_end_date => p_effective_end_date
2291 ,p_object_version_number => p_object_version_number
2292 ,p_effective_date => p_effective_date
2293 ,p_datetrack_mode => p_datetrack_mode
2294 );
2295 elsif p_table_alias = 'DCP' then
2296 BEN_DPNT_CVRD_PLIP_RT_API.delete_DPNT_CVRD_PLIP_RT
2297 (p_validate => p_validate
2298 ,p_dpnt_cvrd_plip_rt_id => p_pk_id
2299 ,p_effective_start_date => p_effective_start_date
2300 ,p_effective_end_date => p_effective_end_date
2301 ,p_object_version_number => p_object_version_number
2302 ,p_effective_date => p_effective_date
2303 ,p_datetrack_mode => p_datetrack_mode
2304 );
2305 elsif p_table_alias = 'DCO' then
2306 BEN_DPNT_CVD_O_PTIP_RT_API.delete_DPNT_CVD_O_PTIP_RT
2307 (p_validate => p_validate
2308 ,p_dpnt_cvrd_othr_ptip_rt_id => p_pk_id
2309 ,p_effective_start_date => p_effective_start_date
2310 ,p_effective_end_date => p_effective_end_date
2311 ,p_object_version_number => p_object_version_number
2312 ,p_effective_date => p_effective_date
2313 ,p_datetrack_mode => p_datetrack_mode
2314 );
2315 elsif p_table_alias = 'DCL' then
2316 BEN_DPNT_CVRD_OTHR_PL_RT_API.delete_DPNT_CVRD_OTHR_PL_RT
2317 (p_validate => p_validate
2318 ,p_dpnt_cvrd_othr_pl_rt_id => p_pk_id
2319 ,p_effective_start_date => p_effective_start_date
2320 ,p_effective_end_date => p_effective_end_date
2321 ,p_object_version_number => p_object_version_number
2322 ,p_effective_date => p_effective_date
2323 ,p_datetrack_mode => p_datetrack_mode
2324 );
2325 elsif p_table_alias = 'EPM' then
2326 BEN_ENRLD_ANTHR_PGM_RT_API.delete_ENRLD_ANTHR_PGM_RT
2327 (p_validate => p_validate
2328 ,p_enrld_anthr_pgm_rt_id => p_pk_id
2329 ,p_effective_start_date => p_effective_start_date
2330 ,p_effective_end_date => p_effective_end_date
2331 ,p_object_version_number => p_object_version_number
2332 ,p_effective_date => p_effective_date
2333 ,p_datetrack_mode => p_datetrack_mode
2334 );
2335 elsif p_table_alias = 'PGR' then
2336 BEN_PEOPLE_GROUP_RATE_API.delete_PEOPLE_GROUP_RATE
2337 (p_validate => p_validate
2338 ,p_ppl_grp_rt_id => p_pk_id
2339 ,p_effective_start_date => p_effective_start_date
2340 ,p_effective_end_date => p_effective_end_date
2341 ,p_object_version_number => p_object_version_number
2342 ,p_effective_date => p_effective_date
2343 ,p_datetrack_mode => p_datetrack_mode
2344 );
2345 end if;
2346 hr_utility.set_location('Leaving: '||l_proc || ' for ' || p_table_alias || ' p_pk_id: ' ||p_pk_id ,20);
2347 exception
2348 when OTHERS THEN
2349 hr_utility.set_location('Delete failed for: '|| p_table_alias || ' primary key: '||p_pk_id ,30);
2350 --NOTIFY
2351 p_delete_failed := 'Y';
2352 l_encoded_message := fnd_message.get;
2353 if(p_parent_entity_name is null or p_parent_entity_name = p_entity_name) then
2354 fnd_message.set_name('BEN', 'BEN_94154_PDW_DELETE_FAILED');
2355 fnd_message.set_token('NAME', p_entity_name );
2356 fnd_message.set_token('MESSAGE', l_encoded_message);
2357 fnd_message.raise_error;
2358 else
2359 fnd_message.set_name('BEN', 'BEN_94160_PDW_DELETE_FAILED');
2360 fnd_message.set_token('NAME', p_parent_entity_name );
2361 fnd_message.set_token('CHILD', p_entity_name );
2362 fnd_message.set_token('MESSAGE',l_encoded_message);
2363 fnd_message.raise_error;
2364 end if;
2365 end call_delete_api;
2366
2367 -- p_validate 0 means false
2368
2369 procedure call_delete_apis
2370 ( p_process_validate in Number default 0
2371 ,p_copy_entity_txn_id in Number
2372 ,p_delete_failed out nocopy varchar2
2373 ) is
2374
2375 cursor c_copy_entity_txn is
2376 select cet.src_effective_date effective_date
2377 from pqh_copy_entity_txns cet
2378 where cet.copy_entity_txn_id = p_copy_entity_txn_id;
2379
2380
2381 cursor c_deleted_rows(p_effective_date date) is
2382 select table_alias, datetrack_mode p_datetrack_mode, information1 p_pk_id, information2 p_effective_start_date, information3 p_effective_end_date,information5 entity_name, information265 p_object_version_number from ben_copy_entity_results
2383 where copy_entity_txn_id = p_copy_entity_txn_id
2384 and dml_operation = 'DELETE'
2385 and p_effective_date between nvl(information2,p_effective_date) and nvl(information3,p_effective_date)
2386 group by order_in_hierarchy,table_alias,order_in_group,information1,datetrack_mode,information2,information3,information5, information265
2387 order by order_in_hierarchy desc, order_in_group desc ;
2388
2389 l_effective_date pqh_copy_entity_txns.src_effective_date%type;
2390 l_date_to_use pqh_copy_entity_txns.src_effective_date%type;
2391 l_proc varchar2(72) := g_package||'call_delete_apis';
2392 l_datetrack_mode ben_copy_entity_results.datetrack_mode%type;
2393
2394 begin
2395 hr_utility.set_location('Entering: '||l_proc,10);
2396 open c_copy_entity_txn;
2397 fetch c_copy_entity_txn into l_effective_date;
2398 close c_copy_entity_txn;
2399
2400 for l_deleted_rows in c_deleted_rows(l_effective_date) loop
2401 -- if we are tryin to delete on the day entity was created, it needs to be purged
2402 if(l_effective_date = l_deleted_rows.p_effective_start_date) then
2403 l_datetrack_mode := hr_api.g_zap;
2404 l_date_to_use := l_effective_date;
2405 else
2406 -- for plan design wizard we want to end date deleted rows a day before
2407 l_datetrack_mode := l_deleted_rows.p_datetrack_mode;
2408 l_date_to_use := l_effective_date -1;
2409 end if;
2410
2411 call_delete_api
2412 ( p_process_validate => p_process_validate
2413 , p_pk_id => l_deleted_rows.p_pk_id
2414 , p_table_alias => l_deleted_rows.table_alias
2415 , p_effective_date => l_date_to_use
2416 , p_effective_start_date => l_deleted_rows.p_effective_start_date
2417 , p_effective_end_date => l_deleted_rows.p_effective_end_date
2418 , p_object_version_number => l_deleted_rows.p_object_version_number
2419 , p_datetrack_mode => l_datetrack_mode
2420 , p_parent_entity_name => null
2421 , p_entity_name => l_deleted_rows.entity_name
2422 , p_delete_failed => p_delete_failed
2423 );
2424
2425 end loop;
2426 hr_utility.set_location('Leaving: '||l_proc,20);
2427 end call_delete_apis;
2428
2429
2430 procedure call_delete_apis_for_hierarchy
2431 ( p_process_validate in Number default 0
2432 ,p_copy_entity_txn_id in Number
2433 ,p_parent_entity_result_id in varchar2
2434 ,p_delete_failed out nocopy varchar2
2435 ) is
2436 cursor c_copy_entity_txn is
2437 select cet.src_effective_date effective_date
2438 from pqh_copy_entity_txns cet
2439 where cet.copy_entity_txn_id = p_copy_entity_txn_id;
2440
2441 -- we need to call delete api for all the dependents and the parent row itself.
2442 cursor c_deleted_rows(p_effective_date date) is
2443 select table_alias, datetrack_mode p_datetrack_mode, information1 p_pk_id, information2 p_effective_start_date, information3 p_effective_end_date,information5 entity_name, information265 p_object_version_number from ben_copy_entity_results
2444 where( copy_entity_txn_id = p_copy_entity_txn_id
2445 and pd_parent_entity_result_id = p_parent_entity_result_id
2446 and dml_operation = 'DELETE'
2447 and p_effective_date between nvl(information2,p_effective_date) and nvl(information3,p_effective_date))
2448 or
2449 copy_entity_result_id = p_parent_entity_result_id
2450 group by order_in_hierarchy,table_alias,order_in_group,information1,datetrack_mode,information2,information3,information5, information265
2451 order by order_in_hierarchy desc, order_in_group desc ;
2452
2453 cursor c_parent_entity_name is
2454 select information5 parent_entity_name from ben_copy_entity_results
2455 where copy_entity_result_id = p_parent_entity_result_id;
2456
2457 l_effective_date pqh_copy_entity_txns.src_effective_date%type;
2458 l_date_to_use pqh_copy_entity_txns.src_effective_date%type;
2459 l_proc varchar2(72) := g_package||'call_delete_apis_for_hierarchy';
2460 l_datetrack_mode ben_copy_entity_results.datetrack_mode%type;
2461 l_parent_entity_name ben_copy_entity_results.information5%type;
2462 begin
2463 hr_utility.set_location('Entering: '||l_proc,10);
2464 open c_copy_entity_txn;
2465 fetch c_copy_entity_txn into l_effective_date;
2466 close c_copy_entity_txn;
2467 open c_parent_entity_name;
2468 fetch c_parent_entity_name into l_parent_entity_name;
2469 close c_parent_entity_name;
2470
2471
2472 for l_deleted_rows in c_deleted_rows(l_effective_date) loop
2473 -- if we are tryin to delete on the day entity was created, it needs to be purged
2474 if( l_effective_date = l_deleted_rows.p_effective_start_date) then
2475 l_datetrack_mode := hr_api.g_zap;
2476 l_date_to_use := l_effective_date;
2477 else
2478 -- for plan design wizard we want to end date deleted rows a day before
2479 l_datetrack_mode := l_deleted_rows.p_datetrack_mode;
2480 l_date_to_use := l_effective_date -1;
2481 end if;
2482
2483 call_delete_api
2484 ( p_process_validate => p_process_validate
2485 , p_pk_id => l_deleted_rows.p_pk_id
2486 , p_table_alias => l_deleted_rows.table_alias
2487 , p_effective_date => l_date_to_use
2488 , p_effective_start_date => l_deleted_rows.p_effective_start_date
2489 , p_effective_end_date => l_deleted_rows.p_effective_end_date
2490 , p_object_version_number => l_deleted_rows.p_object_version_number
2491 , p_datetrack_mode => l_datetrack_mode
2492 , p_parent_entity_name => l_parent_entity_name
2493 , p_entity_name => l_deleted_rows.entity_name
2494 , p_delete_failed => p_delete_failed
2495 );
2496
2497 end loop;
2498 hr_utility.set_location('Leaving: '||l_proc,20);
2499 end call_delete_apis_for_hierarchy;
2500
2501 end ben_plan_design_delete_api;
2502