DBA Data[Home] [Help]

APPS.BEN_SVA_BUS dependencies on DT_API

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

251: p_argument_value => p_datetrack_mode);
252: --
253: -- Only perform the validation if the datetrack update mode is valid
254: --
255: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
256: --
257: --
258: -- Ensure the arguments are not null
259: --

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

312: -- Processing continues.
313: --
314: -- Post Failure:
315: -- If a row exists by determining the returning Boolean value from the
316: -- generic dt_api.rows_exist function then we must supply an error via
317: -- the use of the local exception handler l_rows_exist.
318: --
319: -- Developer Implementation Notes:
320: -- This procedure should not need maintenance unless the HR Schema model

Line 372: If (dt_api.rows_exist

368: (p_api_name => l_proc,
369: p_argument => 'svc_area_id',
370: p_argument_value => p_svc_area_id);
371: --
372: If (dt_api.rows_exist
373: (p_base_table_name => 'ben_elig_svc_area_prte_f',
374: p_base_key_column => 'svc_area_id',
375: p_base_key_value => p_svc_area_id,
376: p_from_date => p_validation_start_date,

Line 381: If (dt_api.rows_exist

377: p_to_date => p_validation_end_date)) Then
378: l_table_name := 'ben_elig_svc_area_prte_f';
379: Raise l_rows_exist;
380: End If;
381: If (dt_api.rows_exist
382: (p_base_table_name => 'ben_svc_area_pstl_zip_rng_f',
383: p_base_key_column => 'svc_area_id',
384: p_base_key_value => p_svc_area_id,
385: p_from_date => p_validation_start_date,

Line 390: If (dt_api.rows_exist

386: p_to_date => p_validation_end_date)) Then
387: l_table_name := 'ben_svc_area_pstl_zip_rng_f';
388: Raise l_rows_exist;
389: End If;
390: If (dt_api.rows_exist
391: (p_base_table_name => 'ben_svc_area_rt_f',
392: p_base_key_column => 'svc_area_id',
393: p_base_key_value => p_svc_area_id,
394: p_from_date => p_validation_start_date,