APPS.HR_KI_ITF_LOAD_API SQL Statements

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

Line: 9

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_USER_INTERFACE_ID in out nocopy NUMBER,
  X_USER_INTERFACE_KEY in VARCHAR2,
  X_TYPE in VARCHAR2,
  X_FORM_NAME in varchar2,
  X_PAGE_REGION_CODE in VARCHAR2,
  X_REGION_CODE 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_USER_INTERFACES
    where user_interface_id = X_USER_INTERFACE_ID;

Line: 30

select HR_KI_USER_INTERFACES_S.NEXTVAL into X_USER_INTERFACE_ID from sys.dual;

Line: 32

  insert into HR_KI_USER_INTERFACES (
    USER_INTERFACE_ID,
    USER_INTERFACE_KEY,
    TYPE,
    FORM_NAME,
    PAGE_REGION_CODE,
    REGION_CODE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER
  ) values (
    X_USER_INTERFACE_ID,
    X_USER_INTERFACE_KEY,
    X_TYPE,
    X_FORM_NAME,
    X_PAGE_REGION_CODE,
    X_REGION_CODE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    1
  );

Line: 66

                                   'HR_KI_HIERARCHIES.insert_row');

Line: 72

end INSERT_ROW;

Line: 81

   X_LAST_UPDATE_DATE     in VARCHAR2,
   X_CUSTOM_MODE          in VARCHAR2,
   X_OWNER                in VARCHAR2
  )

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

Line: 91

  l_last_update_date   HR_KI_USER_INTERFACES.last_update_date%TYPE       := SYSDATE;

Line: 92

  l_last_updated_by    HR_KI_USER_INTERFACES.last_updated_by%TYPE         := 0;

Line: 93

  l_last_update_login  HR_KI_USER_INTERFACES.last_update_login%TYPE       := 0;

Line: 99

  db_ludate date;    -- entity update date in db

Line: 104

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

Line: 118

  l_last_updated_by := fnd_load_util.owner_id(X_OWNER);

Line: 122

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

Line: 133

      INSERT_ROW
        (
         X_ROWID                    => l_rowid
        ,X_USER_INTERFACE_ID        => l_user_interface_id
        ,X_USER_INTERFACE_KEY       => X_USER_INTERFACE_KEY
        ,X_TYPE                     => X_TYPE
        ,X_FORM_NAME                => X_FORM_NAME
        ,X_PAGE_REGION_CODE         => X_PAGE_REGION_CODE
	,X_REGION_CODE              => X_REGION_CODE
        ,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
        );