APPS.HZ_PARTY_PREFERENCES_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID                 in out NOCOPY VARCHAR2,
  X_PARTY_PREFERENCE_ID   in     NUMBER,
  X_PARTY_ID              in     NUMBER,
  X_MODULE                in     VARCHAR2,
  X_CATEGORY              in     VARCHAR2,
  X_PREFERENCE_CODE       in     VARCHAR2,
  X_VALUE_VARCHAR2        in     VARCHAR2,
  X_VALUE_NUMBER          in     NUMBER,
  X_VALUE_DATE            in     DATE,
  X_VALUE_NAME            in     VARCHAR2,
  X_ADDITIONAL_VALUE1     in     VARCHAR2,
  X_ADDITIONAL_VALUE2     in     VARCHAR2,
  X_ADDITIONAL_VALUE3     in     VARCHAR2,
  X_ADDITIONAL_VALUE4     in     VARCHAR2,
  X_ADDITIONAL_VALUE5     in     VARCHAR2,
  X_OBJECT_VERSION_NUMBER in     NUMBER,
  X_CREATED_BY            in     NUMBER,
  X_CREATION_DATE         in     DATE,
  X_LAST_UPDATED_BY       in     NUMBER,
  X_LAST_UPDATE_DATE      in     DATE,
  X_LAST_UPDATE_LOGIN     in     NUMBER
) is
  cursor C is select ROWID from HZ_PARTY_PREFERENCES
    where PARTY_PREFERENCE_ID = X_PARTY_PREFERENCE_ID;

