DBA Data[Home] [Help]

APPS.PER_SCN_INS dependencies on PER_SOLUTION_CMPT_NAMES

Line 93: -- Insert the row into: per_solution_cmpt_names

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

Line 95: insert into per_solution_cmpt_names

91: --
92: --
93: -- Insert the row into: per_solution_cmpt_names
94: --
95: insert into per_solution_cmpt_names
96: (solution_id
97: ,component_name
98: ,solution_type_name
99: ,name

Line 179: from per_solution_cmpt_names

175: ) is
176: --
177: Cursor C_Sel2 is
178: Select null
179: from per_solution_cmpt_names
180: where solution_id = per_scn_ins.g_solution_id_i
181: and component_name = per_scn_ins.g_component_name_i
182: and solution_type_name = per_scn_ins.g_solution_type_name_i;
183: --

Line 204: fnd_message.set_token('TABLE_NAME','per_solution_cmpt_names');

200: --
201: -- The primary key values are already in use.
202: --
203: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
204: fnd_message.set_token('TABLE_NAME','per_solution_cmpt_names');
205: fnd_message.raise_error;
206: End If;
207: Close C_Sel2;
208: --

Line 293: (p_module_name => 'PER_SOLUTION_CMPT_NAMES'

289: --
290: when hr_api.cannot_find_prog_unit then
291: --
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'PER_SOLUTION_CMPT_NAMES'
294: ,p_hook_type => 'AI');
295: --
296: end;
297: --