APPS.BEN_VPF_BUS dependencies on DT_API

Line 134: If (dt_api.rows_exist

130: <> ben_vpf_shd.g_old_rec.vrbl_usg_cd) then
131:
132: if ben_vpf_shd.g_old_rec.vrbl_usg_cd = 'RT' then
133: --
134: If (dt_api.rows_exist
135: (p_base_table_name => 'ben_acty_vrbl_rt_f',
136: p_base_key_column => 'vrbl_rt_prfl_id',
137: p_base_key_value => p_vrbl_rt_prfl_id,
138: p_from_date => p_validation_start_date,

Line 151: If (dt_api.rows_exist

147: End If;
148: --
149: if ben_vpf_shd.g_old_rec.vrbl_usg_cd = 'CVG' then
150: --
151: If (dt_api.rows_exist
152: (p_base_table_name => 'ben_bnft_vrbl_rt_f',
153: p_base_key_column => 'vrbl_rt_prfl_id',
154: p_base_key_value => p_vrbl_rt_prfl_id,
155: p_from_date => p_validation_start_date,

Line 169: If (dt_api.rows_exist

165: --
166: --
167: if ben_vpf_shd.g_old_rec.vrbl_usg_cd = 'ACP' then
168: --
169: If (dt_api.rows_exist
170: (p_base_table_name => 'ben_actl_prem_vrbl_rt_f',
171: p_base_key_column => 'vrbl_rt_prfl_id',
172: p_base_key_value => p_vrbl_rt_prfl_id,
173: p_from_date => p_validation_start_date,

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

3903: p_argument_value => p_datetrack_mode);
3904: --
3905: -- Only perform the validation if the datetrack update mode is valid
3906: --
3907: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
3908: --
3909: --
3910: -- Ensure the arguments are not null
3911: --

Line 3923: NOT (dt_api.check_min_max_dates

3919: p_argument => 'validation_end_date',
3920: p_argument_value => p_validation_end_date);
3921: --
3922: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
3923: NOT (dt_api.check_min_max_dates
3924: (p_base_table_name => 'ben_oipl_f',
3925: p_base_key_column => 'oipl_id',
3926: p_base_key_value => p_oipl_id,
3927: p_from_date => p_validation_start_date,

Line 3933: --NOT (dt_api.check_min_max_dates

3929: l_table_name := 'ben_oipl_f';
3930: Raise l_integrity_error;
3931: End If;
3932: --If ((nvl(p_pl_typ_opt_typ_id, hr_api.g_number) <> hr_api.g_number) and
3933: --NOT (dt_api.check_min_max_dates
3934: -- (p_base_table_name => 'ben_pl_typ_opt_typ_f',
3935: -- p_base_key_column => 'pl_typ_opt_typ_id',
3936: -- p_base_key_value => p_pl_typ_opt_typ_id,
3937: -- p_from_date => p_validation_start_date,

Line 3943: NOT (dt_api.check_min_max_dates

3939: --l_table_name := 'ben_pl_typ_opt_typ_f';
3940: --Raise l_integrity_error;
3941: --End If;
3942: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
3943: NOT (dt_api.check_min_max_dates
3944: (p_base_table_name => 'ben_pl_f',
3945: p_base_key_column => 'pl_id',
3946: p_base_key_value => p_pl_id,
3947: p_from_date => p_validation_start_date,

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

3995: -- Processing continues.
3996: --
3997: -- Post Failure:
3998: -- If a row exists by determining the returning Boolean value from the
3999: -- generic dt_api.rows_exist function then we must supply an error via
4000: -- the use of the local exception handler l_rows_exist.
4001: --
4002: -- Developer Implementation Notes:
4003: -- This procedure should not need maintenance unless the HR Schema model

Line 4057: If (dt_api.rows_exist

4053: (p_api_name => l_proc,
4054: p_argument => 'vrbl_rt_prfl_id',
4055: p_argument_value => p_vrbl_rt_prfl_id);
4056: --
4057: If (dt_api.rows_exist
4058: (p_base_table_name => 'BEN_VRBL_RT_ELIG_PRFL_F',
4059: p_base_key_column => 'vrbl_rt_prfl_id',
4060: p_base_key_value => p_vrbl_rt_prfl_id,
4061: p_from_date => p_validation_start_date,

Line 4067: If (dt_api.rows_exist

4063: l_table_name := 'BEN_VRBL_RT_ELIG_PRFL_F';
4064: Raise l_rows_exist;
4065: End If;
4066: --
4067: If (dt_api.rows_exist
4068: (p_base_table_name => 'ben_age_rt_f',
4069: p_base_key_column => 'vrbl_rt_prfl_id',
4070: p_base_key_value => p_vrbl_rt_prfl_id,
4071: p_from_date => p_validation_start_date,

Line 4076: If (dt_api.rows_exist

4072: p_to_date => p_validation_end_date)) Then
4073: l_table_name := 'ben_age_rt_f';
4074: Raise l_criteria_rows_exist;
4075: End If;
4076: If (dt_api.rows_exist
4077: (p_base_table_name => 'ben_benfts_grp_rt_f',
4078: p_base_key_column => 'vrbl_rt_prfl_id',
4079: p_base_key_value => p_vrbl_rt_prfl_id,
4080: p_from_date => p_validation_start_date,

Line 4085: If (dt_api.rows_exist

4081: p_to_date => p_validation_end_date)) Then
4082: l_table_name := 'ben_benfts_grp_rt_f';
4083: Raise l_criteria_rows_exist;
4084: End If;
4085: If (dt_api.rows_exist
4086: (p_base_table_name => 'ben_loa_rsn_rt_f',
4087: p_base_key_column => 'vrbl_rt_prfl_id',
4088: p_base_key_value => p_vrbl_rt_prfl_id,
4089: p_from_date => p_validation_start_date,

Line 4094: If (dt_api.rows_exist

4090: p_to_date => p_validation_end_date)) Then
4091: l_table_name := 'ben_loa_rsn_rt_f';
4092: Raise l_criteria_rows_exist;
4093: End If;
4094: If (dt_api.rows_exist
4095: (p_base_table_name => 'ben_los_rt_f',
4096: p_base_key_column => 'vrbl_rt_prfl_id',
4097: p_base_key_value => p_vrbl_rt_prfl_id,
4098: p_from_date => p_validation_start_date,

Line 4103: If (dt_api.rows_exist

4099: p_to_date => p_validation_end_date)) Then
4100: l_table_name := 'ben_los_rt_f';
4101: Raise l_criteria_rows_exist;
4102: End If;
4103: If (dt_api.rows_exist
4104: (p_base_table_name => 'ben_tbco_use_rt_f',
4105: p_base_key_column => 'vrbl_rt_prfl_id',
4106: p_base_key_value => p_vrbl_rt_prfl_id,
4107: p_from_date => p_validation_start_date,

Line 4112: If (dt_api.rows_exist

4108: p_to_date => p_validation_end_date)) Then
4109: l_table_name := 'ben_tbco_use_rt_f';
4110: Raise l_criteria_rows_exist;
4111: End If;
4112: If (dt_api.rows_exist
4113: (p_base_table_name => 'ben_pct_fl_tm_rt_f',
4114: p_base_key_column => 'vrbl_rt_prfl_id',
4115: p_base_key_value => p_vrbl_rt_prfl_id,
4116: p_from_date => p_validation_start_date,

Line 4121: If (dt_api.rows_exist

4117: p_to_date => p_validation_end_date)) Then
4118: l_table_name := 'ben_pct_fl_tm_rt_f';
4119: Raise l_criteria_rows_exist;
4120: End If;
4121: If (dt_api.rows_exist
4122: (p_base_table_name => 'ben_vrbl_rt_prfl_rl_f',
4123: p_base_key_column => 'vrbl_rt_prfl_id',
4124: p_base_key_value => p_vrbl_rt_prfl_id,
4125: p_from_date => p_validation_start_date,

Line 4130: If (dt_api.rows_exist

4126: p_to_date => p_validation_end_date)) Then
4127: l_table_name := 'ben_vrbl_rt_prfl_rl_f';
4128: Raise l_criteria_rows_exist;
4129: End If;
4130: If (dt_api.rows_exist
4131: (p_base_table_name => 'ben_wk_loc_rt_f',
4132: p_base_key_column => 'vrbl_rt_prfl_id',
4133: p_base_key_value => p_vrbl_rt_prfl_id,
4134: p_from_date => p_validation_start_date,

Line 4139: If (dt_api.rows_exist

4135: p_to_date => p_validation_end_date)) Then
4136: l_table_name := 'ben_wk_loc_rt_f';
4137: Raise l_criteria_rows_exist;
4138: End If;
4139: If (dt_api.rows_exist
4140: (p_base_table_name => 'ben_org_unit_rt_f',
4141: p_base_key_column => 'vrbl_rt_prfl_id',
4142: p_base_key_value => p_vrbl_rt_prfl_id,
4143: p_from_date => p_validation_start_date,

Line 4148: If (dt_api.rows_exist

4144: p_to_date => p_validation_end_date)) Then
4145: l_table_name := 'ben_org_unit_rt_f';
4146: Raise l_criteria_rows_exist;
4147: End If;
4148: If (dt_api.rows_exist
4149: (p_base_table_name => 'ben_comp_lvl_rt_f',
4150: p_base_key_column => 'vrbl_rt_prfl_id',
4151: p_base_key_value => p_vrbl_rt_prfl_id,
4152: p_from_date => p_validation_start_date,

Line 4157: If (dt_api.rows_exist

4153: p_to_date => p_validation_end_date)) Then
4154: l_table_name := 'ben_comp_lvl_rt_f';
4155: Raise l_criteria_rows_exist;
4156: End If;
4157: If (dt_api.rows_exist
4158: (p_base_table_name => 'ben_hrs_wkd_in_perd_rt_f',
4159: p_base_key_column => 'vrbl_rt_prfl_id',
4160: p_base_key_value => p_vrbl_rt_prfl_id,
4161: p_from_date => p_validation_start_date,

Line 4166: If (dt_api.rows_exist

4162: p_to_date => p_validation_end_date)) Then
4163: l_table_name := 'ben_hrs_wkd_in_perd_rt_f';
4164: Raise l_criteria_rows_exist;
4165: End If;
4166: If (dt_api.rows_exist
4167: (p_base_table_name => 'ben_grade_rt_f',
4168: p_base_key_column => 'vrbl_rt_prfl_id',
4169: p_base_key_value => p_vrbl_rt_prfl_id,
4170: p_from_date => p_validation_start_date,

Line 4175: If (dt_api.rows_exist

4171: p_to_date => p_validation_end_date)) Then
4172: l_table_name := 'ben_grade_rt_f';
4173: Raise l_criteria_rows_exist;
4174: End If;
4175: If (dt_api.rows_exist
4176: (p_base_table_name => 'ben_actl_prem_vrbl_rt_f',
4177: p_base_key_column => 'vrbl_rt_prfl_id',
4178: p_base_key_value => p_vrbl_rt_prfl_id,
4179: p_from_date => p_validation_start_date,

Line 4184: If (dt_api.rows_exist

4180: p_to_date => p_validation_end_date)) Then
4181: l_table_name := 'ben_actl_prem_vrbl_rt_f';
4182: Raise l_criteria_rows_exist;
4183: End If;
4184: If (dt_api.rows_exist
4185: (p_base_table_name => 'ben_bnft_vrbl_rt_f',
4186: p_base_key_column => 'vrbl_rt_prfl_id',
4187: p_base_key_value => p_vrbl_rt_prfl_id,
4188: p_from_date => p_validation_start_date,

Line 4193: If (dt_api.rows_exist

4189: p_to_date => p_validation_end_date)) Then
4190: l_table_name := 'ben_bnft_vrbl_rt_f';
4191: Raise l_rows_exist;
4192: End If;
4193: If (dt_api.rows_exist
4194: (p_base_table_name => 'ben_fl_tm_pt_tm_rt_f',
4195: p_base_key_column => 'vrbl_rt_prfl_id',
4196: p_base_key_value => p_vrbl_rt_prfl_id,
4197: p_from_date => p_validation_start_date,

Line 4202: If (dt_api.rows_exist

4198: p_to_date => p_validation_end_date)) Then
4199: l_table_name := 'ben_fl_tm_pt_tm_rt_f';
4200: Raise l_criteria_rows_exist;
4201: End If;
4202: If (dt_api.rows_exist
4203: (p_base_table_name => 'ben_lgl_enty_rt_f',
4204: p_base_key_column => 'vrbl_rt_prfl_id',
4205: p_base_key_value => p_vrbl_rt_prfl_id,
4206: p_from_date => p_validation_start_date,

Line 4211: If (dt_api.rows_exist

4207: p_to_date => p_validation_end_date)) Then
4208: l_table_name := 'ben_lgl_enty_rt_f';
4209: Raise l_criteria_rows_exist;
4210: End If;
4211: If (dt_api.rows_exist
4212: (p_base_table_name => 'ben_lbr_mmbr_rt_f',
4213: p_base_key_column => 'vrbl_rt_prfl_id',
4214: p_base_key_value => p_vrbl_rt_prfl_id,
4215: p_from_date => p_validation_start_date,

Line 4220: If (dt_api.rows_exist

4216: p_to_date => p_validation_end_date)) Then
4217: l_table_name := 'ben_lbr_mmbr_rt_f';
4218: Raise l_criteria_rows_exist;
4219: End If;
4220: If (dt_api.rows_exist
4221: (p_base_table_name => 'ben_svc_area_rt_f',
4222: p_base_key_column => 'vrbl_rt_prfl_id',
4223: p_base_key_value => p_vrbl_rt_prfl_id,
4224: p_from_date => p_validation_start_date,

Line 4229: If (dt_api.rows_exist

4225: p_to_date => p_validation_end_date)) Then
4226: l_table_name := 'ben_svc_area_rt_f';
4227: Raise l_criteria_rows_exist;
4228: End If;
4229: If (dt_api.rows_exist
4230: (p_base_table_name => 'ben_py_bss_rt_f',
4231: p_base_key_column => 'vrbl_rt_prfl_id',
4232: p_base_key_value => p_vrbl_rt_prfl_id,
4233: p_from_date => p_validation_start_date,

Line 4238: If (dt_api.rows_exist

4234: p_to_date => p_validation_end_date)) Then
4235: l_table_name := 'ben_py_bss_rt_f';
4236: Raise l_criteria_rows_exist;
4237: End If;
4238: If (dt_api.rows_exist
4239: (p_base_table_name => 'ben_pyrl_rt_f',
4240: p_base_key_column => 'vrbl_rt_prfl_id',
4241: p_base_key_value => p_vrbl_rt_prfl_id,
4242: p_from_date => p_validation_start_date,

Line 4247: If (dt_api.rows_exist

4243: p_to_date => p_validation_end_date)) Then
4244: l_table_name := 'ben_pyrl_rt_f';
4245: Raise l_criteria_rows_exist;
4246: End If;
4247: If (dt_api.rows_exist
4248: (p_base_table_name => 'ben_pstl_zip_rt_f',
4249: p_base_key_column => 'vrbl_rt_prfl_id',
4250: p_base_key_value => p_vrbl_rt_prfl_id,
4251: p_from_date => p_validation_start_date,

Line 4256: If (dt_api.rows_exist

4252: p_to_date => p_validation_end_date)) Then
4253: l_table_name := 'ben_pstl_zip_rt_f';
4254: Raise l_criteria_rows_exist;
4255: End If;
4256: If (dt_api.rows_exist
4257: (p_base_table_name => 'ben_per_typ_rt_f',
4258: p_base_key_column => 'vrbl_rt_prfl_id',
4259: p_base_key_value => p_vrbl_rt_prfl_id,
4260: p_from_date => p_validation_start_date,

Line 4265: If (dt_api.rows_exist

4261: p_to_date => p_validation_end_date)) Then
4262: l_table_name := 'ben_per_typ_rt_f';
4263: Raise l_criteria_rows_exist;
4264: End If;
4265: If (dt_api.rows_exist
4266: (p_base_table_name => 'ben_hrly_slrd_rt_f',
4267: p_base_key_column => 'vrbl_rt_prfl_id',
4268: p_base_key_value => p_vrbl_rt_prfl_id,
4269: p_from_date => p_validation_start_date,

Line 4274: If (dt_api.rows_exist

4270: p_to_date => p_validation_end_date)) Then
4271: l_table_name := 'ben_hrly_slrd_rt_f';
4272: Raise l_criteria_rows_exist;
4273: End If;
4274: If (dt_api.rows_exist
4275: (p_base_table_name => 'ben_gndr_rt_f',
4276: p_base_key_column => 'vrbl_rt_prfl_id',
4277: p_base_key_value => p_vrbl_rt_prfl_id,
4278: p_from_date => p_validation_start_date,

Line 4283: If (dt_api.rows_exist

4279: p_to_date => p_validation_end_date)) Then
4280: l_table_name := 'ben_gndr_rt_f';
4281: Raise l_criteria_rows_exist;
4282: End If;
4283: If (dt_api.rows_exist
4284: (p_base_table_name => 'ben_cmbn_age_los_rt_f',
4285: p_base_key_column => 'vrbl_rt_prfl_id',
4286: p_base_key_value => p_vrbl_rt_prfl_id,
4287: p_from_date => p_validation_start_date,

Line 4292: If (dt_api.rows_exist

4288: p_to_date => p_validation_end_date)) Then
4289: l_table_name := 'ben_cmbn_age_los_rt_f';
4290: Raise l_criteria_rows_exist;
4291: End If;
4292: If (dt_api.rows_exist
4293: (p_base_table_name => 'ben_brgng_unit_rt_f',
4294: p_base_key_column => 'vrbl_rt_prfl_id',
4295: p_base_key_value => p_vrbl_rt_prfl_id,
4296: p_from_date => p_validation_start_date,

Line 4301: If (dt_api.rows_exist

4297: p_to_date => p_validation_end_date)) Then
4298: l_table_name := 'ben_brgng_unit_rt_f';
4299: Raise l_criteria_rows_exist;
4300: End If;
4301: If (dt_api.rows_exist
4302: (p_base_table_name => 'ben_asnt_set_rt_f',
4303: p_base_key_column => 'vrbl_rt_prfl_id',
4304: p_base_key_value => p_vrbl_rt_prfl_id,
4305: p_from_date => p_validation_start_date,

Line 4310: If (dt_api.rows_exist

4306: p_to_date => p_validation_end_date)) Then
4307: l_table_name := 'ben_asnt_set_rt_f';
4308: Raise l_criteria_rows_exist;
4309: End If;
4310: If (dt_api.rows_exist
4311: (p_base_table_name => 'ben_acty_vrbl_rt_f',
4312: p_base_key_column => 'vrbl_rt_prfl_id',
4313: p_base_key_value => p_vrbl_rt_prfl_id,
4314: p_from_date => p_validation_start_date,

Line 4319: If (dt_api.rows_exist

4315: p_to_date => p_validation_end_date)) Then
4316: l_table_name := 'ben_acty_vrbl_rt_f';
4317: Raise l_rows_exist;
4318: End If;
4319: If (dt_api.rows_exist
4320: (p_base_table_name => 'ben_ppl_grp_rt_f',
4321: p_base_key_column => 'vrbl_rt_prfl_id',
4322: p_base_key_value => p_vrbl_rt_prfl_id,
4323: p_from_date => p_validation_start_date,

Line 4329: If (dt_api.rows_exist

4325: l_table_name := 'ben_ppl_grp_rt_f';
4326: Raise l_criteria_rows_exist;
4327: End If;
4328:
4329: If (dt_api.rows_exist
4330: (p_base_table_name => 'BEN_CBR_QUALD_BNF_RT_F',
4331: p_base_key_column => 'vrbl_rt_prfl_id',
4332: p_base_key_value => p_vrbl_rt_prfl_id,
4333: p_from_date => p_validation_start_date,

Line 4339: If (dt_api.rows_exist

4335: l_table_name := 'ben_cbr_quald_bnf_rt_f';
4336: Raise l_criteria_rows_exist;
4337: End If;
4338:
4339: If (dt_api.rows_exist
4340: (p_base_table_name => 'BEN_CNTNG_PRTN_PRFL_RT_F',
4341: p_base_key_column => 'vrbl_rt_prfl_id',
4342: p_base_key_value => p_vrbl_rt_prfl_id,
4343: p_from_date => p_validation_start_date,

Line 4348: If (dt_api.rows_exist

4344: p_to_date => p_validation_end_date)) Then
4345: l_table_name := 'ben_cntng_prtn_prfl_rt_f';
4346: Raise l_criteria_rows_exist;
4347: End If;
4348: If (dt_api.rows_exist
4349: (p_base_table_name => 'BEN_COMPTNCY_RT_F',
4350: p_base_key_column => 'vrbl_rt_prfl_id',
4351: p_base_key_value => p_vrbl_rt_prfl_id,
4352: p_from_date => p_validation_start_date,

Line 4357: If (dt_api.rows_exist

4353: p_to_date => p_validation_end_date)) Then
4354: l_table_name := 'ben_comptncy_rt_f';
4355: Raise l_criteria_rows_exist;
4356: End If;
4357: If (dt_api.rows_exist
4358: (p_base_table_name => 'BEN_JOB_RT_F',
4359: p_base_key_column => 'vrbl_rt_prfl_id',
4360: p_base_key_value => p_vrbl_rt_prfl_id,
4361: p_from_date => p_validation_start_date,

Line 4366: If (dt_api.rows_exist

4362: p_to_date => p_validation_end_date)) Then
4363: l_table_name := 'ben_job_rt_f';
4364: Raise l_criteria_rows_exist;
4365: End If;
4366: If (dt_api.rows_exist
4367: (p_base_table_name => 'BEN_LVG_RSN_RT_F',
4368: p_base_key_column => 'vrbl_rt_prfl_id',
4369: p_base_key_value => p_vrbl_rt_prfl_id,
4370: p_from_date => p_validation_start_date,

Line 4375: If (dt_api.rows_exist

4371: p_to_date => p_validation_end_date)) Then
4372: l_table_name := 'ben_lvg_rsn_rt_f';
4373: Raise l_criteria_rows_exist;
4374: End If;
4375: If (dt_api.rows_exist
4376: (p_base_table_name => 'BEN_OPTD_MDCR_RT_F',
4377: p_base_key_column => 'vrbl_rt_prfl_id',
4378: p_base_key_value => p_vrbl_rt_prfl_id,
4379: p_from_date => p_validation_start_date,

Line 4384: If (dt_api.rows_exist

4380: p_to_date => p_validation_end_date)) Then
4381: l_table_name := 'ben_optd_mdcr_rt_f';
4382: Raise l_criteria_rows_exist;
4383: End If;
4384: If (dt_api.rows_exist
4385: (p_base_table_name => 'BEN_PSTN_RT_F',
4386: p_base_key_column => 'vrbl_rt_prfl_id',
4387: p_base_key_value => p_vrbl_rt_prfl_id,
4388: p_from_date => p_validation_start_date,

Line 4393: If (dt_api.rows_exist

4389: p_to_date => p_validation_end_date)) Then
4390: l_table_name := 'ben_pstn_rt_f';
4391: Raise l_criteria_rows_exist;
4392: End If;
4393: If (dt_api.rows_exist
4394: (p_base_table_name => 'BEN_DPNT_CVRD_OTHR_PGM_RT_F',
4395: p_base_key_column => 'vrbl_rt_prfl_id',
4396: p_base_key_value => p_vrbl_rt_prfl_id,
4397: p_from_date => p_validation_start_date,

Line 4402: If (dt_api.rows_exist

4398: p_to_date => p_validation_end_date)) Then
4399: l_table_name := 'ben_dpnt_cvrd_othr_pgm_rt_f';
4400: Raise l_criteria_rows_exist;
4401: End If;
4402: If (dt_api.rows_exist
4403: (p_base_table_name => 'BEN_DPNT_CVRD_OTHR_PL_RT_F',
4404: p_base_key_column => 'vrbl_rt_prfl_id',
4405: p_base_key_value => p_vrbl_rt_prfl_id,
4406: p_from_date => p_validation_start_date,

Line 4411: If (dt_api.rows_exist

4407: p_to_date => p_validation_end_date)) Then
4408: l_table_name := 'ben_dpnt_cvrd_othr_pl_rt_f';
4409: Raise l_criteria_rows_exist;
4410: End If;
4411: If (dt_api.rows_exist
4412: (p_base_table_name => 'BEN_DPNT_CVRD_OTHR_PTIP_RT_F',
4413: p_base_key_column => 'vrbl_rt_prfl_id',
4414: p_base_key_value => p_vrbl_rt_prfl_id,
4415: p_from_date => p_validation_start_date,

Line 4420: If (dt_api.rows_exist

4416: p_to_date => p_validation_end_date)) Then
4417: l_table_name := 'ben_dpnt_cvrd_othr_ptip_rt_f';
4418: Raise l_criteria_rows_exist;
4419: End If;
4420: If (dt_api.rows_exist
4421: (p_base_table_name => 'BEN_DPNT_CVRD_PLIP_RT_F',
4422: p_base_key_column => 'vrbl_rt_prfl_id',
4423: p_base_key_value => p_vrbl_rt_prfl_id,
4424: p_from_date => p_validation_start_date,

Line 4429: If (dt_api.rows_exist

4425: p_to_date => p_validation_end_date)) Then
4426: l_table_name := 'ben_dpnt_cvrd_othr_plip_rt_f';
4427: Raise l_criteria_rows_exist;
4428: End If;
4429: If (dt_api.rows_exist
4430: (p_base_table_name => 'BEN_DPNT_OTHR_PTIP_RT_F',
4431: p_base_key_column => 'vrbl_rt_prfl_id',
4432: p_base_key_value => p_vrbl_rt_prfl_id,
4433: p_from_date => p_validation_start_date,

Line 4438: If (dt_api.rows_exist

4434: p_to_date => p_validation_end_date)) Then
4435: l_table_name := 'ben_dpnt_othr_ptip_rt_f';
4436: Raise l_criteria_rows_exist;
4437: End If;
4438: If (dt_api.rows_exist
4439: (p_base_table_name => 'BEN_QUA_IN_GR_RT_F',
4440: p_base_key_column => 'vrbl_rt_prfl_id',
4441: p_base_key_value => p_vrbl_rt_prfl_id,
4442: p_from_date => p_validation_start_date,

Line 4447: If (dt_api.rows_exist

4443: p_to_date => p_validation_end_date)) Then
4444: l_table_name := 'ben_qua_in_gr_rt_f';
4445: Raise l_criteria_rows_exist;
4446: End If;
4447: If (dt_api.rows_exist
4448: (p_base_table_name => 'BEN_PERF_RTNG_RT_F',
4449: p_base_key_column => 'vrbl_rt_prfl_id',
4450: p_base_key_value => p_vrbl_rt_prfl_id,
4451: p_from_date => p_validation_start_date,

Line 4457: If (dt_api.rows_exist

4453: l_table_name := 'ben_perf_rtng_rt_f';
4454: Raise l_criteria_rows_exist;
4455: End If;
4456:
4457: If (dt_api.rows_exist
4458: (p_base_table_name => 'BEN_ENRLD_ANTHR_OIPL_RT_F',
4459: p_base_key_column => 'vrbl_rt_prfl_id',
4460: p_base_key_value => p_vrbl_rt_prfl_id,
4461: p_from_date => p_validation_start_date,

Line 4466: If (dt_api.rows_exist

4462: p_to_date => p_validation_end_date)) Then
4463: l_table_name := 'ben_enrld_anthr_oipl_rt_f';
4464: Raise l_criteria_rows_exist;
4465: End If;
4466: If (dt_api.rows_exist
4467: (p_base_table_name => 'BEN_ENRLD_ANTHR_PGM_RT_F',
4468: p_base_key_column => 'vrbl_rt_prfl_id',
4469: p_base_key_value => p_vrbl_rt_prfl_id,
4470: p_from_date => p_validation_start_date,

Line 4475: If (dt_api.rows_exist

4471: p_to_date => p_validation_end_date)) Then
4472: l_table_name := 'ben_enrld_anthr_pgm_rt_f';
4473: Raise l_criteria_rows_exist;
4474: End If;
4475: If (dt_api.rows_exist
4476: (p_base_table_name => 'BEN_ENRLD_ANTHR_PLIP_RT_F',
4477: p_base_key_column => 'vrbl_rt_prfl_id',
4478: p_base_key_value => p_vrbl_rt_prfl_id,
4479: p_from_date => p_validation_start_date,

Line 4484: If (dt_api.rows_exist

4480: p_to_date => p_validation_end_date)) Then
4481: l_table_name := 'ben_enrld_anthr_plip_rt_f';
4482: Raise l_criteria_rows_exist;
4483: End If;
4484: If (dt_api.rows_exist
4485: (p_base_table_name => 'BEN_ENRLD_ANTHR_PL_RT_F',
4486: p_base_key_column => 'vrbl_rt_prfl_id',
4487: p_base_key_value => p_vrbl_rt_prfl_id,
4488: p_from_date => p_validation_start_date,

Line 4493: If (dt_api.rows_exist

4489: p_to_date => p_validation_end_date)) Then
4490: l_table_name := 'ben_enrld_anthr_pl_rt_f';
4491: Raise l_criteria_rows_exist;
4492: End If;
4493: If (dt_api.rows_exist
4494: (p_base_table_name => 'BEN_ENRLD_ANTHR_PTIP_RT_F',
4495: p_base_key_column => 'vrbl_rt_prfl_id',
4496: p_base_key_value => p_vrbl_rt_prfl_id,
4497: p_from_date => p_validation_start_date,

Line 4502: If (dt_api.rows_exist

4498: p_to_date => p_validation_end_date)) Then
4499: l_table_name := 'ben_enrld_anthr_ptip_rt_f';
4500: Raise l_criteria_rows_exist;
4501: End If;
4502: If (dt_api.rows_exist
4503: (p_base_table_name => 'BEN_NO_OTHR_CVG_RT_F',
4504: p_base_key_column => 'vrbl_rt_prfl_id',
4505: p_base_key_value => p_vrbl_rt_prfl_id,
4506: p_from_date => p_validation_start_date,

Line 4511: If (dt_api.rows_exist

4507: p_to_date => p_validation_end_date)) Then
4508: l_table_name := 'ben_no_othr_cvg_rt_f';
4509: Raise l_criteria_rows_exist;
4510: End If;
4511: If (dt_api.rows_exist
4512: (p_base_table_name => 'BEN_OTHR_PTIP_RT_F',
4513: p_base_key_column => 'vrbl_rt_prfl_id',
4514: p_base_key_value => p_vrbl_rt_prfl_id,
4515: p_from_date => p_validation_start_date,

Line 4520: If (dt_api.rows_exist

4516: p_to_date => p_validation_end_date)) Then
4517: l_table_name := 'ben_othr_ptip_rt_f';
4518: Raise l_criteria_rows_exist;
4519: End If;
4520: If (dt_api.rows_exist
4521: (p_base_table_name => 'BEN_PRTT_ANTHR_PL_RT_F',
4522: p_base_key_column => 'vrbl_rt_prfl_id',
4523: p_base_key_value => p_vrbl_rt_prfl_id,
4524: p_from_date => p_validation_start_date,

Line 4529: If (dt_api.rows_exist

4525: p_to_date => p_validation_end_date)) Then
4526: l_table_name := 'ben_prtt_anthr_pl_rt_f';
4527: Raise l_criteria_rows_exist;
4528: End If;
4529: If (dt_api.rows_exist
4530: (p_base_table_name => 'BEN_QUAL_TITL_RT_F',
4531: p_base_key_column => 'vrbl_rt_prfl_id',
4532: p_base_key_value => p_vrbl_rt_prfl_id,
4533: p_from_date => p_validation_start_date,

Line 4542: If (dt_api.rows_exist

4538: --
4539: --
4540: --Bug : 3476138
4541: --
4542: If (dt_api.rows_exist
4543: (p_base_table_name => 'ben_bnft_vrbl_rt_f',
4544: p_base_key_column => 'vrbl_rt_prfl_id',
4545: p_base_key_value => p_vrbl_rt_prfl_id,
4546: p_from_date => p_validation_start_date,

Line 4553: If (dt_api.rows_exist

4549: Raise l_rows_exist;
4550: End If;
4551: --
4552: --
4553: If (dt_api.rows_exist
4554: (p_base_table_name => 'ben_acty_vrbl_rt_f',
4555: p_base_key_column => 'vrbl_rt_prfl_id',
4556: p_base_key_value => p_vrbl_rt_prfl_id,
4557: p_from_date => p_validation_start_date,

Line 4564: If (dt_api.rows_exist

4560: Raise l_rows_exist;
4561: End If;
4562: --
4563: --
4564: If (dt_api.rows_exist
4565: (p_base_table_name => 'ben_actl_prem_vrbl_rt_f',
4566: p_base_key_column => 'vrbl_rt_prfl_id',
4567: p_base_key_value => p_vrbl_rt_prfl_id,
4568: p_from_date => p_validation_start_date,

Line 4575: If (dt_api.rows_exist

4571: Raise l_rows_exist;
4572: End If;
4573: --
4574: --
4575: If (dt_api.rows_exist
4576: (p_base_table_name => 'ben_vrbl_rt_elig_prfl_f',
4577: p_base_key_column => 'vrbl_rt_prfl_id',
4578: p_base_key_value => p_vrbl_rt_prfl_id,
4579: p_from_date => p_validation_start_date,

Line 4591: If (dt_api.rows_exist

4587: --
4588: --Bug : 6123832
4589: --
4590: --
4591: If (dt_api.rows_exist
4592: (p_base_table_name => 'ben_dsbld_rt_f',
4593: p_base_key_column => 'vrbl_rt_prfl_id',
4594: p_base_key_value => p_vrbl_rt_prfl_id,
4595: p_from_date => p_validation_start_date,

Line 4602: If (dt_api.rows_exist

4598: Raise l_rows_exist;
4599: End If;
4600: --
4601: --
4602: If (dt_api.rows_exist
4603: (p_base_table_name => 'ben_ee_stat_rt_f',
4604: p_base_key_column => 'vrbl_rt_prfl_id',
4605: p_base_key_value => p_vrbl_rt_prfl_id,
4606: p_from_date => p_validation_start_date,

Line 4613: If (dt_api.rows_exist

4609: Raise l_rows_exist;
4610: End If;
4611: --
4612: --
4613: If (dt_api.rows_exist
4614: (p_base_table_name => 'ben_poe_rt_f',
4615: p_base_key_column => 'vrbl_rt_prfl_id',
4616: p_base_key_value => p_vrbl_rt_prfl_id,
4617: p_from_date => p_validation_start_date,

Line 4624: If (dt_api.rows_exist

4620: Raise l_rows_exist;
4621: End If;
4622: --
4623: --
4624: If (dt_api.rows_exist
4625: (p_base_table_name => 'ben_schedd_hrs_rt_f',
4626: p_base_key_column => 'vrbl_rt_prfl_id',
4627: p_base_key_value => p_vrbl_rt_prfl_id,
4628: p_from_date => p_validation_start_date,

Line 4635: If (dt_api.rows_exist

4631: Raise l_rows_exist;
4632: End If;
4633: --
4634: --
4635: If (dt_api.rows_exist
4636: (p_base_table_name => 'ben_ttl_cvg_vol_rt_f',
4637: p_base_key_column => 'vrbl_rt_prfl_id',
4638: p_base_key_value => p_vrbl_rt_prfl_id,
4639: p_from_date => p_validation_start_date,

Line 4646: If (dt_api.rows_exist

4642: Raise l_rows_exist;
4643: End If;
4644: --
4645: --
4646: If (dt_api.rows_exist
4647: (p_base_table_name => 'ben_ttl_prtt_rt_f',
4648: p_base_key_column => 'vrbl_rt_prfl_id',
4649: p_base_key_value => p_vrbl_rt_prfl_id,
4650: p_from_date => p_validation_start_date,

Line 4657: If (dt_api.rows_exist

4653: Raise l_rows_exist;
4654: End If;
4655: --
4656: --
4657: If (dt_api.rows_exist
4658: (p_base_table_name => 'ben_vrbl_rt_prfl_rl_f',
4659: p_base_key_column => 'vrbl_rt_prfl_id',
4660: p_base_key_value => p_vrbl_rt_prfl_id,
4661: p_from_date => p_validation_start_date,