APPS.FF_LOAD_FTYPES_PKG dependencies on FF_CONTEXTS

Line 35: ,p_context_name in FF_CONTEXTS.context_name%TYPE);

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:
37: -- Called from insert_fcontext_usages and will
38: -- check if the formula type id is valid one......
39: Function chk_formula_type_name(p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE) Return Number;

Line 43: Function chk_context_name(p_context_name in FF_CONTEXTS.context_name%TYPE) Return Number;

39: Function chk_formula_type_name(p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE) Return Number;
40:
41: -- Called from insert_fcontext_usages and will
42: -- check if the context is valid one......
43: Function chk_context_name(p_context_name in FF_CONTEXTS.context_name%TYPE) Return Number;
44: -- ----------------------------------------------------------------------------
45: -- |---------------------------< LOAD_ROW >------------------------------------|
46: -- ----------------------------------------------------------------------------
47: Procedure load_row (

Line 118: ,p_context_name in FF_CONTEXTS.context_name%TYPE)

114: -- |---------------------------< load_row_context_usages >------------------------------------|
115: -- -------------------------------------------------------------------------------------------
116: Procedure load_row_context_usages (
117: p_formula_type_name in FF_FORMULA_TYPES.formula_type_name%TYPE
118: ,p_context_name in FF_CONTEXTS.context_name%TYPE)
119: is
120: --
121: l_exist_form_con_id number;
122: l_proc varchar2(100) := g_package || 'load_row_context_usages';

Line 129: ,FF_CONTEXTS fco

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
132: AND fft.FORMULA_TYPE_NAME = p_formula_type_name
133: AND fco.context_name = p_context_name;

Line 226: ,p_context_name in FF_CONTEXTS.context_name%TYPE) IS

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:
228: l_proc varchar2(100) := g_package || 'insert_fcontext_usages';
229:
230: l_formula_type_id FF_FORMULA_TYPES.formula_type_id%TYPE := 0;

Line 231: l_context_id FF_CONTEXTS.context_name%TYPE := 0;

227:
228: l_proc varchar2(100) := g_package || 'insert_fcontext_usages';
229:
230: l_formula_type_id FF_FORMULA_TYPES.formula_type_id%TYPE := 0;
231: l_context_id FF_CONTEXTS.context_name%TYPE := 0;
232: Begin
233: hr_utility.set_location('Entering:'|| l_proc, 10);
234: --Check if the formula type id is valid one......
235: l_formula_type_id := chk_formula_type_name(p_formula_type_name => p_formula_type_name);

Line 290: Function chk_context_name(p_context_name in FF_CONTEXTS.context_name%TYPE)

286: End chk_formula_type_name;
287:
288: -- Called from insert_fcontext_usages and will
289: -- check if the context is valid one, also will return the contextid......
290: Function chk_context_name(p_context_name in FF_CONTEXTS.context_name%TYPE)
291: Return Number
292: IS
293: --Cursor to see if the formula_type_id exists
294: Cursor csr_fcon_id Is

Line 296: From FF_CONTEXTS

292: IS
293: --Cursor to see if the formula_type_id exists
294: Cursor csr_fcon_id Is
295: Select context_id
296: From FF_CONTEXTS
297: Where context_name = p_context_name;
298:
299: --local variable
300: l_context_id NUMBER;