eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_KI_TIS_LOAD_API SQL Statements

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

Line: 10


procedure INSERT_ROW (
  X_ROWID                 in out nocopy VARCHAR2,
  X_TOPIC_INTEGRATIONS_ID in out nocopy NUMBER,
  X_TOPIC_ID              in NUMBER,
  X_INTEGRATION_ID        in NUMBER,
  X_PARAM_NAME1           in VARCHAR2,
  X_PARAM_VALUE1          in VARCHAR2,
  X_PARAM_NAME2           in VARCHAR2,
  X_PARAM_VALUE2          in VARCHAR2,
  X_PARAM_NAME3           in VARCHAR2,
  X_PARAM_VALUE3          in VARCHAR2,
  X_PARAM_NAME4           in VARCHAR2,
  X_PARAM_VALUE4          in VARCHAR2,
  X_PARAM_NAME5           in VARCHAR2,
  X_PARAM_VALUE5          in VARCHAR2,
  X_PARAM_NAME6           in VARCHAR2,
  X_PARAM_VALUE6          in VARCHAR2,
  X_PARAM_NAME7           in VARCHAR2,
  X_PARAM_VALUE7          in VARCHAR2,
  X_PARAM_NAME8           in VARCHAR2,
  X_PARAM_VALUE8          in VARCHAR2,
  X_PARAM_NAME9           in VARCHAR2,
  X_PARAM_VALUE9          in VARCHAR2,
  X_PARAM_NAME10          in VARCHAR2,
  X_PARAM_VALUE10         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
  L_LOCK_HANDLE             varchar2(500);

Line: 45


    SELECT ROWID
      FROM HR_KI_TOPIC_INTEGRATIONS
     WHERE topic_integrations_id = x_topic_integrations_id;

Line: 61


    select HR_KI_TOPIC_INTEGRATIONS_S.NEXTVAL into x_topic_integrations_id
    from sys.dual;

Line: 64


    insert into HR_KI_TOPIC_INTEGRATIONS (
      TOPIC_INTEGRATIONS_ID,
      TOPIC_ID,
      INTEGRATION_ID,
      PARAM_NAME1,
      PARAM_VALUE1,
      PARAM_NAME2,
      PARAM_VALUE2,
      PARAM_NAME3,
      PARAM_VALUE3,
      PARAM_NAME4,
      PARAM_VALUE4,
      PARAM_NAME5,
      PARAM_VALUE5,
      PARAM_NAME6,
      PARAM_VALUE6,
      PARAM_NAME7,
      PARAM_VALUE7,
      PARAM_NAME8,
      PARAM_VALUE8,
      PARAM_NAME9,
      PARAM_VALUE9,
      PARAM_NAME10,
      PARAM_VALUE10,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN,
      OBJECT_VERSION_NUMBER
    ) values (
      X_TOPIC_INTEGRATIONS_ID,
      X_TOPIC_ID,
      X_INTEGRATION_ID,
      X_PARAM_NAME1,
      X_PARAM_VALUE1,
      X_PARAM_NAME2,
      X_PARAM_VALUE2,
      X_PARAM_NAME3,
      X_PARAM_VALUE3,
      X_PARAM_NAME4,
      X_PARAM_VALUE4,
      X_PARAM_NAME5,
      X_PARAM_VALUE5,
      X_PARAM_NAME6,
      X_PARAM_VALUE6,
      X_PARAM_NAME7,
      X_PARAM_VALUE7,
      X_PARAM_NAME8,
      X_PARAM_VALUE8,
      X_PARAM_NAME9,
      X_PARAM_VALUE9,
      X_PARAM_NAME10,
      X_PARAM_VALUE10,
      X_CREATION_DATE,
      X_CREATED_BY,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN,
      1
    );

Line: 133


                                   'HR_KI_TOPIC_INTEGRATIONS.insert_row');

Line: 139


end INSERT_ROW;

Line: 143


