APPS.BEN_BPP_BUS dependencies on DT_API

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

1930: p_argument_value => p_datetrack_mode);
1931: --
1932: -- Only perform the validation if the datetrack update mode is valid
1933: --
1934: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
1935: --
1936: --
1937: -- Ensure the arguments are not null
1938: --

Line 1950: NOT (dt_api.check_min_max_dates

1946: p_argument => 'validation_end_date',
1947: p_argument_value => p_validation_end_date);
1948: --
1949: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
1950: NOT (dt_api.check_min_max_dates
1951: (p_base_table_name => 'ben_pgm_f',
1952: p_base_key_column => 'pgm_id',
1953: p_base_key_value => p_pgm_id,
1954: p_from_date => p_validation_start_date,

Line 1960: NOT (dt_api.check_min_max_dates

1956: l_table_name := 'ben_pgm_f';
1957: Raise l_integrity_error;
1958: End If;
1959: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
1960: NOT (dt_api.check_min_max_dates
1961: (p_base_table_name => 'ben_plip_f',
1962: p_base_key_column => 'plip_id',
1963: p_base_key_value => p_plip_id,
1964: p_from_date => p_validation_start_date,

Line 1970: NOT (dt_api.check_min_max_dates

1966: l_table_name := 'ben_plip_f';
1967: Raise l_integrity_error;
1968: End If;
1969: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
1970: NOT (dt_api.check_min_max_dates
1971: (p_base_table_name => 'ben_ptip_f',
1972: p_base_key_column => 'ptip_id',
1973: p_base_key_value => p_ptip_id,
1974: p_from_date => p_validation_start_date,

Line 1980: NOT (dt_api.check_min_max_dates

1976: l_table_name := 'ben_ptip_f';
1977: Raise l_integrity_error;
1978: End If;
1979: If ((nvl(p_cmbn_plip_id, hr_api.g_number) <> hr_api.g_number) and
1980: NOT (dt_api.check_min_max_dates
1981: (p_base_table_name => 'ben_cmbn_plip_f',
1982: p_base_key_column => 'cmbn_plip_id',
1983: p_base_key_value => p_cmbn_plip_id,
1984: p_from_date => p_validation_start_date,

Line 1990: NOT (dt_api.check_min_max_dates

1986: l_table_name := 'ben_cmbn_plip_f';
1987: Raise l_integrity_error;
1988: End If;
1989: If ((nvl(p_cmbn_ptip_id, hr_api.g_number) <> hr_api.g_number) and
1990: NOT (dt_api.check_min_max_dates
1991: (p_base_table_name => 'ben_cmbn_ptip_f',
1992: p_base_key_column => 'cmbn_ptip_id',
1993: p_base_key_value => p_cmbn_ptip_id,
1994: p_from_date => p_validation_start_date,

Line 2000: NOT (dt_api.check_min_max_dates

1996: l_table_name := 'ben_cmbn_ptip_f';
1997: Raise l_integrity_error;
1998: End If;
1999: If ((nvl(p_cmbn_ptip_opt_id, hr_api.g_number) <> hr_api.g_number) and
2000: NOT (dt_api.check_min_max_dates
2001: (p_base_table_name => 'ben_cmbn_ptip_opt_f',
2002: p_base_key_column => 'cmbn_ptip_opt_id',
2003: p_base_key_value => p_cmbn_ptip_opt_id,
2004: p_from_date => p_validation_start_date,

Line 2010: NOT (dt_api.check_min_max_dates

2006: l_table_name := 'ben_cmbn_ptip_opt_f';
2007: Raise l_integrity_error;
2008: End If;
2009: If ((nvl(p_oiplip_id, hr_api.g_number) <> hr_api.g_number) and
2010: NOT (dt_api.check_min_max_dates
2011: (p_base_table_name => 'ben_oiplip_f',
2012: p_base_key_column => 'oiplip_id',
2013: p_base_key_value => p_oiplip_id,
2014: p_from_date => p_validation_start_date,

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

2061: -- Processing continues.
2062: --
2063: -- Post Failure:
2064: -- If a row exists by determining the returning Boolean value from the
2065: -- generic dt_api.rows_exist function then we must supply an error via
2066: -- the use of the local exception handler l_rows_exist.
2067: --
2068: -- Developer Implementation Notes:
2069: -- This procedure should not need maintenance unless the HR Schema model

Line 2121: If (dt_api.rows_exist

2117: (p_api_name => l_proc,
2118: p_argument => 'bnft_prvdr_pool_id',
2119: p_argument_value => p_bnft_prvdr_pool_id);
2120: --
2121: If (dt_api.rows_exist
2122: (p_base_table_name => 'ben_aplcn_to_bnft_pool_f',
2123: p_base_key_column => 'bnft_prvdr_pool_id',
2124: p_base_key_value => p_bnft_prvdr_pool_id,
2125: p_from_date => p_validation_start_date,

Line 2130: If (dt_api.rows_exist

2126: p_to_date => p_validation_end_date)) Then
2127: l_table_name := 'ben_aplcn_to_bnft_pool_f';
2128: Raise l_rows_exist;
2129: End If;
2130: If (dt_api.rows_exist
2131: (p_base_table_name => 'ben_bnft_pool_rlovr_rqmt_f',
2132: p_base_key_column => 'bnft_prvdr_pool_id',
2133: p_base_key_value => p_bnft_prvdr_pool_id,
2134: p_from_date => p_validation_start_date,

Line 2139: If (dt_api.rows_exist

2135: p_to_date => p_validation_end_date)) Then
2136: l_table_name := 'ben_bnft_pool_rlovr_rqmt_f';
2137: Raise l_rows_exist;
2138: End If;
2139: If (dt_api.rows_exist
2140: (p_base_table_name => 'ben_bnft_prvdd_ldgr_f',
2141: p_base_key_column => 'bnft_prvdr_pool_id',
2142: p_base_key_value => p_bnft_prvdr_pool_id,
2143: p_from_date => p_validation_start_date,