DBA Data[Home] [Help]

APPS.PER_PCL_BUS dependencies on DT_API

Line 1994: NOT (dt_api.check_min_max_dates

1990: ,p_argument_value => p_validation_end_date
1991: );
1992: --
1993: If ((nvl(p_grade_spine_id, hr_api.g_number) <> hr_api.g_number) and
1994: NOT (dt_api.check_min_max_dates
1995: (p_base_table_name => 'per_grade_spines_f'
1996: ,p_base_key_column => 'GRADE_SPINE_ID'
1997: ,p_base_key_value => p_grade_spine_id
1998: ,p_from_date => p_validation_start_date

Line 2004: NOT (dt_api.check_min_max_dates

2000: l_table_name := 'grade spines';
2001: raise l_integrity_error;
2002: End If;
2003: If ((nvl(p_step_id, hr_api.g_number) <> hr_api.g_number) and
2004: NOT (dt_api.check_min_max_dates
2005: (p_base_table_name => 'per_spinal_point_steps_f'
2006: ,p_base_key_column => 'STEP_ID'
2007: ,p_base_key_value => p_step_id
2008: ,p_from_date => p_validation_start_date

Line 2014: NOT (dt_api.check_min_max_dates

2010: l_table_name := 'spinal point steps';
2011: raise l_integrity_error;
2012: End If;
2013: If ((nvl(p_from_step_id, hr_api.g_number) <> hr_api.g_number) and
2014: NOT (dt_api.check_min_max_dates
2015: (p_base_table_name => 'per_spinal_point_steps_f'
2016: ,p_base_key_column => 'STEP_ID'
2017: ,p_base_key_value => p_from_step_id
2018: ,p_from_date => p_validation_start_date

Line 2024: NOT (dt_api.check_min_max_dates

2020: l_table_name := 'spinal point steps';
2021: raise l_integrity_error;
2022: End If;
2023: If ((nvl(p_to_step_id, hr_api.g_number) <> hr_api.g_number) and
2024: NOT (dt_api.check_min_max_dates
2025: (p_base_table_name => 'per_spinal_point_steps_f'
2026: ,p_base_key_column => 'STEP_ID'
2027: ,p_base_key_value => p_to_step_id
2028: ,p_from_date => p_validation_start_date

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

2073: -- Processing continues.
2074: --
2075: -- Post Failure:
2076: -- If a row exists by determining the returning Boolean value from the
2077: -- generic dt_api.rows_exist function then we must supply an error via
2078: -- the use of the local exception handler l_rows_exist.
2079: --
2080: -- Developer Implementation Notes:
2081: -- This procedure should not need maintenance unless the HR Schema model