DBA Data[Home] [Help]

APPS.BEN_CBP_BUS dependencies on DT_API

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

126: p_argument_value => p_datetrack_mode);
127: --
128: -- Only perform the validation if the datetrack update mode is valid
129: --
130: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
131: --
132: --
133: -- Ensure the arguments are not null
134: --

Line 146: NOT (dt_api.check_min_max_dates

142: p_argument => 'validation_end_date',
143: p_argument_value => p_validation_end_date);
144: --
145: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
146: NOT (dt_api.check_min_max_dates
147: (p_base_table_name => 'ben_pgm_f',
148: p_base_key_column => 'pgm_id',
149: p_base_key_value => p_pgm_id,
150: p_from_date => p_validation_start_date,

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

198: -- Processing continues.
199: --
200: -- Post Failure:
201: -- If a row exists by determining the returning Boolean value from the
202: -- generic dt_api.rows_exist function then we must supply an error via
203: -- the use of the local exception handler l_rows_exist.
204: --
205: -- Developer Implementation Notes:
206: -- This procedure should not need maintenance unless the HR Schema model

Line 258: If (dt_api.rows_exist

254: (p_api_name => l_proc,
255: p_argument => 'cmbn_ptip_id',
256: p_argument_value => p_cmbn_ptip_id);
257: --
258: If (dt_api.rows_exist
259: (p_base_table_name => 'ben_ptip_f',
260: p_base_key_column => 'cmbn_ptip_id',
261: p_base_key_value => p_cmbn_ptip_id,
262: p_from_date => p_validation_start_date,

Line 267: If (dt_api.rows_exist

263: p_to_date => p_validation_end_date)) Then
264: l_table_name := 'ben_ptip_f';
265: Raise l_rows_exist;
266: End If;
267: If (dt_api.rows_exist
268: (p_base_table_name => 'ben_bnft_prvdr_pool_f',
269: p_base_key_column => 'cmbn_ptip_id',
270: p_base_key_value => p_cmbn_ptip_id,
271: p_from_date => p_validation_start_date,

Line 276: If (dt_api.rows_exist

272: p_to_date => p_validation_end_date)) Then
273: l_table_name := 'ben_bnft_prvdr_pool_f';
274: Raise l_rows_exist;
275: End If;
276: If (dt_api.rows_exist
277: (p_base_table_name => 'ben_acty_base_rt_f',
278: p_base_key_column => 'cmbn_ptip_id',
279: p_base_key_value => p_cmbn_ptip_id,
280: p_from_date => p_validation_start_date,