4744: p_argument_value => p_datetrack_mode);
4745: --
4746: -- Only perform the validation if the datetrack update mode is valid
4747: --
4748: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
4749: --
4750: --
4751: -- Ensure the arguments are not null
4752: --
4760: p_argument => 'validation_end_date',
4761: p_argument_value => p_validation_end_date);
4762: --
4763: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
4764: NOT (dt_api.check_min_max_dates
4765: (p_base_table_name => 'ben_pgm_f',
4766: p_base_key_column => 'pgm_id',
4767: p_base_key_value => p_pgm_id,
4768: p_from_date => p_validation_start_date,
4770: l_table_name := 'ben_pgm_f';
4771: Raise l_integrity_error;
4772: End If;
4773: If ((nvl(p_cmbn_ptip_id, hr_api.g_number) <> hr_api.g_number) and
4774: NOT (dt_api.check_min_max_dates
4775: (p_base_table_name => 'ben_cmbn_ptip_f',
4776: p_base_key_column => 'cmbn_ptip_id',
4777: p_base_key_value => p_cmbn_ptip_id,
4778: p_from_date => p_validation_start_date,
4780: l_table_name := 'ben_cmbn_ptip_f';
4781: Raise l_integrity_error;
4782: End If;
4783: If ((nvl(p_cmbn_ptip_opt_id, hr_api.g_number) <> hr_api.g_number) and
4784: NOT (dt_api.check_min_max_dates
4785: (p_base_table_name => 'ben_cmbn_ptip_opt_f',
4786: p_base_key_column => 'cmbn_ptip_opt_id',
4787: p_base_key_value => p_cmbn_ptip_opt_id,
4788: p_from_date => p_validation_start_date,
4790: l_table_name := 'ben_cmbn_ptip_f';
4791: Raise l_integrity_error;
4792: End If;
4793: If ((nvl(p_acrs_ptip_cvg_id, hr_api.g_number) <> hr_api.g_number) and
4794: NOT (dt_api.check_min_max_dates
4795: (p_base_table_name => 'ben_acrs_ptip_cvg_f',
4796: p_base_key_column => 'acrs_ptip_cvg_id',
4797: p_base_key_value => p_acrs_ptip_cvg_id,
4798: p_from_date => p_validation_start_date,
4800: l_table_name := 'ben_cmbn_ptip_f';
4801: Raise l_integrity_error;
4802: End If;
4803: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and
4804: NOT (dt_api.check_min_max_dates
4805: (p_base_table_name => 'ben_pl_typ_f',
4806: p_base_key_column => 'pl_typ_id',
4807: p_base_key_value => p_pl_typ_id,
4808: p_from_date => p_validation_start_date,
4854: -- Processing continues.
4855: --
4856: -- Post Failure:
4857: -- If a row exists by determining the returning Boolean value from the
4858: -- generic dt_api.rows_exist function then we must supply an error via
4859: -- the use of the local exception handler l_rows_exist.
4860: --
4861: -- Developer Implementation Notes:
4862: -- This procedure should not need maintenance unless the HR Schema model
4910: (p_api_name => l_proc,
4911: p_argument => 'ptip_id',
4912: p_argument_value => p_ptip_id);
4913: --
4914: If (dt_api.rows_exist
4915: (p_base_table_name => 'ben_elig_per_f',
4916: p_base_key_column => 'ptip_id',
4917: p_base_key_value => p_ptip_id,
4918: p_from_date => p_validation_start_date,
4919: p_to_date => p_validation_end_date)) Then
4920: l_table_name := 'ben_elig_per_f';
4921: Raise l_rows_exist;
4922: End If;
4923: If (dt_api.rows_exist
4924: (p_base_table_name => 'ben_wv_prtn_rsn_ptip_f',
4925: p_base_key_column => 'ptip_id',
4926: p_base_key_value => p_ptip_id,
4927: p_from_date => p_validation_start_date,
4928: p_to_date => p_validation_end_date)) Then
4929: l_table_name := 'ben_wv_prtn_rsn_ptip_f';
4930: Raise l_rows_exist;
4931: End If;
4932: If (dt_api.rows_exist
4933: (p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',
4934: p_base_key_column => 'ptip_id',
4935: p_base_key_value => p_ptip_id,
4936: p_from_date => p_validation_start_date,
4937: p_to_date => p_validation_end_date)) Then
4938: l_table_name := 'ben_ler_chg_dpnt_cvg_f';
4939: Raise l_rows_exist;
4940: End If;
4941: If (dt_api.rows_exist
4942: (p_base_table_name => 'ben_acty_base_rt_f',
4943: p_base_key_column => 'ptip_id',
4944: p_base_key_value => p_ptip_id,
4945: p_from_date => p_validation_start_date,
4946: p_to_date => p_validation_end_date)) Then
4947: l_table_name := 'ben_acty_base_rt_f';
4948: Raise l_rows_exist;
4949: End If;
4950: If (dt_api.rows_exist
4951: (p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',
4952: p_base_key_column => 'ptip_id',
4953: p_base_key_value => p_ptip_id,
4954: p_from_date => p_validation_start_date,
4955: p_to_date => p_validation_end_date)) Then
4956: l_table_name := 'ben_apld_dpnt_cvg_elig_prfl_f';
4957: Raise l_rows_exist;
4958: End If;
4959: If (dt_api.rows_exist
4960: (p_base_table_name => 'ben_ptip_dpnt_cvg_ctfn_f',
4961: p_base_key_column => 'ptip_id',
4962: p_base_key_value => p_ptip_id,
4963: p_from_date => p_validation_start_date,