eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ABR_BUS dependencies on DT_API

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

4415: p_argument_value => p_datetrack_mode);
4416: --
4417: -- Only perform the validation if the datetrack update mode is valid
4418: --
4419: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
4420: --
4421: --
4422: -- Ensure the arguments are not null
4423: --

Line 4435: NOT (dt_api.check_min_max_dates

4431: p_argument => 'validation_end_date',
4432: p_argument_value => p_validation_end_date);
4433: --
4434: If ((nvl(p_prtl_mo_det_mthd_rl, hr_api.g_number) <> hr_api.g_number) and
4435: NOT (dt_api.check_min_max_dates
4436: (p_base_table_name => 'ff_formulas_f',
4437: p_base_key_column => 'formula_id',
4438: p_base_key_value => p_prtl_mo_det_mthd_rl,
4439: p_from_date => p_validation_start_date,

Line 4445: NOT (dt_api.check_min_max_dates

4441: l_table_name := 'ff_formulas_f';
4442: Raise l_integrity_error;
4443: End If;
4444: If ((nvl(p_prtl_mo_eff_dt_det_rl, hr_api.g_number) <> hr_api.g_number) and
4445: NOT (dt_api.check_min_max_dates
4446: (p_base_table_name => 'ff_formulas_f',
4447: p_base_key_column => 'formula_id',
4448: p_base_key_value => p_prtl_mo_eff_dt_det_rl,
4449: p_from_date => p_validation_start_date,

Line 4455: NOT (dt_api.check_min_max_dates

4451: l_table_name := 'ff_formulas_f';
4452: Raise l_integrity_error;
4453: End If;
4454: If ((nvl(p_rndg_rl, hr_api.g_number) <> hr_api.g_number) and
4455: NOT (dt_api.check_min_max_dates
4456: (p_base_table_name => 'ff_formulas_f',
4457: p_base_key_column => 'formula_id',
4458: p_base_key_value => p_rndg_rl,
4459: p_from_date => p_validation_start_date,

Line 4465: NOT (dt_api.check_min_max_dates

4461: l_table_name := 'ff_formulas_f';
4462: Raise l_integrity_error;
4463: End If;
4464: If ((nvl(p_lwr_lmt_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4465: NOT (dt_api.check_min_max_dates
4466: (p_base_table_name => 'ff_formulas_f',
4467: p_base_key_column => 'formula_id',
4468: p_base_key_value => p_lwr_lmt_calc_rl,
4469: p_from_date => p_validation_start_date,

Line 4475: NOT (dt_api.check_min_max_dates

4471: l_table_name := 'ff_formulas_f';
4472: Raise l_integrity_error;
4473: End If;
4474: If ((nvl(p_upr_lmt_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4475: NOT (dt_api.check_min_max_dates
4476: (p_base_table_name => 'ff_formulas_f',
4477: p_base_key_column => 'formula_id',
4478: p_base_key_value => p_upr_lmt_calc_rl,
4479: p_from_date => p_validation_start_date,

Line 4485: NOT (dt_api.check_min_max_dates

4481: l_table_name := 'ff_formulas_f';
4482: Raise l_integrity_error;
4483: End If;
4484: If ((nvl(p_val_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4485: NOT (dt_api.check_min_max_dates
4486: (p_base_table_name => 'ff_formulas_f',
4487: p_base_key_column => 'formula_id',
4488: p_base_key_value => p_val_calc_rl,
4489: p_from_date => p_validation_start_date,

Line 4495: NOT (dt_api.check_min_max_dates

4491: l_table_name := 'ff_formulas_f';
4492: Raise l_integrity_error;
4493: End If;
4494: If ((nvl(p_vstg_for_acty_rt_id, hr_api.g_number) <> hr_api.g_number) and
4495: NOT (dt_api.check_min_max_dates
4496: (p_base_table_name => 'ben_vstg_for_acty_rt_f',
4497: p_base_key_column => 'vstg_for_acty_rt_id',
4498: p_base_key_value => p_vstg_for_acty_rt_id,
4499: p_from_date => p_validation_start_date,

Line 4505: NOT (dt_api.check_min_max_dates

4501: l_table_name := 'ben_vstg_for_acty_rt_f';
4502: Raise l_integrity_error;
4503: End If;
4504: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
4505: NOT (dt_api.check_min_max_dates
4506: (p_base_table_name => 'ben_actl_prem_f',
4507: p_base_key_column => 'actl_prem_id',
4508: p_base_key_value => p_actl_prem_id,
4509: p_from_date => p_validation_start_date,

Line 4515: NOT (dt_api.check_min_max_dates

4511: l_table_name := 'ben_vstg_for_acty_rt_f';
4512: Raise l_integrity_error;
4513: End If;
4514: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
4515: NOT (dt_api.check_min_max_dates
4516: (p_base_table_name => 'ben_pgm_f',
4517: p_base_key_column => 'pgm_id',
4518: p_base_key_value => p_pgm_id,
4519: p_from_date => p_validation_start_date,

Line 4525: NOT (dt_api.check_min_max_dates

4521: l_table_name := 'ben_pgm_f';
4522: Raise l_integrity_error;
4523: End If;
4524: If ((nvl(p_parnt_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
4525: NOT (dt_api.check_min_max_dates
4526: (p_base_table_name => 'ben_acty_base_rt_f',
4527: p_base_key_column => 'acty_base_rt_id',
4528: p_base_key_value => p_parnt_acty_base_rt_id,
4529: p_from_date => p_validation_start_date,

Line 4535: NOT (dt_api.check_min_max_dates

4531: l_table_name := 'ben_acty_base_rt_f';
4532: Raise l_integrity_error;
4533: End If;
4534: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
4535: NOT (dt_api.check_min_max_dates
4536: (p_base_table_name => 'ben_ptip_f',
4537: p_base_key_column => 'ptip_id',
4538: p_base_key_value => p_ptip_id,
4539: p_from_date => p_validation_start_date,

Line 4545: NOT (dt_api.check_min_max_dates

4541: l_table_name := 'ben_ptip_f';
4542: Raise l_integrity_error;
4543: End If;
4544: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
4545: NOT (dt_api.check_min_max_dates
4546: (p_base_table_name => 'ben_oipl_f',
4547: p_base_key_column => 'oipl_id',
4548: p_base_key_value => p_oipl_id,
4549: p_from_date => p_validation_start_date,

Line 4555: NOT (dt_api.check_min_max_dates

4551: l_table_name := 'ben_oipl_f';
4552: Raise l_integrity_error;
4553: End If;
4554: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
4555: NOT (dt_api.check_min_max_dates
4556: (p_base_table_name => 'ben_opt_f',
4557: p_base_key_column => 'opt_id',
4558: p_base_key_value => p_opt_id,
4559: p_from_date => p_validation_start_date,

Line 4565: NOT (dt_api.check_min_max_dates

4561: l_table_name := 'ben_opt_f';
4562: Raise l_integrity_error;
4563: End If;
4564: If ((nvl(p_oiplip_id, hr_api.g_number) <> hr_api.g_number) and
4565: NOT (dt_api.check_min_max_dates
4566: (p_base_table_name => 'ben_oiplip_f',
4567: p_base_key_column => 'oiplip_id',
4568: p_base_key_value => p_oiplip_id,
4569: p_from_date => p_validation_start_date,

Line 4575: NOT (dt_api.check_min_max_dates

4571: l_table_name := 'ben_oiplip_f';
4572: Raise l_integrity_error;
4573: End If;
4574: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
4575: NOT (dt_api.check_min_max_dates
4576: (p_base_table_name => 'ben_plip_f',
4577: p_base_key_column => 'plip_id',
4578: p_base_key_value => p_plip_id,
4579: p_from_date => p_validation_start_date,

Line 4585: NOT (dt_api.check_min_max_dates

4581: l_table_name := 'ben_plip_f';
4582: Raise l_integrity_error;
4583: End If;
4584: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
4585: NOT (dt_api.check_min_max_dates
4586: (p_base_table_name => 'ben_pl_f',
4587: p_base_key_column => 'pl_id',
4588: p_base_key_value => p_pl_id,
4589: p_from_date => p_validation_start_date,

Line 4597: NOT (dt_api.check_min_max_dates

4593: End If;
4594: -- ELEMENT_TYPE
4595: -- Bug: 5367301 start
4596: If ((nvl(p_element_type_id, hr_api.g_number) <> hr_api.g_number) and
4597: NOT (dt_api.check_min_max_dates
4598: (p_base_table_name => 'pay_element_types_f',
4599: p_base_key_column => 'element_type_id',
4600: p_base_key_value => p_element_type_id,
4601: p_from_date => p_validation_start_date,

Line 4608: NOT (dt_api.check_min_max_dates

4604: Raise l_integrity_error;
4605: End If;
4606: --
4607: If ((nvl(p_input_va_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4608: NOT (dt_api.check_min_max_dates
4609: (p_base_table_name => 'ff_formulas_f',
4610: p_base_key_column => 'formula_id',
4611: p_base_key_value => p_input_va_calc_rl,
4612: p_from_date => p_validation_start_date,

Line 4619: NOT (dt_api.check_min_max_dates

4615: Raise l_integrity_error;
4616: End If;
4617: --
4618: If ((nvl(p_element_det_rl, hr_api.g_number) <> hr_api.g_number) and
4619: NOT (dt_api.check_min_max_dates
4620: (p_base_table_name => 'ff_formulas_f',
4621: p_base_key_column => 'formula_id',
4622: p_base_key_value => p_element_det_rl,
4623: p_from_date => p_validation_start_date,

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

4675: -- Processing continues.
4676: --
4677: -- Post Failure:
4678: -- If a row exists by determining the returning Boolean value from the
4679: -- generic dt_api.rows_exist function then we must supply an error via
4680: -- the use of the local exception handler l_rows_exist.
4681: --
4682: -- Developer Implementation Notes:
4683: -- This procedure should not need maintenance unless the HR Schema model

Line 4735: If (dt_api.rows_exist

4731: (p_api_name => l_proc,
4732: p_argument => 'acty_base_rt_id',
4733: p_argument_value => p_acty_base_rt_id);
4734: --
4735: If (dt_api.rows_exist
4736: (p_base_table_name => 'ben_acty_rt_ptd_lmt_f',
4737: p_base_key_column => 'acty_base_rt_id',
4738: p_base_key_value => p_acty_base_rt_id,
4739: p_from_date => p_validation_start_date,

Line 4744: If (dt_api.rows_exist

4740: p_to_date => p_validation_end_date)) Then
4741: l_table_name := 'ben_acty_rt_ptd_lmt_f';
4742: Raise l_rows_exist;
4743: End If;
4744: If (dt_api.rows_exist
4745: (p_base_table_name => 'ben_acty_rt_pymt_sched_f',
4746: p_base_key_column => 'acty_base_rt_id',
4747: p_base_key_value => p_acty_base_rt_id,
4748: p_from_date => p_validation_start_date,

Line 4753: If (dt_api.rows_exist

4749: p_to_date => p_validation_end_date)) Then
4750: l_table_name := 'ben_acty_rt_pymt_sched_f';
4751: Raise l_rows_exist;
4752: End If;
4753: If (dt_api.rows_exist
4754: (p_base_table_name => 'ben_acty_base_rt_f',
4755: p_base_key_column => 'parnt_acty_base_rt_id',
4756: p_base_key_value => p_acty_base_rt_id,
4757: p_from_date => p_validation_start_date,

Line 4762: If (dt_api.rows_exist

4758: p_to_date => p_validation_end_date)) Then
4759: l_table_name := 'ben_acty_base_rt_f';
4760: Raise l_rows_exist;
4761: End If;
4762: If (dt_api.rows_exist
4763: (p_base_table_name => 'ben_acty_vrbl_rt_f',
4764: p_base_key_column => 'acty_base_rt_id',
4765: p_base_key_value => p_acty_base_rt_id,
4766: p_from_date => p_validation_start_date,

Line 4771: If (dt_api.rows_exist

4767: p_to_date => p_validation_end_date)) Then
4768: l_table_name := 'ben_acty_vrbl_rt_f';
4769: Raise l_rows_exist;
4770: End If;
4771: If (dt_api.rows_exist
4772: (p_base_table_name => 'ben_prtl_mo_rt_prtn_val_f',
4773: p_base_key_column => 'acty_base_rt_id',
4774: p_base_key_value => p_acty_base_rt_id,
4775: p_from_date => p_validation_start_date,

Line 4780: If (dt_api.rows_exist

4776: p_to_date => p_validation_end_date)) Then
4777: l_table_name := 'ben_prtl_mo_rt_prtn_val_f';
4778: Raise l_rows_exist;
4779: End If;
4780: If (dt_api.rows_exist
4781: (p_base_table_name => 'ben_mtchg_rt_f',
4782: p_base_key_column => 'acty_base_rt_id',
4783: p_base_key_value => p_acty_base_rt_id,
4784: p_from_date => p_validation_start_date,

Line 4789: If (dt_api.rows_exist

4785: p_to_date => p_validation_end_date)) Then
4786: l_table_name := 'ben_mtchg_rt_f';
4787: Raise l_rows_exist;
4788: End If;
4789: If (dt_api.rows_exist
4790: (p_base_table_name => 'ben_bnft_prvdd_ldgr_f',
4791: p_base_key_column => 'acty_base_rt_id',
4792: p_base_key_value => p_acty_base_rt_id,
4793: p_from_date => p_validation_start_date,

Line 4798: If (dt_api.rows_exist

4794: p_to_date => p_validation_end_date)) Then
4795: l_table_name := 'ben_bnft_prvdd_ldgr_f';
4796: Raise l_rows_exist;
4797: End If;
4798: If (dt_api.rows_exist
4799: (p_base_table_name => 'ben_bnft_pool_rlovr_rqmt_f',
4800: p_base_key_column => 'acty_base_rt_id',
4801: p_base_key_value => p_acty_base_rt_id,
4802: p_from_date => p_validation_start_date,

Line 4807: If (dt_api.rows_exist

4803: p_to_date => p_validation_end_date)) Then
4804: l_table_name := 'ben_bnft_pool_rlovr_rqmt_f';
4805: Raise l_rows_exist;
4806: End If;
4807: If (dt_api.rows_exist
4808: (p_base_table_name => 'ben_aplcn_to_bnft_pool_f',
4809: p_base_key_column => 'acty_base_rt_id',
4810: p_base_key_value => p_acty_base_rt_id,
4811: p_from_date => p_validation_start_date,

Line 4816: If (dt_api.rows_exist

4812: p_to_date => p_validation_end_date)) Then
4813: l_table_name := 'ben_aplcn_to_bnft_pool_f';
4814: Raise l_rows_exist;
4815: End If;
4816: If (dt_api.rows_exist
4817: (p_base_table_name => 'ben_vrbl_rt_rl_f',
4818: p_base_key_column => 'acty_base_rt_id',
4819: p_base_key_value => p_acty_base_rt_id,
4820: p_from_date => p_validation_start_date,

Line 4825: If (dt_api.rows_exist

4821: p_to_date => p_validation_end_date)) Then
4822: l_table_name := 'ben_vrbl_rt_rl_f';
4823: Raise l_rows_exist;
4824: End If;
4825: If (dt_api.rows_exist
4826: (p_base_table_name => 'ben_comp_lvl_acty_rt_f',
4827: p_base_key_column => 'acty_base_rt_id',
4828: p_base_key_value => p_acty_base_rt_id,
4829: p_from_date => p_validation_start_date,