DBA Data[Home] [Help]

APPS.FF_FFXWSDFF_PKG dependencies on FF_FUNCTION_PARAMETERS

Line 216: delete from ff_function_parameters

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:

Line 336: -- III : Row handlers for FF_FUNCTION_PARAMETERS --

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,

Line 351: from ff_function_parameters

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:

Line 356: insert into ff_function_parameters(

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,

Line 403: from ff_function_parameters

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;

Line 449: update ff_function_parameters set

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,

Line 470: delete from ff_function_parameters

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;

Line 497: from ff_function_parameters

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: