eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_BEC_UPD dependencies on HR_API

Line 95: When hr_api.check_integrity_violated Then

91: --
92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: --
94: Exception
95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
98: ben_bec_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

95: When hr_api.check_integrity_violated Then
96: -- A check constraint has been violated
97: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
98: ben_bec_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
103: ben_bec_shd.constraint_error

Line 100: When hr_api.parent_integrity_violated Then

96: -- A check constraint has been violated
97: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
98: ben_bec_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
103: ben_bec_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

100: When hr_api.parent_integrity_violated Then
101: -- Parent integrity has been violated
102: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
103: ben_bec_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
108: ben_bec_shd.constraint_error

Line 105: When hr_api.unique_integrity_violated Then

101: -- Parent integrity has been violated
102: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
103: ben_bec_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
108: ben_bec_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

105: When hr_api.unique_integrity_violated Then
106: -- Unique integrity has been violated
107: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
108: ben_bec_shd.constraint_error
109: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
110: When Others Then
111: ben_bec_shd.g_api_dml := false; -- Unset the api dml status
112: Raise;
113: End update_dml;

Line 240: when hr_api.cannot_find_prog_unit then

236: ,p_object_version_number_o =>ben_bec_shd.g_old_rec.object_version_number);
237: --
238: exception
239: --
240: when hr_api.cannot_find_prog_unit then
241: --
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'ben_batch_elctbl_chc_info'
244: ,p_hook_type => 'AU');

Line 242: hr_api.cannot_find_prog_unit_error

238: exception
239: --
240: when hr_api.cannot_find_prog_unit then
241: --
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'ben_batch_elctbl_chc_info'
244: ,p_hook_type => 'AU');
245: --
246: end;

Line 309: If (p_rec.benefit_action_id = hr_api.g_number) then

305: -- p_rec plsql record structure
306: -- to see if a system default is being used. If a system default
307: -- is being used then we must set to the 'current' argument value.
308: --
309: If (p_rec.benefit_action_id = hr_api.g_number) then
310: p_rec.benefit_action_id :=
311: ben_bec_shd.g_old_rec.benefit_action_id;
312: End If;
313: If (p_rec.person_id = hr_api.g_number) then

Line 313: If (p_rec.person_id = hr_api.g_number) then

309: If (p_rec.benefit_action_id = hr_api.g_number) then
310: p_rec.benefit_action_id :=
311: ben_bec_shd.g_old_rec.benefit_action_id;
312: End If;
313: If (p_rec.person_id = hr_api.g_number) then
314: p_rec.person_id :=
315: ben_bec_shd.g_old_rec.person_id;
316: End If;
317: If (p_rec.pgm_id = hr_api.g_number) then

Line 317: If (p_rec.pgm_id = hr_api.g_number) then

313: If (p_rec.person_id = hr_api.g_number) then
314: p_rec.person_id :=
315: ben_bec_shd.g_old_rec.person_id;
316: End If;
317: If (p_rec.pgm_id = hr_api.g_number) then
318: p_rec.pgm_id :=
319: ben_bec_shd.g_old_rec.pgm_id;
320: End If;
321: If (p_rec.pl_id = hr_api.g_number) then

Line 321: If (p_rec.pl_id = hr_api.g_number) then

317: If (p_rec.pgm_id = hr_api.g_number) then
318: p_rec.pgm_id :=
319: ben_bec_shd.g_old_rec.pgm_id;
320: End If;
321: If (p_rec.pl_id = hr_api.g_number) then
322: p_rec.pl_id :=
323: ben_bec_shd.g_old_rec.pl_id;
324: End If;
325: If (p_rec.oipl_id = hr_api.g_number) then

Line 325: If (p_rec.oipl_id = hr_api.g_number) then

321: If (p_rec.pl_id = hr_api.g_number) then
322: p_rec.pl_id :=
323: ben_bec_shd.g_old_rec.pl_id;
324: End If;
325: If (p_rec.oipl_id = hr_api.g_number) then
326: p_rec.oipl_id :=
327: ben_bec_shd.g_old_rec.oipl_id;
328: End If;
329: If (p_rec.enrt_cvg_strt_dt = hr_api.g_date) then

Line 329: If (p_rec.enrt_cvg_strt_dt = hr_api.g_date) then

325: If (p_rec.oipl_id = hr_api.g_number) then
326: p_rec.oipl_id :=
327: ben_bec_shd.g_old_rec.oipl_id;
328: End If;
329: If (p_rec.enrt_cvg_strt_dt = hr_api.g_date) then
330: p_rec.enrt_cvg_strt_dt :=
331: ben_bec_shd.g_old_rec.enrt_cvg_strt_dt;
332: End If;
333: If (p_rec.enrt_perd_strt_dt = hr_api.g_date) then

