DBA Data[Home] [Help]

APPS.FF_LOAD_FTYPES_PKG dependencies on FF_FTYPE_CONTEXT_USAGES

Line 32: -- into FF_FTYPE_CONTEXT_USAGES table

28: ,p_last_updated_by in ff_formula_types.LAST_UPDATED_BY%TYPE
29: ,p_last_update_login in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);
30:
31: -- Called from load_row_context_usages and will insert new rows
32: -- into FF_FTYPE_CONTEXT_USAGES table
33: Procedure insert_fcontext_usages(
34: p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE
35: ,p_context_name in FF_CONTEXTS.context_name%TYPE);
36:

Line 127: FROM FF_FTYPE_CONTEXT_USAGES fcu

123:
124: --Cursor to see if the formula type context usage is existing.....
125: Cursor csr_existing IS
126: SELECT fcu.FORMULA_TYPE_ID
127: FROM FF_FTYPE_CONTEXT_USAGES fcu
128: ,FF_FORMULA_TYPES fft
129: ,FF_CONTEXTS fco
130: WHERE fcu.FORMULA_TYPE_ID = fft.FORMULA_TYPE_ID
131: AND fcu.context_id = fco.context_id

Line 223: -- Called from load_row_context_usages and will insert new rows into FF_FTYPE_CONTEXT_USAGES table

219: End update_formula_types;
220: --
221:
222: --
223: -- Called from load_row_context_usages and will insert new rows into FF_FTYPE_CONTEXT_USAGES table
224: Procedure insert_fcontext_usages(
225: p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE
226: ,p_context_name in FF_CONTEXTS.context_name%TYPE) IS
227:

Line 241: Insert into FF_FTYPE_CONTEXT_USAGES

237: --Check if the context is valid one......
238: l_context_id := chk_context_name(p_context_name => p_context_name);
239:
240: If (l_formula_type_id <> 0 and l_context_id <> 0) Then
241: Insert into FF_FTYPE_CONTEXT_USAGES
242: (formula_type_id
243: ,context_id)
244: Values (l_formula_type_id
245: ,l_context_id);