DBA Data[Home] [Help]

APPS.BEN_CPP_BUS dependencies on DT_API

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

4243: p_argument_value => p_datetrack_mode);
4244: --
4245: -- Only perform the validation if the datetrack update mode is valid
4246: --
4247: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
4248: --
4249: --
4250: -- Ensure the arguments are not null
4251: --

Line 4263: NOT (dt_api.check_min_max_dates

4259: p_argument => 'validation_end_date',
4260: p_argument_value => p_validation_end_date);
4261: --
4262: If ((nvl(p_dflt_enrt_det_rl, hr_api.g_number) <> hr_api.g_number) and
4263: NOT (dt_api.check_min_max_dates
4264: (p_base_table_name => 'ff_formulas_f',
4265: p_base_key_column => 'formula_id',
4266: p_base_key_value => p_dflt_enrt_det_rl,
4267: p_from_date => p_validation_start_date,

Line 4273: NOT (dt_api.check_min_max_dates

4269: l_table_name := 'ff_formulas_f';
4270: Raise l_integrity_error;
4271: End If;
4272: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
4273: NOT (dt_api.check_min_max_dates
4274: (p_base_table_name => 'ben_pl_f',
4275: p_base_key_column => 'pl_id',
4276: p_base_key_value => p_pl_id,
4277: p_from_date => p_validation_start_date,

Line 4283: NOT (dt_api.check_min_max_dates

4279: l_table_name := 'ben_pl_f';
4280: Raise l_integrity_error;
4281: End If;
4282: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
4283: NOT (dt_api.check_min_max_dates
4284: (p_base_table_name => 'ben_pgm_f',
4285: p_base_key_column => 'pgm_id',
4286: p_base_key_value => p_pgm_id,
4287: p_from_date => p_validation_start_date,

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

4333: -- Processing continues.
4334: --
4335: -- Post Failure:
4336: -- If a row exists by determining the returning Boolean value from the
4337: -- generic dt_api.rows_exist function then we must supply an error via
4338: -- the use of the local exception handler l_rows_exist.
4339: --
4340: -- Developer Implementation Notes:
4341: -- This procedure should not need maintenance unless the HR Schema model

Line 4393: If (dt_api.rows_exist

4389: (p_api_name => l_proc,
4390: p_argument => 'plip_id',
4391: p_argument_value => p_plip_id);
4392: --
4393: If (dt_api.rows_exist
4394: (p_base_table_name => 'ben_acty_base_rt_f',
4395: p_base_key_column => 'plip_id',
4396: p_base_key_value => p_plip_id,
4397: p_from_date => p_validation_start_date,

Line 4402: If (dt_api.rows_exist

4398: p_to_date => p_validation_end_date)) Then
4399: l_table_name := 'ben_acty_base_rt_f';
4400: Raise l_rows_exist;
4401: End If;
4402: If (dt_api.rows_exist
4403: (p_base_table_name => 'ben_elig_per_f',
4404: p_base_key_column => 'plip_id',
4405: p_base_key_value => p_plip_id,
4406: p_from_date => p_validation_start_date,