APPS.PN_VAR_CONSTRAINTS_PKG SQL Statements

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

Line: 13

procedure INSERT_ROW (
  X_ROWID                 in out NOCOPY VARCHAR2,
  X_CONSTRAINT_ID         in out NOCOPY NUMBER,
  X_CONSTRAINT_NUM        in out NOCOPY NUMBER,
  X_PERIOD_ID             in NUMBER,
  X_CONSTR_CAT_CODE       in VARCHAR2,
  X_TYPE_CODE             in VARCHAR2,
  X_AMOUNT                in NUMBER,
  X_AGREEMENT_TEMPLATE_ID in NUMBER,
  X_CONSTR_TEMPLATE_ID    in NUMBER,
  X_CONSTR_DEFAULT_ID     in NUMBER,
  X_COMMENTS              in VARCHAR2,
  X_ATTRIBUTE_CATEGORY    in VARCHAR2,
  X_ATTRIBUTE1            in VARCHAR2,
  X_ATTRIBUTE2            in VARCHAR2,
  X_ATTRIBUTE3            in VARCHAR2,
  X_ATTRIBUTE4            in VARCHAR2,
  X_ATTRIBUTE5            in VARCHAR2,
  X_ATTRIBUTE6            in VARCHAR2,
  X_ATTRIBUTE7            in VARCHAR2,
  X_ATTRIBUTE8            in VARCHAR2,
  X_ATTRIBUTE9            in VARCHAR2,
  X_ATTRIBUTE10           in VARCHAR2,
  X_ATTRIBUTE11           in VARCHAR2,
  X_ATTRIBUTE12           in VARCHAR2,
  X_ATTRIBUTE13           in VARCHAR2,
  X_ATTRIBUTE14           in VARCHAR2,
  X_ATTRIBUTE15           in VARCHAR2,
  X_ORG_ID                in NUMBER,
  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_CONSTR_START_DATE     in DATE,
  X_CONSTR_END_DATE       in DATE
)
IS
   CURSOR C IS
      SELECT ROWID
      FROM PN_VAR_CONSTRAINTS_ALL
      WHERE CONSTRAINT_ID = X_CONSTRAINT_ID;

Line: 60

   PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.INSERT_ROW (+)');

Line: 65

   SELECT  nvl(max(CONSTRAINT_NUM),0)
   INTO    X_CONSTRAINT_NUM
   FROM    PN_VAR_CONSTRAINTS_ALL
   WHERE   PERIOD_ID = X_PERIOD_ID;

Line: 76

     SELECT  pn_var_constraints_s.nextval
     INTO    X_CONSTRAINT_ID
     FROM    dual;

Line: 97

   INSERT INTO PN_VAR_CONSTRAINTS_ALL
   (
    CONSTRAINT_ID,
    CONSTRAINT_NUM,
    PERIOD_ID,
    CONSTR_CAT_CODE,
    TYPE_CODE,
    AMOUNT,
    AGREEMENT_TEMPLATE_ID,
    CONSTR_TEMPLATE_ID,
    CONSTR_DEFAULT_ID,
    COMMENTS,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ORG_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    CONSTR_START_DATE,
    CONSTR_END_DATE
  )
   VALUES
   (
    X_CONSTRAINT_ID,
    X_CONSTRAINT_NUM,
    X_PERIOD_ID,
    X_CONSTR_CAT_CODE,
    X_TYPE_CODE,
    X_AMOUNT,
    X_AGREEMENT_TEMPLATE_ID,
    X_CONSTR_TEMPLATE_ID,
    X_CONSTR_DEFAULT_ID,
    X_COMMENTS,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_ORG_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_CONSTR_START_DATE,
    X_CONSTR_END_DATE);

Line: 179

   PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.INSERT_ROW (-)');

Line: 181

END INSERT_ROW;

Line: 223

     SELECT *
     FROM PN_VAR_CONSTRAINTS_ALL
     WHERE CONSTRAINT_ID = X_CONSTRAINT_ID
     FOR UPDATE OF CONSTRAINT_ID NOWAIT;

Line: 447

