APPS.HR_KI_TPC_LOAD_API SQL Statements

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

Line: 8

procedure UPDATE_ROW (
  X_TOPIC_ID in NUMBER,
  X_NAME  in VARCHAR2,
  X_HANDLER 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_TOPICS set
    HANDLER = X_HANDLER,
    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 TOPIC_ID = X_TOPIC_ID;

Line: 30

  update HR_KI_TOPICS_TL set
    NAME = X_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 TOPIC_ID = X_TOPIC_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 41

        insert into HR_KI_TOPICS_TL (
                    TOPIC_ID,
                        NAME,
                    CREATED_BY,
                        CREATION_DATE,
                        LAST_UPDATED_BY,
                        LAST_UPDATE_DATE,
                        LAST_UPDATE_LOGIN,
                        LANGUAGE,
                        SOURCE_LANG
          ) select
                X_TOPIC_ID,
                X_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_TOPICS_TL T
                    where T.TOPIC_ID = X_TOPIC_ID
                    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 71

end UPDATE_ROW;

Line: 74

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_TOPIC_ID in out nocopy NUMBER,
  X_TOPIC_KEY in VARCHAR2,
  X_HANDLER in VARCHAR2,
  X_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_TOPICS
    where topic_id = X_TOPIC_ID;

Line: 91

  select HR_KI_TOPICS_S.NEXTVAL into X_TOPIC_ID from SYS.DUAL;

Line: 93

  insert into HR_KI_TOPICS (
    TOPIC_ID,
    TOPIC_KEY,
    HANDLER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER
  ) values (
    X_TOPIC_ID,
    X_TOPIC_KEY,
    X_HANDLER,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    1
  );

Line: 116

  insert into HR_KI_TOPICS_TL (
    TOPIC_ID,
    NAME,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_TOPIC_ID,
    X_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_TOPICS_TL T
    where T.TOPIC_ID = X_TOPIC_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 150

                                   'hr_ki_topics.insert_row');

Line: 157

end INSERT_ROW;

Line: 166

   X_LAST_UPDATE_DATE in varchar2

  )
is
  l_proc               VARCHAR2(61) := 'HR_KI_TPC_LOAD_API.LOAD_ROW';

Line: 174

  l_last_update_date   HR_KI_TOPICS.last_update_date%TYPE       := SYSDATE;

Line: 175

  l_last_updated_by    HR_KI_TOPICS.last_updated_by%TYPE         := 0;

Line: 176

  l_last_update_login  HR_KI_TOPICS.last_update_login%TYPE       := 0;

Line: 181

  db_ludate date;    -- entity update date in db

Line: 185

        select topic_id,object_version_number
        from HR_KI_TOPICS
        where upper(topic_key) = upper(X_TOPIC_KEY);

Line: 196

  l_last_updated_by := fnd_load_util.owner_id(X_OWNER);

Line: 200

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

Line: 210

      INSERT_ROW
        (X_ROWID                    => l_rowid
            ,X_TOPIC_ID                 => l_topic_id
            ,X_TOPIC_KEY                => X_TOPIC_KEY
        ,X_HANDLER                  => X_HANDLER
            ,X_NAME                     => X_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: 225

  select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from HR_KI_TOPICS
          where topic_id = l_topic_id;

Line: 231

  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_TOPIC_ID                 => l_topic_id
       ,X_NAME                     => X_NAME
       ,X_HANDLER                  => X_HANDLER
       ,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: 256

  X_LAST_UPDATE_DATE in varchar2
  )
is
  l_topic_id     HR_KI_TOPICS.topic_id%TYPE;

Line: 262

  f_ludate  date;    -- entity update date in file

Line: 264

  db_ludate date;    -- entity update date in db

Line: 274

  select topic_id into l_topic_id
  from HR_KI_TOPICS
  where upper(topic_key) = upper(X_TOPIC_KEY);

Line: 283

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

Line: 286

          select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from HR_KI_TOPICS_TL
          where
          LANGUAGE = userenv('LANG')
          and topic_id = l_topic_id;

Line: 297

          UPDATE HR_KI_TOPICS_TL
          SET
            NAME = X_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  topic_id = l_topic_id;