APPS.BEN_COP_BUS dependencies on DT_API

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

2155: p_argument_value => p_datetrack_mode);
2156: --
2157: -- Only perform the validation if the datetrack update mode is valid
2158: --
2159: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
2160: --
2161: --
2162: -- Ensure the arguments are not null
2163: --

Line 2175: NOT (dt_api.check_min_max_dates

2171: p_argument => 'validation_end_date',
2172: p_argument_value => p_validation_end_date);
2173: --
2174: If ((nvl(p_dflt_enrt_det_rl, hr_api.g_number) <> hr_api.g_number) and
2175: NOT (dt_api.check_min_max_dates
2176: (p_base_table_name => 'ff_formulas_f',
2177: p_base_key_column => 'formula_id',
2178: p_base_key_value => p_dflt_enrt_det_rl,
2179: p_from_date => p_validation_start_date,

Line 2185: NOT (dt_api.check_min_max_dates

2181: l_table_name := 'ff_formulas_f';
2182: Raise l_integrity_error;
2183: End If;
2184: If ((nvl(p_mndtry_rl, hr_api.g_number) <> hr_api.g_number) and
2185: NOT (dt_api.check_min_max_dates
2186: (p_base_table_name => 'ff_formulas_f',
2187: p_base_key_column => 'formula_id',
2188: p_base_key_value => p_mndtry_rl,
2189: p_from_date => p_validation_start_date,

Line 2195: NOT (dt_api.check_min_max_dates

2191: l_table_name := 'ff_formulas_f';
2192: Raise l_integrity_error;
2193: End If;
2194: If ((nvl(p_rqd_perd_enrt_nenrt_rl, hr_api.g_number) <> hr_api.g_number) and
2195: NOT (dt_api.check_min_max_dates
2196: (p_base_table_name => 'ff_formulas_f',
2197: p_base_key_column => 'formula_id',
2198: p_base_key_value => p_rqd_perd_enrt_nenrt_rl,
2199: p_from_date => p_validation_start_date,

Line 2205: NOT (dt_api.check_min_max_dates

2201: l_table_name := 'ff_formulas_f';
2202: Raise l_integrity_error;
2203: End If;
2204: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
2205: NOT (dt_api.check_min_max_dates
2206: (p_base_table_name => 'ben_actl_prem_f',
2207: p_base_key_column => 'actl_prem_id',
2208: p_base_key_value => p_actl_prem_id,
2209: p_from_date => p_validation_start_date,

Line 2215: NOT (dt_api.check_min_max_dates

2211: l_table_name := 'ben_actl_prem_f';
2212: Raise l_integrity_error;
2213: End If;
2214: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
2215: NOT (dt_api.check_min_max_dates
2216: (p_base_table_name => 'ben_pl_f',
2217: p_base_key_column => 'pl_id',
2218: p_base_key_value => p_pl_id,
2219: p_from_date => p_validation_start_date,

Line 2225: NOT (dt_api.check_min_max_dates

2221: l_table_name := 'ben_pl_f';
2222: Raise l_integrity_error;
2223: End If;
2224: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
2225: NOT (dt_api.check_min_max_dates
2226: (p_base_table_name => 'ben_opt_f',
2227: p_base_key_column => 'opt_id',
2228: p_base_key_value => p_opt_id,
2229: p_from_date => p_validation_start_date,

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

2277: -- Processing continues.
2278: --
2279: -- Post Failure:
2280: -- If a row exists by determining the returning Boolean value from the
2281: -- generic dt_api.rows_exist function then we must supply an error via
2282: -- the use of the local exception handler l_rows_exist.
2283: --
2284: -- Developer Implementation Notes:
2285: -- This procedure should not need maintenance unless the HR Schema model

Line 2355: If (dt_api.rows_exist

2351: close c1;
2352: --
2353: -- commented out to fix bug 1244535
2354: /*
2355: If (dt_api.rows_exist
2356: (p_base_table_name => 'ben_elig_per_opt_f',
2357: p_base_key_column => 'opt_id',
2358: p_base_key_value => l_opt_id,
2359: p_from_date => p_validation_start_date,

Line 2369: If (dt_api.rows_exist

2365: -- Bug - 1894249
2366: -- Added validation to ensure that the option cannot be deleted
2367: -- if a participant has been enrolled in the oipl .
2368:
2369: If (dt_api.rows_exist
2370: (p_base_table_name => 'ben_prtt_enrt_rslt_f',
2371: p_base_key_column => 'oipl_id',
2372: p_base_key_value => p_oipl_id,
2373: p_from_date => p_validation_start_date,

Line 2392: If (dt_api.rows_exist

2388: End if;
2389: Close c_epe ;
2390: End if;
2391:
2392: If (dt_api.rows_exist
2393: (p_base_table_name => 'ben_elig_to_prte_rsn_f',
2394: p_base_key_column => 'oipl_id',
2395: p_base_key_value => p_oipl_id,
2396: p_from_date => p_validation_start_date,

Line 2401: If (dt_api.rows_exist

2397: p_to_date => p_validation_end_date)) Then
2398: l_table_name := 'ben_elig_to_prte_rsn_f';
2399: Raise l_rows_exist;
2400: End If;
2401: If (dt_api.rows_exist
2402: (p_base_table_name => 'ben_ler_chg_oipl_enrt_f',
2403: p_base_key_column => 'oipl_id',
2404: p_base_key_value => p_oipl_id,
2405: p_from_date => p_validation_start_date,

Line 2410: If (dt_api.rows_exist

2406: p_to_date => p_validation_end_date)) Then
2407: l_table_name := 'ben_ler_chg_oipl_enrt_f';
2408: Raise l_rows_exist;
2409: End If;
2410: If (dt_api.rows_exist
2411: (p_base_table_name => 'ben_prtn_elig_f',
2412: p_base_key_column => 'oipl_id',
2413: p_base_key_value => p_oipl_id,
2414: p_from_date => p_validation_start_date,

Line 2419: If (dt_api.rows_exist

2415: p_to_date => p_validation_end_date)) Then
2416: l_table_name := 'ben_prtn_elig_f';
2417: Raise l_rows_exist;
2418: End If;
2419: If (dt_api.rows_exist
2420: (p_base_table_name => 'ben_cvg_amt_calc_mthd_f',
2421: p_base_key_column => 'oipl_id',
2422: p_base_key_value => p_oipl_id,
2423: p_from_date => p_validation_start_date,

Line 2428: If (dt_api.rows_exist

2424: p_to_date => p_validation_end_date)) Then
2425: l_table_name := 'ben_cvg_amt_calc_mthd_f';
2426: Raise l_rows_exist;
2427: End If;
2428: If (dt_api.rows_exist
2429: (p_base_table_name => 'ben_acty_base_rt_f',
2430: p_base_key_column => 'oipl_id',
2431: p_base_key_value => p_oipl_id,
2432: p_from_date => p_validation_start_date,