procedure UPDATE_ROW (
  X_CONSTRAINT_ID         in NUMBER,
  X_CONSTRAINT_NUM        in NUMBER,
  X_PERIOD_ID             in NUMBER,
  X_CONSTR_CAT_CODE       in VARCHAR2,
  X_TYPE_CODE             in VARCHAR2,
  X_AMOUNT                in NUMBER,
  X_AGREEMENT_TEMPLATE_ID in NUMBER,
  X_CONSTR_TEMPLATE_ID    in NUMBER,
  X_CONSTR_DEFAULT_ID     in NUMBER,
  X_COMMENTS              in VARCHAR2,
  X_ATTRIBUTE_CATEGORY    in VARCHAR2,
  X_ATTRIBUTE1            in VARCHAR2,
  X_ATTRIBUTE2            in VARCHAR2,
  X_ATTRIBUTE3            in VARCHAR2,
  X_ATTRIBUTE4            in VARCHAR2,
  X_ATTRIBUTE5            in VARCHAR2,
  X_ATTRIBUTE6            in VARCHAR2,
  X_ATTRIBUTE7            in VARCHAR2,
  X_ATTRIBUTE8            in VARCHAR2,
  X_ATTRIBUTE9            in VARCHAR2,
  X_ATTRIBUTE10           in VARCHAR2,
  X_ATTRIBUTE11           in VARCHAR2,
  X_ATTRIBUTE12           in VARCHAR2,
  X_ATTRIBUTE13           in VARCHAR2,
  X_ATTRIBUTE14           in VARCHAR2,
  X_ATTRIBUTE15           in VARCHAR2,
  X_LAST_UPDATE_DATE      in DATE,
  X_LAST_UPDATED_BY       in NUMBER,
  X_LAST_UPDATE_LOGIN     in NUMBER,
  X_CONSTR_START_DATE     in DATE,
  X_CONSTR_END_DATE       in DATE
)
IS
    l_return_status         VARCHAR2(30)    := NULL;

Line: 485

  PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.UPDATE_ROW (+)');

Line: 503

  UPDATE PN_VAR_CONSTRAINTS_ALL SET
    CONSTRAINT_NUM        = X_CONSTRAINT_NUM,
    PERIOD_ID             = X_PERIOD_ID,
    CONSTR_CAT_CODE       = X_CONSTR_CAT_CODE,
    TYPE_CODE             = X_TYPE_CODE,
    AMOUNT                = X_AMOUNT,
    AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID,
    CONSTR_TEMPLATE_ID    = X_CONSTR_TEMPLATE_ID,
    CONSTR_DEFAULT_ID     = X_CONSTR_DEFAULT_ID,
    COMMENTS              = X_COMMENTS,
    ATTRIBUTE_CATEGORY    = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1            = X_ATTRIBUTE1,
    ATTRIBUTE2            = X_ATTRIBUTE2,
    ATTRIBUTE3            = X_ATTRIBUTE3,
    ATTRIBUTE4            = X_ATTRIBUTE4,
    ATTRIBUTE5            = X_ATTRIBUTE5,
    ATTRIBUTE6            = X_ATTRIBUTE6,
    ATTRIBUTE7            = X_ATTRIBUTE7,
    ATTRIBUTE8            = X_ATTRIBUTE8,
    ATTRIBUTE9            = X_ATTRIBUTE9,
    ATTRIBUTE10           = X_ATTRIBUTE10,
    ATTRIBUTE11           = X_ATTRIBUTE11,
    ATTRIBUTE12           = X_ATTRIBUTE12,
    ATTRIBUTE13           = X_ATTRIBUTE13,
    ATTRIBUTE14           = X_ATTRIBUTE14,
    ATTRIBUTE15           = X_ATTRIBUTE15,
    LAST_UPDATE_DATE      = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY       = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN     = X_LAST_UPDATE_LOGIN,
    CONSTR_START_DATE     = X_CONSTR_START_DATE,
    CONSTR_END_DATE       = X_CONSTR_END_DATE
  WHERE CONSTRAINT_ID = X_CONSTRAINT_ID;

Line: 540

  PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.UPDATE_ROW (+)');

Line: 542

END UPDATE_ROW;

Line: 553

procedure DELETE_ROW (
  X_CONSTRAINT_ID in NUMBER
)
IS
BEGIN

  PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.DELETE_ROW (+)');

Line: 561

  DELETE FROM PN_VAR_CONSTRAINTS_ALL
  WHERE CONSTRAINT_ID = X_CONSTRAINT_ID;

Line: 568

  PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.DELETE_ROW (-)');

Line: 570

END DELETE_ROW;

Line: 596

    SELECT  1
    INTO    l_dummy
    FROM    dual
    WHERE   not exists
        (
            SELECT  1
            FROM    pn_var_constraints_all   constr
            WHERE   constr.amount           < (x_amount)
            AND     ((x_constraint_id       is null) or
                      (constr.constraint_id <> x_constraint_id))
            AND     constr.period_id        = x_period_id
            AND     constr.constr_cat_code  = x_constr_cat_code
            AND     constr.type_code        = 'MAX'
        );