APPS.FF_LOAD_FTYPES_PKG SQL Statements

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

Line: 14

Procedure insert_formula_types(
                p_formula_type_name  in ff_formula_types.formula_type_name%TYPE
               ,p_type_description   in ff_formula_types.type_description%TYPE
               ,p_created_by         in ff_formula_types.CREATED_BY%TYPE
               ,p_creation_date      in ff_formula_types.CREATION_DATE%TYPE
               ,p_last_update_date   in ff_formula_types.LAST_UPDATE_DATE%TYPE
               ,p_last_updated_by    in ff_formula_types.LAST_UPDATED_BY%TYPE
               ,p_last_update_login  in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);

Line: 24

Procedure update_formula_types(
                p_formula_type_name  in ff_formula_types.formula_type_name%TYPE
               ,p_type_description   in ff_formula_types.type_description%TYPE
               ,p_last_update_date   in ff_formula_types.LAST_UPDATE_DATE%TYPE
               ,p_last_updated_by    in ff_formula_types.LAST_UPDATED_BY%TYPE
               ,p_last_update_login  in ff_formula_types.LAST_UPDATE_LOGIN%TYPE);

Line: 33

Procedure insert_fcontext_usages(
               p_formula_type_name  in FF_FORMULA_TYPES.formula_type_name%TYPE
              ,p_context_name       in FF_CONTEXTS.context_name%TYPE);

Line: 57

  l_last_updated_by    ff_formula_types.LAST_UPDATED_BY%TYPE;

Line: 58

  l_last_update_login  ff_formula_types.LAST_UPDATE_LOGIN%TYPE;

Line: 59

  l_last_update_date   ff_formula_types.LAST_UPDATE_DATE%TYPE;

Line: 65

    select  fft.formula_type_id
      from   ff_formula_types fft
     where fft.formula_type_name = p_formula_type_name;

Line: 75

  l_last_update_date  := l_sysdate;

Line: 76

  l_last_updated_by   := fnd_global.user_id;

Line: 77

  l_last_update_login := fnd_global.login_id;

Line: 85

    update_formula_types(
      p_formula_type_name   => p_formula_type_name
     ,p_type_description    => p_type_description
     ,p_last_update_date    => l_last_update_date
     ,p_last_updated_by     => l_last_updated_by
     ,p_last_update_login   => l_last_update_login);

Line: 96

    insert_formula_types(
      p_formula_type_name   => p_formula_type_name
     ,p_type_description    => p_type_description
     ,p_created_by          => l_created_by
     ,p_creation_date       => l_creation_date
     ,p_last_update_date    => l_last_update_date
     ,p_last_updated_by     => l_last_updated_by
     ,p_last_update_login   => l_last_update_login);

Line: 126

    SELECT fcu.FORMULA_TYPE_ID
     FROM FF_FTYPE_CONTEXT_USAGES fcu
         ,FF_FORMULA_TYPES fft
         ,FF_CONTEXTS fco
    WHERE fcu.FORMULA_TYPE_ID = fft.FORMULA_TYPE_ID
      AND fcu.context_id = fco.context_id
      AND fft.FORMULA_TYPE_NAME = p_formula_type_name
      AND fco.context_name = p_context_name;

Line: 146

    insert_fcontext_usages(
         p_formula_type_name     => p_formula_type_name
        ,p_context_name          => p_context_name);

Line: 163

Procedure insert_formula_types(
                p_formula_type_name  in ff_formula_types.formula_type_name%TYPE
               ,p_type_description   in ff_formula_types.type_description%TYPE
               ,p_created_by         in ff_formula_types.CREATED_BY%TYPE
               ,p_creation_date      in ff_formula_types.CREATION_DATE%TYPE
               ,p_last_update_date   in ff_formula_types.LAST_UPDATE_DATE%TYPE
               ,p_last_updated_by    in ff_formula_types.LAST_UPDATED_BY%TYPE
               ,p_last_update_login  in ff_formula_types.LAST_UPDATE_LOGIN%TYPE) Is
  l_proc   varchar2(100) := g_package || 'insert_formula_types';

Line: 177

 Insert Into FF_FORMULA_TYPES(
                    FORMULA_TYPE_ID
                   ,FORMULA_TYPE_NAME
                   ,TYPE_DESCRIPTION
                   ,LAST_UPDATE_DATE
                   ,LAST_UPDATED_BY
                   ,LAST_UPDATE_LOGIN
                   ,CREATED_BY
                   ,CREATION_DATE) Values
                   (FF_FORMULA_TYPES_S.NEXTVAL
                   ,p_formula_type_name
                   ,p_type_description
                   ,p_last_update_date
                   ,p_last_updated_by
                   ,p_last_update_login
                   ,p_created_by
                   ,p_creation_date);

Line: 196

End insert_formula_types;

Line: 199

Procedure update_formula_types(
                p_formula_type_name  in ff_formula_types.formula_type_name%TYPE
               ,p_type_description   in ff_formula_types.type_description%TYPE
               ,p_last_update_date   in ff_formula_types.LAST_UPDATE_DATE%TYPE
               ,p_last_updated_by    in ff_formula_types.LAST_UPDATED_BY%TYPE
               ,p_last_update_login  in ff_formula_types.LAST_UPDATE_LOGIN%TYPE) Is
--
  l_proc   varchar2(100) := g_package || 'update_formula_types';

Line: 211

    Update ff_formula_types
       set type_description  = p_type_description
          ,last_update_date  = p_last_update_date
          ,last_updated_by   = p_last_updated_by
          ,last_update_login = p_last_update_login
     Where formula_type_name = p_formula_type_name;

Line: 219

End update_formula_types;

Line: 224

Procedure insert_fcontext_usages(
               p_formula_type_name  in FF_FORMULA_TYPES.formula_type_name%TYPE
              ,p_context_name       in FF_CONTEXTS.context_name%TYPE) IS

  l_proc   varchar2(100) := g_package || 'insert_fcontext_usages';

Line: 241

     Insert into FF_FTYPE_CONTEXT_USAGES
                 (formula_type_id
                 ,context_id)
                 Values (l_formula_type_id
                        ,l_context_id);

Line: 250

End insert_fcontext_usages;

Line: 260

    Select formula_type_id
      From FF_FORMULA_TYPES
     Where formula_type_name =  p_formula_type_name;

Line: 295

    Select context_id
      From FF_CONTEXTS
     Where context_name =  p_context_name;