APPS.BEN_PEN_BUS dependencies on DT_API

Line 3705: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then

3701: p_argument_value => p_datetrack_mode);
3702: --
3703: -- Only perform the validation if the datetrack update mode is valid
3704: --
3705: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
3706: --
3707: --
3708: -- Ensure the arguments are not null
3709: --

Line 3721: NOT (dt_api.check_min_max_dates

3717: p_argument => 'validation_end_date',
3718: p_argument_value => p_validation_end_date);
3719: --
3720: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
3721: NOT (dt_api.check_min_max_dates
3722: (p_base_table_name => 'ben_pgm_f',
3723: p_base_key_column => 'pgm_id',
3724: p_base_key_value => p_pgm_id,
3725: p_from_date => p_validation_start_date,

Line 3731: NOT (dt_api.check_min_max_dates

3727: l_table_name := 'ben_pgm_f';
3728: Raise l_integrity_error;
3729: End If;
3730: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
3731: NOT (dt_api.check_min_max_dates
3732: (p_base_table_name => 'ben_oipl_f',
3733: p_base_key_column => 'oipl_id',
3734: p_base_key_value => p_oipl_id,
3735: p_from_date => p_validation_start_date,

Line 3741: NOT (dt_api.check_min_max_dates

3737: l_table_name := 'ben_oipl_f';
3738: Raise l_integrity_error;
3739: End If;
3740: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
3741: NOT (dt_api.check_min_max_dates
3742: (p_base_table_name => 'ben_pl_f',
3743: p_base_key_column => 'pl_id',
3744: p_base_key_value => p_pl_id,
3745: p_from_date => p_validation_start_date,

Line 3751: NOT (dt_api.check_min_max_dates

3747: l_table_name := 'ben_pl_f';
3748: Raise l_integrity_error;
3749: End If;
3750: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and
3751: NOT (dt_api.check_min_max_dates
3752: (p_base_table_name => 'ben_pl_typ_f',
3753: p_base_key_column => 'pl_typ_id',
3754: p_base_key_value => p_pl_typ_id,
3755: p_from_date => p_validation_start_date,

Line 3761: NOT (dt_api.check_min_max_dates

3757: l_table_name := 'ben_pl_typ_f';
3758: Raise l_integrity_error;
3759: End If;
3760: If ((nvl(p_prtt_enrt_rslt_id, hr_api.g_number) <> hr_api.g_number) and
3761: NOT (dt_api.check_min_max_dates
3762: (p_base_table_name => 'ben_prtt_enrt_rslt_f',
3763: p_base_key_column => 'prtt_enrt_rslt_id',
3764: p_base_key_value => p_prtt_enrt_rslt_id,
3765: p_from_date => p_validation_start_date,

Line 3815: -- generic dt_api.rows_exist function then we must supply an error via

3811: -- Processing continues.
3812: --
3813: -- Post Failure:
3814: -- If a row exists by determining the returning Boolean value from the
3815: -- generic dt_api.rows_exist function then we must supply an error via
3816: -- the use of the local exception handler l_rows_exist.
3817: --
3818: -- Developer Implementation Notes:
3819: -- This procedure should not need maintenance unless the HR Schema model

Line 3871: If (dt_api.rows_exist

3867: (p_api_name => l_proc,
3868: p_argument => 'prtt_enrt_rslt_id',
3869: p_argument_value => p_prtt_enrt_rslt_id);
3870: /*
3871: If (dt_api.rows_exist
3872: (p_base_table_name => 'ben_bnft_prvdd_ldgr_f',
3873: p_base_key_column => 'prtt_enrt_rslt_id',
3874: p_base_key_value => p_prtt_enrt_rslt_id,
3875: p_from_date => p_validation_start_date,

Line 3881: If (dt_api.rows_exist

3877: l_table_name := 'ben_bnft_prvdd_ldgr_f';
3878: Raise l_rows_exist;
3879: End If;
3880: */
3881: If (dt_api.rows_exist
3882: (p_base_table_name => 'ben_pl_bnf_f',
3883: p_base_key_column => 'prtt_enrt_rslt_id',
3884: p_base_key_value => p_prtt_enrt_rslt_id,
3885: p_from_date => p_validation_start_date,

Line 3893: If (dt_api.rows_exist

3889: End If;
3890:
3891: If p_effective_date < p_validation_start_date then
3892: -- Added the above condition for bug 3646239
3893: If (dt_api.rows_exist
3894: (p_base_table_name => 'ben_elig_cvrd_dpnt_f',
3895: p_base_key_column => 'prtt_enrt_rslt_id',
3896: p_base_key_value => p_prtt_enrt_rslt_id,
3897: p_from_date => p_validation_start_date,

Line 3904: If (dt_api.rows_exist

3900: Raise l_rows_exist;
3901: End If;
3902: End If;
3903:
3904: If (dt_api.rows_exist
3905: (p_base_table_name => 'ben_prtt_enrt_actn_f',
3906: p_base_key_column => 'prtt_enrt_rslt_id',
3907: p_base_key_value => p_prtt_enrt_rslt_id,
3908: p_from_date => p_validation_start_date,

Line 3913: If (dt_api.rows_exist

3909: p_to_date => p_validation_end_date)) Then
3910: l_table_name := 'ben_prtt_enrt_actn_f';
3911: Raise l_rows_exist;
3912: End If;
3913: If (dt_api.rows_exist
3914: (p_base_table_name => 'ben_prtt_enrt_ctfn_prvdd_f',
3915: p_base_key_column => 'prtt_enrt_rslt_id',
3916: p_base_key_value => p_prtt_enrt_rslt_id,
3917: p_from_date => p_validation_start_date,

Line 3961: ben_batch_dt_api.batch_validate_bgp_id

3957: hr_utility.set_location('Entering:'||l_proc, 5);
3958: --
3959: -- Call context sensitive validate bgp cache routine
3960: --
3961: ben_batch_dt_api.batch_validate_bgp_id
3962: (p_business_group_id => p_rec.business_group_id
3963: );
3964: --
3965: /*

Line 4095: ben_batch_dt_api.batch_validate_bgp_id

4091: hr_utility.set_location('Entering:'||l_proc, 5);
4092: --
4093: -- Call context sensitive validate bgp cache routine
4094: --
4095: ben_batch_dt_api.batch_validate_bgp_id
4096: (p_business_group_id => p_rec.business_group_id
4097: );
4098: --
4099: /*