[Home] [Help]
4793: p_argument_value => p_datetrack_mode);
4794: --
4795: -- Only perform the validation if the datetrack update mode is valid
4796: --
4797: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
4798: --
4799: --
4800: -- Ensure the arguments are not null
4801: --
4809: p_argument => 'validation_end_date',
4810: p_argument_value => p_validation_end_date);
4811: --
4812: If ((nvl(p_auto_enrt_mthd_rl, hr_api.g_number) <> hr_api.g_number) and
4813: NOT (dt_api.check_min_max_dates
4814: (p_base_table_name => 'ff_formulas_f',
4815: p_base_key_column => 'formula_id',
4816: p_base_key_value => p_auto_enrt_mthd_rl,
4817: p_from_date => p_validation_start_date,
4819: l_table_name := 'ff_formulas_f';
4820: Raise l_integrity_error;
4821: End If;
4822: If ((nvl(p_mn_cvg_rl, hr_api.g_number) <> hr_api.g_number) and
4823: NOT (dt_api.check_min_max_dates
4824: (p_base_table_name => 'ff_formulas_f',
4825: p_base_key_column => 'formula_id',
4826: p_base_key_value => p_mn_cvg_rl,
4827: p_from_date => p_validation_start_date,
4829: l_table_name := 'ff_formulas_f';
4830: Raise l_integrity_error;
4831: End If;
4832: If ((nvl(p_mx_cvg_rl, hr_api.g_number) <> hr_api.g_number) and
4833: NOT (dt_api.check_min_max_dates
4834: (p_base_table_name => 'ff_formulas_f',
4835: p_base_key_column => 'formula_id',
4836: p_base_key_value => p_mx_cvg_rl,
4837: p_from_date => p_validation_start_date,
4839: l_table_name := 'ff_formulas_f';
4840: Raise l_integrity_error;
4841: End If;
4842: If ((nvl(p_bnft_prvdr_pool_id, hr_api.g_number) <> hr_api.g_number) and
4843: NOT (dt_api.check_min_max_dates
4844: (p_base_table_name => 'ben_bnft_prvdr_pool_f',
4845: p_base_key_column => 'bnft_prvdr_pool_id',
4846: p_base_key_value => p_bnft_prvdr_pool_id,
4847: p_from_date => p_validation_start_date,
4849: l_table_name := 'ff_formulas_f';
4850: Raise l_integrity_error;
4851: End If;
4852: If ((nvl(p_enrt_rl, hr_api.g_number) <> hr_api.g_number) and
4853: NOT (dt_api.check_min_max_dates
4854: (p_base_table_name => 'ff_formulas_f',
4855: p_base_key_column => 'formula_id',
4856: p_base_key_value => p_enrt_rl,
4857: p_from_date => p_validation_start_date,
4859: l_table_name := 'ff_formulas_f';
4860: Raise l_integrity_error;
4861: End If;
4862: If ((nvl(p_rqd_perd_enrt_nenrt_rl, hr_api.g_number) <> hr_api.g_number) and
4863: NOT (dt_api.check_min_max_dates
4864: (p_base_table_name => 'ff_formulas_f',
4865: p_base_key_column => 'formula_id',
4866: p_base_key_value => p_rqd_perd_enrt_nenrt_rl,
4867: p_from_date => p_validation_start_date,
4869: l_table_name := 'ff_formulas_f';
4870: Raise l_integrity_error;
4871: End If;
4872: If ((nvl(p_mx_wtg_perd_rl, hr_api.g_number) <> hr_api.g_number) and
4873: NOT (dt_api.check_min_max_dates
4874: (p_base_table_name => 'ff_formulas_f',
4875: p_base_key_column => 'formula_id',
4876: p_base_key_value => p_mx_wtg_perd_rl,
4877: p_from_date => p_validation_start_date,
4879: l_table_name := 'ff_formulas_f';
4880: Raise l_integrity_error;
4881: End If;
4882: If ((nvl(p_nip_dflt_enrt_det_rl, hr_api.g_number) <> hr_api.g_number) and
4883: NOT (dt_api.check_min_max_dates
4884: (p_base_table_name => 'ff_formulas_f',
4885: p_base_key_column => 'formula_id',
4886: p_base_key_value => p_nip_dflt_enrt_det_rl,
4887: p_from_date => p_validation_start_date,
4889: l_table_name := 'ff_formulas_f';
4890: Raise l_integrity_error;
4891: End If;
4892: If ((nvl(p_dpnt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4893: NOT (dt_api.check_min_max_dates
4894: (p_base_table_name => 'ff_formulas_f',
4895: p_base_key_column => 'formula_id',
4896: p_base_key_value => p_dpnt_cvg_end_dt_rl,
4897: p_from_date => p_validation_start_date,
4899: l_table_name := 'ff_formulas_f';
4900: Raise l_integrity_error;
4901: End If;
4902: If ((nvl(p_dpnt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4903: NOT (dt_api.check_min_max_dates
4904: (p_base_table_name => 'ff_formulas_f',
4905: p_base_key_column => 'formula_id',
4906: p_base_key_value => p_dpnt_cvg_strt_dt_rl,
4907: p_from_date => p_validation_start_date,
4909: l_table_name := 'ff_formulas_f';
4910: Raise l_integrity_error;
4911: End If;
4912: If ((nvl(p_prort_prtl_yr_cvg_rstrn_rl, hr_api.g_number) <> hr_api.g_number) and
4913: NOT (dt_api.check_min_max_dates
4914: (p_base_table_name => 'ff_formulas_f',
4915: p_base_key_column => 'formula_id',
4916: p_base_key_value => p_prort_prtl_yr_cvg_rstrn_rl,
4917: p_from_date => p_validation_start_date,
4919: l_table_name := 'ff_formulas_f';
4920: Raise l_integrity_error;
4921: End If;
4922: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and
4923: NOT (dt_api.check_min_max_dates
4924: (p_base_table_name => 'ben_pl_typ_f',
4925: p_base_key_column => 'pl_typ_id',
4926: p_base_key_value => p_pl_typ_id,
4927: p_from_date => p_validation_start_date,
4933:
4934: -- Commented out because actl_prem_f is parent of plan!!!!!!!!!
4935: --
4936: -- If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
4937: -- NOT (dt_api.check_min_max_dates
4938: -- (p_base_table_name => 'ben_actl_prem_f',
4939: -- p_base_key_column => 'actl_prem_id',
4940: -- p_base_key_value => p_actl_prem_id,
4941: -- p_from_date => p_validation_start_date,
4944: -- Raise l_integrity_error;
4945: -- End If;
4946: --
4947: If ((nvl(p_dflt_to_asn_pndg_ctfn_rl, hr_api.g_number) <> hr_api.g_number) and
4948: NOT (dt_api.check_min_max_dates
4949: (p_base_table_name => 'ff_formulas_f',
4950: p_base_key_column => 'formula_id',
4951: p_base_key_value => p_dflt_to_asn_pndg_ctfn_rl,
4952: p_from_date => p_validation_start_date,
4955: Raise l_integrity_error;
4956: End If;
4957: --
4958: If ((nvl(p_dpnt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4959: NOT (dt_api.check_min_max_dates
4960: (p_base_table_name => 'ff_formulas_f',
4961: p_base_key_column => 'formula_id',
4962: p_base_key_value => p_dpnt_cvg_end_dt_rl,
4963: p_from_date => p_validation_start_date,
4966: Raise l_integrity_error;
4967: End If;
4968: --
4969: If ((nvl(p_dpnt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4970: NOT (dt_api.check_min_max_dates
4971: (p_base_table_name => 'ff_formulas_f',
4972: p_base_key_column => 'formula_id',
4973: p_base_key_value => p_dpnt_cvg_strt_dt_rl,
4974: p_from_date => p_validation_start_date,
4977: Raise l_integrity_error;
4978: End If;
4979: --
4980: If ((nvl(p_enrt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4981: NOT (dt_api.check_min_max_dates
4982: (p_base_table_name => 'ff_formulas_f',
4983: p_base_key_column => 'formula_id',
4984: p_base_key_value => p_enrt_cvg_end_dt_rl,
4985: p_from_date => p_validation_start_date,
4988: Raise l_integrity_error;
4989: End If;
4990: --
4991: If ((nvl(p_enrt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
4992: NOT (dt_api.check_min_max_dates
4993: (p_base_table_name => 'ff_formulas_f',
4994: p_base_key_column => 'formula_id',
4995: p_base_key_value => p_enrt_cvg_strt_dt_rl,
4996: p_from_date => p_validation_start_date,
4999: Raise l_integrity_error;
5000: End If;
5001: --
5002: If ((nvl(p_postelcn_edit_rl, hr_api.g_number) <> hr_api.g_number) and
5003: NOT (dt_api.check_min_max_dates
5004: (p_base_table_name => 'ff_formulas_f',
5005: p_base_key_column => 'formula_id',
5006: p_base_key_value => p_postelcn_edit_rl,
5007: p_from_date => p_validation_start_date,
5010: Raise l_integrity_error;
5011: End If;
5012: --
5013: If ((nvl(p_rt_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5014: NOT (dt_api.check_min_max_dates
5015: (p_base_table_name => 'ff_formulas_f',
5016: p_base_key_column => 'formula_id',
5017: p_base_key_value => p_rt_end_dt_rl,
5018: p_from_date => p_validation_start_date,
5021: Raise l_integrity_error;
5022: End If;
5023: --
5024: If ((nvl(p_rt_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5025: NOT (dt_api.check_min_max_dates
5026: (p_base_table_name => 'ff_formulas_f',
5027: p_base_key_column => 'formula_id',
5028: p_base_key_value => p_rt_strt_dt_rl,
5029: p_from_date => p_validation_start_date,
5076: -- Processing continues.
5077: --
5078: -- Post Failure:
5079: -- If a row exists by determining the returning Boolean value from the
5080: -- generic dt_api.rows_exist function then we must supply an error via
5081: -- the use of the local exception handler l_rows_exist.
5082: --
5083: -- Developer Implementation Notes:
5084: -- This procedure should not need maintenance unless the HR Schema model
5145: (p_api_name => l_proc,
5146: p_argument => 'pl_id',
5147: p_argument_value => p_pl_id);
5148: --
5149: If (dt_api.rows_exist
5150: (p_base_table_name => 'ben_pl_regy_bod_f',
5151: p_base_key_column => 'pl_id',
5152: p_base_key_value => p_pl_id,
5153: p_from_date => p_validation_start_date,
5154: p_to_date => p_validation_end_date)) Then
5155: l_table_name := 'ben_pl_regy_bod_f';
5156: Raise l_rows_exist;
5157: End If;
5158: If (dt_api.rows_exist
5159: (p_base_table_name => 'ben_oipl_f',
5160: p_base_key_column => 'pl_id',
5161: p_base_key_value => p_pl_id,
5162: p_from_date => p_validation_start_date,
5163: p_to_date => p_validation_end_date)) Then
5164: l_table_name := 'ben_oipl_f';
5165: Raise l_rows_exist;
5166: End If;
5167: If (dt_api.rows_exist
5168: (p_base_table_name => 'ben_popl_enrt_typ_cycl_f',
5169: p_base_key_column => 'pl_id',
5170: p_base_key_value => p_pl_id,
5171: p_from_date => p_validation_start_date,
5172: p_to_date => p_validation_end_date)) Then
5173: l_table_name := 'ben_popl_enrt_typ_cycl_f';
5174: Raise l_rows_exist;
5175: End If;
5176: If (dt_api.rows_exist
5177: (p_base_table_name => 'ben_vald_rlshp_for_reimb_f',
5178: p_base_key_column => 'pl_id',
5179: p_base_key_value => p_pl_id,
5180: p_from_date => p_validation_start_date,
5181: p_to_date => p_validation_end_date)) Then
5182: l_table_name := 'ben_vald_rlshp_for_reimb_f';
5183: Raise l_rows_exist;
5184: End If;
5185: If (dt_api.rows_exist
5186: (p_base_table_name => 'ben_ler_chg_pl_nip_enrt_f',
5187: p_base_key_column => 'pl_id',
5188: p_base_key_value => p_pl_id,
5189: p_from_date => p_validation_start_date,
5190: p_to_date => p_validation_end_date)) Then
5191: l_table_name := 'ben_ler_chg_pl_nip_enrt_f';
5192: Raise l_rows_exist;
5193: End If;
5194: If (dt_api.rows_exist
5195: (p_base_table_name => 'ben_pl_gd_or_svc_f',
5196: p_base_key_column => 'pl_id',
5197: p_base_key_value => p_pl_id,
5198: p_from_date => p_validation_start_date,
5199: p_to_date => p_validation_end_date)) Then
5200: l_table_name := 'ben_pl_gd_or_svc_f';
5201: Raise l_rows_exist;
5202: End If;
5203: If (dt_api.rows_exist
5204: (p_base_table_name => 'ben_plip_f',
5205: p_base_key_column => 'pl_id',
5206: p_base_key_value => p_pl_id,
5207: p_from_date => p_validation_start_date,
5208: p_to_date => p_validation_end_date)) Then
5209: l_table_name := 'ben_plip_f';
5210: Raise l_rows_exist;
5211: End If;
5212: If (dt_api.rows_exist
5213: (p_base_table_name => 'ben_pl_regn_f',
5214: p_base_key_column => 'pl_id',
5215: p_base_key_value => p_pl_id,
5216: p_from_date => p_validation_start_date,
5217: p_to_date => p_validation_end_date)) Then
5218: l_table_name := 'ben_pl_regn_f';
5219: Raise l_rows_exist;
5220: End If;
5221: If (dt_api.rows_exist
5222: (p_base_table_name => 'ben_elig_to_prte_rsn_f',
5223: p_base_key_column => 'pl_id',
5224: p_base_key_value => p_pl_id,
5225: p_from_date => p_validation_start_date,
5226: p_to_date => p_validation_end_date)) Then
5227: l_table_name := 'ben_elig_to_prte_rsn_f';
5228: Raise l_rows_exist;
5229: End If;
5230: If (dt_api.rows_exist
5231: (p_base_table_name => 'ben_prtn_elig_f',
5232: p_base_key_column => 'pl_id',
5233: p_base_key_value => p_pl_id,
5234: p_from_date => p_validation_start_date,
5235: p_to_date => p_validation_end_date)) Then
5236: l_table_name := 'ben_prtn_elig_f';
5237: Raise l_rows_exist;
5238: End If;
5239: If (dt_api.rows_exist
5240: (p_base_table_name => 'ben_cvg_amt_calc_mthd_f',
5241: p_base_key_column => 'pl_id',
5242: p_base_key_value => p_pl_id,
5243: p_from_date => p_validation_start_date,
5244: p_to_date => p_validation_end_date)) Then
5245: l_table_name := 'ben_cvg_amt_calc_mthd_f';
5246: Raise l_rows_exist;
5247: End If;
5248: If (dt_api.rows_exist
5249: (p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',
5250: p_base_key_column => 'pl_id',
5251: p_base_key_value => p_pl_id,
5252: p_from_date => p_validation_start_date,
5253: p_to_date => p_validation_end_date)) Then
5254: l_table_name := 'ben_ler_chg_dpnt_cvg_f';
5255: Raise l_rows_exist;
5256: End If;
5257: If (dt_api.rows_exist
5258: (p_base_table_name => 'ben_popl_org_f',
5259: p_base_key_column => 'pl_id',
5260: p_base_key_value => p_pl_id,
5261: p_from_date => p_validation_start_date,
5262: p_to_date => p_validation_end_date)) Then
5263: l_table_name := 'ben_popl_org_f';
5264: Raise l_rows_exist;
5265: End If;
5266: If (dt_api.rows_exist
5267: (p_base_table_name => 'ben_elig_per_f',
5268: p_base_key_column => 'pl_id',
5269: p_base_key_value => p_pl_id,
5270: p_from_date => p_validation_start_date,
5271: p_to_date => p_validation_end_date)) Then
5272: l_table_name := 'ben_elig_per_f';
5273: Raise l_rows_exist;
5274: End If;
5275: If (dt_api.rows_exist
5276: (p_base_table_name => 'ben_acty_base_rt_f',
5277: p_base_key_column => 'pl_id',
5278: p_base_key_value => p_pl_id,
5279: p_from_date => p_validation_start_date,
5280: p_to_date => p_validation_end_date)) Then
5281: l_table_name := 'ben_acty_base_rt_f';
5282: Raise l_rows_exist;
5283: End If;
5284: If (dt_api.rows_exist
5285: (p_base_table_name => 'ben_pl_dpnt_cvg_ctfn_f',
5286: p_base_key_column => 'pl_id',
5287: p_base_key_value => p_pl_id,
5288: p_from_date => p_validation_start_date,
5289: p_to_date => p_validation_end_date)) Then
5290: l_table_name := 'ben_pl_dpnt_cvg_ctfn_f';
5291: Raise l_rows_exist;
5292: End If;
5293: If (dt_api.rows_exist
5294: (p_base_table_name => 'ben_pl_bnf_ctfn_f',
5295: p_base_key_column => 'pl_id',
5296: p_base_key_value => p_pl_id,
5297: p_from_date => p_validation_start_date,
5298: p_to_date => p_validation_end_date)) Then
5299: l_table_name := 'ben_pl_bnf_ctfn_f';
5300: Raise l_rows_exist;
5301: End If;
5302: If (dt_api.rows_exist
5303: (p_base_table_name => 'ben_popl_rptg_grp_f',
5304: p_base_key_column => 'pl_id',
5305: p_base_key_value => p_pl_id,
5306: p_from_date => p_validation_start_date,
5307: p_to_date => p_validation_end_date)) Then
5308: l_table_name := 'ben_popl_rptg_grp_f';
5309: Raise l_rows_exist;
5310: End If;
5311: If (dt_api.rows_exist
5312: (p_base_table_name => 'ben_prtt_reimbmt_rqst_f',
5313: p_base_key_column => 'pl_id',
5314: p_base_key_value => p_pl_id,
5315: p_from_date => p_validation_start_date,
5316: p_to_date => p_validation_end_date)) Then
5317: l_table_name := 'ben_prtt_reimbmt_rqst_f';
5318: Raise l_rows_exist;
5319: End If;
5320: If (dt_api.rows_exist
5321: (p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',
5322: p_base_key_column => 'pl_id',
5323: p_base_key_value => p_pl_id,
5324: p_from_date => p_validation_start_date,
5325: p_to_date => p_validation_end_date)) Then
5326: l_table_name := 'ben_apld_dpnt_cvg_elig_prfl_f';
5327: Raise l_rows_exist;
5328: End If;
5329: If (dt_api.rows_exist
5330: (p_base_table_name => 'ben_dsgn_rqmt_f',
5331: p_base_key_column => 'pl_id',
5332: p_base_key_value => p_pl_id,
5333: p_from_date => p_validation_start_date,
5334: p_to_date => p_validation_end_date)) Then
5335: l_table_name := 'ben_dsgn_rqmt_f';
5336: Raise l_rows_exist;
5337: End If;
5338: If (dt_api.rows_exist
5339: (p_base_table_name => 'ben_elig_prtt_anthr_pl_prte_f',
5340: p_base_key_column => 'pl_id',
5341: p_base_key_value => p_pl_id,
5342: p_from_date => p_validation_start_date,
5343: p_to_date => p_validation_end_date)) Then
5344: l_table_name := 'ben_elig_prtt_anthr_pl_prte_f';
5345: Raise l_rows_exist;
5346: End If;
5347: If (dt_api.rows_exist
5348: (p_base_table_name => 'ben_pl_r_oipl_asset_f',
5349: p_base_key_column => 'pl_id',
5350: p_base_key_value => p_pl_id,
5351: p_from_date => p_validation_start_date,
5352: p_to_date => p_validation_end_date)) Then
5353: l_table_name := 'ben_pl_r_oipl_asset_f';
5354: Raise l_rows_exist;
5355: End If;
5356: If (dt_api.rows_exist
5357: (p_base_table_name => 'ben_prtt_enrt_rslt_f',
5358: p_base_key_column => 'pl_id',
5359: p_base_key_value => p_pl_id,
5360: p_from_date => p_validation_start_date,
5361: p_to_date => p_validation_end_date)) Then
5362: l_table_name := 'ben_prtt_enrt_rslt_f';
5363: Raise l_rows_exist;
5364: End If;
5365: If (dt_api.rows_exist
5366: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
5367: p_base_key_column => 'pl_id',
5368: p_base_key_value => p_pl_id,
5369: p_from_date => p_validation_start_date,
5370: p_to_date => p_validation_end_date)) Then
5371: l_table_name := 'ben_vrbl_rt_prfl_f';
5372: Raise l_rows_exist;
5373: End If;
5374: If (dt_api.rows_exist
5375: (p_base_table_name => 'ben_wv_prtn_rsn_pl_f',
5376: p_base_key_column => 'pl_id',
5377: p_base_key_value => p_pl_id,
5378: p_from_date => p_validation_start_date,
5379: p_to_date => p_validation_end_date)) Then
5380: l_table_name := 'ben_wv_prtn_rsn_pl_f';
5381: Raise l_rows_exist;
5382: End If;
5383: If (dt_api.rows_exist
5384: (p_base_table_name => 'ben_bnft_rstrn_ctfn_f',
5385: p_base_key_column => 'pl_id',
5386: p_base_key_value => p_pl_id,
5387: p_from_date => p_validation_start_date,
5388: p_to_date => p_validation_end_date)) Then
5389: l_table_name := 'ben_bnft_rstrn_ctfn_f';
5390: Raise l_rows_exist;
5391: End If;
5392: /* If (dt_api.rows_exist -- Bug 4304937
5393: (p_base_table_name => 'ben_popl_yr_perd',
5394: p_base_key_column => 'pl_id',
5395: p_base_key_value => p_pl_id,
5396: p_from_date => p_validation_start_date,
5397: p_to_date => p_validation_end_date)) Then
5398: l_table_name := 'ben_popl_yr_perd';
5399: Raise l_rows_exist;
5400: End If;
5401: If (dt_api.rows_exist -- Bug 4304937
5402: (p_base_table_name => 'ben_cwb_wksht_grp',
5403: p_base_key_column => 'pl_id',
5404: p_base_key_value => p_pl_id,
5405: p_from_date => p_validation_start_date,