Line 333: If (p_rec.enrt_perd_strt_dt = hr_api.g_date) then

329: If (p_rec.enrt_cvg_strt_dt = hr_api.g_date) then
330: p_rec.enrt_cvg_strt_dt :=
331: ben_bec_shd.g_old_rec.enrt_cvg_strt_dt;
332: End If;
333: If (p_rec.enrt_perd_strt_dt = hr_api.g_date) then
334: p_rec.enrt_perd_strt_dt :=
335: ben_bec_shd.g_old_rec.enrt_perd_strt_dt;
336: End If;
337: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then

Line 337: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then

333: If (p_rec.enrt_perd_strt_dt = hr_api.g_date) then
334: p_rec.enrt_perd_strt_dt :=
335: ben_bec_shd.g_old_rec.enrt_perd_strt_dt;
336: End If;
337: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then
338: p_rec.enrt_perd_end_dt :=
339: ben_bec_shd.g_old_rec.enrt_perd_end_dt;
340: End If;
341: If (p_rec.erlst_deenrt_dt = hr_api.g_date) then

Line 341: If (p_rec.erlst_deenrt_dt = hr_api.g_date) then

337: If (p_rec.enrt_perd_end_dt = hr_api.g_date) then
338: p_rec.enrt_perd_end_dt :=
339: ben_bec_shd.g_old_rec.enrt_perd_end_dt;
340: End If;
341: If (p_rec.erlst_deenrt_dt = hr_api.g_date) then
342: p_rec.erlst_deenrt_dt :=
343: ben_bec_shd.g_old_rec.erlst_deenrt_dt;
344: End If;
345: If (p_rec.dflt_enrt_dt = hr_api.g_date) then

Line 345: If (p_rec.dflt_enrt_dt = hr_api.g_date) then

341: If (p_rec.erlst_deenrt_dt = hr_api.g_date) then
342: p_rec.erlst_deenrt_dt :=
343: ben_bec_shd.g_old_rec.erlst_deenrt_dt;
344: End If;
345: If (p_rec.dflt_enrt_dt = hr_api.g_date) then
346: p_rec.dflt_enrt_dt :=
347: ben_bec_shd.g_old_rec.dflt_enrt_dt;
348: End If;
349: If (p_rec.enrt_typ_cycl_cd = hr_api.g_varchar2) then

Line 349: If (p_rec.enrt_typ_cycl_cd = hr_api.g_varchar2) then

345: If (p_rec.dflt_enrt_dt = hr_api.g_date) then
346: p_rec.dflt_enrt_dt :=
347: ben_bec_shd.g_old_rec.dflt_enrt_dt;
348: End If;
349: If (p_rec.enrt_typ_cycl_cd = hr_api.g_varchar2) then
350: p_rec.enrt_typ_cycl_cd :=
351: ben_bec_shd.g_old_rec.enrt_typ_cycl_cd;
352: End If;
353: If (p_rec.comp_lvl_cd = hr_api.g_varchar2) then

Line 353: If (p_rec.comp_lvl_cd = hr_api.g_varchar2) then

349: If (p_rec.enrt_typ_cycl_cd = hr_api.g_varchar2) then
350: p_rec.enrt_typ_cycl_cd :=
351: ben_bec_shd.g_old_rec.enrt_typ_cycl_cd;
352: End If;
353: If (p_rec.comp_lvl_cd = hr_api.g_varchar2) then
354: p_rec.comp_lvl_cd :=
355: ben_bec_shd.g_old_rec.comp_lvl_cd;
356: End If;
357: If (p_rec.mndtry_flag = hr_api.g_varchar2) then

Line 357: If (p_rec.mndtry_flag = hr_api.g_varchar2) then

353: If (p_rec.comp_lvl_cd = hr_api.g_varchar2) then
354: p_rec.comp_lvl_cd :=
355: ben_bec_shd.g_old_rec.comp_lvl_cd;
356: End If;
357: If (p_rec.mndtry_flag = hr_api.g_varchar2) then
358: p_rec.mndtry_flag :=
359: ben_bec_shd.g_old_rec.mndtry_flag;
360: End If;
361: If (p_rec.dflt_flag = hr_api.g_varchar2) then

Line 361: If (p_rec.dflt_flag = hr_api.g_varchar2) then

357: If (p_rec.mndtry_flag = hr_api.g_varchar2) then
358: p_rec.mndtry_flag :=
359: ben_bec_shd.g_old_rec.mndtry_flag;
360: End If;
361: If (p_rec.dflt_flag = hr_api.g_varchar2) then
362: p_rec.dflt_flag :=
363: ben_bec_shd.g_old_rec.dflt_flag;
364: End If;
365: If (p_rec.business_group_id = hr_api.g_number) then

