APPS.PN_INSURANCE_REQUIREMENTS_PKG SQL Statements

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

Line: 12

PROCEDURE Insert_Row (
    X_ROWID                         IN OUT NOCOPY VARCHAR2,
    X_INSURANCE_REQUIREMENT_ID      IN OUT NOCOPY NUMBER,
    X_INSURANCE_TYPE_LOOKUP_CODE    IN     VARCHAR2,
    X_LEASE_ID                      IN     NUMBER,
    X_LEASE_CHANGE_ID               IN     NUMBER,
    X_POLICY_START_DATE             IN     DATE,
    X_POLICY_EXPIRATION_DATE        IN     DATE,
    X_INSURER_NAME                  IN     VARCHAR2,
    X_POLICY_NUMBER                 IN     VARCHAR2,
    X_INSURED_AMOUNT                IN     NUMBER,
    X_REQUIRED_AMOUNT               IN     NUMBER,
    X_STATUS                        IN     VARCHAR2,
    X_INSURANCE_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
)
IS
   CURSOR C IS
      SELECT ROWID
      FROM   pn_insurance_requirements_all
      WHERE  insurance_requirement_id = x_insurance_requirement_id;

Line: 56

    SELECT org_id
    FROM   pn_leases_all
    WHERE  lease_id = X_LEASE_ID ;

Line: 66

   SELECT pn_insurance_requirements_s.NEXTVAL
   INTO   x_insurance_requirement_id
   FROM   DUAL;

Line: 80

   INSERT INTO PN_INSURANCE_REQUIREMENTS_ALL
   (
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_LOGIN,
      INSURANCE_TYPE_LOOKUP_CODE,
      LEASE_ID,
      LEASE_CHANGE_ID,
      POLICY_START_DATE,
      POLICY_EXPIRATION_DATE,
      INSURER_NAME,
      POLICY_NUMBER,
      INSURED_AMOUNT,
      REQUIRED_AMOUNT,
      STATUS,
      INSURANCE_COMMENTS,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      INSURANCE_REQUIREMENT_ID,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      org_id
   )
   VALUES
   (
      X_CREATION_DATE,
      X_CREATED_BY,
      X_LAST_UPDATE_LOGIN,
      X_INSURANCE_TYPE_LOOKUP_CODE,
      X_LEASE_ID,
      X_LEASE_CHANGE_ID,
      X_POLICY_START_DATE,
      X_POLICY_EXPIRATION_DATE,
      X_INSURER_NAME,
      X_POLICY_NUMBER,
      X_INSURED_AMOUNT,
      X_REQUIRED_AMOUNT,
      X_STATUS,
      X_INSURANCE_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_INSURANCE_REQUIREMENT_ID,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      l_org_id
   );

Line: 163

END Insert_Row;

Line: 206

      SELECT *
      FROM   PN_INSURANCE_REQUIREMENTS_ALL
      WHERE  INSURANCE_REQUIREMENT_ID = X_INSURANCE_REQUIREMENT_ID
      FOR    UPDATE OF INSURANCE_REQUIREMENT_ID NOWAIT;

Line: 369

