APPS.BEN_ESW_DEL dependencies on BEN_ESW_SHD

Line 54: (p_rec in out nocopy ben_esw_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ben_esw_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

Line 97: (p_rec in out nocopy ben_esw_shd.g_rec_type

93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy ben_esw_shd.g_rec_type
98: ,p_effective_date in date
99: ,p_datetrack_mode in varchar2
100: ,p_validation_start_date in date
101: ,p_validation_end_date in date

Line 154: (p_rec in out nocopy ben_esw_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy ben_esw_shd.g_rec_type
155: ,p_effective_date in date
156: ,p_datetrack_mode in varchar2
157: ,p_validation_start_date in date
158: ,p_validation_end_date in date

Line 169: := ben_esw_shd.g_old_rec.effective_start_date;

165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.effective_start_date
169: := ben_esw_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = hr_api.g_delete) then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else

Line 179: ben_esw_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ben_esw_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date
181: ,p_base_key_value => p_rec.elig_scre_wtg_id
182: ,p_new_effective_end_date => p_rec.effective_end_date
183: ,p_validation_start_date => p_validation_start_date

Line 228: (p_rec in out nocopy ben_esw_shd.g_rec_type

224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure pre_delete
228: (p_rec in out nocopy ben_esw_shd.g_rec_type
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_validation_start_date in date
232: ,p_validation_end_date in date

Line 288: (p_rec in ben_esw_shd.g_rec_type

284: --
285: -- {End Of Comments}
286: -- ----------------------------------------------------------------------------
287: Procedure post_delete
288: (p_rec in ben_esw_shd.g_rec_type
289: ,p_effective_date in date
290: ,p_datetrack_mode in varchar2
291: ,p_validation_start_date in date
292: ,p_validation_end_date in date

Line 317: => ben_esw_shd.g_old_rec.elig_per_id

313: => p_rec.effective_start_date
314: ,p_effective_end_date
315: => p_rec.effective_end_date
316: ,p_elig_per_id_o
317: => ben_esw_shd.g_old_rec.elig_per_id
318: ,p_elig_per_opt_id_o
319: => ben_esw_shd.g_old_rec.elig_per_opt_id
320: ,p_elig_rslt_id_o
321: => ben_esw_shd.g_old_rec.elig_rslt_id

Line 319: => ben_esw_shd.g_old_rec.elig_per_opt_id

315: => p_rec.effective_end_date
316: ,p_elig_per_id_o
317: => ben_esw_shd.g_old_rec.elig_per_id
318: ,p_elig_per_opt_id_o
319: => ben_esw_shd.g_old_rec.elig_per_opt_id
320: ,p_elig_rslt_id_o
321: => ben_esw_shd.g_old_rec.elig_rslt_id
322: ,p_per_in_ler_id_o
323: => ben_esw_shd.g_old_rec.per_in_ler_id

Line 321: => ben_esw_shd.g_old_rec.elig_rslt_id

317: => ben_esw_shd.g_old_rec.elig_per_id
318: ,p_elig_per_opt_id_o
319: => ben_esw_shd.g_old_rec.elig_per_opt_id
320: ,p_elig_rslt_id_o
321: => ben_esw_shd.g_old_rec.elig_rslt_id
322: ,p_per_in_ler_id_o
323: => ben_esw_shd.g_old_rec.per_in_ler_id
324: ,p_effective_start_date_o
325: => ben_esw_shd.g_old_rec.effective_start_date

Line 323: => ben_esw_shd.g_old_rec.per_in_ler_id

319: => ben_esw_shd.g_old_rec.elig_per_opt_id
320: ,p_elig_rslt_id_o
321: => ben_esw_shd.g_old_rec.elig_rslt_id
322: ,p_per_in_ler_id_o
323: => ben_esw_shd.g_old_rec.per_in_ler_id
324: ,p_effective_start_date_o
325: => ben_esw_shd.g_old_rec.effective_start_date
326: ,p_effective_end_date_o
327: => ben_esw_shd.g_old_rec.effective_end_date

Line 325: => ben_esw_shd.g_old_rec.effective_start_date

321: => ben_esw_shd.g_old_rec.elig_rslt_id
322: ,p_per_in_ler_id_o
323: => ben_esw_shd.g_old_rec.per_in_ler_id
324: ,p_effective_start_date_o
325: => ben_esw_shd.g_old_rec.effective_start_date
326: ,p_effective_end_date_o
327: => ben_esw_shd.g_old_rec.effective_end_date
328: ,p_object_version_number_o
329: => ben_esw_shd.g_old_rec.object_version_number

Line 327: => ben_esw_shd.g_old_rec.effective_end_date

323: => ben_esw_shd.g_old_rec.per_in_ler_id
324: ,p_effective_start_date_o
325: => ben_esw_shd.g_old_rec.effective_start_date
326: ,p_effective_end_date_o
327: => ben_esw_shd.g_old_rec.effective_end_date
328: ,p_object_version_number_o
329: => ben_esw_shd.g_old_rec.object_version_number
330: ,p_eligy_prfl_id_o
331: => ben_esw_shd.g_old_rec.eligy_prfl_id

Line 329: => ben_esw_shd.g_old_rec.object_version_number

325: => ben_esw_shd.g_old_rec.effective_start_date
326: ,p_effective_end_date_o
327: => ben_esw_shd.g_old_rec.effective_end_date
328: ,p_object_version_number_o
329: => ben_esw_shd.g_old_rec.object_version_number
330: ,p_eligy_prfl_id_o
331: => ben_esw_shd.g_old_rec.eligy_prfl_id
332: ,p_crit_tab_short_name_o
333: => ben_esw_shd.g_old_rec.crit_tab_short_name

Line 331: => ben_esw_shd.g_old_rec.eligy_prfl_id

327: => ben_esw_shd.g_old_rec.effective_end_date
328: ,p_object_version_number_o
329: => ben_esw_shd.g_old_rec.object_version_number
330: ,p_eligy_prfl_id_o
331: => ben_esw_shd.g_old_rec.eligy_prfl_id
332: ,p_crit_tab_short_name_o
333: => ben_esw_shd.g_old_rec.crit_tab_short_name
334: ,p_crit_tab_pk_id_o
335: => ben_esw_shd.g_old_rec.crit_tab_pk_id

Line 333: => ben_esw_shd.g_old_rec.crit_tab_short_name

329: => ben_esw_shd.g_old_rec.object_version_number
330: ,p_eligy_prfl_id_o
331: => ben_esw_shd.g_old_rec.eligy_prfl_id
332: ,p_crit_tab_short_name_o
333: => ben_esw_shd.g_old_rec.crit_tab_short_name
334: ,p_crit_tab_pk_id_o
335: => ben_esw_shd.g_old_rec.crit_tab_pk_id
336: ,p_computed_score_o
337: => ben_esw_shd.g_old_rec.computed_score

Line 335: => ben_esw_shd.g_old_rec.crit_tab_pk_id

331: => ben_esw_shd.g_old_rec.eligy_prfl_id
332: ,p_crit_tab_short_name_o
333: => ben_esw_shd.g_old_rec.crit_tab_short_name
334: ,p_crit_tab_pk_id_o
335: => ben_esw_shd.g_old_rec.crit_tab_pk_id
336: ,p_computed_score_o
337: => ben_esw_shd.g_old_rec.computed_score
338: ,p_benefit_action_id_o
339: => ben_esw_shd.g_old_rec.benefit_action_id

Line 337: => ben_esw_shd.g_old_rec.computed_score

333: => ben_esw_shd.g_old_rec.crit_tab_short_name
334: ,p_crit_tab_pk_id_o
335: => ben_esw_shd.g_old_rec.crit_tab_pk_id
336: ,p_computed_score_o
337: => ben_esw_shd.g_old_rec.computed_score
338: ,p_benefit_action_id_o
339: => ben_esw_shd.g_old_rec.benefit_action_id
340: );
341: --

Line 339: => ben_esw_shd.g_old_rec.benefit_action_id

335: => ben_esw_shd.g_old_rec.crit_tab_pk_id
336: ,p_computed_score_o
337: => ben_esw_shd.g_old_rec.computed_score
338: ,p_benefit_action_id_o
339: => ben_esw_shd.g_old_rec.benefit_action_id
340: );
341: --
342: exception
343: --

Line 361: ,p_rec in out nocopy ben_esw_shd.g_rec_type

357: -- ----------------------------------------------------------------------------
358: Procedure del
359: (p_effective_date in date
360: ,p_datetrack_mode in varchar2
361: ,p_rec in out nocopy ben_esw_shd.g_rec_type
362: ) is
363: --
364: l_proc varchar2(72) := g_package||'del';
365: l_validation_start_date date;

Line 377: ben_esw_shd.lck

373: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
374: --
375: -- We must lock the row which we need to delete.
376: --
377: ben_esw_shd.lck
378: (p_effective_date => p_effective_date
379: ,p_datetrack_mode => p_datetrack_mode
380: ,p_elig_scre_wtg_id => p_rec.elig_scre_wtg_id
381: ,p_object_version_number => p_rec.object_version_number

Line 446: l_rec ben_esw_shd.g_rec_type;

442: ,p_effective_start_date out nocopy date
443: ,p_effective_end_date out nocopy date
444: ) is
445: --
446: l_rec ben_esw_shd.g_rec_type;
447: l_proc varchar2(72) := g_package||'del';
448: --
449: Begin
450: hr_utility.set_location('Entering:'||l_proc, 5);