APPS.BEN_CTU_BUS dependencies on DT_API

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

271: p_argument_value => p_datetrack_mode);
272: --
273: -- Only perform the validation if the datetrack update mode is valid
274: --
275: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
276: --
277: --
278: -- Ensure the arguments are not null
279: --

Line 291: NOT (dt_api.check_min_max_dates

287: p_argument => 'validation_end_date',
288: p_argument_value => p_validation_end_date);
289: --
290: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
291: NOT (dt_api.check_min_max_dates
292: (p_base_table_name => 'ben_pgm_f',
293: p_base_key_column => 'pgm_id',
294: p_base_key_value => p_pgm_id,
295: p_from_date => p_validation_start_date,

Line 301: NOT (dt_api.check_min_max_dates

297: l_table_name := 'ben_pgm_f';
298: Raise l_integrity_error;
299: End If;
300: If ((nvl(p_cm_typ_id, hr_api.g_number) <> hr_api.g_number) and
301: NOT (dt_api.check_min_max_dates
302: (p_base_table_name => 'ben_cm_typ_f',
303: p_base_key_column => 'cm_typ_id',
304: p_base_key_value => p_cm_typ_id,
305: p_from_date => p_validation_start_date,

Line 311: NOT (dt_api.check_min_max_dates

307: l_table_name := 'ben_cm_typ_f';
308: Raise l_integrity_error;
309: End If;
310: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
311: NOT (dt_api.check_min_max_dates
312: (p_base_table_name => 'ben_pl_f',
313: p_base_key_column => 'pl_id',
314: p_base_key_value => p_pl_id,
315: p_from_date => p_validation_start_date,

Line 321: NOT (dt_api.check_min_max_dates

317: l_table_name := 'ben_pl_f';
318: Raise l_integrity_error;
319: End If;
320: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and
321: NOT (dt_api.check_min_max_dates
322: (p_base_table_name => 'ben_pl_typ_f',
323: p_base_key_column => 'pl_typ_id',
324: p_base_key_value => p_pl_typ_id,
325: p_from_date => p_validation_start_date,

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

371: -- Processing continues.
372: --
373: -- Post Failure:
374: -- If a row exists by determining the returning Boolean value from the
375: -- generic dt_api.rows_exist function then we must supply an error via
376: -- the use of the local exception handler l_rows_exist.
377: --
378: -- Developer Implementation Notes:
379: -- This procedure should not need maintenance unless the HR Schema model

Line 431: If (dt_api.rows_exist

427: (p_api_name => l_proc,
428: p_argument => 'cm_typ_usg_id',
429: p_argument_value => p_cm_typ_usg_id);
430: --
431: If (dt_api.rows_exist
432: (p_base_table_name => 'ben_per_cm_usg_f',
433: p_base_key_column => 'cm_typ_usg_id',
434: p_base_key_value => p_cm_typ_usg_id,
435: p_from_date => p_validation_start_date,