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_RENT_DATES_PKG SQL Statements

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

Line: 11


procedure INSERT_ROW (
                        X_ROWID                 in out NOCOPY VARCHAR2,
                        X_VAR_RENT_DATE_ID      in out NOCOPY NUMBER,
                        X_VAR_RENT_ID           in NUMBER,
                        X_GL_PERIOD_SET_NAME    in VARCHAR2,
                        X_PERIOD_FREQ_CODE      in VARCHAR2,
                        X_REPTG_FREQ_CODE       in VARCHAR2,
                        X_REPTG_DAY_OF_MONTH    in NUMBER,
                        X_REPTG_DAYS_AFTER      in NUMBER,
                        X_INVG_FREQ_CODE        in VARCHAR2,
                        X_INVG_DAY_OF_MONTH     in NUMBER,
                        X_INVG_DAYS_AFTER       in NUMBER,
                        X_INVG_SPREAD_CODE      in VARCHAR2,
                        X_INVG_TERM             in NUMBER,
                        X_AUDIT_FREQ_CODE       in VARCHAR2,
                        X_AUDIT_DAY_OF_MONTH    in NUMBER,
                        X_AUDIT_DAYS_AFTER      in NUMBER,
                        X_RECON_FREQ_CODE       in VARCHAR2,
                        X_RECON_DAY_OF_MONTH    in NUMBER,
                        X_RECON_DAYS_AFTER      in NUMBER,
                        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,
                        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_USE_GL_CALENDAR       in VARCHAR2,
                        X_PERIOD_TYPE           in VARCHAR2,
                        X_YEAR_START_DATE       in DATE,
                        X_COMMENTS              in VARCHAR2,
                        X_VRG_REPTG_FREQ_CODE   in VARCHAR2
                        )
IS

   CURSOR var_rent_dates IS
      SELECT ROWID
      FROM   PN_VAR_RENT_DATES_ALL
      WHERE  VAR_RENT_DATE_ID = X_VAR_RENT_DATE_ID;

Line: 67


     SELECT org_id FROM PN_VAR_RENTS_ALL WHERE VAR_RENT_ID = X_VAR_RENT_ID;

Line: 72


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

Line: 78


      SELECT  pn_var_rent_dates_s.nextval
      INTO    X_VAR_RENT_DATE_ID
      FROM    dual;

Line: 91


   INSERT INTO PN_VAR_RENT_DATES_ALL
   (
      VAR_RENT_DATE_ID,
      VAR_RENT_ID,
      GL_PERIOD_SET_NAME,
      PERIOD_FREQ_CODE,
      REPTG_FREQ_CODE,
      REPTG_DAY_OF_MONTH,
      REPTG_DAYS_AFTER,
      INVG_FREQ_CODE,
      INVG_DAY_OF_MONTH,
      INVG_DAYS_AFTER,
      INVG_SPREAD_CODE,
      INVG_TERM,
      AUDIT_FREQ_CODE,
      AUDIT_DAY_OF_MONTH,
      AUDIT_DAYS_AFTER,
      RECON_FREQ_CODE,
      RECON_DAY_OF_MONTH,
      RECON_DAYS_AFTER,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ORG_ID,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_LOGIN,
      USE_GL_CALENDAR,
      PERIOD_TYPE,
      YEAR_START_DATE,
      COMMENTS,
      VRG_REPTG_FREQ_CODE
   )
   VALUES
   (
      X_VAR_RENT_DATE_ID,
      X_VAR_RENT_ID,
      X_GL_PERIOD_SET_NAME,
      X_PERIOD_FREQ_CODE,
      X_REPTG_FREQ_CODE,
      X_REPTG_DAY_OF_MONTH,
      X_REPTG_DAYS_AFTER,
      X_INVG_FREQ_CODE,
      X_INVG_DAY_OF_MONTH,
      X_INVG_DAYS_AFTER,
      X_INVG_SPREAD_CODE,
      X_INVG_TERM,
      X_AUDIT_FREQ_CODE,
      X_AUDIT_DAY_OF_MONTH,
      X_AUDIT_DAYS_AFTER,
      X_RECON_FREQ_CODE,
      X_RECON_DAY_OF_MONTH,
      X_RECON_DAYS_AFTER,
      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_CREATION_DATE,
      X_CREATED_BY,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN,
      X_USE_GL_CALENDAR,
      X_PERIOD_TYPE,
      X_YEAR_START_DATE,
      X_COMMENTS,
      X_VRG_REPTG_FREQ_CODE
   );

Line: 196


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

