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_PGM_BUS dependencies on DT_API

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

5835: p_argument_value => p_datetrack_mode);
5836: --
5837: -- Only perform the validation if the datetrack update mode is valid
5838: --
5839: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
5840: --
5841: --
5842: -- Ensure the arguments are not null
5843: --

Line 5856: NOT (dt_api.check_min_max_dates

5852: p_argument_value => p_validation_end_date);
5853: --
5854:
5855: If ((nvl(p_enrt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5856: NOT (dt_api.check_min_max_dates
5857: (p_base_table_name => 'ff_formulas_f',
5858: p_base_key_column => 'formula_id',
5859: p_base_key_value => p_enrt_cvg_end_dt_rl,
5860: p_from_date => p_validation_start_date,

Line 5866: NOT (dt_api.check_min_max_dates

5862: l_table_name := 'ff_formulas_f';
5863: Raise l_integrity_error;
5864: End If;
5865: If ((nvl(p_enrt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5866: NOT (dt_api.check_min_max_dates
5867: (p_base_table_name => 'ff_formulas_f',
5868: p_base_key_column => 'formula_id',
5869: p_base_key_value => p_enrt_cvg_strt_dt_rl,
5870: p_from_date => p_validation_start_date,

Line 5876: NOT (dt_api.check_min_max_dates

5872: l_table_name := 'ff_formulas_f';
5873: Raise l_integrity_error;
5874: End If;
5875: If ((nvl(p_dpnt_cvg_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5876: NOT (dt_api.check_min_max_dates
5877: (p_base_table_name => 'ff_formulas_f',
5878: p_base_key_column => 'formula_id',
5879: p_base_key_value => p_dpnt_cvg_strt_dt_rl,
5880: p_from_date => p_validation_start_date,

Line 5886: NOT (dt_api.check_min_max_dates

5882: l_table_name := 'ff_formulas_f';
5883: Raise l_integrity_error;
5884: End If;
5885: If ((nvl(p_dpnt_cvg_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5886: NOT (dt_api.check_min_max_dates
5887: (p_base_table_name => 'ff_formulas_f',
5888: p_base_key_column => 'formula_id',
5889: p_base_key_value => p_dpnt_cvg_end_dt_rl,
5890: p_from_date => p_validation_start_date,

Line 5897: NOT (dt_api.check_min_max_dates

5893: Raise l_integrity_error;
5894: End If;
5895: /*
5896: If ((nvl(p_prtn_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5897: NOT (dt_api.check_min_max_dates
5898: (p_base_table_name => 'ff_formulas_f',
5899: p_base_key_column => 'formula_id',
5900: p_base_key_value => p_prtn_end_dt_rl,
5901: p_from_date => p_validation_start_date,

Line 5907: NOT (dt_api.check_min_max_dates

5903: l_table_name := 'ff_formulas_f';
5904: Raise l_integrity_error;
5905: End If;
5906: If ((nvl(p_prtn_strt_dt_rl, hr_api.g_number) <> hr_api.g_number) and
5907: NOT (dt_api.check_min_max_dates
5908: (p_base_table_name => 'ff_formulas_f',
5909: p_base_key_column => 'formula_id',
5910: p_base_key_value => p_prtn_strt_dt_rl,
5911: p_from_date => p_validation_start_date,

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

5958: -- Processing continues.
5959: --
5960: -- Post Failure:
5961: -- If a row exists by determining the returning Boolean value from the
5962: -- generic dt_api.rows_exist function then we must supply an error via
5963: -- the use of the local exception handler l_rows_exist.
5964: --
5965: -- Developer Implementation Notes:
5966: -- This procedure should not need maintenance unless the HR Schema model

Line 6025: If (dt_api.rows_exist

6021: (p_api_name => l_proc,
6022: p_argument => 'pgm_id',
6023: p_argument_value => p_pgm_id);
6024: --
6025: If (dt_api.rows_exist
6026: (p_base_table_name => 'ben_ptip_f',
6027: p_base_key_column => 'pgm_id',
6028: p_base_key_value => p_pgm_id,
6029: p_from_date => p_validation_start_date,

Line 6034: If (dt_api.rows_exist

6030: p_to_date => p_validation_end_date)) Then
6031: l_table_name := 'ben_ptip_f';
6032: Raise l_rows_exist;
6033: End If;
6034: If (dt_api.rows_exist
6035: (p_base_table_name => 'ben_popl_enrt_typ_cycl_f',
6036: p_base_key_column => 'pgm_id',
6037: p_base_key_value => p_pgm_id,
6038: p_from_date => p_validation_start_date,

Line 6043: If (dt_api.rows_exist

6039: p_to_date => p_validation_end_date)) Then
6040: l_table_name := 'ben_popl_enrt_typ_cycl_f';
6041: Raise l_rows_exist;
6042: End If;
6043: If (dt_api.rows_exist
6044: (p_base_table_name => 'ben_plip_f',
6045: p_base_key_column => 'pgm_id',
6046: p_base_key_value => p_pgm_id,
6047: p_from_date => p_validation_start_date,

Line 6052: If (dt_api.rows_exist

6048: p_to_date => p_validation_end_date)) Then
6049: l_table_name := 'ben_plip_f';
6050: Raise l_rows_exist;
6051: End If;
6052: If (dt_api.rows_exist
6053: (p_base_table_name => 'ben_prtn_elig_f',
6054: p_base_key_column => 'pgm_id',
6055: p_base_key_value => p_pgm_id,
6056: p_from_date => p_validation_start_date,

Line 6061: If (dt_api.rows_exist

6057: p_to_date => p_validation_end_date)) Then
6058: l_table_name := 'ben_prtn_elig_f';
6059: Raise l_rows_exist;
6060: End If;
6061: If (dt_api.rows_exist
6062: (p_base_table_name => 'ben_elig_to_prte_rsn_f',
6063: p_base_key_column => 'pgm_id',
6064: p_base_key_value => p_pgm_id,
6065: p_from_date => p_validation_start_date,

Line 6070: If (dt_api.rows_exist

6066: p_to_date => p_validation_end_date)) Then
6067: l_table_name := 'ben_elig_to_prte_rsn_f';
6068: Raise l_rows_exist;
6069: End If;
6070: If (dt_api.rows_exist
6071: (p_base_table_name => 'ben_ler_chg_dpnt_cvg_f',
6072: p_base_key_column => 'pgm_id',
6073: p_base_key_value => p_pgm_id,
6074: p_from_date => p_validation_start_date,

Line 6079: If (dt_api.rows_exist

6075: p_to_date => p_validation_end_date)) Then
6076: l_table_name := 'ben_ler_chg_dpnt_cvg_f';
6077: Raise l_rows_exist;
6078: End If;
6079: If (dt_api.rows_exist
6080: (p_base_table_name => 'ben_popl_org_f',
6081: p_base_key_column => 'pgm_id',
6082: p_base_key_value => p_pgm_id,
6083: p_from_date => p_validation_start_date,

Line 6088: If (dt_api.rows_exist

6084: p_to_date => p_validation_end_date)) Then
6085: l_table_name := 'ben_popl_org_f';
6086: Raise l_rows_exist;
6087: End If;
6088: If (dt_api.rows_exist
6089: (p_base_table_name => 'ben_elig_per_f',
6090: p_base_key_column => 'pgm_id',
6091: p_base_key_value => p_pgm_id,
6092: p_from_date => p_validation_start_date,

Line 6097: If (dt_api.rows_exist

6093: p_to_date => p_validation_end_date)) Then
6094: l_table_name := 'ben_elig_per_f';
6095: Raise l_rows_exist;
6096: End If;
6097: If (dt_api.rows_exist
6098: (p_base_table_name => 'ben_acty_base_rt_f',
6099: p_base_key_column => 'pgm_id',
6100: p_base_key_value => p_pgm_id,
6101: p_from_date => p_validation_start_date,

Line 6106: If (dt_api.rows_exist

6102: p_to_date => p_validation_end_date)) Then
6103: l_table_name := 'ben_acty_base_rt_f';
6104: Raise l_rows_exist;
6105: End If;
6106: If (dt_api.rows_exist
6107: (p_base_table_name => 'ben_pgm_dpnt_cvg_ctfn_f',
6108: p_base_key_column => 'pgm_id',
6109: p_base_key_value => p_pgm_id,
6110: p_from_date => p_validation_start_date,

Line 6115: If (dt_api.rows_exist

6111: p_to_date => p_validation_end_date)) Then
6112: l_table_name := 'ben_pgm_dpnt_cvg_ctfn_f';
6113: Raise l_rows_exist;
6114: End If;
6115: If (dt_api.rows_exist
6116: (p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',
6117: p_base_key_column => 'pgm_id',
6118: p_base_key_value => p_pgm_id,
6119: p_from_date => p_validation_start_date,

Line 6124: If (dt_api.rows_exist

6120: p_to_date => p_validation_end_date)) Then
6121: l_table_name := 'ben_apld_dpnt_cvg_elig_prfl_f';
6122: Raise l_rows_exist;
6123: End If;
6124: If (dt_api.rows_exist
6125: (p_base_table_name => 'ben_popl_rptg_grp_f',
6126: p_base_key_column => 'pgm_id',
6127: p_base_key_value => p_pgm_id,
6128: p_from_date => p_validation_start_date,

Line 6133: If (dt_api.rows_exist

6129: p_to_date => p_validation_end_date)) Then
6130: l_table_name := 'ben_popl_rptg_grp_f';
6131: Raise l_rows_exist;
6132: End If;
6133: If (dt_api.rows_exist
6134: (p_base_table_name => 'ben_bnft_prvdr_pool_f',
6135: p_base_key_column => 'pgm_id',
6136: p_base_key_value => p_pgm_id,
6137: p_from_date => p_validation_start_date,

Line 6142: If (dt_api.rows_exist

6138: p_to_date => p_validation_end_date)) Then
6139: l_table_name := 'ben_bnft_prvdr_pool_f';
6140: Raise l_rows_exist;
6141: End If;
6142: If (dt_api.rows_exist
6143: (p_base_table_name => 'ben_drvbl_fctr_uom',
6144: p_base_key_column => 'pgm_id',
6145: p_base_key_value => p_pgm_id,
6146: p_from_date => p_validation_start_date,

Line 6151: If (dt_api.rows_exist

6147: p_to_date => p_validation_end_date)) Then
6148: l_table_name := 'ben_drvbl_fctr_uom';
6149: Raise l_rows_exist;
6150: End If;
6151: If (dt_api.rows_exist
6152: (p_base_table_name => 'ben_elig_cbr_quald_bnf_f',
6153: p_base_key_column => 'pgm_id',
6154: p_base_key_value => p_pgm_id,
6155: p_from_date => p_validation_start_date,

Line 6162: If (dt_api.rows_exist

6158: Raise l_rows_exist;
6159: End If;
6160: /*
6161: hr_utility.set_location('!!!!! 18', 5);
6162: If (dt_api.rows_exist
6163: (p_base_table_name => 'ben_elig_per_elctbl_chc',
6164: p_base_key_column => 'pgm_id',
6165: p_base_key_value => p_pgm_id,
6166: p_from_date => p_validation_start_date,

Line 6173: If (dt_api.rows_exist -- Uncommented, Bug 4339842

6169: Raise l_rows_exist;
6170: End If;
6171: hr_utility.set_location('!!!!! 19', 5);
6172:
6173: If (dt_api.rows_exist -- Uncommented, Bug 4339842
6174: (p_base_table_name => 'ben_popl_yr_perd',
6175: p_base_key_column => 'pgm_id',
6176: p_base_key_value => p_pgm_id,
6177: p_from_date => p_validation_start_date,