APPS.BEN_ADE_BUS dependencies on DT_API

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

393: p_argument_value => p_datetrack_mode);
394: --
395: -- Only perform the validation if the datetrack update mode is valid
396: --
397: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
398: --
399: --
400: -- Ensure the arguments are not null
401: --

Line 413: NOT (dt_api.check_min_max_dates

409: p_argument => 'validation_end_date',
410: p_argument_value => p_validation_end_date);
411: --
412: If ((nvl(p_apld_dpnt_cvg_elig_rl, hr_api.g_number) <> hr_api.g_number) and
413: NOT (dt_api.check_min_max_dates
414: (p_base_table_name => 'ff_formulas_f',
415: p_base_key_column => 'formula_id',
416: p_base_key_value => p_apld_dpnt_cvg_elig_rl,
417: p_from_date => p_validation_start_date,

Line 423: NOT (dt_api.check_min_max_dates

419: l_table_name := 'ff_formulas_f';
420: Raise l_integrity_error;
421: End If;
422: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
423: NOT (dt_api.check_min_max_dates
424: (p_base_table_name => 'ben_pgm_f',
425: p_base_key_column => 'pgm_id',
426: p_base_key_value => p_pgm_id,
427: p_from_date => p_validation_start_date,

Line 433: NOT (dt_api.check_min_max_dates

429: l_table_name := 'ben_pgm_f';
430: Raise l_integrity_error;
431: End If;
432: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
433: NOT (dt_api.check_min_max_dates
434: (p_base_table_name => 'ben_ptip_f',
435: p_base_key_column => 'ptip_id',
436: p_base_key_value => p_ptip_id,
437: p_from_date => p_validation_start_date,

Line 443: NOT (dt_api.check_min_max_dates

439: l_table_name := 'ben_ptip_f';
440: Raise l_integrity_error;
441: End If;
442: If ((nvl(p_dpnt_cvg_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
443: NOT (dt_api.check_min_max_dates
444: (p_base_table_name => 'ben_dpnt_cvg_eligy_prfl_f',
445: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
446: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,
447: p_from_date => p_validation_start_date,

Line 453: NOT (dt_api.check_min_max_dates

449: l_table_name := 'ben_dpnt_cvg_eligy_prfl_f';
450: Raise l_integrity_error;
451: End If;
452: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
453: NOT (dt_api.check_min_max_dates
454: (p_base_table_name => 'ben_pl_f',
455: p_base_key_column => 'pl_id',
456: p_base_key_value => p_pl_id,
457: p_from_date => p_validation_start_date,

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

503: -- Processing continues.
504: --
505: -- Post Failure:
506: -- If a row exists by determining the returning Boolean value from the
507: -- generic dt_api.rows_exist function then we must supply an error via
508: -- the use of the local exception handler l_rows_exist.
509: --
510: -- Developer Implementation Notes:
511: -- This procedure should not need maintenance unless the HR Schema model