DBA Data[Home] [Help]

APPS.FF_FFXWSDFF_PKG dependencies on FF_FUNCTIONS

Line 5: -- I : Row handlers for FF_FUNCTIONS --

1: package body ff_ffxwsdff_pkg as
2: /* $Header: ffxwsdff.pkb 115.1 99/07/16 02:04:17 porting ship $ */
3:
4: --------------------------------------------------------
5: -- I : Row handlers for FF_FUNCTIONS --
6: --------------------------------------------------------
7:
8: procedure insert_function(x_rowid in out varchar2,
9: x_function_id in out number,

Line 27: from ff_functions

23: ) is
24:
25: cursor c_rowid is
26: select rowid
27: from ff_functions
28: where function_id = x_function_id;
29:
30: cursor c_sequence is
31: select ff_functions_s.nextval

Line 31: select ff_functions_s.nextval

27: from ff_functions
28: where function_id = x_function_id;
29:
30: cursor c_sequence is
31: select ff_functions_s.nextval
32: from dual;
33:
34: begin
35:

Line 44: insert into ff_functions(

40: raise no_data_found;
41: end if;
42: close c_sequence;
43:
44: insert into ff_functions(
45: function_id,
46: class,
47: name,
48: alias_name,

Line 114: from ff_functions

110: data_type,
111: definition,
112: legislation_code,
113: description
114: from ff_functions
115: where rowid = x_rowid
116: for update of function_id nowait;
117:
118: recinfo c_row%rowtype;

Line 181: update ff_functions set

177: ) is
178:
179: begin
180:
181: update ff_functions set
182: function_id = x_function_id,
183: class = x_class,
184: name = x_name,
185: alias_name = x_alias_name,

Line 210: delete from ff_functions

206: x_function_id number) is
207:
208: begin
209:
210: delete from ff_functions
211: where rowid = x_rowid;
212:
213: delete from ff_function_context_usages
214: where function_id = x_function_id;