[Home] [Help]
336: p_argument_value => p_datetrack_mode);
337: --
338: -- Only perform the validation if the datetrack update mode is valid
339: --
340: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
341: --
342: --
343: -- Ensure the arguments are not null
344: --
352: p_argument => 'validation_end_date',
353: p_argument_value => p_validation_end_date);
354: --
355: If ((nvl(p_formula_id, hr_api.g_number) <> hr_api.g_number) and
356: NOT (dt_api.check_min_max_dates
357: (p_base_table_name => 'ff_formulas_f',
358: p_base_key_column => 'formula_id',
359: p_base_key_value => p_formula_id,
360: p_from_date => p_validation_start_date,
363: Raise l_integrity_error;
364: End If;
365: --
366: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
367: NOT (dt_api.check_min_max_dates
368: (p_base_table_name => 'ben_eligy_prfl_f',
369: p_base_key_column => 'eligy_prfl_id',
370: p_base_key_value => p_eligy_prfl_id,
371: p_from_date => p_validation_start_date,
418: -- Processing continues.
419: --
420: -- Post Failure:
421: -- If a row exists by determining the returning Boolean value from the
422: -- generic dt_api.rows_exist function then we must supply an error via
423: -- the use of the local exception handler l_rows_exist.
424: --
425: -- Developer Implementation Notes:
426: -- This procedure should not need maintenance unless the HR Schema model
474: (p_api_name => l_proc,
475: p_argument => 'eligy_prfl_rl_id',
476: p_argument_value => p_eligy_prfl_rl_id);
477: --
478: -- If (dt_api.rows_exist
479: -- (p_base_table_name => 'ben_eligy_prfl_f',
480: -- p_base_key_column => 'eligy_prfl_rl_id',
481: -- p_base_key_value => p_eligy_prfl_rl_id,
482: -- p_from_date => p_validation_start_date,