APPS.BEN_LER_BUS dependencies on DT_API

Line 178: If (dt_api.rows_exist

174: Begin
175: --
176: hr_utility.set_location('Entering:'||l_proc, 5);
177: --
178: If (dt_api.rows_exist
179: (p_base_table_name => 'ben_lee_rsn_f',
180: p_base_key_column => 'ler_id',
181: p_base_key_value => p_ler_id,
182: p_from_date => p_validation_start_date,

Line 186: If (dt_api.rows_exist

182: p_from_date => p_validation_start_date,
183: p_to_date => p_validation_end_date)) Then
184: l_table_name := 'ben_lee_rsn_f';
185: End If;
186: If (dt_api.rows_exist
187: (p_base_table_name => 'ben_ler_chg_plip_enrt_f',
188: p_base_key_column => 'ler_id',
189: p_base_key_value => p_ler_id,
190: p_from_date => p_validation_start_date,

Line 194: If (dt_api.rows_exist

190: p_from_date => p_validation_start_date,
191: p_to_date => p_validation_end_date)) Then
192: l_table_name := 'ben_ler_chg_plip_enrt_f';
193: End If;
194: If (dt_api.rows_exist
195: (p_base_table_name => 'ben_ler_chg_pl_nip_enrt_f',
196: p_base_key_column => 'ler_id',
197: p_base_key_value => p_ler_id,
198: p_from_date => p_validation_start_date,

Line 202: If (dt_api.rows_exist

198: p_from_date => p_validation_start_date,
199: p_to_date => p_validation_end_date)) Then
200: l_table_name := 'ben_ler_chg_pl_nip_enrt_f';
201: End If;
202: If (dt_api.rows_exist
203: (p_base_table_name => 'ben_ler_chg_oipl_enrt_f',
204: p_base_key_column => 'ler_id',
205: p_base_key_value => p_ler_id,
206: p_from_date => p_validation_start_date,

Line 210: If (dt_api.rows_exist

206: p_from_date => p_validation_start_date,
207: p_to_date => p_validation_end_date)) Then
208: l_table_name := 'ben_ler_chg_oipl_enrt_f';
209: End If;
210: If (dt_api.rows_exist
211: (p_base_table_name => 'ben_elig_to_prte_rsn_f',
212: p_base_key_column => 'ler_id',
213: p_base_key_value => p_ler_id,
214: p_from_date => p_validation_start_date,

Line 218: If (dt_api.rows_exist

214: p_from_date => p_validation_start_date,
215: p_to_date => p_validation_end_date)) Then
216: l_table_name := 'ben_elig_to_prte_rsn_f';
217: End If;
218: If (dt_api.rows_exist
219: (p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',
220: p_base_key_column => 'ler_id',
221: p_base_key_value => p_ler_id,
222: p_from_date => p_validation_start_date,

Line 226: If (dt_api.rows_exist

222: p_from_date => p_validation_start_date,
223: p_to_date => p_validation_end_date)) Then
224: l_table_name := 'ben_ler_chg_dpnt_cvg_f';
225: End If;
226: If (dt_api.rows_exist
227: (p_base_table_name => 'ben_elig_per_f',
228: p_base_key_column => 'ler_id',
229: p_base_key_value => p_ler_id,
230: p_from_date => p_validation_start_date,

Line 234: If (dt_api.rows_exist

230: p_from_date => p_validation_start_date,
231: p_to_date => p_validation_end_date)) Then
232: l_table_name := 'ben_elig_per_f';
233: End If;
234: If (dt_api.rows_exist
235: (p_base_table_name => 'ben_ler_per_info_cs_ler_f',
236: p_base_key_column => 'ler_id',
237: p_base_key_value => p_ler_id,
238: p_from_date => p_validation_start_date,

Line 242: If (dt_api.rows_exist

238: p_from_date => p_validation_start_date,
239: p_to_date => p_validation_end_date)) Then
240: l_table_name := 'ben_ler_per_info_cs_ler_f';
241: End If;
242: If (dt_api.rows_exist
243: (p_base_table_name => 'ben_ler_rltd_per_cs_ler_f',
244: p_base_key_column => 'ler_id',
245: p_base_key_value => p_ler_id,
246: p_from_date => p_validation_start_date,

Line 250: If (dt_api.rows_exist

246: p_from_date => p_validation_start_date,
247: p_to_date => p_validation_end_date)) Then
248: l_table_name := 'ben_ler_rltd_per_cs_ler_f';
249: End If;
250: If (dt_api.rows_exist
251: (p_base_table_name => 'ben_css_rltd_per_per_in_ler_f',
252: p_base_key_column => 'ler_id',
253: p_base_key_value => p_ler_id,
254: p_from_date => p_validation_start_date,

Line 258: If (dt_api.rows_exist

254: p_from_date => p_validation_start_date,
255: p_to_date => p_validation_end_date)) Then
256: l_table_name := 'ben_css_rltd_per_per_in_ler_f';
257: End If;
258: If (dt_api.rows_exist
259: (p_base_table_name => 'ben_css_rltd_per_per_in_ler_f',
260: p_base_key_column => 'rsltg_ler_id',
261: p_base_key_value => p_ler_id,
262: p_from_date => p_validation_start_date,

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

1824: p_argument_value => p_datetrack_mode);
1825: --
1826: -- Only perform the validation if the datetrack update mode is valid
1827: --
1828: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
1829: --
1830: --
1831: -- Ensure the arguments are not null
1832: --

Line 1844: NOT (dt_api.check_min_max_dates

1840: p_argument => 'validation_end_date',
1841: p_argument_value => p_validation_end_date);
1842: --
1843: If ((nvl(p_formula_id, hr_api.g_number) <> hr_api.g_number) and
1844: NOT (dt_api.check_min_max_dates
1845: (p_base_table_name => 'ff_formulas_f',
1846: p_base_key_column => 'formula_id',
1847: p_base_key_value => p_formula_id,
1848: p_from_date => p_validation_start_date,