212:
213: delete from ff_function_context_usages
214: where function_id = x_function_id;
215:
216: delete from ff_function_parameters
217: where function_id = x_function_id;
218:
219: end delete_function;
220:
332: end delete_context_usage;
333:
334:
335: -----------------------------------------------------------
336: -- III : Row handlers for FF_FUNCTION_PARAMETERS --
337: -----------------------------------------------------------
338:
339: procedure insert_parameter(x_rowid in out varchar2,
340: x_function_id number,
347: ) is
348:
349: cursor c_rowid is
350: select rowid
351: from ff_function_parameters
352: where function_id = x_function_id;
353:
354: begin
355:
352: where function_id = x_function_id;
353:
354: begin
355:
356: insert into ff_function_parameters(
357: function_id,
358: sequence_number,
359: class,
360: continuing_parameter,
399: continuing_parameter,
400: data_type,
401: name,
402: optional
403: from ff_function_parameters
404: where rowid = x_rowid
405: for update of function_id nowait;
406:
407: recinfo c_row%rowtype;
445: ) is
446:
447: begin
448:
449: update ff_function_parameters set
450: function_id = x_function_id,
451: sequence_number = x_sequence_number,
452: class = x_class,
453: continuing_parameter = x_continuing_parameter,
466: procedure delete_parameter(x_rowid varchar2) is
467:
468: begin
469:
470: delete from ff_function_parameters
471: where rowid = x_rowid;
472:
473: if (sql%notfound) then
474: raise no_data_found;
493: v_parameter_sequence number := null;
494:
495: cursor c_next_parameter_sequence is
496: select nvl (max (sequence_number), 0) + 1
497: from ff_function_parameters
498: where function_id = p_function_id;
499:
500: begin
501: