eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_VAR_ABAT_DEFAULTS_PKG SQL Statements

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

Line: 10


procedure INSERT_ROW (
    X_ROWID                  in out NOCOPY VARCHAR2
   ,X_ABATEMENT_ID           in out NOCOPY NUMBER
   ,X_VAR_RENT_ID            in NUMBER
   ,X_START_DATE             in DATE
   ,X_END_DATE               in DATE
   ,X_TYPE_CODE              in VARCHAR2
   ,X_AMOUNT                 in NUMBER
   ,X_DESCRIPTION            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
   ,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 )
IS
   CURSOR C IS
      SELECT ROWID
      FROM   PN_VAR_ABAT_DEFAULTS_ALL
      WHERE  ABATEMENT_ID = X_ABATEMENT_ID;

Line: 50


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

Line: 57


      SELECT  pn_var_abat_defaults_s.nextval
      INTO    X_ABATEMENT_ID
      FROM    dual;

Line: 62


   INSERT INTO PN_VAR_ABAT_DEFAULTS_ALL
   (
       ABATEMENT_ID
      ,VAR_RENT_ID
      ,START_DATE
      ,END_DATE
      ,TYPE_CODE
      ,AMOUNT
      ,DESCRIPTION
      ,LAST_UPDATE_DATE
      ,LAST_UPDATED_BY
      ,CREATION_DATE
      ,CREATED_BY
      ,LAST_UPDATE_LOGIN
      ,COMMENTS
      ,ATTRIBUTE_CATEGORY
      ,ATTRIBUTE1
      ,ATTRIBUTE2
      ,ATTRIBUTE3
      ,ATTRIBUTE4
      ,ATTRIBUTE5
      ,ATTRIBUTE6
      ,ATTRIBUTE7
      ,ATTRIBUTE8
      ,ATTRIBUTE9
      ,ATTRIBUTE10
      ,ATTRIBUTE11
      ,ATTRIBUTE12
      ,ATTRIBUTE13
      ,ATTRIBUTE14
      ,ATTRIBUTE15
      ,ORG_ID
   )
   VALUES
   (
       X_ABATEMENT_ID
      ,X_VAR_RENT_ID
      ,X_START_DATE
      ,X_END_DATE
      ,X_TYPE_CODE
      ,X_AMOUNT
      ,X_DESCRIPTION
      ,X_LAST_UPDATE_DATE
      ,X_LAST_UPDATED_BY
      ,X_CREATION_DATE
      ,X_CREATED_BY
      ,X_LAST_UPDATE_LOGIN
      ,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
   ) ;

Line: 137


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

Line: 139


END INSERT_ROW;

Line: 156


   ,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_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)
IS

   CURSOR c1 IS
      SELECT *
      FROM PN_VAR_ABAT_DEFAULTS_ALL
      WHERE ABATEMENT_ID = X_ABATEMENT_ID
      FOR UPDATE OF ABATEMENT_ID NOWAIT;

Line: 370


procedure UPDATE_ROW (
    X_ABATEMENT_ID           in NUMBER
   ,X_VAR_RENT_ID            in NUMBER
   ,X_START_DATE             in DATE
   ,X_END_DATE               in DATE
   ,X_TYPE_CODE              in VARCHAR2
   ,X_AMOUNT                 in NUMBER
   ,X_DESCRIPTION            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
   ,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)
IS
BEGIN

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

Line: 406


   UPDATE PN_VAR_ABAT_DEFAULTS_ALL SET
       ABATEMENT_ID        = X_ABATEMENT_ID
      ,VAR_RENT_ID         = X_VAR_RENT_ID
      ,START_DATE          = X_START_DATE
      ,END_DATE            = X_END_DATE
      ,TYPE_CODE           = X_TYPE_CODE
      ,AMOUNT              = X_AMOUNT
      ,DESCRIPTION         = X_DESCRIPTION
      ,LAST_UPDATE_DATE    = X_LAST_UPDATE_DATE
      ,LAST_UPDATED_BY     = X_LAST_UPDATED_BY
      ,CREATION_DATE       = X_CREATION_DATE
      ,CREATED_BY          = X_CREATED_BY
      ,LAST_UPDATE_LOGIN   = X_LAST_UPDATE_LOGIN
      ,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
      ,ORG_ID              = X_ORG_ID
   WHERE ABATEMENT_ID = X_ABATEMENT_ID;

Line: 443


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

Line: 445


END UPDATE_ROW;

Line: 454


procedure DELETE_ROW ( X_ABATEMENT_ID in NUMBER)
IS
BEGIN

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

Line: 460


   DELETE FROM PN_VAR_ABAT_DEFAULTS_ALL
   WHERE  ABATEMENT_ID = X_ABATEMENT_ID;

Line: 467


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

Line: 469


END DELETE_ROW;