APPS.XDP_WI_PARAMETERS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in OUT NOCOPY VARCHAR2,
-- skilaru 7/17/01 WI_PARAMETER_ID column dropped
--  X_WI_PARAMETER_ID is dropped in 11.5.6
--  X_WI_PARAMETER_ID in NUMBER,
  X_PARAMETER_NAME in VARCHAR2,
  X_WORKITEM_ID in NUMBER,
  X_REQUIRED_FLAG in VARCHAR2,
  X_LOG_IN_AUDIT_TRAIL_FLAG in VARCHAR2,
  X_VALUE_LOOKUP_SQL in VARCHAR2,
  X_VALIDATION_PROCEDURE in VARCHAR2,
  X_EVALUATION_MODE in VARCHAR2,
  X_EVALUATION_SEQ in NUMBER,
  X_EVALUATION_PROCEDURE in VARCHAR2,
  X_DISPLAY_SEQ in NUMBER,
  X_DEFAULT_VALUE in VARCHAR2,
  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
) is
  cursor C is
    select ROWID
    from   XDP_WI_PARAMETERS
    -- skilaru 7/17/01 WI_PARAMETER_ID column dropped
    --  where  WI_PARAMETER_ID = X_WI_PARAMETER_ID
    where  PARAMETER_NAME = X_PARAMETER_NAME
    and    WORKITEM_ID     = X_WORKITEM_ID;

Line: 34

  insert into XDP_WI_PARAMETERS (
    WORKITEM_ID,
    -- skilaru 7/17/01 WI_PARAMETER_ID column dropped
    -- WI_PARAMETER_ID,
    PARAMETER_NAME,
    REQUIRED_FLAG,
    LOG_IN_AUDIT_TRAIL_FLAG,
    VALUE_LOOKUP_SQL,
    VALIDATION_PROCEDURE,
    EVALUATION_MODE,
    EVALUATION_SEQ,
    EVALUATION_PROCEDURE,
    DISPLAY_SEQ,
    DEFAULT_VALUE,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_WORKITEM_ID,
    -- skilaru 7/17/01 WI_PARAMETER_ID column dropped
    -- X_WI_PARAMETER_ID,
    X_PARAMETER_NAME,
    X_REQUIRED_FLAG,
    X_LOG_IN_AUDIT_TRAIL_FLAG,
    X_VALUE_LOOKUP_SQL,
    X_VALIDATION_PROCEDURE,
    X_EVALUATION_MODE,
    X_EVALUATION_SEQ,
    X_EVALUATION_PROCEDURE,
    X_DISPLAY_SEQ,
    X_DEFAULT_VALUE,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 82

end INSERT_ROW;

Line: 99

  cursor c1 is select
      REQUIRED_FLAG,
      LOG_IN_AUDIT_TRAIL_FLAG,
      VALUE_LOOKUP_SQL,
      VALIDATION_PROCEDURE,
      EVALUATION_MODE,
      EVALUATION_SEQ,
      EVALUATION_PROCEDURE,
      DISPLAY_SEQ,
      DEFAULT_VALUE
    from XDP_WI_PARAMETERS
    -- skilaru 7/17/01 WI_PARAMETER_ID column dropped
    -- where WI_PARAMETER_ID = X_WI_PARAMETER_ID
    where PARAMETER_NAME = X_PARAMETER_NAME
    and WORKITEM_ID       = X_WORKITEM_ID
    -- skilaru 7/17/01 WI_PARAMETER_ID column dropped
    -- for update of WI_PARAMETER_ID nowait;

Line: 116

    for update of PARAMETER_NAME nowait;

Line: 147

procedure UPDATE_ROW (
  -- skilaru 7/17/01 WI_PARAMETER_ID dropped
  -- X_WI_PARAMETER_ID in NUMBER,
  X_PARAMETER_NAME in VARCHAR2,
  X_WORKITEM_ID in NUMBER,
  X_REQUIRED_FLAG in VARCHAR2,
  X_LOG_IN_AUDIT_TRAIL_FLAG in VARCHAR2,
  X_VALUE_LOOKUP_SQL in VARCHAR2,
  X_VALIDATION_PROCEDURE in VARCHAR2,
  X_EVALUATION_MODE in VARCHAR2,
  X_EVALUATION_SEQ in NUMBER,
  X_EVALUATION_PROCEDURE in VARCHAR2,
  X_DISPLAY_SEQ in NUMBER,
  X_DEFAULT_VALUE in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update XDP_WI_PARAMETERS set
    REQUIRED_FLAG = X_REQUIRED_FLAG,
    LOG_IN_AUDIT_TRAIL_FLAG = X_LOG_IN_AUDIT_TRAIL_FLAG,
    VALUE_LOOKUP_SQL = X_VALUE_LOOKUP_SQL,
    VALIDATION_PROCEDURE = X_VALIDATION_PROCEDURE,
    EVALUATION_MODE = X_EVALUATION_MODE,
    EVALUATION_SEQ = X_EVALUATION_SEQ,
    EVALUATION_PROCEDURE = X_EVALUATION_PROCEDURE,
    DISPLAY_SEQ = X_DISPLAY_SEQ,
    DEFAULT_VALUE = X_DEFAULT_VALUE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  -- skilaru 7/17/01 WI_PARAMETER_ID is dropped
  -- where WI_PARAMETER_ID = X_WI_PARAMETER_ID
  where PARAMETER_NAME = X_PARAMETER_NAME
  and   WORKITEM_ID     = X_WORKITEM_ID;

Line: 187

end UPDATE_ROW;

Line: 189

procedure DELETE_ROW (
  -- skilaru 7/17/01 WI_PARAMETER_ID dropped
  -- X_WI_PARAMETER_ID in NUMBER,
  X_PARAMETER_NAME in VARCHAR2,
  X_WORKITEM_ID in NUMBER
) is
begin
  delete from XDP_WI_PARAMETERS
  -- skilaru 7/17/01 WI_PARAMETER_ID dropped
  -- where WI_PARAMETER_ID = X_WI_PARAMETER_ID
  where PARAMETER_NAME = X_PARAMETER_NAME
  and   WORKITEM_ID     = X_WORKITEM_ID;

Line: 206

end DELETE_ROW;