APPS.BEN_PEN_BUS dependencies on DT_API

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

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

Line 3722: NOT (dt_api.check_min_max_dates

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

Line 3732: NOT (dt_api.check_min_max_dates

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

Line 3742: NOT (dt_api.check_min_max_dates

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

Line 3752: NOT (dt_api.check_min_max_dates

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

Line 3762: NOT (dt_api.check_min_max_dates

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

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

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

Line 3872: If (dt_api.rows_exist

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

Line 3882: If (dt_api.rows_exist

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

Line 3894: If (dt_api.rows_exist

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

Line 3905: If (dt_api.rows_exist

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

Line 3914: If (dt_api.rows_exist

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

Line 3962: ben_batch_dt_api.batch_validate_bgp_id

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

Line 4096: ben_batch_dt_api.batch_validate_bgp_id

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