APPS.HR_KI_OTY_LOAD_API SQL Statements

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

Line: 10

procedure UPDATE_ROW (
  X_OPTION_TYPE_ID in NUMBER,
  X_DISPLAY_TYPE in VARCHAR2,
  X_OPTION_NAME in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER

) is

begin


   update HR_KI_OPTION_TYPES
   set
   DISPLAY_TYPE = X_DISPLAY_TYPE,
   LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
   LAST_UPDATED_BY = X_LAST_UPDATED_BY,
   LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
   OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER+1
  where OPTION_TYPE_ID = X_OPTION_TYPE_ID;

Line: 34

  update HR_KI_OPTION_TYPES_TL set
    OPTION_NAME = X_OPTION_NAME,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where OPTION_TYPE_ID = X_OPTION_TYPE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 45

        insert into HR_KI_OPTION_TYPES_TL (
                        OPTION_TYPE_ID,
                        OPTION_NAME,
                        CREATED_BY,
                        CREATION_DATE,
                        LAST_UPDATED_BY,
                        LAST_UPDATE_DATE,
                        LAST_UPDATE_LOGIN,
                        LANGUAGE,
                        SOURCE_LANG
          ) select
                X_OPTION_TYPE_ID,
                X_OPTION_NAME,
                1 ,
                SYSDATE,
                X_LAST_UPDATED_BY,
                X_LAST_UPDATE_DATE,
                X_LAST_UPDATE_LOGIN,
                L.LANGUAGE_CODE,
                userenv('LANG')
          from FND_LANGUAGES L
          where L.INSTALLED_FLAG in ('I', 'B')
          and not exists
            (select NULL
                    from HR_KI_OPTION_TYPES_TL T
                    where T.OPTION_TYPE_ID = X_OPTION_TYPE_ID
                    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 75

end UPDATE_ROW;

Line: 78

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_OPTION_TYPE_ID in out nocopy NUMBER,
  X_OPTION_TYPE_KEY in VARCHAR2,
  X_DISPLAY_TYPE in VARCHAR2,
  X_OPTION_NAME in varchar2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is

  cursor C is select ROWID from HR_KI_OPTION_TYPES
    where option_type_id = X_OPTION_TYPE_ID;

Line: 96

select HR_KI_OPTION_TYPES_S.NEXTVAL into X_OPTION_TYPE_ID from sys.dual;

Line: 98

  insert into HR_KI_OPTION_TYPES (
    OPTION_TYPE_ID,
    OPTION_TYPE_KEY,
    DISPLAY_TYPE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER
  ) values (
    X_OPTION_TYPE_ID,
    X_OPTION_TYPE_KEY,
    X_DISPLAY_TYPE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    1
  );

Line: 121

  insert into HR_KI_OPTION_TYPES_TL (
    OPTION_TYPE_ID,
    OPTION_NAME,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_OPTION_TYPE_ID,
    X_OPTION_NAME,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from HR_KI_OPTION_TYPES_TL T
    where T.OPTION_TYPE_ID = X_OPTION_TYPE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 155

                                   'hr_ki_option_types.insert_row');

Line: 162

end INSERT_ROW;

Line: 171

   X_LAST_UPDATE_DATE in varchar2

  )
is
  l_proc               VARCHAR2(31) := 'HR_KI_OTY_LOAD_API.LOAD_ROW';

Line: 179

  l_last_update_date   HR_KI_OPTION_TYPES.last_update_date%TYPE       := SYSDATE;

Line: 180

  l_last_updated_by    HR_KI_OPTION_TYPES.last_updated_by%TYPE         := 0;

Line: 181

  l_last_update_login  HR_KI_OPTION_TYPES.last_update_login%TYPE       := 0;

Line: 186

  db_ludate date;    -- entity update date in db

Line: 190

        select option_type_id,object_version_number
        from HR_KI_OPTION_TYPES
        where upper(option_type_key) = upper(X_OPTION_TYPE_KEY);

Line: 201

  l_last_updated_by := fnd_load_util.owner_id(X_OWNER);

Line: 205

  l_last_update_date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD hh24:mi:ss'), sysdate);

Line: 216

      INSERT_ROW
        (X_ROWID                    => l_rowid
        ,X_OPTION_TYPE_ID           => l_option_type_id
        ,X_OPTION_TYPE_KEY          => X_OPTION_TYPE_KEY
        ,X_DISPLAY_TYPE             => X_DISPLAY_TYPE
        ,X_OPTION_NAME              => X_OPTION_NAME
        ,X_CREATED_BY               => l_created_by
        ,X_CREATION_DATE            => l_creation_date
        ,X_LAST_UPDATE_DATE         => l_last_update_date
        ,X_LAST_UPDATED_BY          => l_last_updated_by
        ,X_LAST_UPDATE_LOGIN        => l_last_update_login
        );

Line: 232

  select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from HR_KI_OPTION_TYPES
          where option_type_id = l_option_type_id;

Line: 238

          if (fnd_load_util.upload_test(l_last_updated_by, l_last_update_date, db_luby,
                                                db_ludate, X_CUSTOM_MODE)) then

              UPDATE_ROW
              (        X_OPTION_TYPE_ID           => l_option_type_id
               ,X_OPTION_NAME              => X_OPTION_NAME
               ,X_DISPLAY_TYPE             => X_DISPLAY_TYPE
               ,X_LAST_UPDATE_DATE         => l_last_update_date
               ,X_LAST_UPDATED_BY          => l_last_updated_by
               ,X_LAST_UPDATE_LOGIN        => l_last_update_login
               ,X_OBJECT_VERSION_NUMBER    => l_object_version_number
              );

Line: 263

  X_LAST_UPDATE_DATE in varchar2
  )
is
  l_option_type_id     HR_KI_OPTION_TYPES.option_type_id%TYPE;

Line: 269

  f_ludate  date;    -- entity update date in file

Line: 271

  db_ludate date;    -- entity update date in db

Line: 280

  select option_type_id into l_option_type_id
  from HR_KI_OPTION_TYPES
  where upper(option_type_key) = upper(X_OPTION_TYPE_KEY);

Line: 289

  f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD hh24:mi:ss'), sysdate);

Line: 292

          select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from HR_KI_OPTION_TYPES_TL
          where
          LANGUAGE = userenv('LANG')
          and option_type_id = l_option_type_id;

Line: 303

          UPDATE HR_KI_OPTION_TYPES_TL
          SET
            OPTION_NAME = X_OPTION_NAME,
            LAST_UPDATE_DATE = f_ludate ,
            LAST_UPDATED_BY = f_luby,
            LAST_UPDATE_LOGIN = 0,
            SOURCE_LANG = userenv('LANG')
            where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
               and  option_type_id = l_option_type_id;