DBA Data[Home] [Help]

APPS.PER_SCN_INS dependencies on PER_SOLUTION_CMPT_NAMES

Line 97: p_entity_name=>'PER_SOLUTION_CMPT_NAMES',

93: -- Added the following code as a part of Zero Downtime Patching Project.
94: -- Code Starts Here.
95: --
96: PER_RIC_PKG.chk_integrity (
97: p_entity_name=>'PER_SOLUTION_CMPT_NAMES',
98: p_ref_entity_info=>
99: PER_RIC_PKG.ref_entity_tbl(
100: PER_RIC_PKG.ref_info_rec('PER_SOLUTIONS',
101: PER_RIC_PKG.column_info_tbl(

Line 112: -- Insert the row into: per_solution_cmpt_names

108: --
109: -- Code Ends Here
110: --
111: --
112: -- Insert the row into: per_solution_cmpt_names
113: --
114: insert into per_solution_cmpt_names
115: (solution_id
116: ,component_name

Line 114: insert into per_solution_cmpt_names

110: --
111: --
112: -- Insert the row into: per_solution_cmpt_names
113: --
114: insert into per_solution_cmpt_names
115: (solution_id
116: ,component_name
117: ,solution_type_name
118: ,name

Line 198: from per_solution_cmpt_names

194: ) is
195: --
196: Cursor C_Sel2 is
197: Select null
198: from per_solution_cmpt_names
199: where solution_id = per_scn_ins.g_solution_id_i
200: and component_name = per_scn_ins.g_component_name_i
201: and solution_type_name = per_scn_ins.g_solution_type_name_i;
202: --

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

219: --
220: -- The primary key values are already in use.
221: --
222: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
223: fnd_message.set_token('TABLE_NAME','per_solution_cmpt_names');
224: fnd_message.raise_error;
225: End If;
226: Close C_Sel2;
227: --

Line 312: (p_module_name => 'PER_SOLUTION_CMPT_NAMES'

308: --
309: when hr_api.cannot_find_prog_unit then
310: --
311: hr_api.cannot_find_prog_unit_error
312: (p_module_name => 'PER_SOLUTION_CMPT_NAMES'
313: ,p_hook_type => 'AI');
314: --
315: end;
316: --