APPS.BEN_CCM_BUS dependencies on DT_API

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

2048: p_argument_value => p_datetrack_mode);
2049: --
2050: -- Only perform the validation if the datetrack update mode is valid
2051: --
2052: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
2053: --
2054: --
2055: -- Ensure the arguments are not null
2056: --

Line 2068: NOT (dt_api.check_min_max_dates

2064: p_argument => 'validation_end_date',
2065: p_argument_value => p_validation_end_date);
2066: --
2067: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
2068: NOT (dt_api.check_min_max_dates
2069: (p_base_table_name => 'ben_oipl_f',
2070: p_base_key_column => 'oipl_id',
2071: p_base_key_value => p_oipl_id,
2072: p_from_date => p_validation_start_date,

Line 2078: NOT (dt_api.check_min_max_dates

2074: l_table_name := 'ben_oipl_f';
2075: Raise l_integrity_error;
2076: End If;
2077: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
2078: NOT (dt_api.check_min_max_dates
2079: (p_base_table_name => 'ben_pl_f',
2080: p_base_key_column => 'pl_id',
2081: p_base_key_value => p_pl_id,
2082: p_from_date => p_validation_start_date,

Line 2088: NOT (dt_api.check_min_max_dates

2084: l_table_name := 'ben_pl_f';
2085: Raise l_integrity_error;
2086: End If;
2087: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
2088: NOT (dt_api.check_min_max_dates
2089: (p_base_table_name => 'ben_plip_f',
2090: p_base_key_column => 'plip_id',
2091: p_base_key_value => p_plip_id,
2092: p_from_date => p_validation_start_date,

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

2139: -- Processing continues.
2140: --
2141: -- Post Failure:
2142: -- If a row exists by determining the returning Boolean value from the
2143: -- generic dt_api.rows_exist function then we must supply an error via
2144: -- the use of the local exception handler l_rows_exist.
2145: --
2146: -- Developer Implementation Notes:
2147: -- This procedure should not need maintenance unless the HR Schema model

Line 2199: If (dt_api.rows_exist

2195: (p_api_name => l_proc,
2196: p_argument => 'cvg_amt_calc_mthd_id',
2197: p_argument_value => p_cvg_amt_calc_mthd_id);
2198: --
2199: If (dt_api.rows_exist
2200: (p_base_table_name => 'ben_bnft_vrbl_rt_f',
2201: p_base_key_column => 'cvg_amt_calc_mthd_id',
2202: p_base_key_value => p_cvg_amt_calc_mthd_id,
2203: p_from_date => p_validation_start_date,

Line 2208: If (dt_api.rows_exist

2204: p_to_date => p_validation_end_date)) Then
2205: l_table_name := 'ben_bnft_vrbl_rt_f';
2206: Raise l_rows_exist;
2207: End If;
2208: If (dt_api.rows_exist
2209: (p_base_table_name => 'ben_bnft_vrbl_rt_rl_f',
2210: p_base_key_column => 'cvg_amt_calc_mthd_id',
2211: p_base_key_value => p_cvg_amt_calc_mthd_id,
2212: p_from_date => p_validation_start_date,

Line 2217: If (dt_api.rows_exist

2213: p_to_date => p_validation_end_date)) Then
2214: l_table_name := 'ben_bnft_vrbl_rt_rl_f';
2215: Raise l_rows_exist;
2216: End If;
2217: If (dt_api.rows_exist
2218: (p_base_table_name => 'ben_bnft_vrbl_rt_rl_f',
2219: p_base_key_column => 'cvg_amt_calc_mthd_id',
2220: p_base_key_value => p_cvg_amt_calc_mthd_id,
2221: p_from_date => p_validation_start_date,

Line 2226: If (dt_api.rows_exist

2222: p_to_date => p_validation_end_date)) Then
2223: l_table_name := 'ben_bnft_vrbl_rt_rl_f';
2224: Raise l_rows_exist;
2225: End If;
2226: If (dt_api.rows_exist
2227: (p_base_table_name => 'ben_bnft_vrbl_rt_rl_f',
2228: p_base_key_column => 'cvg_amt_calc_mthd_id',
2229: p_base_key_value => p_cvg_amt_calc_mthd_id,
2230: p_from_date => p_validation_start_date,