Line: 198


END INSERT_ROW;

Line: 252


      SELECT *
      FROM PN_VAR_RENT_DATES_ALL
      WHERE VAR_RENT_DATE_ID = X_VAR_RENT_DATE_ID
      FOR UPDATE OF VAR_RENT_DATE_ID NOWAIT;

Line: 515


procedure UPDATE_ROW (
                        X_VAR_RENT_DATE_ID      in NUMBER,
                        X_VAR_RENT_ID           in NUMBER,
                        X_GL_PERIOD_SET_NAME    in VARCHAR2,
                        X_PERIOD_FREQ_CODE      in VARCHAR2,
                        X_REPTG_FREQ_CODE       in VARCHAR2,
                        X_REPTG_DAY_OF_MONTH    in NUMBER,
                        X_REPTG_DAYS_AFTER      in NUMBER,
                        X_INVG_FREQ_CODE        in VARCHAR2,
                        X_INVG_DAY_OF_MONTH     in NUMBER,
                        X_INVG_DAYS_AFTER       in NUMBER,
                        X_INVG_SPREAD_CODE      in VARCHAR2,
                        X_INVG_TERM             in NUMBER,
                        X_AUDIT_FREQ_CODE       in VARCHAR2,
                        X_AUDIT_DAY_OF_MONTH    in NUMBER,
                        X_AUDIT_DAYS_AFTER      in NUMBER,
                        X_RECON_FREQ_CODE       in VARCHAR2,
                        X_RECON_DAY_OF_MONTH    in NUMBER,
                        X_RECON_DAYS_AFTER      in NUMBER,
                        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,
                        X_USE_GL_CALENDAR       in VARCHAR2,
                        X_PERIOD_TYPE           in VARCHAR2,
                        X_YEAR_START_DATE       in DATE,
                        X_COMMENTS              in VARCHAR2,
                        X_VRG_REPTG_FREQ_CODE   in VARCHAR2
                )
IS
BEGIN

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

Line: 564


   UPDATE PN_VAR_RENT_DATES_ALL
   SET
      VAR_RENT_DATE_ID          = X_VAR_RENT_DATE_ID,
      VAR_RENT_ID               = X_VAR_RENT_ID,
      GL_PERIOD_SET_NAME        = X_GL_PERIOD_SET_NAME,
      PERIOD_FREQ_CODE          = X_PERIOD_FREQ_CODE,
      REPTG_FREQ_CODE           = X_REPTG_FREQ_CODE,
      REPTG_DAY_OF_MONTH        = X_REPTG_DAY_OF_MONTH,
      REPTG_DAYS_AFTER          = X_REPTG_DAYS_AFTER,
      INVG_FREQ_CODE            = X_INVG_FREQ_CODE,
      INVG_DAY_OF_MONTH         = X_INVG_DAY_OF_MONTH,
      INVG_DAYS_AFTER           = X_INVG_DAYS_AFTER,
      INVG_SPREAD_CODE          = X_INVG_SPREAD_CODE,
      INVG_TERM                 = X_INVG_TERM,
      AUDIT_FREQ_CODE           = X_AUDIT_FREQ_CODE,
      AUDIT_DAY_OF_MONTH        = X_AUDIT_DAY_OF_MONTH,
      AUDIT_DAYS_AFTER          = X_AUDIT_DAYS_AFTER,
      RECON_FREQ_CODE           = X_RECON_FREQ_CODE,
      RECON_DAY_OF_MONTH        = X_RECON_DAY_OF_MONTH,
      RECON_DAYS_AFTER          = X_RECON_DAYS_AFTER,
      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,
      USE_GL_CALENDAR           = X_USE_GL_CALENDAR,
      PERIOD_TYPE               = X_PERIOD_TYPE,
      YEAR_START_DATE           = X_YEAR_START_DATE,
      COMMENTS                  = X_COMMENTS,
      VRG_REPTG_FREQ_CODE       = X_VRG_REPTG_FREQ_CODE
   WHERE VAR_RENT_DATE_ID       = X_VAR_RENT_DATE_ID   ;

Line: 614


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

Line: 616


END UPDATE_ROW;

Line: 627


procedure DELETE_ROW
        (
            X_VAR_RENT_DATE_ID in NUMBER
        )
IS
BEGIN

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

Line: 636


   DELETE FROM PN_VAR_RENT_DATES_ALL
   WHERE VAR_RENT_DATE_ID = X_VAR_RENT_DATE_ID;

Line: 643


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

Line: 645


END DELETE_ROW;