APPS.PN_INDEX_LEASE_TERMS_PKG SQL Statements

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

Line: 36

procedure INSERT_ROW
(
         X_INDEX_LEASE_TERM_ID         IN OUT NOCOPY    NUMBER
        ,X_INDEX_LEASE_ID              IN        NUMBER
        ,X_INDEX_PERIOD_ID             IN        NUMBER
        ,X_LEASE_TERM_ID               IN        NUMBER
        ,X_RENT_INCREASE_TERM_ID       IN        NUMBER
        ,X_AMOUNT                      IN        NUMBER
        ,X_APPROVED_FLAG               IN        VARCHAR2
        ,X_INDEX_TERM_INDICATOR        IN        VARCHAR2
        ,X_LAST_UPDATE_DATE            IN        DATE
        ,X_LAST_UPDATED_BY             IN        NUMBER
        ,X_CREATION_DATE               IN        DATE
        ,X_CREATED_BY                  IN        NUMBER
        ,X_LAST_UPDATE_LOGIN           IN        NUMBER
) IS

l_return_status         VARCHAR2(30)    := NULL;

Line: 59

  SELECT org_id
  FROM   pn_index_leases_all
  WHERE  index_lease_id = x_index_lease_id;

Line: 66

  PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.insert_row (+)');

Line: 76

            SELECT '1'
            INTO l_rowExists
                           FROM DUAL
            WHERE EXISTS (
                         SELECT 1
                         FROM  pn_index_lease_terms_all ilt
                         WHERE ilt.index_lease_id  = x_index_lease_id
                                        AND   ilt.index_period_id = x_index_period_id
                                        AND   ilt.lease_term_id   = x_lease_term_id
                         AND   ilt.rent_increase_term_id = x_rent_increase_term_id);

Line: 96

                        SELECT PN_INDEX_LEASE_TERM_S.nextval into    X_INDEX_LEASE_TERM_ID from    dual;

Line: 99

                INSERT INTO PN_INDEX_LEASE_TERMS_ALL
                (
                        index_lease_term_id
                        ,index_lease_id
                        ,index_period_id
                        ,lease_term_id
                        ,rent_increase_term_id
                        ,amount
                        ,approved_flag
                        ,index_term_indicator
                        ,last_update_date
                        ,last_updated_by
                        ,creation_date
                        ,created_by
                        ,last_update_login
                        ,org_id
                )
               VALUES
           (
                        x_index_lease_term_id
                        ,x_index_lease_id
                        ,x_index_period_id
                        ,x_lease_term_id
                        ,x_rent_increase_term_id
                        ,x_amount
                        ,x_approved_flag
                        ,x_index_term_indicator
                        ,x_last_update_date
                        ,x_last_updated_by
                        ,x_creation_date
                        ,x_created_by
                        ,x_last_update_login
                        ,l_org_id
                );

Line: 135

   PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.insert_row (-)');

Line: 136

END INSERT_ROW;

Line: 147

procedure UPDATE_ROW
(
         X_INDEX_LEASE_TERM_ID         IN        NUMBER
        ,X_INDEX_LEASE_ID              IN        NUMBER
        ,X_INDEX_PERIOD_ID             IN        NUMBER
        ,X_LEASE_TERM_ID               IN        NUMBER
        ,X_RENT_INCREASE_TERM_ID       IN        NUMBER
        ,X_AMOUNT                      IN        NUMBER
        ,X_APPROVED_FLAG               IN        VARCHAR2
        ,X_INDEX_TERM_INDICATOR        IN        VARCHAR2
        ,X_LAST_UPDATE_DATE            IN        DATE
        ,X_LAST_UPDATED_BY             IN        NUMBER
        ,X_LAST_UPDATE_LOGIN           IN        NUMBER
) IS

BEGIN

  PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.update_row (+)');

Line: 166

UPDATE PN_INDEX_LEASE_TERMS_ALL
SET
         INDEX_LEASE_TERM_ID   = X_INDEX_LEASE_TERM_ID
        ,INDEX_LEASE_ID        = X_INDEX_LEASE_ID
        ,INDEX_PERIOD_ID       = X_INDEX_PERIOD_ID
        ,LEASE_TERM_ID         = X_LEASE_TERM_ID
        ,RENT_INCREASE_TERM_ID = X_RENT_INCREASE_TERM_ID
        ,AMOUNT                = X_AMOUNT
        ,APPROVED_FLAG         = X_APPROVED_FLAG
        ,INDEX_TERM_INDICATOR  = X_INDEX_TERM_INDICATOR
        ,LAST_UPDATE_DATE      = X_LAST_UPDATE_DATE
        ,LAST_UPDATED_BY       = X_LAST_UPDATED_BY
        ,LAST_UPDATE_LOGIN     = X_LAST_UPDATE_LOGIN
WHERE INDEX_LEASE_TERM_ID     =  X_INDEX_LEASE_TERM_ID;

Line: 183

  PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.update_row (-)');

Line: 184

end update_row;

Line: 209

SELECT  *
FROM  PN_INDEX_LEASE_TERMS_ALL
WHERE INDEX_LEASE_TERM_ID = X_INDEX_LEASE_TERM_ID
FOR UPDATE OF INDEX_LEASE_TERM_ID NOWAIT;

Line: 245

procedure delete_row
(
         X_INDEX_LEASE_TERM_ID         IN                NUMBER
        ,X_INDEX_LEASE_ID              IN        NUMBER
        ,X_INDEX_PERIOD_ID             IN        NUMBER
        ,X_LEASE_TERM_ID               IN        NUMBER
        ,X_RENT_INCREASE_TERM_ID       IN        NUMBER
) IS

l_rowExists                             VARCHAR2(10)    := NULL;

Line: 257

  PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.delete_row (+)');

Line: 260

            SELECT '1'
            INTO l_rowExists
            FROM DUAL
            WHERE EXISTS (
                         SELECT 1
                           FROM  pn_index_lease_terms_all ilt
                           WHERE ilt.index_lease_id  = x_index_lease_id
                           AND   ilt.index_period_id = x_index_period_id
                           AND   ilt.lease_term_id   = x_lease_term_id
                           AND   ilt.rent_increase_term_id      = x_rent_increase_term_id);

Line: 279

        DELETE FROM pn_index_lease_terms_all ilt
        WHERE   ilt.index_lease_id              = x_index_lease_id
        AND     ilt.index_period_id             = x_index_period_id
        AND     ilt.lease_term_id               = x_lease_term_id
        AND     ilt.rent_increase_term_id       = x_rent_increase_term_id;

Line: 290

  PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.delete_row (-)');

Line: 291

END delete_row;