APPS.BEN_EPA_BUS dependencies on DT_API

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

1790: p_argument_value => p_datetrack_mode);
1791: --
1792: -- Only perform the validation if the datetrack update mode is valid
1793: --
1794: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
1795: --
1796: --
1797: -- Ensure the arguments are not null
1798: --

Line 1810: NOT (dt_api.check_min_max_dates

1806: p_argument => 'validation_end_date',
1807: p_argument_value => p_validation_end_date);
1808: --
1809: If ((nvl(p_prtn_eff_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
1810: NOT (dt_api.check_min_max_dates
1811: (p_base_table_name => 'ff_formulas_f',
1812: p_base_key_column => 'formula_id',
1813: p_base_key_value => p_prtn_eff_end_dt_rl,
1814: p_from_date => p_validation_start_date,

Line 1820: NOT (dt_api.check_min_max_dates

1816: l_table_name := 'ff_formulas_f';
1817: Raise l_integrity_error;
1818: End If;
1819: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
1820: NOT (dt_api.check_min_max_dates
1821: (p_base_table_name => 'ben_oipl_f',
1822: p_base_key_column => 'oipl_id',
1823: p_base_key_value => p_oipl_id,
1824: p_from_date => p_validation_start_date,

Line 1830: NOT (dt_api.check_min_max_dates

1826: l_table_name := 'ben_oipl_f';
1827: Raise l_integrity_error;
1828: End If;
1829: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
1830: NOT (dt_api.check_min_max_dates
1831: (p_base_table_name => 'ben_pl_f',
1832: p_base_key_column => 'pl_id',
1833: p_base_key_value => p_pl_id,
1834: p_from_date => p_validation_start_date,

Line 1840: NOT (dt_api.check_min_max_dates

1836: l_table_name := 'ben_pl_f';
1837: Raise l_integrity_error;
1838: End If;
1839: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
1840: NOT (dt_api.check_min_max_dates
1841: (p_base_table_name => 'ben_pgm_f',
1842: p_base_key_column => 'pgm_id',
1843: p_base_key_value => p_pgm_id,
1844: p_from_date => p_validation_start_date,

Line 1850: NOT (dt_api.check_min_max_dates

1846: l_table_name := 'ben_pgm_f';
1847: Raise l_integrity_error;
1848: End If;
1849: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
1850: NOT (dt_api.check_min_max_dates
1851: (p_base_table_name => 'ben_ptip_f',
1852: p_base_key_column => 'ptip_id',
1853: p_base_key_value => p_ptip_id,
1854: p_from_date => p_validation_start_date,

Line 1860: NOT (dt_api.check_min_max_dates

1856: l_table_name := 'ben_ptip_f';
1857: Raise l_integrity_error;
1858: End If;
1859: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
1860: NOT (dt_api.check_min_max_dates
1861: (p_base_table_name => 'ben_plip_f',
1862: p_base_key_column => 'plip_id',
1863: p_base_key_value => p_plip_id,
1864: p_from_date => p_validation_start_date,

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

1912: -- Processing continues.
1913: --
1914: -- Post Failure:
1915: -- If a row exists by determining the returning Boolean value from the
1916: -- generic dt_api.rows_exist function then we must supply an error via
1917: -- the use of the local exception handler l_rows_exist.
1918: --
1919: -- Developer Implementation Notes:
1920: -- This procedure should not need maintenance unless the HR Schema model

Line 1972: If (dt_api.rows_exist

1968: (p_api_name => l_proc,
1969: p_argument => 'prtn_elig_id',
1970: p_argument_value => p_prtn_elig_id);
1971: --
1972: If (dt_api.rows_exist
1973: (p_base_table_name => 'ben_prtn_eligy_rl_f',
1974: p_base_key_column => 'prtn_elig_id',
1975: p_base_key_value => p_prtn_elig_id,
1976: p_from_date => p_validation_start_date,

Line 1981: If (dt_api.rows_exist

1977: p_to_date => p_validation_end_date)) Then
1978: l_table_name := 'ben_eligy_rl_f';
1979: Raise l_rows_exist;
1980: End If;
1981: If (dt_api.rows_exist
1982: (p_base_table_name => 'ben_prtn_elig_prfl_f',
1983: p_base_key_column => 'prtn_elig_id',
1984: p_base_key_value => p_prtn_elig_id,
1985: p_from_date => p_validation_start_date,