APPS.PN_VAR_RENT_INV_PKG SQL Statements

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

Line: 17

procedure INSERT_ROW (
    X_ROWID                  IN OUT NOCOPY VARCHAR2,
    X_VAR_RENT_INV_ID        IN OUT NOCOPY NUMBER,
    X_ADJUST_NUM             IN NUMBER,
    X_INVOICE_DATE           IN DATE,
    X_FOR_PER_RENT           IN NUMBER,
    X_TOT_ACT_VOL            IN NUMBER,
    X_ACT_PER_RENT           IN NUMBER,
    X_CONSTR_ACTUAL_RENT     IN NUMBER,
    X_ABATEMENT_APPL         IN NUMBER,
    X_REC_ABATEMENT          IN NUMBER,
    X_REC_ABATEMENT_OVERRIDE IN NUMBER,
    X_NEGATIVE_RENT          IN NUMBER,
    X_ACTUAL_INVOICED_AMOUNT IN NUMBER,
    X_PERIOD_ID              IN NUMBER,
    X_VAR_RENT_ID            IN NUMBER,
    X_FORECASTED_TERM_STATUS IN VARCHAR2,
    X_VARIANCE_TERM_STATUS   IN VARCHAR2,
    X_ACTUAL_TERM_STATUS     IN VARCHAR2,
    X_FORECASTED_EXP_CODE    IN VARCHAR2,
    X_VARIANCE_EXP_CODE      IN VARCHAR2,
    X_ACTUAL_EXP_CODE        IN VARCHAR2,
    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_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_ORG_ID                 IN NUMBER,
    X_CREDIT_FLAG            IN VARCHAR2,
    X_TRUE_UP_AMOUNT         IN NUMBER,
    X_TRUE_UP_STATUS         IN VARCHAR2,
    X_TRUE_UP_EXP_CODE       IN VARCHAR2
) IS
  CURSOR C IS
    SELECT ROWID
    FROM PN_VAR_RENT_INV_ALL
    WHERE VAR_RENT_INV_ID = X_VAR_RENT_INV_ID;

Line: 73

    SELECT org_id
    FROM PN_VAR_RENTS_ALL
    WHERE VAR_RENT_ID = X_VAR_RENT_ID;

Line: 83

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

Line: 98

         SELECT PN_VAR_RENT_INV_S.nextval
         INTO X_VAR_RENT_INV_ID
         FROM dual;

Line: 105

  INSERT INTO PN_VAR_RENT_INV_ALL (
    VAR_RENT_INV_ID,
    ADJUST_NUM,
    INVOICE_DATE,
    FOR_PER_RENT,
    TOT_ACT_VOL,
    ACT_PER_RENT,
    CONSTR_ACTUAL_RENT,
    ABATEMENT_APPL,
    REC_ABATEMENT,
    REC_ABATEMENT_OVERRIDE,
    NEGATIVE_RENT,
    ACTUAL_INVOICED_AMOUNT,
    PERIOD_ID,
    VAR_RENT_ID,
    FORECASTED_TERM_STATUS,
    VARIANCE_TERM_STATUS,
    ACTUAL_TERM_STATUS,
    FORECASTED_EXP_CODE,
    VARIANCE_EXP_CODE,
    ACTUAL_EXP_CODE,
    COMMENTS,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ORG_ID,
    CREDIT_FLAG,
    TRUE_UP_AMT,
    TRUE_UP_STATUS,
    TRUE_UP_EXP_CODE
  ) VALUES
  ( X_VAR_RENT_INV_ID,
    X_ADJUST_NUM,
    X_INVOICE_DATE,
    ROUND(X_FOR_PER_RENT, l_precision),
    ROUND(X_TOT_ACT_VOL, l_precision),   -- bug # 6007571
    ROUND(X_ACT_PER_RENT, l_precision),
    ROUND(X_CONSTR_ACTUAL_RENT, l_precision),
    X_ABATEMENT_APPL,
    X_REC_ABATEMENT,
    X_REC_ABATEMENT_OVERRIDE,
    X_NEGATIVE_RENT,
    ROUND(X_ACTUAL_INVOICED_AMOUNT, l_precision),
    X_PERIOD_ID,
    X_VAR_RENT_ID,
    X_FORECASTED_TERM_STATUS,
    X_VARIANCE_TERM_STATUS,
    X_ACTUAL_TERM_STATUS,
    X_FORECASTED_EXP_CODE,
    X_VARIANCE_EXP_CODE,
    X_ACTUAL_EXP_CODE,
    X_COMMENTS,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    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,
    l_ORG_ID,
    X_CREDIT_FLAG,
    X_TRUE_UP_AMOUNT,
    X_TRUE_UP_STATUS,
    X_TRUE_UP_EXP_CODE);

