APPS.FF_LOAD_CONTEXTS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

Procedure insert_contexts(
               p_context_name    in ff_contexts.context_name%TYPE
               ,p_context_level   in ff_contexts.context_level%TYPE
               ,p_data_type       in ff_contexts.data_type%TYPE);

Line: 213

    select  fcon.context_id
      from   ff_contexts fcon
     where  fcon.context_name   = p_context_name;

Line: 232

    insert_contexts(
                p_context_name   => p_context_name
               ,p_context_level  => p_context_level
               ,p_data_type      => p_data_type);

Line: 249

Procedure insert_contexts(
                p_context_name    in ff_contexts.context_name%TYPE
               ,p_context_level   in ff_contexts.context_level%TYPE
               ,p_data_type       in ff_contexts.data_type%TYPE) Is
--
  l_proc   varchar2(100) := g_package || 'insert_contexts';

Line: 261

 Insert Into FF_CONTEXTS(
                     CONTEXT_ID
                    ,CONTEXT_LEVEL
                    ,CONTEXT_NAME
                    ,DATA_TYPE) Values
                   (FF_CONTEXTS_S.NEXTVAL
                   ,p_context_level
                   ,p_context_name
                   ,p_data_type);

Line: 273

End insert_contexts;