DBA Data[Home] [Help]

APPS.BEN_APR_BUS dependencies on DT_API

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

1982: p_argument_value => p_datetrack_mode);
1983: --
1984: -- Only perform the validation if the datetrack update mode is valid
1985: --
1986: If (dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode)) then
1987: --
1988: --
1989: -- Ensure the arguments are not null
1990: --

Line 2003: NOT (dt_api.check_min_max_dates

1999: p_argument_value => p_validation_end_date);
2000: --
2001: /*
2002: If ((nvl(p_comp_lvl_fctr_id, hr_api.g_number) <> hr_api.g_number) and
2003: NOT (dt_api.check_min_max_dates
2004: (p_base_table_name => 'ben_comp_lvl_fctr',
2005: p_base_key_column => 'comp_lvl_fctr_id',
2006: p_base_key_value => p_comp_lvl_fctr_id,
2007: p_from_date => p_validation_start_date,

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

2054: -- Processing continues.
2055: --
2056: -- Post Failure:
2057: -- If a row exists by determining the returning Boolean value from the
2058: -- generic dt_api.rows_exist function then we must supply an error via
2059: -- the use of the local exception handler l_rows_exist.
2060: --
2061: -- Developer Implementation Notes:
2062: -- This procedure should not need maintenance unless the HR Schema model

Line 2114: If (dt_api.rows_exist

2110: (p_api_name => l_proc,
2111: p_argument => 'actl_prem_id',
2112: p_argument_value => p_actl_prem_id);
2113: --
2114: If (dt_api.rows_exist
2115: (p_base_table_name => 'ben_oipl_f',
2116: p_base_key_column => 'actl_prem_id',
2117: p_base_key_value => p_actl_prem_id,
2118: p_from_date => p_validation_start_date,

Line 2123: If (dt_api.rows_exist

2119: p_to_date => p_validation_end_date)) Then
2120: l_table_name := 'ben_oipl_f';
2121: Raise l_rows_exist;
2122: End If;
2123: If (dt_api.rows_exist
2124: (p_base_table_name => 'ben_actl_prem_vrbl_rt_f',
2125: p_base_key_column => 'actl_prem_id',
2126: p_base_key_value => p_actl_prem_id,
2127: p_from_date => p_validation_start_date,

Line 2132: If (dt_api.rows_exist

2128: p_to_date => p_validation_end_date)) Then
2129: l_table_name := 'ben_actl_prem_vrbl_rt_f';
2130: Raise l_rows_exist;
2131: End If;
2132: If (dt_api.rows_exist
2133: (p_base_table_name => 'ben_prtt_prem_f',
2134: p_base_key_column => 'actl_prem_id',
2135: p_base_key_value => p_actl_prem_id,
2136: p_from_date => p_validation_start_date,

Line 2142: -- If (dt_api.rows_exist

2138: l_table_name := 'ben_prtt_prem_f';
2139: Raise l_rows_exist;
2140: End If;
2141:
2142: -- If (dt_api.rows_exist
2143: -- (p_base_table_name => 'ben_actl_prem_vrbl_rt_rl_f',
2144: -- p_base_key_column => 'actl_prem_id',
2145: -- p_base_key_value => p_actl_prem_id,
2146: -- p_from_date => p_validation_start_date,