procedure UPDATE_ROW
  (X_TOPIC_INTEGRATIONS_ID in NUMBER,
   X_TOPIC_ID              in NUMBER,
   X_INTEGRATION_ID        in NUMBER,
   X_PARAM_NAME1           in VARCHAR2,
   X_PARAM_VALUE1          in VARCHAR2,
   X_PARAM_NAME2           in VARCHAR2,
   X_PARAM_VALUE2          in VARCHAR2,
   X_PARAM_NAME3           in VARCHAR2,
   X_PARAM_VALUE3          in VARCHAR2,
   X_PARAM_NAME4           in VARCHAR2,
   X_PARAM_VALUE4          in VARCHAR2,
   X_PARAM_NAME5           in VARCHAR2,
   X_PARAM_VALUE5          in VARCHAR2,
   X_PARAM_NAME6           in VARCHAR2,
   X_PARAM_VALUE6          in VARCHAR2,
   X_PARAM_NAME7           in VARCHAR2,
   X_PARAM_VALUE7          in VARCHAR2,
   X_PARAM_NAME8           in VARCHAR2,
   X_PARAM_VALUE8          in VARCHAR2,
   X_PARAM_NAME9           in VARCHAR2,
   X_PARAM_VALUE9          in VARCHAR2,
   X_PARAM_NAME10          in VARCHAR2,
   X_PARAM_VALUE10         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,
   X_OBJECT_VERSION_NUMBER in NUMBER
   ) as
  L_LOCK_HANDLE             varchar2(500);

Line: 188


    UPDATE HR_KI_TOPIC_INTEGRATIONS TIS
       SET tis.topic_id              = X_TOPIC_ID
          ,tis.integration_id        = X_INTEGRATION_ID
          ,tis.PARAM_NAME1           = X_PARAM_NAME1
          ,tis.PARAM_VALUE1          = X_PARAM_VALUE1
          ,tis.PARAM_NAME2           = X_PARAM_NAME2
          ,tis.PARAM_VALUE2          = X_PARAM_VALUE2
          ,tis.PARAM_NAME3           = X_PARAM_NAME3
          ,tis.PARAM_VALUE3          = X_PARAM_VALUE3
          ,tis.PARAM_NAME4           = X_PARAM_NAME4
          ,tis.PARAM_VALUE4          = X_PARAM_VALUE4
          ,tis.PARAM_NAME5           = X_PARAM_NAME5
          ,tis.PARAM_VALUE5          = X_PARAM_VALUE5
          ,tis.PARAM_NAME6           = X_PARAM_NAME6
          ,tis.PARAM_VALUE6          = X_PARAM_VALUE6
          ,tis.PARAM_NAME7           = X_PARAM_NAME7
          ,tis.PARAM_VALUE7          = X_PARAM_VALUE7
          ,tis.PARAM_NAME8           = X_PARAM_NAME8
          ,tis.PARAM_VALUE8          = X_PARAM_VALUE8
          ,tis.PARAM_NAME9           = X_PARAM_NAME9
          ,tis.PARAM_VALUE9          = X_PARAM_VALUE9
          ,tis.PARAM_NAME10          = X_PARAM_NAME10
          ,tis.PARAM_VALUE10         = X_PARAM_VALUE10
          ,tis.CREATED_BY            = X_CREATED_BY
          ,tis.CREATION_DATE         = X_CREATION_DATE
          ,tis.LAST_UPDATE_DATE      = X_LAST_UPDATE_DATE
          ,tis.LAST_UPDATED_BY       = X_LAST_UPDATED_BY
          ,tis.LAST_UPDATE_LOGIN     = X_LAST_UPDATE_LOGIN
          ,tis.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
     WHERE tis.TOPIC_INTEGRATIONS_ID = X_TOPIC_INTEGRATIONS_ID;

Line: 219


end UPDATE_ROW;

Line: 235


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

Line: 240


        select integration_id
        from HR_KI_INTEGRATIONS
        where upper(integration_key) = upper(X_INTEGRATION_KEY);

Line: 291


   X_LAST_UPDATE_DATE in VARCHAR2,
   X_CUSTOM_MODE      in VARCHAR2,
   X_OWNER            in VARCHAR2
   )
is
  l_proc                   VARCHAR2(31) := 'HR_KI_TIS_LOAD_API.LOAD_ROW';

Line: 300


  l_last_update_date       HR_KI_TOPIC_INTEGRATIONS.last_update_date%TYPE   := SYSDATE;

Line: 301


  l_last_updated_by        HR_KI_TOPIC_INTEGRATIONS.last_updated_by%TYPE    := 0;

Line: 302


  l_last_update_login      HR_KI_TOPIC_INTEGRATIONS.last_update_login%TYPE  := 0;

Line: 308


  db_ludate                date;    -- entity update date in db

Line: 311


    select tpi.topic_integrations_id,
           nvl(tpi.object_version_number,1)
      from hr_ki_topic_integrations tpi,
           hr_ki_topics top,
           hr_ki_integrations int
     where tpi.topic_id        = top.topic_id
       and tpi.integration_id  = int.integration_id
       and top.topic_key       = X_TOPIC_KEY
       and int.integration_key = X_INTEGRATION_KEY;

