APPS.IRC_PCV_INS dependencies on IRC_PROF_AREA_CRITERIA_VALUES

Line 87: -- Insert the row into: irc_prof_area_criteria_values

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: irc_prof_area_criteria_values
88: --
89: insert into irc_prof_area_criteria_values
90: (prof_area_criteria_value_id
91: ,search_criteria_id

Line 89: insert into irc_prof_area_criteria_values

85: --
86: --
87: -- Insert the row into: irc_prof_area_criteria_values
88: --
89: insert into irc_prof_area_criteria_values
90: (prof_area_criteria_value_id
91: ,search_criteria_id
92: ,professional_area
93: ,object_version_number

Line 171: from irc_prof_area_criteria_values

167: Cursor C_Sel1 is select irc_prof_area_criteria_value_s.nextval from sys.dual;
168: --
169: Cursor C_Sel2 is
170: Select null
171: from irc_prof_area_criteria_values
172: where prof_area_criteria_value_id =
173: irc_pcv_ins.g_prof_area_criteria_valu_id_i;
174: --
175: l_proc varchar2(72) := g_package||'pre_insert';

Line 193: fnd_message.set_token('TABLE_NAME','irc_prof_area_criteria_values');

189: --
190: -- The primary key values are already in use.
191: --
192: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
193: fnd_message.set_token('TABLE_NAME','irc_prof_area_criteria_values');
194: fnd_message.raise_error;
195: End If;
196: Close C_Sel2;
197: --

Line 278: (p_module_name => 'IRC_PROF_AREA_CRITERIA_VALUES'

274: --
275: when hr_api.cannot_find_prog_unit then
276: --
277: hr_api.cannot_find_prog_unit_error
278: (p_module_name => 'IRC_PROF_AREA_CRITERIA_VALUES'
279: ,p_hook_type => 'AI');
280: --
281: end;
282: --