APPS.FND_OBJECT_DEFINITIONS_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_OBJECT_DEFINITION_ID in NUMBER,
  X_APPLICATION_ID in NUMBER,
  X_OBJECT_ID in NUMBER,
  X_OBJECT_DEFINITION_TYPE in VARCHAR2,
  X_OBJECT_VERSION in VARCHAR2,
  X_OBJECT_EXTENSION_VERSION in VARCHAR2,
  X_STATUS in VARCHAR2,
  X_ENABLED_FLAG in VARCHAR2,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  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,
  X_OBJECT_DEFINITION in XMLTYPE,
  X_OBJECT_REFERENCE in XMLTYPE
) is
begin

  insert into FND_OBJECT_DEFINITIONS (
    OBJECT_DEFINITION_ID,
    APPLICATION_ID,
    OBJECT_ID,
    OBJECT_DEFINITION_TYPE,
    OBJECT_VERSION,
    OBJECT_EXTENSION_VERSION,
    STATUS,
    ENABLED_FLAG,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_DEFINITION,
    OBJECT_REFERENCE
  ) values (
    X_OBJECT_DEFINITION_ID,
    X_APPLICATION_ID,
    X_OBJECT_ID,
    X_OBJECT_DEFINITION_TYPE,
    X_OBJECT_VERSION,
    X_OBJECT_EXTENSION_VERSION,
    X_STATUS,
    X_ENABLED_FLAG,
    X_START_DATE_ACTIVE,
    X_END_DATE_ACTIVE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_OBJECT_DEFINITION,
    X_OBJECT_REFERENCE
  );

Line: 63

end INSERT_ROW;

Line: 65

procedure UPDATE_ROW (
  X_APPLICATION_ID in NUMBER,
  X_OBJECT_ID in NUMBER,
  X_OBJECT_DEFINITION_TYPE in VARCHAR2,
  X_OBJECT_VERSION in VARCHAR2,
  X_OBJECT_EXTENSION_VERSION in VARCHAR2,
  X_STATUS in VARCHAR2,
  X_ENABLED_FLAG in VARCHAR2,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  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,
  X_OBJECT_DEFINITION in XMLTYPE,
  X_OBJECT_REFERENCE in XMLTYPE
) is
begin

  update FND_OBJECT_DEFINITIONS set
    APPLICATION_ID = X_APPLICATION_ID,
    OBJECT_DEFINITION_TYPE = X_OBJECT_DEFINITION_TYPE,
    OBJECT_VERSION = X_OBJECT_VERSION,
    OBJECT_EXTENSION_VERSION = X_OBJECT_EXTENSION_VERSION,
    STATUS = X_STATUS,
    ENABLED_FLAG = X_ENABLED_FLAG,
    START_DATE_ACTIVE = X_START_DATE_ACTIVE,
    END_DATE_ACTIVE = X_END_DATE_ACTIVE,
    CREATION_DATE = X_CREATION_DATE,
    CREATED_BY = X_CREATED_BY,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    OBJECT_DEFINITION = X_OBJECT_DEFINITION,
    OBJECT_REFERENCE = X_OBJECT_REFERENCE
  where OBJECT_ID = X_OBJECT_ID;

Line: 107

end UPDATE_ROW;

Line: 120

  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_DEFINITION in XMLTYPE,
  X_OBJECT_REFERENCE in XMLTYPE
) is
 app_id     number;

Line: 131

 f_ludate   date;    -- entity update date in file

Line: 133

 db_ludate  date;    -- entity update date in db

Line: 136

  select object_id, last_updated_by, last_update_date
  into obj_id, db_luby, db_ludate
  from fnd_objects
  where obj_name = X_OBJ_NAME;

Line: 141

  fnd_object_definitions_pkg.UPDATE_ROW (
      X_APPLICATION_ID             => X_APPLICATION_ID,
      X_OBJECT_ID                  => obj_id,
      X_OBJECT_DEFINITION_TYPE     => X_OBJECT_DEFINITION_TYPE,
      X_OBJECT_VERSION             => '12.0',
      X_OBJECT_EXTENSION_VERSION   => X_OBJECT_EXTENSION_VERSION,
      X_STATUS                     => X_STATUS,
      X_ENABLED_FLAG               => X_ENABLED_FLAG,
      X_START_DATE_ACTIVE          => X_START_DATE_ACTIVE,
      X_END_DATE_ACTIVE            => '',
      X_CREATION_DATE              => X_CREATION_DATE,
      X_CREATED_BY                 => X_CREATED_BY,
      X_LAST_UPDATE_DATE           => X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY            => X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN          => X_LAST_UPDATE_LOGIN,
      X_OBJECT_DEFINITION          => X_OBJECT_DEFINITION,
      X_OBJECT_REFERENCE           => X_OBJECT_REFERENCE);

Line: 162

  select fnd_object_definitions_s.nextval into obj_def_id from dual;

Line: 164

  fnd_object_definitions_pkg.INSERT_ROW (
      X_OBJECT_DEFINITION_ID       => obj_def_id,
      X_APPLICATION_ID             => X_APPLICATION_ID,
      X_OBJECT_ID                  => obj_id,
      X_OBJECT_DEFINITION_TYPE     => X_OBJECT_DEFINITION_TYPE,
      X_OBJECT_VERSION             => '12.0',
      X_OBJECT_EXTENSION_VERSION   => X_OBJECT_EXTENSION_VERSION,
      X_STATUS                     => X_STATUS,
      X_ENABLED_FLAG               => X_ENABLED_FLAG,
      X_START_DATE_ACTIVE          => X_START_DATE_ACTIVE,
      X_END_DATE_ACTIVE            => '',
      X_CREATION_DATE              => X_CREATION_DATE,
      X_CREATED_BY                 => X_CREATED_BY,
      X_LAST_UPDATE_DATE           => X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY            => X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN          => X_LAST_UPDATE_LOGIN,
      X_OBJECT_DEFINITION          => X_OBJECT_DEFINITION,
      X_OBJECT_REFERENCE           => X_OBJECT_REFERENCE);