Line: 322


  X_CURRENT_LAST_UPDATE_DATE   HR_KI_TOPIC_INTEGRATIONS.last_update_date%TYPE;

Line: 338


  l_last_updated_by := fnd_load_util.owner_id(X_OWNER);

Line: 341


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

Line: 351


     INSERT_ROW
      (X_ROWID                  => l_rowid
      ,X_TOPIC_INTEGRATIONS_ID  => l_topic_integrations_id
      ,X_TOPIC_ID               => l_topic_id
      ,X_INTEGRATION_ID         => l_integration_id
      ,X_PARAM_NAME1            => X_PARAM_NAME1
      ,X_PARAM_VALUE1           => X_PARAM_VALUE1
      ,X_PARAM_NAME2            => X_PARAM_NAME2
      ,X_PARAM_VALUE2           => X_PARAM_VALUE2
      ,X_PARAM_NAME3            => X_PARAM_NAME3
      ,X_PARAM_VALUE3           => X_PARAM_VALUE3
      ,X_PARAM_NAME4            => X_PARAM_NAME4
      ,X_PARAM_VALUE4           => X_PARAM_VALUE4
      ,X_PARAM_NAME5            => X_PARAM_NAME5
      ,X_PARAM_VALUE5           => X_PARAM_VALUE5
      ,X_PARAM_NAME6            => X_PARAM_NAME6
      ,X_PARAM_VALUE6           => X_PARAM_VALUE6
      ,X_PARAM_NAME7            => X_PARAM_NAME7
      ,X_PARAM_VALUE7           => X_PARAM_VALUE7
      ,X_PARAM_NAME8            => X_PARAM_NAME8
      ,X_PARAM_VALUE8           => X_PARAM_VALUE8
      ,X_PARAM_NAME9            => X_PARAM_NAME9
      ,X_PARAM_VALUE9           => X_PARAM_VALUE9
      ,X_PARAM_NAME10           => X_PARAM_NAME10
      ,X_PARAM_VALUE10          => X_PARAM_VALUE10
      ,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: 384


    SELECT tis.LAST_UPDATED_BY,
           tis.LAST_UPDATE_DATE
      INTO X_CURRENT_OWNER,
           X_CURRENT_LAST_UPDATE_DATE
      FROM HR_KI_TOPIC_INTEGRATIONS tis
     WHERE tis.topic_id = l_topic_id
       AND tis.integration_id = l_integration_id;

Line: 393


         (P_FILE_ID              => l_last_updated_by
         ,P_FILE_LUD             => l_last_update_date
         ,P_DB_ID                => X_CURRENT_OWNER
         ,P_DB_LUD               => to_date(X_CURRENT_LAST_UPDATE_DATE,'YYYY/MM/DD HH24:MI:SS')
         ,P_CUSTOM_MODE          => X_CUSTOM_MODE
         )
       ) then
      UPDATE_ROW
      (X_TOPIC_INTEGRATIONS_ID  => l_topic_integrations_id
      ,X_TOPIC_ID               => l_topic_id
      ,X_INTEGRATION_ID         => l_integration_id
      ,X_PARAM_NAME1            => X_PARAM_NAME1
      ,X_PARAM_VALUE1           => X_PARAM_VALUE1
      ,X_PARAM_NAME2            => X_PARAM_NAME2
      ,X_PARAM_VALUE2           => X_PARAM_VALUE2
      ,X_PARAM_NAME3            => X_PARAM_NAME3
      ,X_PARAM_VALUE3           => X_PARAM_VALUE3
      ,X_PARAM_NAME4            => X_PARAM_NAME4
      ,X_PARAM_VALUE4           => X_PARAM_VALUE4
      ,X_PARAM_NAME5            => X_PARAM_NAME5
      ,X_PARAM_VALUE5           => X_PARAM_VALUE5
      ,X_PARAM_NAME6            => X_PARAM_NAME6
      ,X_PARAM_VALUE6           => X_PARAM_VALUE6
      ,X_PARAM_NAME7            => X_PARAM_NAME7
      ,X_PARAM_VALUE7           => X_PARAM_VALUE7
      ,X_PARAM_NAME8            => X_PARAM_NAME8
      ,X_PARAM_VALUE8           => X_PARAM_VALUE8
      ,X_PARAM_NAME9            => X_PARAM_NAME9
      ,X_PARAM_VALUE9           => X_PARAM_VALUE9
      ,X_PARAM_NAME10           => X_PARAM_NAME10
      ,X_PARAM_VALUE10          => X_PARAM_VALUE10
      ,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
      ,X_OBJECT_VERSION_NUMBER  => l_object_version_number + 1
      );