APPS.PER_STC_INS dependencies on PER_SOLUTION_TYPE_CMPTS

Line 93: -- Insert the row into: per_solution_type_cmpts

89: p_rec.object_version_number := 1; -- Initialise the object version
90: --
91: --
92: --
93: -- Insert the row into: per_solution_type_cmpts
94: --
95: insert into per_solution_type_cmpts
96: (component_name
97: ,solution_type_name

Line 95: insert into per_solution_type_cmpts

91: --
92: --
93: -- Insert the row into: per_solution_type_cmpts
94: --
95: insert into per_solution_type_cmpts
96: (component_name
97: ,solution_type_name
98: ,legislation_code
99: ,api_name

Line 183: from per_solution_type_cmpts

179: ) is
180: --
181: Cursor C_Sel2 is
182: Select null
183: from per_solution_type_cmpts
184: where component_name = per_stc_ins.g_component_name_i
185: and solution_type_name = per_stc_ins.g_solution_type_name_i
186: and legislation_code = per_stc_ins.g_legislation_code_i;
187: --

Line 208: fnd_message.set_token('TABLE_NAME','per_solution_type_cmpts');

204: --
205: -- The primary key values are already in use.
206: --
207: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
208: fnd_message.set_token('TABLE_NAME','per_solution_type_cmpts');
209: fnd_message.raise_error;
210: End If;
211: Close C_Sel2;
212: --

Line 302: (p_module_name => 'PER_SOLUTION_TYPE_CMPTS'

298: --
299: when hr_api.cannot_find_prog_unit then
300: --
301: hr_api.cannot_find_prog_unit_error
302: (p_module_name => 'PER_SOLUTION_TYPE_CMPTS'
303: ,p_hook_type => 'AI');
304: --
305: end;
306: --