APPS.BEN_RZR_BUS dependencies on DT_API

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

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

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

321: -- Processing continues.
322: --
323: -- Post Failure:
324: -- If a row exists by determining the returning Boolean value from the
325: -- generic dt_api.rows_exist function then we must supply an error via
326: -- the use of the local exception handler l_rows_exist.
327: --
328: -- Developer Implementation Notes:
329: -- This procedure should not need maintenance unless the HR Schema model

Line 382: If (dt_api.rows_exist

378: (p_api_name => l_proc,
379: p_argument => 'pstl_zip_rng_id',
380: p_argument_value => p_pstl_zip_rng_id);
381: --
382: If (dt_api.rows_exist
383: (p_base_table_name => 'ben_elig_pstl_cd_r_rng_prte_f',
384: p_base_key_column => 'pstl_zip_rng_id',
385: p_base_key_value => p_pstl_zip_rng_id,
386: p_from_date => p_validation_start_date,

Line 392: If (dt_api.rows_exist

388: -- l_table_name := 'ben_elig_pstl_cd_r_rng_prte_f';
389: l_child_rec := 'Participant Eligibility Profiles';
390: Raise l_rows_exist;
391: End If;
392: If (dt_api.rows_exist
393: (p_base_table_name => 'ben_elig_pstl_cd_r_rng_cvg_f',
394: p_base_key_column => 'pstl_zip_rng_id',
395: p_base_key_value => p_pstl_zip_rng_id,
396: p_from_date => p_validation_start_date,

Line 402: If (dt_api.rows_exist

398: -- l_table_name := 'ben_elig_pstl_cd_r_rng_cvg_f';
399: l_child_rec := 'Dependent Coverage Eligibility Profiles';
400: Raise l_rows_exist;
401: End If;
402: If (dt_api.rows_exist
403: (p_base_table_name => 'ben_pstl_zip_rt_f',
404: p_base_key_column => 'pstl_zip_rng_id',
405: p_base_key_value => p_pstl_zip_rng_id,
406: p_from_date => p_validation_start_date,

Line 412: If (dt_api.rows_exist

408: -- l_table_name := 'ben_pstl_zip_rt_f';
409: l_child_rec := 'Variable Rate Criteria';
410: Raise l_rows_exist;
411: End If;
412: If (dt_api.rows_exist
413: (p_base_table_name => 'ben_svc_area_pstl_zip_rng_f',
414: p_base_key_column => 'pstl_zip_rng_id',
415: p_base_key_value => p_pstl_zip_rng_id,
416: p_from_date => p_validation_start_date,