APPS.XDP_FA_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,
  X_FULFILLMENT_ACTION_ID in NUMBER,
  X_PARAMETER_NAME in VARCHAR2,
  X_EVALUATION_PROCEDURE in VARCHAR2,
  X_EVALUATION_SEQ in NUMBER,
  X_LOG_IN_AUDIT_TRAIL_FLAG 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_FA_PARAMETERS
    where FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID
    and PARAMETER_NAME = X_PARAMETER_NAME;

Line: 22

  insert into XDP_FA_PARAMETERS (
    FULFILLMENT_ACTION_ID,
    PARAMETER_NAME,
    EVALUATION_PROCEDURE,
    EVALUATION_SEQ,
    LOG_IN_AUDIT_TRAIL_FLAG,
    DEFAULT_VALUE,
    DISPLAY_SEQ,
    CREATION_DATE,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_FULFILLMENT_ACTION_ID,
    X_PARAMETER_NAME,
    X_EVALUATION_PROCEDURE,
    X_EVALUATION_SEQ,
    X_LOG_IN_AUDIT_TRAIL_FLAG,
    X_DEFAULT_VALUE,
    X_DISPLAY_SEQ,
    X_CREATION_DATE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN
  ) ;

Line: 57

end INSERT_ROW;

Line: 68

  cursor c1 is select
      EVALUATION_PROCEDURE,
      EVALUATION_SEQ,
      LOG_IN_AUDIT_TRAIL_FLAG,
      DISPLAY_SEQ,
      DEFAULT_VALUE
    from XDP_FA_PARAMETERS
    where FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID
    and PARAMETER_NAME = X_PARAMETER_NAME
    for update of FULFILLMENT_ACTION_ID nowait;

Line: 100

procedure UPDATE_ROW (
  X_FULFILLMENT_ACTION_ID in NUMBER,
  X_PARAMETER_NAME in VARCHAR2,
  X_EVALUATION_PROCEDURE in VARCHAR2,
  X_EVALUATION_SEQ in NUMBER,
  X_LOG_IN_AUDIT_TRAIL_FLAG 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_FA_PARAMETERS set
    EVALUATION_PROCEDURE = X_EVALUATION_PROCEDURE,
    EVALUATION_SEQ = X_EVALUATION_SEQ,
    LOG_IN_AUDIT_TRAIL_FLAG = X_LOG_IN_AUDIT_TRAIL_FLAG,
    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
  where FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID
  and PARAMETER_NAME = X_PARAMETER_NAME ;

Line: 128

end UPDATE_ROW;

Line: 130

procedure DELETE_ROW (
  X_FULFILLMENT_ACTION_ID in NUMBER,
  X_PARAMETER_NAME in VARCHAR2
) is
begin
  delete from XDP_FA_PARAMETERS
  where FULFILLMENT_ACTION_ID = X_FULFILLMENT_ACTION_ID
  and PARAMETER_NAME = X_PARAMETER_NAME ;

Line: 143

end DELETE_ROW;