APPS.PER_STC_INS dependencies on PER_SOLUTION_TYPE_CMPTS

Line 97: p_entity_name=> 'PER_SOLUTION_TYPE_CMPTS',

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_TYPE_CMPTS',
98: p_ref_entity=>'PER_SOLUTION_TYPES',
99: p_ref_column_name=>'SOLUTION_TYPE_NAME',
100: -- Start changes for bug 12639446
101: p_ref_col_value_number=>NULL,

Line 110: -- Insert the row into: per_solution_type_cmpts

106: --
107: -- Code Ends Here
108: --
109: --
110: -- Insert the row into: per_solution_type_cmpts
111: --
112: insert into per_solution_type_cmpts
113: (component_name
114: ,solution_type_name

Line 112: insert into per_solution_type_cmpts

108: --
109: --
110: -- Insert the row into: per_solution_type_cmpts
111: --
112: insert into per_solution_type_cmpts
113: (component_name
114: ,solution_type_name
115: ,legislation_code
116: ,api_name

Line 200: from per_solution_type_cmpts

196: ) is
197: --
198: Cursor C_Sel2 is
199: Select null
200: from per_solution_type_cmpts
201: where component_name = per_stc_ins.g_component_name_i
202: and solution_type_name = per_stc_ins.g_solution_type_name_i
203: and legislation_code = per_stc_ins.g_legislation_code_i;
204: --

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

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

Line 319: (p_module_name => 'PER_SOLUTION_TYPE_CMPTS'

315: --
316: when hr_api.cannot_find_prog_unit then
317: --
318: hr_api.cannot_find_prog_unit_error
319: (p_module_name => 'PER_SOLUTION_TYPE_CMPTS'
320: ,p_hook_type => 'AI');
321: --
322: end;
323: --