PROCEDURE Update_Row
(
    X_INSURANCE_REQUIREMENT_ID      IN     NUMBER,
    X_INSURANCE_TYPE_LOOKUP_CODE    IN     VARCHAR2,
    X_LEASE_ID                      IN     NUMBER,
    X_LEASE_CHANGE_ID               IN     NUMBER,
    X_POLICY_START_DATE             IN     DATE,
    X_POLICY_EXPIRATION_DATE        IN     DATE,
    X_INSURER_NAME                  IN     VARCHAR2,
    X_POLICY_NUMBER                 IN     VARCHAR2,
    X_INSURED_AMOUNT                IN     NUMBER,
    X_REQUIRED_AMOUNT               IN     NUMBER,
    X_STATUS                        IN     VARCHAR2,
    X_INSURANCE_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
   CURSOR c2 IS
      SELECT *
      FROM   pn_insurance_requirements_all
      WHERE  insurance_requirement_id = x_insurance_requirement_id;

Line: 435

         SELECT pn_insur_require_history_s.NEXTVAL
         INTO   l_insuranceHistoryId
         FROM   DUAL;

Line: 439

         INSERT INTO PN_INSUR_REQUIRE_HISTORY
         (
            INSURANCE_HISTORY_ID,
            INSURANCE_TYPE_LOOKUP_CODE,
            LEASE_ID,
            LEASE_CHANGE_ID,
            NEW_LEASE_CHANGE_ID,
            POLICY_START_DATE,
            POLICY_EXPIRATION_DATE,
            INSURER_NAME,
            POLICY_NUMBER,
            INSURED_AMOUNT,
            REQUIRED_AMOUNT,
            STATUS,
            INSURANCE_COMMENTS,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            INSURANCE_REQUIREMENT_ID,
            CREATION_DATE,
            CREATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN
         )
         VALUES
         (
            l_insuranceHistoryId,
            recInfoForHist.INSURANCE_TYPE_LOOKUP_CODE,
            recInfoForHist.LEASE_ID,
            recInfoForHist.LEASE_CHANGE_ID,
            X_LEASE_CHANGE_ID,
            recInfoForHist.POLICY_START_DATE,
            recInfoForHist.POLICY_EXPIRATION_DATE,
            recInfoForHist.INSURER_NAME,
            recInfoForHist.POLICY_NUMBER,
            recInfoForHist.INSURED_AMOUNT,
            recInfoForHist.REQUIRED_AMOUNT,
            recInfoForHist.STATUS,
            recInfoForHist.INSURANCE_COMMENTS,
            recInfoForHist.ATTRIBUTE_CATEGORY,
            recInfoForHist.ATTRIBUTE1,
            recInfoForHist.ATTRIBUTE2,
            recInfoForHist.ATTRIBUTE3,
            recInfoForHist.ATTRIBUTE4,
            recInfoForHist.ATTRIBUTE5,
            recInfoForHist.ATTRIBUTE6,
            recInfoForHist.ATTRIBUTE7,
            recInfoForHist.ATTRIBUTE8,
            recInfoForHist.ATTRIBUTE9,
            recInfoForHist.ATTRIBUTE10,
            recInfoForHist.ATTRIBUTE11,
            recInfoForHist.ATTRIBUTE12,
            recInfoForHist.ATTRIBUTE13,
            recInfoForHist.ATTRIBUTE14,
            recInfoForHist.ATTRIBUTE15,
            recInfoForHist.INSURANCE_REQUIREMENT_ID,
            recInfoForHist.CREATION_DATE,
            recInfoForHist.CREATED_BY,
            recInfoForHist.LAST_UPDATE_DATE,
            recInfoForHist.LAST_UPDATED_BY,
            recInfoForHist.LAST_UPDATE_LOGIN
         );

Line: 518

   UPDATE pn_insurance_requirements_all
   SET    INSURANCE_TYPE_LOOKUP_CODE      = X_INSURANCE_TYPE_LOOKUP_CODE,
          LEASE_CHANGE_ID                 = X_LEASE_CHANGE_ID,
          POLICY_START_DATE               = X_POLICY_START_DATE,
          POLICY_EXPIRATION_DATE          = X_POLICY_EXPIRATION_DATE,
          INSURER_NAME                    = X_INSURER_NAME,
          POLICY_NUMBER                   = X_POLICY_NUMBER,
          INSURED_AMOUNT                  = X_INSURED_AMOUNT,
          REQUIRED_AMOUNT                 = X_REQUIRED_AMOUNT,
          STATUS                          = X_STATUS,
          INSURANCE_COMMENTS              = X_INSURANCE_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,
          INSURANCE_REQUIREMENT_ID        = X_INSURANCE_REQUIREMENT_ID,
          LAST_UPDATE_DATE                = X_LAST_UPDATE_DATE,
          LAST_UPDATED_BY                 = X_LAST_UPDATED_BY,
          LAST_UPDATE_LOGIN               = X_LAST_UPDATE_LOGIN
   WHERE  INSURANCE_REQUIREMENT_ID = X_INSURANCE_REQUIREMENT_ID ;

Line: 555

END Update_Row;

Line: 565

PROCEDURE Delete_Row
(
   X_INSURANCE_REQUIREMENT_ID      IN     NUMBER
)
IS
BEGIN
   DELETE FROM pn_insurance_requirements_all
   WHERE  insurance_requirement_id = x_insurance_requirement_id;

Line: 577

END Delete_Row;