APPS.FF_LOAD_CONTEXTS_PKG dependencies on FF_CONTEXTS

Line 7: (context_name ff_contexts.context_name%type

3: -- ----------------------------------------------------------------------------
4: -- | Data Structure Definitions |
5: -- ----------------------------------------------------------------------------
6: type r_context is record
7: (context_name ff_contexts.context_name%type
8: ,data_type ff_contexts.data_type%type
9: );
10:
11: type t_contexts is table of r_context index by binary_integer;

Line 8: ,data_type ff_contexts.data_type%type

4: -- | Data Structure Definitions |
5: -- ----------------------------------------------------------------------------
6: type r_context is record
7: (context_name ff_contexts.context_name%type
8: ,data_type ff_contexts.data_type%type
9: );
10:
11: type t_contexts is table of r_context index by binary_integer;
12: -- ----------------------------------------------------------------------------

Line 26: p_context_name in ff_contexts.context_name%TYPE

22: -- | Private Procedures |
23: -- ----------------------------------------------------------------------------
24: -- Called from load row and will insert new rows into ff_formula_types table
25: Procedure insert_contexts(
26: p_context_name in ff_contexts.context_name%TYPE
27: ,p_context_level in ff_contexts.context_level%TYPE
28: ,p_data_type in ff_contexts.data_type%TYPE);
29:
30: --

Line 27: ,p_context_level in ff_contexts.context_level%TYPE

23: -- ----------------------------------------------------------------------------
24: -- Called from load row and will insert new rows into ff_formula_types table
25: Procedure insert_contexts(
26: p_context_name in ff_contexts.context_name%TYPE
27: ,p_context_level in ff_contexts.context_level%TYPE
28: ,p_data_type in ff_contexts.data_type%TYPE);
29:
30: --
31: -- Build the list of permitted contexts.

Line 28: ,p_data_type in ff_contexts.data_type%TYPE);

24: -- Called from load row and will insert new rows into ff_formula_types table
25: Procedure insert_contexts(
26: p_context_name in ff_contexts.context_name%TYPE
27: ,p_context_level in ff_contexts.context_level%TYPE
28: ,p_data_type in ff_contexts.data_type%TYPE);
29:
30: --
31: -- Build the list of permitted contexts.
32: --

Line 204: p_context_name in ff_contexts.context_name%TYPE

200: -- ----------------------------------------------------------------------------
201: -- |---------------------------< LOAD_ROW >------------------------------------|
202: -- ----------------------------------------------------------------------------
203: Procedure load_row (
204: p_context_name in ff_contexts.context_name%TYPE
205: ,p_context_level in ff_contexts.context_level%TYPE
206: ,p_data_type in ff_contexts.data_type%TYPE) is
207: --
208: l_existing_con_id number;

Line 205: ,p_context_level in ff_contexts.context_level%TYPE

201: -- |---------------------------< LOAD_ROW >------------------------------------|
202: -- ----------------------------------------------------------------------------
203: Procedure load_row (
204: p_context_name in ff_contexts.context_name%TYPE
205: ,p_context_level in ff_contexts.context_level%TYPE
206: ,p_data_type in ff_contexts.data_type%TYPE) is
207: --
208: l_existing_con_id number;
209: l_proc varchar2(100) := g_package || 'load_row';

Line 206: ,p_data_type in ff_contexts.data_type%TYPE) is

202: -- ----------------------------------------------------------------------------
203: Procedure load_row (
204: p_context_name in ff_contexts.context_name%TYPE
205: ,p_context_level in ff_contexts.context_level%TYPE
206: ,p_data_type in ff_contexts.data_type%TYPE) is
207: --
208: l_existing_con_id number;
209: l_proc varchar2(100) := g_package || 'load_row';
210: --

Line 214: from ff_contexts fcon

210: --
211: --Cursor to see if the existing formula type is updated.....
212: cursor csr_existing is
213: select fcon.context_id
214: from ff_contexts fcon
215: where fcon.context_name = p_context_name;
216:
217: BEGIN
218: --

Line 250: p_context_name in ff_contexts.context_name%TYPE

246: -- | Private Procedures |
247: -- ----------------------------------------------------------------------------
248: -- Called from load row and will insert new rows into ff_formula_types table
249: Procedure insert_contexts(
250: p_context_name in ff_contexts.context_name%TYPE
251: ,p_context_level in ff_contexts.context_level%TYPE
252: ,p_data_type in ff_contexts.data_type%TYPE) Is
253: --
254: l_proc varchar2(100) := g_package || 'insert_contexts';

Line 251: ,p_context_level in ff_contexts.context_level%TYPE

247: -- ----------------------------------------------------------------------------
248: -- Called from load row and will insert new rows into ff_formula_types table
249: Procedure insert_contexts(
250: p_context_name in ff_contexts.context_name%TYPE
251: ,p_context_level in ff_contexts.context_level%TYPE
252: ,p_data_type in ff_contexts.data_type%TYPE) Is
253: --
254: l_proc varchar2(100) := g_package || 'insert_contexts';
255: --

Line 252: ,p_data_type in ff_contexts.data_type%TYPE) Is

248: -- Called from load row and will insert new rows into ff_formula_types table
249: Procedure insert_contexts(
250: p_context_name in ff_contexts.context_name%TYPE
251: ,p_context_level in ff_contexts.context_level%TYPE
252: ,p_data_type in ff_contexts.data_type%TYPE) Is
253: --
254: l_proc varchar2(100) := g_package || 'insert_contexts';
255: --
256: Begin

Line 261: Insert Into FF_CONTEXTS(

257: --
258: hr_utility.set_location('Entering:'|| l_proc, 10);
259:
260: --Insert into ff_formula_types table
261: Insert Into FF_CONTEXTS(
262: CONTEXT_ID
263: ,CONTEXT_LEVEL
264: ,CONTEXT_NAME
265: ,DATA_TYPE) Values

Line 266: (FF_CONTEXTS_S.NEXTVAL

262: CONTEXT_ID
263: ,CONTEXT_LEVEL
264: ,CONTEXT_NAME
265: ,DATA_TYPE) Values
266: (FF_CONTEXTS_S.NEXTVAL
267: ,p_context_level
268: ,p_context_name
269: ,p_data_type);
270: --