APPS.HR_KI_HRC_LOAD_API SQL Statements

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

Line: 10

procedure UPDATE_ROW (
  X_HIERARCHY_ID in NUMBER,
  X_PARENT_HIERARCHY_ID in NUMBER,
  X_NAME in VARCHAR2,
  X_DESCRIPTION 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_HIERARCHIES
   set
   PARENT_HIERARCHY_ID = X_PARENT_HIERARCHY_ID,
   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 HIERARCHY_ID = X_HIERARCHY_ID;

Line: 35

  update HR_KI_HIERARCHIES_TL set
    NAME = X_NAME,
    DESCRIPTION = X_DESCRIPTION,
    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 HIERARCHY_ID = X_HIERARCHY_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 47

        insert into HR_KI_HIERARCHIES_TL (
                        HIERARCHY_ID,
                        NAME,
                        DESCRIPTION,
                        CREATED_BY,
                        CREATION_DATE,
                        LAST_UPDATED_BY,
                        LAST_UPDATE_DATE,
                        LAST_UPDATE_LOGIN,
                        LANGUAGE,
                        SOURCE_LANG
          ) select
                X_HIERARCHY_ID,
                X_NAME,
                X_DESCRIPTION,
                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_HIERARCHIES_TL T
                    where T.hierarchy_id = X_hierarchy_id
                    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 79

end UPDATE_ROW;

Line: 82

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_HIERARCHY_ID in out nocopy NUMBER,
  X_HIERARCHY_KEY in VARCHAR2,
  X_PARENT_HIERARCHY_ID in NUMBER,
  X_NAME in varchar2,
  X_DESCRIPTION in VARCHAR2,
  X_CREATED_BY in NUMBER,
  X_CREATION_DATE in DATE,
  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_HIERARCHIES
    where hierarchy_id = X_HIERARCHY_ID;

Line: 102

select HR_KI_HIERARCHIES_S.NEXTVAL into X_HIERARCHY_ID from sys.dual;

Line: 104

  insert into HR_KI_HIERARCHIES (
    HIERARCHY_ID,
    HIERARCHY_KEY,
    PARENT_HIERARCHY_ID,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER
  ) values (
    X_HIERARCHY_ID,
    X_HIERARCHY_KEY,
    X_PARENT_HIERARCHY_ID,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    1
  );

Line: 127

  insert into HR_KI_HIERARCHIES_TL (
    HIERARCHY_ID,
    NAME,
    DESCRIPTION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_HIERARCHY_ID,
    X_NAME,
    X_DESCRIPTION,
    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_HIERARCHIES_TL T
    where T.hierarchy_id = X_hierarchy_id
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 163

                                   'HR_KI_HIERARCHIES.insert_row');

Line: 170

end INSERT_ROW;

Line: 183

        select hierarchy_id
        from HR_KI_HIERARCHIES
        where upper(hierarchy_key) = upper(X_PARENT_HIERARCHY_KEY);

Line: 216

   X_LAST_UPDATE_DATE     in VARCHAR2,
   X_CUSTOM_MODE          in VARCHAR2,
   X_OWNER                in VARCHAR2

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

Line: 226

  l_last_update_date   HR_KI_HIERARCHIES.last_update_date%TYPE       := SYSDATE;

Line: 227

  l_last_updated_by    HR_KI_HIERARCHIES.last_updated_by%TYPE         := 0;

Line: 228

  l_last_update_login  HR_KI_HIERARCHIES.last_update_login%TYPE       := 0;

Line: 234

  db_ludate date;    -- entity update date in db

Line: 239

        select hierarchy_id,object_version_number
        from HR_KI_HIERARCHIES
        where upper(hierarchy_key) = upper(X_HIERARCHY_KEY);

Line: 255

  l_last_updated_by := fnd_load_util.owner_id(X_OWNER);

Line: 259

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

Line: 270

      INSERT_ROW
        (
         X_ROWID                    => l_rowid
        ,X_HIERARCHY_ID             => l_hierarchy_id
        ,X_HIERARCHY_KEY            => X_HIERARCHY_KEY
        ,X_PARENT_HIERARCHY_ID      => l_parent_hierarchy_id
        ,X_NAME                     => X_NAME
        ,X_DESCRIPTION              => X_DESCRIPTION
        ,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: 289

  select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from HR_KI_HIERARCHIES
          where hierarchy_id = l_hierarchy_id;

Line: 295

          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_HIERARCHY_ID             => l_hierarchy_id
               ,X_PARENT_HIERARCHY_ID      => l_parent_hierarchy_id
               ,X_NAME                     => X_NAME
               ,X_DESCRIPTION              => X_DESCRIPTION
               ,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: 324

  X_LAST_UPDATE_DATE in varchar2
  )
is
  l_hierarchy_id     HR_KI_HIERARCHIES.hierarchy_id%TYPE;

Line: 330

  f_ludate  date;    -- entity update date in file

Line: 332

  db_ludate date;    -- entity update date in db

Line: 340

  select hierarchy_id into l_hierarchy_id
  from HR_KI_HIERARCHIES
  where upper(hierarchy_key) = upper(X_HIERARCHY_KEY);

Line: 349

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

Line: 352

          select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from HR_KI_HIERARCHIES_TL
          where
          LANGUAGE = userenv('LANG')
          and hierarchy_id = l_hierarchy_id;

Line: 363

          UPDATE HR_KI_HIERARCHIES_TL
          SET
            NAME = X_NAME,
            DESCRIPTION = X_DESCRIPTION,
            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  hierarchy_id = l_hierarchy_id;