DBA Data[Home] [Help]

APPS.BEN_CQR_BUS dependencies on DT_API

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

522: p_argument_value => p_datetrack_mode);
523: --
524: -- Only perform the validation if the datetrack update mode is valid
525: --
526: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
527: --
528: --
529: -- Ensure the arguments are not null
530: --

Line 542: NOT (dt_api.check_min_max_dates

538: p_argument => 'validation_end_date',
539: p_argument_value => p_validation_end_date);
540: --
541: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
542: NOT (dt_api.check_min_max_dates
543: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
544: p_base_key_column => 'vrbl_rt_prfl_id',
545: p_base_key_value => p_vrbl_rt_prfl_id,
546: p_from_date => p_validation_start_date,

Line 552: NOT (dt_api.check_min_max_dates

548: l_table_name := 'ben_vrbl_rt_prfl_f';
549: Raise l_integrity_error;
550: End If;
551: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
552: NOT (dt_api.check_min_max_dates
553: (p_base_table_name => 'ben_pgm_f',
554: p_base_key_column => 'pgm_id',
555: p_base_key_value => p_pgm_id,
556: p_from_date => p_validation_start_date,

Line 562: NOT (dt_api.check_min_max_dates

558: l_table_name := 'ben_pgm_f';
559: Raise l_integrity_error;
560: End If;
561: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
562: NOT (dt_api.check_min_max_dates
563: (p_base_table_name => 'ben_ptip_f',
564: p_base_key_column => 'ptip_id',
565: p_base_key_value => p_ptip_id,
566: p_from_date => p_validation_start_date,

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

613: -- Processing continues.
614: --
615: -- Post Failure:
616: -- If a row exists by determining the returning Boolean value from the
617: -- generic dt_api.rows_exist function then we must supply an error via
618: -- the use of the local exception handler l_rows_exist.
619: --
620: -- Developer Implementation Notes:
621: -- This procedure should not need maintenance unless the HR Schema model