Line 365: If (p_rec.business_group_id = hr_api.g_number) then

361: If (p_rec.dflt_flag = hr_api.g_varchar2) then
362: p_rec.dflt_flag :=
363: ben_bec_shd.g_old_rec.dflt_flag;
364: End If;
365: If (p_rec.business_group_id = hr_api.g_number) then
366: p_rec.business_group_id :=
367: ben_bec_shd.g_old_rec.business_group_id;
368: End If;
369: --

Line 426: p_benefit_action_id in number default hr_api.g_number,

422: Procedure upd
423: (
424: p_effective_date in date,
425: p_batch_elctbl_id in number,
426: p_benefit_action_id in number default hr_api.g_number,
427: p_person_id in number default hr_api.g_number,
428: p_pgm_id in number default hr_api.g_number,
429: p_pl_id in number default hr_api.g_number,
430: p_oipl_id in number default hr_api.g_number,

Line 427: p_person_id in number default hr_api.g_number,

423: (
424: p_effective_date in date,
425: p_batch_elctbl_id in number,
426: p_benefit_action_id in number default hr_api.g_number,
427: p_person_id in number default hr_api.g_number,
428: p_pgm_id in number default hr_api.g_number,
429: p_pl_id in number default hr_api.g_number,
430: p_oipl_id in number default hr_api.g_number,
431: p_enrt_cvg_strt_dt in date default hr_api.g_date,

Line 428: p_pgm_id in number default hr_api.g_number,

424: p_effective_date in date,
425: p_batch_elctbl_id in number,
426: p_benefit_action_id in number default hr_api.g_number,
427: p_person_id in number default hr_api.g_number,
428: p_pgm_id in number default hr_api.g_number,
429: p_pl_id in number default hr_api.g_number,
430: p_oipl_id in number default hr_api.g_number,
431: p_enrt_cvg_strt_dt in date default hr_api.g_date,
432: p_enrt_perd_strt_dt in date default hr_api.g_date,

Line 429: p_pl_id in number default hr_api.g_number,

425: p_batch_elctbl_id in number,
426: p_benefit_action_id in number default hr_api.g_number,
427: p_person_id in number default hr_api.g_number,
428: p_pgm_id in number default hr_api.g_number,
429: p_pl_id in number default hr_api.g_number,
430: p_oipl_id in number default hr_api.g_number,
431: p_enrt_cvg_strt_dt in date default hr_api.g_date,
432: p_enrt_perd_strt_dt in date default hr_api.g_date,
433: p_enrt_perd_end_dt in date default hr_api.g_date,

Line 430: p_oipl_id in number default hr_api.g_number,

426: p_benefit_action_id in number default hr_api.g_number,
427: p_person_id in number default hr_api.g_number,
428: p_pgm_id in number default hr_api.g_number,
429: p_pl_id in number default hr_api.g_number,
430: p_oipl_id in number default hr_api.g_number,
431: p_enrt_cvg_strt_dt in date default hr_api.g_date,
432: p_enrt_perd_strt_dt in date default hr_api.g_date,
433: p_enrt_perd_end_dt in date default hr_api.g_date,
434: p_erlst_deenrt_dt in date default hr_api.g_date,

Line 431: p_enrt_cvg_strt_dt in date default hr_api.g_date,

427: p_person_id in number default hr_api.g_number,
428: p_pgm_id in number default hr_api.g_number,
429: p_pl_id in number default hr_api.g_number,
430: p_oipl_id in number default hr_api.g_number,
431: p_enrt_cvg_strt_dt in date default hr_api.g_date,
432: p_enrt_perd_strt_dt in date default hr_api.g_date,
433: p_enrt_perd_end_dt in date default hr_api.g_date,
434: p_erlst_deenrt_dt in date default hr_api.g_date,
435: p_dflt_enrt_dt in date default hr_api.g_date,

Line 432: p_enrt_perd_strt_dt in date default hr_api.g_date,

428: p_pgm_id in number default hr_api.g_number,
429: p_pl_id in number default hr_api.g_number,
430: p_oipl_id in number default hr_api.g_number,
431: p_enrt_cvg_strt_dt in date default hr_api.g_date,
432: p_enrt_perd_strt_dt in date default hr_api.g_date,
433: p_enrt_perd_end_dt in date default hr_api.g_date,
434: p_erlst_deenrt_dt in date default hr_api.g_date,
435: p_dflt_enrt_dt in date default hr_api.g_date,
436: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,

Line 433: p_enrt_perd_end_dt in date default hr_api.g_date,

429: p_pl_id in number default hr_api.g_number,
430: p_oipl_id in number default hr_api.g_number,
431: p_enrt_cvg_strt_dt in date default hr_api.g_date,
432: p_enrt_perd_strt_dt in date default hr_api.g_date,
433: p_enrt_perd_end_dt in date default hr_api.g_date,
434: p_erlst_deenrt_dt in date default hr_api.g_date,
435: p_dflt_enrt_dt in date default hr_api.g_date,
436: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
437: p_comp_lvl_cd in varchar2 default hr_api.g_varchar2,

Line 434: p_erlst_deenrt_dt in date default hr_api.g_date,

430: p_oipl_id in number default hr_api.g_number,
431: p_enrt_cvg_strt_dt in date default hr_api.g_date,
432: p_enrt_perd_strt_dt in date default hr_api.g_date,
433: p_enrt_perd_end_dt in date default hr_api.g_date,
434: p_erlst_deenrt_dt in date default hr_api.g_date,
435: p_dflt_enrt_dt in date default hr_api.g_date,
436: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
437: p_comp_lvl_cd in varchar2 default hr_api.g_varchar2,
438: p_mndtry_flag in varchar2 default hr_api.g_varchar2,

Line 435: p_dflt_enrt_dt in date default hr_api.g_date,

431: p_enrt_cvg_strt_dt in date default hr_api.g_date,
432: p_enrt_perd_strt_dt in date default hr_api.g_date,
433: p_enrt_perd_end_dt in date default hr_api.g_date,
434: p_erlst_deenrt_dt in date default hr_api.g_date,
435: p_dflt_enrt_dt in date default hr_api.g_date,
436: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
437: p_comp_lvl_cd in varchar2 default hr_api.g_varchar2,
438: p_mndtry_flag in varchar2 default hr_api.g_varchar2,
439: p_dflt_flag in varchar2 default hr_api.g_varchar2,

Line 436: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,

432: p_enrt_perd_strt_dt in date default hr_api.g_date,
433: p_enrt_perd_end_dt in date default hr_api.g_date,
434: p_erlst_deenrt_dt in date default hr_api.g_date,
435: p_dflt_enrt_dt in date default hr_api.g_date,
436: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
437: p_comp_lvl_cd in varchar2 default hr_api.g_varchar2,
438: p_mndtry_flag in varchar2 default hr_api.g_varchar2,
439: p_dflt_flag in varchar2 default hr_api.g_varchar2,
440: p_business_group_id in number default hr_api.g_number,

Line 437: p_comp_lvl_cd in varchar2 default hr_api.g_varchar2,

433: p_enrt_perd_end_dt in date default hr_api.g_date,
434: p_erlst_deenrt_dt in date default hr_api.g_date,
435: p_dflt_enrt_dt in date default hr_api.g_date,
436: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
437: p_comp_lvl_cd in varchar2 default hr_api.g_varchar2,
438: p_mndtry_flag in varchar2 default hr_api.g_varchar2,
439: p_dflt_flag in varchar2 default hr_api.g_varchar2,
440: p_business_group_id in number default hr_api.g_number,
441: p_object_version_number in out nocopy number

Line 438: p_mndtry_flag in varchar2 default hr_api.g_varchar2,

434: p_erlst_deenrt_dt in date default hr_api.g_date,
435: p_dflt_enrt_dt in date default hr_api.g_date,
436: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
437: p_comp_lvl_cd in varchar2 default hr_api.g_varchar2,
438: p_mndtry_flag in varchar2 default hr_api.g_varchar2,
439: p_dflt_flag in varchar2 default hr_api.g_varchar2,
440: p_business_group_id in number default hr_api.g_number,
441: p_object_version_number in out nocopy number
442: ) is

Line 439: p_dflt_flag in varchar2 default hr_api.g_varchar2,

435: p_dflt_enrt_dt in date default hr_api.g_date,
436: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
437: p_comp_lvl_cd in varchar2 default hr_api.g_varchar2,
438: p_mndtry_flag in varchar2 default hr_api.g_varchar2,
439: p_dflt_flag in varchar2 default hr_api.g_varchar2,
440: p_business_group_id in number default hr_api.g_number,
441: p_object_version_number in out nocopy number
442: ) is
443: --

Line 440: p_business_group_id in number default hr_api.g_number,

436: p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2,
437: p_comp_lvl_cd in varchar2 default hr_api.g_varchar2,
438: p_mndtry_flag in varchar2 default hr_api.g_varchar2,
439: p_dflt_flag in varchar2 default hr_api.g_varchar2,
440: p_business_group_id in number default hr_api.g_number,
441: p_object_version_number in out nocopy number
442: ) is
443: --
444: l_rec ben_bec_shd.g_rec_type;