86: p_rec.object_version_number := 1; -- Initialise the object version
87: --
88: ff_ffp_shd.g_api_dml := true; -- Set the api dml status
89: --
90: -- Insert the row into: ff_function_parameters
91: --
92: insert into ff_function_parameters
93: (function_id
94: ,sequence_number
88: ff_ffp_shd.g_api_dml := true; -- Set the api dml status
89: --
90: -- Insert the row into: ff_function_parameters
91: --
92: insert into ff_function_parameters
93: (function_id
94: ,sequence_number
95: ,class
96: ,continuing_parameter
176: ) is
177: --
178: Cursor C_Sel1 is
179: select nvl(max(sequence_number) + 1, 1)
180: from ff_function_parameters
181: where function_id = p_rec.function_id;
182: --
183: Cursor C_Sel2 is
184: Select null
181: where function_id = p_rec.function_id;
182: --
183: Cursor C_Sel2 is
184: Select null
185: from ff_function_parameters
186: where function_id =
187: ff_ffp_ins.g_function_id_i
188: or sequence_number =
189: ff_ffp_ins.g_sequence_number_i;
206: --
207: -- The primary key values are already in use.
208: --
209: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
210: fnd_message.set_token('TABLE_NAME','ff_function_parameters');
211: fnd_message.raise_error;
212: End If;
213: Close C_Sel2;
214: --
302: --
303: when hr_api.cannot_find_prog_unit then
304: --
305: hr_api.cannot_find_prog_unit_error
306: (p_module_name => 'FF_FUNCTION_PARAMETERS'
307: ,p_hook_type => 'AI');
308: --
309: end;
310: --