Line: 31

  insert into HZ_PARTY_PREFERENCES (
    PARTY_PREFERENCE_ID,
    PARTY_ID,
    MODULE,
    CATEGORY,
    PREFERENCE_CODE,
    VALUE_VARCHAR2,
    VALUE_NUMBER,
    VALUE_DATE,
    VALUE_NAME,
    ADDITIONAL_VALUE1,
    ADDITIONAL_VALUE2,
    ADDITIONAL_VALUE3,
    ADDITIONAL_VALUE4,
    ADDITIONAL_VALUE5,
    OBJECT_VERSION_NUMBER,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
  )
    VALUES
 (  X_PARTY_PREFERENCE_ID
  , DECODE(X_PARTY_ID, FND_API.G_MISS_NUM, NULL, X_PARTY_ID)
  , DECODE(X_MODULE, FND_API.G_MISS_CHAR, NULL, X_MODULE)
  , DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, NULL, X_CATEGORY)
  , DECODE(X_PREFERENCE_CODE,  FND_API.G_MISS_CHAR, NULL, X_PREFERENCE_CODE)
  , DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, NULL, X_VALUE_VARCHAR2)
  , DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, NULL, X_VALUE_NUMBER)
  , DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), X_VALUE_DATE)
  , DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, NULL, X_VALUE_NAME)
  , DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE1)
  , DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE2)
  , DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE3)
  , DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE4)
  , DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, NULL, X_ADDITIONAL_VALUE5)
  , DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER)
  , DECODE(X_CREATED_BY, FND_API.G_MISS_NUM, NULL, X_CREATED_BY)
  , DECODE(x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
  , DECODE(x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
  , DECODE(x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
  , DECODE(x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
  ) returning ROWID into X_ROWID;

Line: 89

end INSERT_ROW;

Line: 108

  cursor c1 is select
      PARTY_ID,
      MODULE,
      CATEGORY,
      PREFERENCE_CODE,
      VALUE_VARCHAR2,
      VALUE_NUMBER,
      VALUE_DATE,
      VALUE_NAME,
      ADDITIONAL_VALUE1,
      ADDITIONAL_VALUE2,
      ADDITIONAL_VALUE3,
      ADDITIONAL_VALUE4,
      ADDITIONAL_VALUE5,
      OBJECT_VERSION_NUMBER
    from HZ_PARTY_PREFERENCES
    where PARTY_PREFERENCE_ID = X_PARTY_PREFERENCE_ID
    for update of PARTY_PREFERENCE_ID nowait;

Line: 166

procedure UPDATE_ROW (
  X_PARTY_PREFERENCE_ID    in NUMBER,
  X_PARTY_ID               in NUMBER,
  X_MODULE                 in VARCHAR2,
  X_CATEGORY               in VARCHAR2,
  X_PREFERENCE_CODE        in VARCHAR2,
  X_VALUE_VARCHAR2         in VARCHAR2,
  X_VALUE_NUMBER           in NUMBER,
  X_VALUE_DATE             in DATE,
  X_VALUE_NAME             in VARCHAR2,
  X_ADDITIONAL_VALUE1      in VARCHAR2,
  X_ADDITIONAL_VALUE2      in VARCHAR2,
  X_ADDITIONAL_VALUE3      in VARCHAR2,
  X_ADDITIONAL_VALUE4      in VARCHAR2,
  X_ADDITIONAL_VALUE5      in VARCHAR2,
  X_OBJECT_VERSION_NUMBER  in NUMBER,
  X_LAST_UPDATED_BY        in NUMBER,
  X_LAST_UPDATE_DATE       in DATE,
  X_LAST_UPDATE_LOGIN      in NUMBER
) is
begin
  update HZ_PARTY_PREFERENCES set
    PARTY_ID = DECODE(X_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, X_PARTY_ID),
    MODULE = DECODE(X_MODULE, FND_API.G_MISS_CHAR, MODULE, X_MODULE),
    CATEGORY = DECODE(X_CATEGORY, FND_API.G_MISS_CHAR, CATEGORY, X_CATEGORY),
    PREFERENCE_CODE = DECODE(X_PREFERENCE_CODE,FND_API.G_MISS_CHAR, PREFERENCE_CODE, X_PREFERENCE_CODE),
    VALUE_VARCHAR2 = DECODE(X_VALUE_VARCHAR2, FND_API.G_MISS_CHAR, VALUE_VARCHAR2, X_VALUE_VARCHAR2),
    VALUE_NUMBER = DECODE(X_VALUE_NUMBER, FND_API.G_MISS_NUM, VALUE_NUMBER, X_VALUE_NUMBER),
    VALUE_DATE = DECODE(X_VALUE_DATE, FND_API.G_MISS_DATE, VALUE_DATE, X_VALUE_DATE),
    VALUE_NAME = DECODE(X_VALUE_NAME, FND_API.G_MISS_CHAR, VALUE_NAME, X_VALUE_NAME),
    ADDITIONAL_VALUE1 = DECODE(X_ADDITIONAL_VALUE1, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE1, X_ADDITIONAL_VALUE1),
    ADDITIONAL_VALUE2 = DECODE(X_ADDITIONAL_VALUE2, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE2, X_ADDITIONAL_VALUE2),
    ADDITIONAL_VALUE3 = DECODE(X_ADDITIONAL_VALUE3, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE3, X_ADDITIONAL_VALUE3),
    ADDITIONAL_VALUE4 = DECODE(X_ADDITIONAL_VALUE4, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE4, X_ADDITIONAL_VALUE4),
    ADDITIONAL_VALUE5 = DECODE(X_ADDITIONAL_VALUE5, FND_API.G_MISS_CHAR, ADDITIONAL_VALUE5, X_ADDITIONAL_VALUE5),
    OBJECT_VERSION_NUMBER = DECODE(X_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, X_OBJECT_VERSION_NUMBER),
    LAST_UPDATE_DATE = DECODE(X_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, X_LAST_UPDATE_DATE),
    LAST_UPDATED_BY = DECODE(X_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, X_LAST_UPDATED_BY),
    LAST_UPDATE_LOGIN = DECODE(X_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, X_LAST_UPDATE_LOGIN)
  where PARTY_PREFERENCE_ID = X_PARTY_PREFERENCE_ID;

Line: 210

end UPDATE_ROW;

Line: 212

procedure DELETE_ROW (
  X_PARTY_PREFERENCE_ID   in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER
) is
begin
  delete from HZ_PARTY_PREFERENCES
  where PARTY_PREFERENCE_ID = X_PARTY_PREFERENCE_ID
  and   OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER;

Line: 225

end DELETE_ROW;