DBA Data[Home] [Help]

APPS.BEN_PCM_BUS dependencies on DT_API

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

228: p_argument_value => p_datetrack_mode);
229: --
230: -- Only perform the validation if the datetrack update mode is valid
231: --
232: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
233: --
234: --
235: -- Ensure the arguments are not null
236: --

Line 248: NOT (dt_api.check_min_max_dates

244: p_argument => 'validation_end_date',
245: p_argument_value => p_validation_end_date);
246: --
247: If ((nvl(p_cm_typ_id, hr_api.g_number) <> hr_api.g_number) and
248: NOT (dt_api.check_min_max_dates
249: (p_base_table_name => 'ben_cm_typ_f',
250: p_base_key_column => 'cm_typ_id',
251: p_base_key_value => p_cm_typ_id,
252: p_from_date => p_validation_start_date,

Line 258: NOT (dt_api.check_min_max_dates

254: l_table_name := 'ben_cm_typ_f';
255: Raise l_integrity_error;
256: End If;
257: If ((nvl(p_prtt_enrt_actn_id, hr_api.g_number) <> hr_api.g_number) and
258: NOT (dt_api.check_min_max_dates
259: (p_base_table_name => 'ben_prtt_enrt_actn_f',
260: p_base_key_column => 'prtt_enrt_actn_id',
261: p_base_key_value => p_prtt_enrt_actn_id,
262: p_from_date => p_validation_start_date,

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

309: -- Processing continues.
310: --
311: -- Post Failure:
312: -- If a row exists by determining the returning Boolean value from the
313: -- generic dt_api.rows_exist function then we must supply an error via
314: -- the use of the local exception handler l_rows_exist.
315: --
316: -- Developer Implementation Notes:
317: -- This procedure should not need maintenance unless the HR Schema model

Line 369: If (dt_api.rows_exist

365: (p_api_name => l_proc,
366: p_argument => 'per_cm_id',
367: p_argument_value => p_per_cm_id);
368: --
369: If (dt_api.rows_exist
370: (p_base_table_name => 'ben_per_cm_prvdd_f',
371: p_base_key_column => 'per_cm_id',
372: p_base_key_value => p_per_cm_id,
373: p_from_date => p_validation_start_date,

Line 378: If (dt_api.rows_exist

374: p_to_date => p_validation_end_date)) Then
375: l_table_name := 'ben_per_cm_prvdd_f';
376: Raise l_rows_exist;
377: End If;
378: If (dt_api.rows_exist
379: (p_base_table_name => 'ben_per_cm_trgr_f',
380: p_base_key_column => 'per_cm_id',
381: p_base_key_value => p_per_cm_id,
382: p_from_date => p_validation_start_date,

Line 387: If (dt_api.rows_exist

383: p_to_date => p_validation_end_date)) Then
384: l_table_name := 'ben_per_cm_trgr_f';
385: Raise l_rows_exist;
386: End If;
387: If (dt_api.rows_exist
388: (p_base_table_name => 'ben_per_cm_usg_f',
389: p_base_key_column => 'per_cm_id',
390: p_base_key_value => p_per_cm_id,
391: p_from_date => p_validation_start_date,