APPS.HR_KI_UCX_LOAD_API SQL Statements

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

Line: 8

procedure UPDATE_ROW (
                 X_UI_CONTEXT_ID            in number
                ,X_LABEL                    in varchar
                ,X_LOCATION                 in varchar
                ,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_UI_CONTEXTS
   set
   LABEL = X_LABEL,
   LOCATION=X_LOCATION,
   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 UI_CONTEXT_ID = X_UI_CONTEXT_ID;

Line: 30

end UPDATE_ROW;

Line: 32

procedure INSERT_ROW (
  X_ROWID                    in out nocopy VARCHAR2,
  X_UI_CONTEXT_ID            in out nocopy NUMBER,
  X_USER_INTERFACE_ID        in NUMBER,
  X_UI_CONTEXT_KEY           in VARCHAR,
  X_LABEL                    in VARCHAR,
  X_LOCATION                 in VARCHAR,
  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_UI_CONTEXTS
    where ui_context_id = x_ui_context_id;

Line: 52

select HR_KI_UI_CONTEXTS_S.NEXTVAL into x_ui_context_id from sys.dual;

Line: 54

  insert into HR_KI_UI_CONTEXTS (
    ui_context_id,
    ui_context_key,
    user_interface_id,
    label,
    location,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER
  ) values (
    X_UI_CONTEXT_ID,
    X_UI_CONTEXT_KEY,
    X_USER_INTERFACE_ID,
    X_LABEL,
    X_LOCATION,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    1
  );

Line: 86

                                   'HR_KI_UI_CONTEXTS.insert_row');

Line: 93

end INSERT_ROW;

Line: 105

        select user_interface_id
        from HR_KI_USER_INTERFACES
        where upper(user_interface_key) = upper(X_USER_INTERFACE_KEY);

Line: 131

   X_LAST_UPDATE_DATE   in VARCHAR2,
   X_CUSTOM_MODE        in VARCHAR2,
   X_OWNER              in VARCHAR2

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

Line: 141

  l_last_update_date   HR_KI_UI_CONTEXTS.last_update_date%TYPE       := SYSDATE;

Line: 142

  l_last_updated_by    HR_KI_UI_CONTEXTS.last_updated_by%TYPE         := 0;

Line: 143

  l_last_update_login  HR_KI_UI_CONTEXTS.last_update_login%TYPE       := 0;

Line: 150

  db_ludate date;    -- entity update date in db

Line: 153

    select uic.ui_context_id,uic.object_version_number
        from HR_KI_UI_CONTEXTS uic,
        hr_ki_user_interfaces uit
   where uic.user_interface_id = uit.user_interface_id
     and upper(uic.ui_context_key)=upper(x_ui_context_key)
     and upper(uit.user_interface_key)=upper(x_user_interface_key);

Line: 172

  l_last_updated_by := fnd_load_util.owner_id(X_OWNER);

Line: 176

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

Line: 187

      INSERT_ROW
        (
         X_ROWID                    => l_rowid
        ,X_UI_CONTEXT_ID            => l_ui_context_id
        ,X_USER_INTERFACE_ID        => l_user_interface_id
        ,X_UI_CONTEXT_KEY           => x_ui_context_key
        ,X_LABEL                    => x_label
        ,X_LOCATION                 => x_location
        ,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: 205

   select LAST_UPDATED_BY, LAST_UPDATE_DATE
           into db_luby, db_ludate
           from HR_KI_UI_CONTEXTS
           where ui_context_id = l_ui_context_id;

Line: 211

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

-- Updating label is allowed but the UI_CONTEXT_KEY will not be updated
-- by convention UI_CONTEXT_KEY should be ::

-- Ideally we should not allow to update,but chances are
-- that we need way to handle updation of label
-- Recommended way is to create new row

               UPDATE_ROW
               (
                 X_UI_CONTEXT_ID            => l_ui_context_id
                ,X_LABEL                    => X_LABEL
                ,X_LOCATION                 => X_LOCATION
                ,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
               );