DBA Data[Home] [Help]

APPS.FF_FFXWSDFF_PKG dependencies on FF_FUNCTION_CONTEXT_USAGES

Line 213: delete from ff_function_context_usages

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;
215:
216: delete from ff_function_parameters
217: where function_id = x_function_id;

Line 223: -- II : Row handlers for FF_FUNCTION_CONTEXT_USAGES --

219: end delete_function;
220:
221:
222: -------------------------------------------------------------
223: -- II : Row handlers for FF_FUNCTION_CONTEXT_USAGES --
224: -------------------------------------------------------------
225:
226: procedure insert_context_usage(x_rowid in out varchar2,
227: x_function_id number,

Line 234: from ff_function_context_usages

230: ) is
231:
232: cursor c_rowid is
233: select rowid
234: from ff_function_context_usages
235: where function_id = x_function_id;
236:
237: begin
238:

Line 239: insert into ff_function_context_usages(

235: where function_id = x_function_id;
236:
237: begin
238:
239: insert into ff_function_context_usages(
240: function_id,
241: sequence_number,
242: context_id
243: )values(

Line 270: from ff_function_context_usages

266: cursor c_row is
267: select function_id,
268: sequence_number,
269: context_id
270: from ff_function_context_usages
271: where rowid = x_rowid
272: for update of function_id nowait;
273:
274: recinfo c_row%rowtype;

Line 308: update ff_function_context_usages set

304: ) is
305:
306: begin
307:
308: update ff_function_context_usages set
309: function_id = x_function_id,
310: sequence_number = x_sequence_number,
311: context_id = x_context_id
312: where rowid = x_rowid;

Line 325: delete from ff_function_context_usages

321: procedure delete_context_usage(x_rowid varchar2) is
322:
323: begin
324:
325: delete from ff_function_context_usages
326: where rowid = x_rowid;
327:
328: if (sql%notfound) then
329: raise no_data_found;

Line 524: from ff_function_context_usages

520: v_context_sequence number := null;
521:
522: cursor c_next_context_sequence is
523: select nvl (max (sequence_number), 0) + 1
524: from ff_function_context_usages
525: where function_id = p_function_id;
526:
527: begin
528: