APPS.BEN_LDC_BUS dependencies on DT_API

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

1119: p_argument_value => p_datetrack_mode);
1120: --
1121: -- Only perform the validation if the datetrack update mode is valid
1122: --
1123: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
1124: --
1125: --
1126: -- Ensure the arguments are not null
1127: --

Line 1139: NOT (dt_api.check_min_max_dates

1135: p_argument => 'validation_end_date',
1136: p_argument_value => p_validation_end_date);
1137: --
1138: If ((nvl(p_ler_chg_dpnt_cvg_rl, hr_api.g_number) <> hr_api.g_number) and
1139: NOT (dt_api.check_min_max_dates
1140: (p_base_table_name => 'ff_formulas_f',
1141: p_base_key_column => 'formula_id',
1142: p_base_key_value => p_ler_chg_dpnt_cvg_rl,
1143: p_from_date => p_validation_start_date,

Line 1149: NOT (dt_api.check_min_max_dates

1145: l_table_name := 'ff_formulas_f';
1146: Raise l_integrity_error;
1147: End If;
1148: If ((nvl(p_cvg_eff_strt_rl, hr_api.g_number) <> hr_api.g_number) and
1149: NOT (dt_api.check_min_max_dates
1150: (p_base_table_name => 'ff_formulas_f',
1151: p_base_key_column => 'formula_id',
1152: p_base_key_value => p_cvg_eff_strt_rl,
1153: p_from_date => p_validation_start_date,

Line 1159: NOT (dt_api.check_min_max_dates

1155: l_table_name := 'ff_formulas_f';
1156: Raise l_integrity_error;
1157: End If;
1158: If ((nvl(p_cvg_eff_end_rl, hr_api.g_number) <> hr_api.g_number) and
1159: NOT (dt_api.check_min_max_dates
1160: (p_base_table_name => 'ff_formulas_f',
1161: p_base_key_column => 'formula_id',
1162: p_base_key_value => p_cvg_eff_end_rl,
1163: p_from_date => p_validation_start_date,

Line 1169: NOT (dt_api.check_min_max_dates

1165: l_table_name := 'ff_formulas_f';
1166: Raise l_integrity_error;
1167: End If;
1168: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
1169: NOT (dt_api.check_min_max_dates
1170: (p_base_table_name => 'ben_ptip_f',
1171: p_base_key_column => 'ptip_id',
1172: p_base_key_value => p_ptip_id,
1173: p_from_date => p_validation_start_date,

Line 1179: NOT (dt_api.check_min_max_dates

1175: l_table_name := 'ben_ptip_f';
1176: Raise l_integrity_error;
1177: End If;
1178: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and
1179: NOT (dt_api.check_min_max_dates
1180: (p_base_table_name => 'ben_ler_f',
1181: p_base_key_column => 'ler_id',
1182: p_base_key_value => p_ler_id,
1183: p_from_date => p_validation_start_date,

Line 1189: NOT (dt_api.check_min_max_dates

1185: l_table_name := 'ben_ler_f';
1186: Raise l_integrity_error;
1187: End If;
1188: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
1189: NOT (dt_api.check_min_max_dates
1190: (p_base_table_name => 'ben_pl_f',
1191: p_base_key_column => 'pl_id',
1192: p_base_key_value => p_pl_id,
1193: p_from_date => p_validation_start_date,

Line 1199: NOT (dt_api.check_min_max_dates

1195: l_table_name := 'ben_pl_f';
1196: Raise l_integrity_error;
1197: End If;
1198: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
1199: NOT (dt_api.check_min_max_dates
1200: (p_base_table_name => 'ben_pgm_f',
1201: p_base_key_column => 'pgm_id',
1202: p_base_key_value => p_pgm_id,
1203: p_from_date => p_validation_start_date,

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

1249: -- Processing continues.
1250: --
1251: -- Post Failure:
1252: -- If a row exists by determining the returning Boolean value from the
1253: -- generic dt_api.rows_exist function then we must supply an error via
1254: -- the use of the local exception handler l_rows_exist.
1255: --
1256: -- Developer Implementation Notes:
1257: -- This procedure should not need maintenance unless the HR Schema model

Line 1309: If (dt_api.rows_exist

1305: (p_api_name => l_proc,
1306: p_argument => 'ler_chg_dpnt_cvg_id',
1307: p_argument_value => p_ler_chg_dpnt_cvg_id);
1308: --
1309: If (dt_api.rows_exist
1310: (p_base_table_name => 'ben_ler_chg_dpnt_cvg_ctfn_f',
1311: p_base_key_column => 'ler_chg_dpnt_cvg_id',
1312: p_base_key_value => p_ler_chg_dpnt_cvg_id,
1313: p_from_date => p_validation_start_date,