[Home] [Help]
87: -- Added the following code as a part of Zero Downtime Patching Project.
88: -- Code Starts Here.
89: --
90: per_ric_pkg.Chk_integrity(
91: p_entity_name=>'PER_SOLUTIONS', -- Modified for the bug 12639446
92: p_ref_entity=>'PER_SOLUTION_TYPES',
93: p_ref_column_name=>'SOLUTION_TYPE_NAME',
94: -- Modified for bug 12639446
95: p_ref_col_value_number=>NULL,
99: --
100: -- Code Ends Here
101: --
102: --
103: -- Insert the row into: per_solutions
104: --
105: insert into per_solutions
106: (solution_name
107: ,solution_id
101: --
102: --
103: -- Insert the row into: per_solutions
104: --
105: insert into per_solutions
106: (solution_name
107: ,solution_id
108: ,description
109: ,link_to_full_description
189: Procedure pre_insert
190: (p_rec in out nocopy per_sol_shd.g_rec_type
191: ) is
192: --
193: Cursor C_Sel1 is select per_solutions_s.nextval from sys.dual;
194: --
195: Cursor C_Sel2 is
196: Select null
197: from per_solutions
193: Cursor C_Sel1 is select per_solutions_s.nextval from sys.dual;
194: --
195: Cursor C_Sel2 is
196: Select null
197: from per_solutions
198: where solution_id =
199: per_sol_ins.g_solution_id_i;
200: --
201: l_proc varchar2(72) := g_package||'pre_insert';
215: --
216: -- The primary key values are already in use.
217: --
218: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
219: fnd_message.set_token('TABLE_NAME','per_solutions');
220: fnd_message.raise_error;
221: End If;
222: Close C_Sel2;
223: --
310: --
311: when hr_api.cannot_find_prog_unit then
312: --
313: hr_api.cannot_find_prog_unit_error
314: (p_module_name => 'PER_SOLUTIONS'
315: ,p_hook_type => 'AI');
316: --
317: end;
318: --