APPS.FLM_SEQ_ATTRIBUTES_PKG SQL Statements

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

Line: 15

          x_last_update_date            in      varchar2) is
begin
   if (x_upload_mode = 'NLS') then
      FLM_SEQ_ATTRIBUTES_PKG.TRANSLATE_ROW(
         x_custom_mode,
	 x_attribute_id,
         x_description,
	 x_owner,
	 x_last_update_date);

Line: 35

	 x_last_update_date);

Line: 44

          x_last_update_date            in      varchar2) is
   user_id NUMBER := 0;

Line: 46

   f_ludate  date;    -- entity update date in file

Line: 48

   db_ludate date;    -- entity update date in db

Line: 53

   f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 56

   select LAST_UPDATED_BY, LAST_UPDATE_DATE
   into   db_luby, db_ludate
   from   FLM_SEQ_ATTRIBUTES
   where  ATTRIBUTE_ID = x_attribute_id;

Line: 63

      update FLM_SEQ_ATTRIBUTES set
             DESCRIPTION = x_description,
             LAST_UPDATED_BY = user_id,
             LAST_UPDATE_DATE = f_ludate,
             LAST_UPDATE_LOGIN = 0
      where  ATTRIBUTE_ID = x_attribute_id
        and  userenv('LANG') = (select  LANGUAGE_CODE
                               from     FND_LANGUAGES
                               where    INSTALLED_FLAG = 'B' );

Line: 91

          x_last_update_date            in      varchar2) is
   user_id NUMBER := 0;

Line: 93

   f_ludate  date;    -- entity update date in file

Line: 95

   db_ludate date;    -- entity update date in db

Line: 101

   f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 103

   select count(*)
     into other_att
     from FLM_SEQ_ATTRIBUTES
    where ATTRIBUTE_NAME = x_attribute_name
      and ATTRIBUTE_ID > 1000;

Line: 113

   select LAST_UPDATED_BY, LAST_UPDATE_DATE
   into   db_luby, db_ludate
   from   FLM_SEQ_ATTRIBUTES
   where  ATTRIBUTE_ID = x_attribute_id;

Line: 120

      update FLM_SEQ_ATTRIBUTES set
             ATTRIBUTE_NAME = x_attribute_name,
             DESCRIPTION = x_description,
             USER_DEFINED_FLAG = x_user_defined_flag,
             ATTRIBUTE_TYPE = x_attribute_type,
             ATTRIBUTE_SOURCE = x_attribute_source,
             ATTRIBUTE_VALUE_TYPE = x_attribute_value_type,
             LAST_UPDATE_DATE = f_ludate,
             LAST_UPDATED_BY = user_id,
             LAST_UPDATE_LOGIN = 0
      where  ATTRIBUTE_ID = x_attribute_id;

Line: 136

      insert into FLM_SEQ_ATTRIBUTES (
                  ATTRIBUTE_ID,
                  ATTRIBUTE_NAME,
                  DESCRIPTION,
                  USER_DEFINED_FLAG,
                  ATTRIBUTE_TYPE,
                  ATTRIBUTE_SOURCE,
                  ATTRIBUTE_VALUE_TYPE,
                  OBJECT_VERSION_NUMBER,
                  LAST_UPDATE_DATE,
                  LAST_UPDATED_BY,
                  CREATION_DATE,
                  CREATED_BY,
                  LAST_UPDATE_LOGIN )
           values (
                  x_attribute_id,
                  x_attribute_name,
                  x_description,
                  x_user_defined_flag,
                  x_attribute_type,
                  x_attribute_source,
                  x_attribute_value_type,
                  1,
                  f_ludate,
                  user_id,
                  f_ludate,
                  user_id,
                  0 );