DBA Data[Home] [Help]

APPS.PN_INDEX_EXCLUDE_TERM_PKG SQL Statements

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

Line: 15

procedure INSERT_ROW
(
   X_INDEX_EXCLUDE_TERM_ID      IN OUT NOCOPY    NUMBER
   ,X_ORG_ID                    IN               NUMBER
   ,X_INDEX_LEASE_ID            IN               NUMBER
   ,X_PAYMENT_TERM_ID           IN               NUMBER
   ,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
   ,X_INCLUDE_EXCLUDE_FLAG      IN               VARCHAR2
)
IS
   l_return_status         VARCHAR2(30)    := NULL;
Line: 34

     SELECT org_id FROM pn_index_leases_all WHERE index_lease_id = x_index_lease_id;
Line: 38

   PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.insert_row (+)');
Line: 43

      SELECT '1'
      INTO l_rowExists
      FROM DUAL
      WHERE EXISTS ( SELECT 1
                     FROM pn_index_exclude_term_all exclude
                     WHERE exclude.index_lease_id = x_index_lease_id
                     AND exclude.payment_term_id = x_payment_term_id
                     AND exclude.org_id = x_org_id);
Line: 69

         SELECT PN_INDEX_EXCLUDE_TERM_s.nextval
         INTO   X_INDEX_EXCLUDE_TERM_ID
         FROM   dual;
Line: 74

      INSERT INTO PN_INDEX_EXCLUDE_TERM_ALL
      (
          INDEX_EXCLUDE_TERM_ID
         ,ORG_ID
         ,INDEX_LEASE_ID
         ,PAYMENT_TERM_ID
         ,LAST_UPDATE_DATE
         ,LAST_UPDATED_BY
         ,CREATION_DATE
         ,CREATED_BY
         ,LAST_UPDATE_LOGIN
         ,INCLUDE_EXCLUDE_FLAG
      )
      VALUES
      (
          X_INDEX_EXCLUDE_TERM_ID
         ,l_org_id
         ,X_INDEX_LEASE_ID
         ,X_PAYMENT_TERM_ID
         ,X_LAST_UPDATE_DATE
         ,X_LAST_UPDATED_BY
         ,X_CREATION_DATE
         ,X_CREATED_BY
         ,X_LAST_UPDATE_LOGIN
         ,X_INCLUDE_EXCLUDE_FLAG
      );
Line: 103

   PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.insert_row (-)');
Line: 105

END INSERT_ROW;
Line: 119

procedure UPDATE_ROW
(
    X_INDEX_EXCLUDE_TERM_ID         IN        NUMBER
   ,X_INDEX_LEASE_ID                IN        NUMBER
   ,X_PAYMENT_TERM_ID               IN        NUMBER
   ,X_LAST_UPDATE_DATE              IN        DATE
   ,X_LAST_UPDATED_BY               IN        NUMBER
   ,X_LAST_UPDATE_LOGIN             IN        NUMBER
   ,X_INCLUDE_EXCLUDE_FLAG          IN        VARCHAR2
)
IS
   l_return_status    VARCHAR2(30) := NULL;
Line: 134

   PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.update_row (+)');
Line: 140

   UPDATE PN_INDEX_EXCLUDE_TERM_ALL
   SET
       INDEX_LEASE_ID                =X_INDEX_LEASE_ID
      ,PAYMENT_TERM_ID               =X_PAYMENT_TERM_ID
      ,LAST_UPDATE_DATE              =X_LAST_UPDATE_DATE
      ,LAST_UPDATED_BY               =X_LAST_UPDATED_BY
      ,LAST_UPDATE_LOGIN             =X_LAST_UPDATE_LOGIN
      ,INCLUDE_EXCLUDE_FLAG          =X_INCLUDE_EXCLUDE_FLAG
   WHERE INDEX_EXCLUDE_TERM_ID = X_INDEX_EXCLUDE_TERM_ID;
Line: 153

  PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.update_row (-)');
Line: 155

END update_row;
Line: 177

      SELECT * FROM  PN_INDEX_EXCLUDE_TERM_ALL
      WHERE INDEX_EXCLUDE_TERM_ID = X_INDEX_EXCLUDE_TERM_ID
      FOR UPDATE OF INDEX_EXCLUDE_TERM_ID NOWAIT;
Line: 225

procedure delete_row
(
    X_INDEX_LEASE_ID                IN        NUMBER
   ,X_PAYMENT_TERM_ID               IN        NUMBER
)
IS

   l_rowExists     VARCHAR2(10)    := NULL;
Line: 236

   PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.delete_row (+)');
Line: 239

      SELECT '1'
      INTO l_rowExists
      FROM DUAL
      WHERE EXISTS ( SELECT 1
                     FROM pn_index_exclude_term_all  exclude
                     WHERE exclude.index_lease_id = x_index_lease_id
                     AND exclude.payment_term_id = x_payment_term_id);
Line: 254

      DELETE FROM PN_INDEX_EXCLUDE_TERM_ALL
      WHERE INDEX_LEASE_ID = X_INDEX_LEASE_ID
      AND   PAYMENT_TERM_ID = X_PAYMENT_TERM_ID;
Line: 264

   PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.delete_row (-)');
Line: 266

END delete_row;
Line: 276

procedure DELETE_ALL_EXCLUDE_TERMS( X_INDEX_LEASE_ID  IN  NUMBER )
IS

BEGIN

   PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.DELETE_ALL_EXCLUDE_TERMS (+)');
Line: 283

      DELETE FROM PN_INDEX_EXCLUDE_TERM_ALL
      WHERE INDEX_LEASE_ID = X_INDEX_LEASE_ID;
Line: 286

   PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.DELETE_ALL_EXCLUDE_TERMS (-)');
Line: 288

END DELETE_ALL_EXCLUDE_TERMS;