APPS.IRC_PCV_BUS dependencies on IRC_PROF_AREA_CRITERIA_VALUES

Line 170: (p_search_criteria_id in irc_prof_area_criteria_values.search_criteria_id%TYPE

166: --
167: -- {End Of Comments}
168: -- ----------------------------------------------------------------------------
169: Procedure chk_search_criteria_id
170: (p_search_criteria_id in irc_prof_area_criteria_values.search_criteria_id%TYPE
171: ) IS
172: --
173: l_proc varchar2(72) := g_package || 'chk_search_criteria_id';
174: l_search_criteria_id varchar2(1);

Line 209: 'IRC_PROF_AREA_CRITERIA_VALUES.SEARCH_CRITERIA_ID'

205: exception
206: when app_exception.application_exception then
207: if hr_multi_message.exception_add
208: (p_associated_column1 =>
209: 'IRC_PROF_AREA_CRITERIA_VALUES.SEARCH_CRITERIA_ID'
210: ) then
211: hr_utility.set_location(' Leaving:'||l_proc,60);
212: raise;
213: end if;

Line 245: (p_professional_area in irc_prof_area_criteria_values.professional_area%TYPE

241: --
242: -- {End Of Comments}
243: -- ----------------------------------------------------------------------------
244: Procedure chk_professional_area
245: (p_professional_area in irc_prof_area_criteria_values.professional_area%TYPE
246: ,p_effective_date in date
247: ,p_prof_area_criteria_value_id in irc_prof_area_criteria_values.prof_area_criteria_value_id%TYPE
248: ,p_object_version_number in irc_prof_area_criteria_values.object_version_number%TYPE
249: ) IS

Line 247: ,p_prof_area_criteria_value_id in irc_prof_area_criteria_values.prof_area_criteria_value_id%TYPE

243: -- ----------------------------------------------------------------------------
244: Procedure chk_professional_area
245: (p_professional_area in irc_prof_area_criteria_values.professional_area%TYPE
246: ,p_effective_date in date
247: ,p_prof_area_criteria_value_id in irc_prof_area_criteria_values.prof_area_criteria_value_id%TYPE
248: ,p_object_version_number in irc_prof_area_criteria_values.object_version_number%TYPE
249: ) IS
250: --
251: l_proc varchar2(72) := g_package || 'chk_professional_area';

Line 248: ,p_object_version_number in irc_prof_area_criteria_values.object_version_number%TYPE

244: Procedure chk_professional_area
245: (p_professional_area in irc_prof_area_criteria_values.professional_area%TYPE
246: ,p_effective_date in date
247: ,p_prof_area_criteria_value_id in irc_prof_area_criteria_values.prof_area_criteria_value_id%TYPE
248: ,p_object_version_number in irc_prof_area_criteria_values.object_version_number%TYPE
249: ) IS
250: --
251: l_proc varchar2(72) := g_package || 'chk_professional_area';
252: l_api_updating boolean;

Line 282: (p_associated_column1 => 'IRC_PROF_AREA_CRITERIA_VALUES.PROFESSIONAL_AREA'

278: hr_utility.set_location(' Leaving:'||l_proc,40);
279: exception
280: when app_exception.application_exception then
281: if hr_multi_message.exception_add
282: (p_associated_column1 => 'IRC_PROF_AREA_CRITERIA_VALUES.PROFESSIONAL_AREA'
283: ) then
284: hr_utility.set_location(' Leaving:'||l_proc,50);
285: raise;
286: end if;