DBA Data[Home] [Help]

APPS.BEN_PON_BUS dependencies on DT_API

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

256: p_argument_value => p_datetrack_mode);
257: --
258: -- Only perform the validation if the datetrack update mode is valid
259: --
260: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
261: --
262: --
263: -- Ensure the arguments are not null
264: --

Line 276: NOT (dt_api.check_min_max_dates

272: p_argument => 'validation_end_date',
273: p_argument_value => p_validation_end_date);
274: --
275: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
276: NOT (dt_api.check_min_max_dates
277: (p_base_table_name => 'ben_opt_f',
278: p_base_key_column => 'opt_id',
279: p_base_key_value => p_opt_id,
280: p_from_date => p_validation_start_date,

Line 286: NOT (dt_api.check_min_max_dates

282: l_table_name := 'ben_opt_f';
283: Raise l_integrity_error;
284: End If;
285: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and
286: NOT (dt_api.check_min_max_dates
287: (p_base_table_name => 'ben_pl_typ_f',
288: p_base_key_column => 'pl_typ_id',
289: p_base_key_value => p_pl_typ_id,
290: p_from_date => p_validation_start_date,

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

337: -- Processing continues.
338: --
339: -- Post Failure:
340: -- If a row exists by determining the returning Boolean value from the
341: -- generic dt_api.rows_exist function then we must supply an error via
342: -- the use of the local exception handler l_rows_exist.
343: --
344: -- Developer Implementation Notes:
345: -- This procedure should not need maintenance unless the HR Schema model

Line 397: If (dt_api.rows_exist

393: (p_api_name => l_proc,
394: p_argument => 'pl_typ_opt_typ_id',
395: p_argument_value => p_pl_typ_opt_typ_id);
396: --
397: If (dt_api.rows_exist
398: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
399: p_base_key_column => 'pl_typ_opt_typ_id',
400: p_base_key_value => p_pl_typ_opt_typ_id,
401: p_from_date => p_validation_start_date,

Line 407: If (dt_api.rows_exist -- Included for Bug 1880631, check if ELPRO is using this Plan Type in option

403: l_table_name := 'ben_vrbl_rt_prfl_f';
404: Raise l_rows_exist;
405: End If;
406: --
407: If (dt_api.rows_exist -- Included for Bug 1880631, check if ELPRO is using this Plan Type in option
408: (p_base_table_name => 'ben_elig_hlth_cvg_prte_f',
409: p_base_key_column => 'pl_typ_opt_typ_id',
410: p_base_key_value => p_pl_typ_opt_typ_id,
411: p_from_date => p_validation_start_date,