APPS.PER_CNL_INS dependencies on PER_RI_CONFIG_LOCATIONS

Line 87: -- Insert the row into: per_ri_config_locations

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

Line 89: insert into per_ri_config_locations

85: --
86: --
87: -- Insert the row into: per_ri_config_locations
88: --
89: insert into per_ri_config_locations
90: (configuration_code
91: ,configuration_context
92: ,location_id
93: ,location_code

Line 213: Cursor C_Sel1 is select per_ri_config_locations_s.nextval from sys.dual;

209: Procedure pre_insert
210: (p_rec in out nocopy per_cnl_shd.g_rec_type
211: ) is
212: --
213: Cursor C_Sel1 is select per_ri_config_locations_s.nextval from sys.dual;
214: --
215: Cursor C_Sel2 is
216: Select null
217: from per_ri_config_locations

Line 217: from per_ri_config_locations

213: Cursor C_Sel1 is select per_ri_config_locations_s.nextval from sys.dual;
214: --
215: Cursor C_Sel2 is
216: Select null
217: from per_ri_config_locations
218: where location_id =
219: per_cnl_ins.g_location_id_i;
220: --
221: l_proc varchar2(72) := g_package||'pre_insert';

Line 239: fnd_message.set_token('TABLE_NAME','per_ri_config_locations');

235: --
236: -- The primary key values are already in use.
237: --
238: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
239: fnd_message.set_token('TABLE_NAME','per_ri_config_locations');
240: fnd_message.raise_error;
241: End If;
242: Close C_Sel2;
243: --

Line 343: (p_module_name => 'PER_RI_CONFIG_LOCATIONS'

339: --
340: when hr_api.cannot_find_prog_unit then
341: --
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'PER_RI_CONFIG_LOCATIONS'
344: ,p_hook_type => 'AI');
345: --
346: end;
347: --