APPS.BEN_PEP_BUS dependencies on DT_API

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

2378: p_argument_value => p_datetrack_mode);
2379: --
2380: -- Only perform the validation if the datetrack update mode is valid
2381: --
2382: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
2383: --
2384: --
2385: -- Ensure the arguments are not null
2386: --

Line 2398: NOT (dt_api.check_min_max_dates

2394: p_argument => 'validation_end_date',
2395: p_argument_value => p_validation_end_date);
2396: --
2397: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and
2398: NOT (dt_api.check_min_max_dates
2399: (p_base_table_name => 'ben_ler_f',
2400: p_base_key_column => 'ler_id',
2401: p_base_key_value => p_ler_id,
2402: p_from_date => p_validation_start_date,

Line 2408: NOT (dt_api.check_min_max_dates

2404: l_table_name := 'ben_ler_f';
2405: Raise l_integrity_error;
2406: End If;
2407: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
2408: NOT (dt_api.check_min_max_dates
2409: (p_base_table_name => 'ben_pgm_f',
2410: p_base_key_column => 'pgm_id',
2411: p_base_key_value => p_pgm_id,
2412: p_from_date => p_validation_start_date,

Line 2418: NOT (dt_api.check_min_max_dates

2414: l_table_name := 'ben_pgm_f';
2415: Raise l_integrity_error;
2416: End If;
2417: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
2418: NOT (dt_api.check_min_max_dates
2419: (p_base_table_name => 'ben_pl_f',
2420: p_base_key_column => 'pl_id',
2421: p_base_key_value => p_pl_id,
2422: p_from_date => p_validation_start_date,

Line 2428: NOT (dt_api.check_min_max_dates

2424: l_table_name := 'ben_pl_f';
2425: Raise l_integrity_error;
2426: End If;
2427: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
2428: NOT (dt_api.check_min_max_dates
2429: (p_base_table_name => 'ben_plip_f',
2430: p_base_key_column => 'plip_id',
2431: p_base_key_value => p_plip_id,
2432: p_from_date => p_validation_start_date,

Line 2438: NOT (dt_api.check_min_max_dates

2434: l_table_name := 'ben_plip_f';
2435: Raise l_integrity_error;
2436: End If;
2437: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
2438: NOT (dt_api.check_min_max_dates
2439: (p_base_table_name => 'ben_ptip_f',
2440: p_base_key_column => 'ptip_id',
2441: p_base_key_value => p_ptip_id,
2442: p_from_date => p_validation_start_date,

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

2490: -- Processing continues.
2491: --
2492: -- Post Failure:
2493: -- If a row exists by determining the returning Boolean value from the
2494: -- generic dt_api.rows_exist function then we must supply an error via
2495: -- the use of the local exception handler l_rows_exist.
2496: --
2497: -- Developer Implementation Notes:
2498: -- This procedure should not need maintenance unless the HR Schema model

Line 2550: If (dt_api.rows_exist

2546: (p_api_name => l_proc,
2547: p_argument => 'elig_per_id',
2548: p_argument_value => p_elig_per_id);
2549: --
2550: If (dt_api.rows_exist
2551: (p_base_table_name => 'ben_elig_per_opt_f',
2552: p_base_key_column => 'elig_per_id',
2553: p_base_key_value => p_elig_per_id,
2554: p_from_date => p_validation_start_date,