Line: 210

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

Line: 212

END INSERT_ROW;

Line: 283

  SELECT *
  FROM PN_VAR_RENT_INV_ALL
  WHERE VAR_RENT_INV_ID = X_VAR_RENT_INV_ID
  FOR UPDATE OF VAR_RENT_INV_ID nowait;

Line: 585

procedure UPDATE_ROW (
   X_VAR_RENT_INV_ID        IN NUMBER,
   X_ADJUST_NUM             IN NUMBER,
   X_INVOICE_DATE           IN DATE,
   X_FOR_PER_RENT           IN NUMBER,
   X_TOT_ACT_VOL            IN NUMBER,
   X_ACT_PER_RENT           IN NUMBER,
   X_CONSTR_ACTUAL_RENT     IN NUMBER,
   X_ABATEMENT_APPL         IN NUMBER,
   X_REC_ABATEMENT          IN NUMBER,
   X_REC_ABATEMENT_OVERRIDE IN NUMBER,
   X_NEGATIVE_RENT          IN NUMBER,
   X_ACTUAL_INVOICED_AMOUNT IN NUMBER,
   X_PERIOD_ID              IN NUMBER,
   X_VAR_RENT_ID            IN NUMBER,
   X_FORECASTED_TERM_STATUS IN VARCHAR2,
   X_VARIANCE_TERM_STATUS   IN VARCHAR2,
   X_ACTUAL_TERM_STATUS     IN VARCHAR2,
   X_FORECASTED_EXP_CODE    IN VARCHAR2,
   X_VARIANCE_EXP_CODE      IN VARCHAR2,
   X_ACTUAL_EXP_CODE        IN VARCHAR2,
   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
) IS

l_precision  NUMBER;

Line: 632

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

Line: 636

 UPDATE PN_VAR_RENT_INV_ALL SET
   ADJUST_NUM             = X_ADJUST_NUM,
   INVOICE_DATE           = X_INVOICE_DATE,
   FOR_PER_RENT           = ROUND(X_FOR_PER_RENT, l_precision),
   TOT_ACT_VOL            = ROUND(X_TOT_ACT_VOL, l_precision),
   ACT_PER_RENT           = ROUND(X_ACT_PER_RENT, l_precision),
   CONSTR_ACTUAL_RENT     = ROUND(X_CONSTR_ACTUAL_RENT, l_precision),
   ABATEMENT_APPL         = X_ABATEMENT_APPL,
   REC_ABATEMENT          = X_REC_ABATEMENT,
   REC_ABATEMENT_OVERRIDE = X_REC_ABATEMENT_OVERRIDE,
   NEGATIVE_RENT          = X_NEGATIVE_RENT,
   ACTUAL_INVOICED_AMOUNT = ROUND(X_ACTUAL_INVOICED_AMOUNT, l_precision),
   PERIOD_ID              = X_PERIOD_ID,
   FORECASTED_TERM_STATUS = X_FORECASTED_TERM_STATUS,
   VARIANCE_TERM_STATUS   = X_VARIANCE_TERM_STATUS,
   ACTUAL_TERM_STATUS     = X_ACTUAL_TERM_STATUS,
   FORECASTED_EXP_CODE    = X_FORECASTED_EXP_CODE,
   VARIANCE_EXP_CODE      = X_VARIANCE_EXP_CODE,
   ACTUAL_EXP_CODE        = X_ACTUAL_EXP_CODE,
   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
 WHERE VAR_RENT_INV_ID    = X_VAR_RENT_INV_ID;

Line: 682

  PNP_DEBUG_PKG.debug ('PN_VAR_RENT_INV_PKG.UPDATE_ROW (-)');

Line: 684

END UPDATE_ROW;

Line: 694

procedure DELETE_ROW (
  X_VAR_RENT_INV_ID IN NUMBER
) IS
BEGIN

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

Line: 701

  DELETE FROM PN_VAR_RENT_INV_ALL
  WHERE VAR_RENT_INV_ID = X_VAR_RENT_INV_ID;

Line: 708

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

Line: 711

END DELETE_ROW;