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_ESW_UPD dependencies on BEN_ESW_SHD

Line 58: (p_rec in out nocopy ben_esw_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_esw_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 117: ben_esw_shd.constraint_error

113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: ben_esw_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --

Line 122: ben_esw_shd.constraint_error

118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
122: ben_esw_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: --
126: Raise;

Line 161: (p_rec in out nocopy ben_esw_shd.g_rec_type

157: --
158: -- {End Of Comments}
159: -- ----------------------------------------------------------------------------
160: Procedure update_dml
161: (p_rec in out nocopy ben_esw_shd.g_rec_type
162: ,p_effective_date in date
163: ,p_datetrack_mode in varchar2
164: ,p_validation_start_date in date
165: ,p_validation_end_date in date

Line 228: (p_rec in out nocopy ben_esw_shd.g_rec_type

224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure dt_pre_update
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 244: ben_esw_shd.upd_effective_end_date

240: If (p_datetrack_mode <> hr_api.g_correction) then
241: --
242: -- Update the current effective end date
243: --
244: ben_esw_shd.upd_effective_end_date
245: (p_effective_date => p_effective_date
246: ,p_base_key_value => p_rec.elig_scre_wtg_id
247: ,p_new_effective_end_date => (p_validation_start_date - 1)
248: ,p_validation_start_date => p_validation_start_date

Line 313: (p_rec in out nocopy ben_esw_shd.g_rec_type

309: --
310: -- {End Of Comments}
311: -- ----------------------------------------------------------------------------
312: Procedure pre_update
313: (p_rec in out nocopy ben_esw_shd.g_rec_type
314: ,p_effective_date in date
315: ,p_datetrack_mode in varchar2
316: ,p_validation_start_date in date
317: ,p_validation_end_date in date

Line 371: (p_rec in ben_esw_shd.g_rec_type

367: --
368: -- {End Of Comments}
369: -- ----------------------------------------------------------------------------
370: Procedure post_update
371: (p_rec in ben_esw_shd.g_rec_type
372: ,p_effective_date in date
373: ,p_datetrack_mode in varchar2
374: ,p_validation_start_date in date
375: ,p_validation_end_date in date

Line 420: => ben_esw_shd.g_old_rec.elig_per_id

416: => p_rec.computed_score
417: ,p_benefit_action_id
418: => p_rec.benefit_action_id
419: ,p_elig_per_id_o
420: => ben_esw_shd.g_old_rec.elig_per_id
421: ,p_elig_per_opt_id_o
422: => ben_esw_shd.g_old_rec.elig_per_opt_id
423: ,p_elig_rslt_id_o
424: => ben_esw_shd.g_old_rec.elig_rslt_id

Line 422: => ben_esw_shd.g_old_rec.elig_per_opt_id

418: => p_rec.benefit_action_id
419: ,p_elig_per_id_o
420: => ben_esw_shd.g_old_rec.elig_per_id
421: ,p_elig_per_opt_id_o
422: => ben_esw_shd.g_old_rec.elig_per_opt_id
423: ,p_elig_rslt_id_o
424: => ben_esw_shd.g_old_rec.elig_rslt_id
425: ,p_per_in_ler_id_o
426: => ben_esw_shd.g_old_rec.per_in_ler_id

Line 424: => ben_esw_shd.g_old_rec.elig_rslt_id

420: => ben_esw_shd.g_old_rec.elig_per_id
421: ,p_elig_per_opt_id_o
422: => ben_esw_shd.g_old_rec.elig_per_opt_id
423: ,p_elig_rslt_id_o
424: => ben_esw_shd.g_old_rec.elig_rslt_id
425: ,p_per_in_ler_id_o
426: => ben_esw_shd.g_old_rec.per_in_ler_id
427: ,p_effective_start_date_o
428: => ben_esw_shd.g_old_rec.effective_start_date

Line 426: => ben_esw_shd.g_old_rec.per_in_ler_id

422: => ben_esw_shd.g_old_rec.elig_per_opt_id
423: ,p_elig_rslt_id_o
424: => ben_esw_shd.g_old_rec.elig_rslt_id
425: ,p_per_in_ler_id_o
426: => ben_esw_shd.g_old_rec.per_in_ler_id
427: ,p_effective_start_date_o
428: => ben_esw_shd.g_old_rec.effective_start_date
429: ,p_effective_end_date_o
430: => ben_esw_shd.g_old_rec.effective_end_date

Line 428: => ben_esw_shd.g_old_rec.effective_start_date

424: => ben_esw_shd.g_old_rec.elig_rslt_id
425: ,p_per_in_ler_id_o
426: => ben_esw_shd.g_old_rec.per_in_ler_id
427: ,p_effective_start_date_o
428: => ben_esw_shd.g_old_rec.effective_start_date
429: ,p_effective_end_date_o
430: => ben_esw_shd.g_old_rec.effective_end_date
431: ,p_object_version_number_o
432: => ben_esw_shd.g_old_rec.object_version_number

Line 430: => ben_esw_shd.g_old_rec.effective_end_date

426: => ben_esw_shd.g_old_rec.per_in_ler_id
427: ,p_effective_start_date_o
428: => ben_esw_shd.g_old_rec.effective_start_date
429: ,p_effective_end_date_o
430: => ben_esw_shd.g_old_rec.effective_end_date
431: ,p_object_version_number_o
432: => ben_esw_shd.g_old_rec.object_version_number
433: ,p_eligy_prfl_id_o
434: => ben_esw_shd.g_old_rec.eligy_prfl_id

Line 432: => ben_esw_shd.g_old_rec.object_version_number

428: => ben_esw_shd.g_old_rec.effective_start_date
429: ,p_effective_end_date_o
430: => ben_esw_shd.g_old_rec.effective_end_date
431: ,p_object_version_number_o
432: => ben_esw_shd.g_old_rec.object_version_number
433: ,p_eligy_prfl_id_o
434: => ben_esw_shd.g_old_rec.eligy_prfl_id
435: ,p_crit_tab_short_name_o
436: => ben_esw_shd.g_old_rec.crit_tab_short_name

Line 434: => ben_esw_shd.g_old_rec.eligy_prfl_id

430: => ben_esw_shd.g_old_rec.effective_end_date
431: ,p_object_version_number_o
432: => ben_esw_shd.g_old_rec.object_version_number
433: ,p_eligy_prfl_id_o
434: => ben_esw_shd.g_old_rec.eligy_prfl_id
435: ,p_crit_tab_short_name_o
436: => ben_esw_shd.g_old_rec.crit_tab_short_name
437: ,p_crit_tab_pk_id_o
438: => ben_esw_shd.g_old_rec.crit_tab_pk_id

Line 436: => ben_esw_shd.g_old_rec.crit_tab_short_name

432: => ben_esw_shd.g_old_rec.object_version_number
433: ,p_eligy_prfl_id_o
434: => ben_esw_shd.g_old_rec.eligy_prfl_id
435: ,p_crit_tab_short_name_o
436: => ben_esw_shd.g_old_rec.crit_tab_short_name
437: ,p_crit_tab_pk_id_o
438: => ben_esw_shd.g_old_rec.crit_tab_pk_id
439: ,p_computed_score_o
440: => ben_esw_shd.g_old_rec.computed_score

Line 438: => ben_esw_shd.g_old_rec.crit_tab_pk_id

434: => ben_esw_shd.g_old_rec.eligy_prfl_id
435: ,p_crit_tab_short_name_o
436: => ben_esw_shd.g_old_rec.crit_tab_short_name
437: ,p_crit_tab_pk_id_o
438: => ben_esw_shd.g_old_rec.crit_tab_pk_id
439: ,p_computed_score_o
440: => ben_esw_shd.g_old_rec.computed_score
441: ,p_benefit_action_id_o
442: => ben_esw_shd.g_old_rec.benefit_action_id

Line 440: => ben_esw_shd.g_old_rec.computed_score

436: => ben_esw_shd.g_old_rec.crit_tab_short_name
437: ,p_crit_tab_pk_id_o
438: => ben_esw_shd.g_old_rec.crit_tab_pk_id
439: ,p_computed_score_o
440: => ben_esw_shd.g_old_rec.computed_score
441: ,p_benefit_action_id_o
442: => ben_esw_shd.g_old_rec.benefit_action_id
443: );
444: --

Line 442: => ben_esw_shd.g_old_rec.benefit_action_id

438: => ben_esw_shd.g_old_rec.crit_tab_pk_id
439: ,p_computed_score_o
440: => ben_esw_shd.g_old_rec.computed_score
441: ,p_benefit_action_id_o
442: => ben_esw_shd.g_old_rec.benefit_action_id
443: );
444: --
445: exception
446: --

Line 502: (p_rec in out nocopy ben_esw_shd.g_rec_type

498: --
499: -- {End Of Comments}
500: -- ----------------------------------------------------------------------------
501: Procedure convert_defs
502: (p_rec in out nocopy ben_esw_shd.g_rec_type
503: ) is
504: --
505: Begin
506: --

Line 514: ben_esw_shd.g_old_rec.elig_per_id;

510: -- is being used then we must set to the 'current' argument value.
511: --
512: If (p_rec.elig_per_id = hr_api.g_number) then
513: p_rec.elig_per_id :=
514: ben_esw_shd.g_old_rec.elig_per_id;
515: End If;
516: If (p_rec.elig_per_opt_id = hr_api.g_number) then
517: p_rec.elig_per_opt_id :=
518: ben_esw_shd.g_old_rec.elig_per_opt_id;

Line 518: ben_esw_shd.g_old_rec.elig_per_opt_id;

514: ben_esw_shd.g_old_rec.elig_per_id;
515: End If;
516: If (p_rec.elig_per_opt_id = hr_api.g_number) then
517: p_rec.elig_per_opt_id :=
518: ben_esw_shd.g_old_rec.elig_per_opt_id;
519: End If;
520: If (p_rec.elig_rslt_id = hr_api.g_number) then
521: p_rec.elig_rslt_id :=
522: ben_esw_shd.g_old_rec.elig_rslt_id;

Line 522: ben_esw_shd.g_old_rec.elig_rslt_id;

518: ben_esw_shd.g_old_rec.elig_per_opt_id;
519: End If;
520: If (p_rec.elig_rslt_id = hr_api.g_number) then
521: p_rec.elig_rslt_id :=
522: ben_esw_shd.g_old_rec.elig_rslt_id;
523: End If;
524: If (p_rec.per_in_ler_id = hr_api.g_number) then
525: p_rec.per_in_ler_id :=
526: ben_esw_shd.g_old_rec.per_in_ler_id;

Line 526: ben_esw_shd.g_old_rec.per_in_ler_id;

522: ben_esw_shd.g_old_rec.elig_rslt_id;
523: End If;
524: If (p_rec.per_in_ler_id = hr_api.g_number) then
525: p_rec.per_in_ler_id :=
526: ben_esw_shd.g_old_rec.per_in_ler_id;
527: End If;
528: If (p_rec.eligy_prfl_id = hr_api.g_number) then
529: p_rec.eligy_prfl_id :=
530: ben_esw_shd.g_old_rec.eligy_prfl_id;

Line 530: ben_esw_shd.g_old_rec.eligy_prfl_id;

526: ben_esw_shd.g_old_rec.per_in_ler_id;
527: End If;
528: If (p_rec.eligy_prfl_id = hr_api.g_number) then
529: p_rec.eligy_prfl_id :=
530: ben_esw_shd.g_old_rec.eligy_prfl_id;
531: End If;
532: If (p_rec.crit_tab_short_name = hr_api.g_varchar2) then
533: p_rec.crit_tab_short_name :=
534: ben_esw_shd.g_old_rec.crit_tab_short_name;

Line 534: ben_esw_shd.g_old_rec.crit_tab_short_name;

530: ben_esw_shd.g_old_rec.eligy_prfl_id;
531: End If;
532: If (p_rec.crit_tab_short_name = hr_api.g_varchar2) then
533: p_rec.crit_tab_short_name :=
534: ben_esw_shd.g_old_rec.crit_tab_short_name;
535: End If;
536: If (p_rec.crit_tab_pk_id = hr_api.g_number) then
537: p_rec.crit_tab_pk_id :=
538: ben_esw_shd.g_old_rec.crit_tab_pk_id;

Line 538: ben_esw_shd.g_old_rec.crit_tab_pk_id;

534: ben_esw_shd.g_old_rec.crit_tab_short_name;
535: End If;
536: If (p_rec.crit_tab_pk_id = hr_api.g_number) then
537: p_rec.crit_tab_pk_id :=
538: ben_esw_shd.g_old_rec.crit_tab_pk_id;
539: End If;
540: If (p_rec.computed_score = hr_api.g_number) then
541: p_rec.computed_score :=
542: ben_esw_shd.g_old_rec.computed_score;

Line 542: ben_esw_shd.g_old_rec.computed_score;

538: ben_esw_shd.g_old_rec.crit_tab_pk_id;
539: End If;
540: If (p_rec.computed_score = hr_api.g_number) then
541: p_rec.computed_score :=
542: ben_esw_shd.g_old_rec.computed_score;
543: End If;
544: If (p_rec.benefit_action_id = hr_api.g_number) then
545: p_rec.benefit_action_id :=
546: ben_esw_shd.g_old_rec.benefit_action_id;

Line 546: ben_esw_shd.g_old_rec.benefit_action_id;

542: ben_esw_shd.g_old_rec.computed_score;
543: End If;
544: If (p_rec.benefit_action_id = hr_api.g_number) then
545: p_rec.benefit_action_id :=
546: ben_esw_shd.g_old_rec.benefit_action_id;
547: End If;
548: --
549: End convert_defs;
550: --

Line 557: ,p_rec in out nocopy ben_esw_shd.g_rec_type

553: -- ----------------------------------------------------------------------------
554: Procedure upd
555: (p_effective_date in date
556: ,p_datetrack_mode in varchar2
557: ,p_rec in out nocopy ben_esw_shd.g_rec_type
558: ) is
559: --
560: l_proc varchar2(72) := g_package||'upd';
561: l_validation_start_date date;

Line 573: ben_esw_shd.lck

569: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
570: --
571: -- We must lock the row which we need to update.
572: --
573: ben_esw_shd.lck
574: (p_effective_date => p_effective_date
575: ,p_datetrack_mode => p_datetrack_mode
576: ,p_elig_scre_wtg_id => p_rec.elig_scre_wtg_id
577: ,p_object_version_number => p_rec.object_version_number

Line 656: l_rec ben_esw_shd.g_rec_type;

652: ,p_effective_start_date out nocopy date
653: ,p_effective_end_date out nocopy date
654: ) is
655: --
656: l_rec ben_esw_shd.g_rec_type;
657: l_proc varchar2(72) := g_package||'upd';
658: --
659: Begin
660: hr_utility.set_location('Entering:'||l_proc, 5);

Line 666: ben_esw_shd.convert_args

662: -- Call conversion function to turn arguments into the
663: -- l_rec structure.
664: --
665: l_rec :=
666: ben_esw_shd.convert_args
667: (p_elig_scre_wtg_id
668: ,p_elig_per_id
669: ,p_elig_per_opt_id
670: ,p_elig_rslt_id