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.

[Home] [Help]

APPS.PN_VAR_BKPTS_DET_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_BKPT_DETAIL_ID        in out NOCOPY NUMBER,
                     X_BKPT_DETAIL_NUM       in out NOCOPY NUMBER,
                     X_BKPT_HEADER_ID        in NUMBER,
                     X_BKPT_START_DATE       in DATE,
                     X_BKPT_END_DATE         in DATE,
                     X_PERIOD_BKPT_VOL_START in NUMBER,
                     X_PERIOD_BKPT_VOL_END   in NUMBER,
                     X_GROUP_BKPT_VOL_START  in NUMBER,
                     X_GROUP_BKPT_VOL_END    in NUMBER,
                     X_BKPT_RATE             in NUMBER,
                     X_BKDT_DEFAULT_ID       in NUMBER,
                     X_VAR_RENT_ID           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,
                     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_ANNUAL_BASIS_AMOUNT   in NUMBER DEFAULT NULL  --03-NOV-2003
                   )
IS

   CURSOR C IS
        SELECT ROWID
        FROM   PN_VAR_BKPTS_DET_ALL
        WHERE  BKPT_DETAIL_ID = X_BKPT_DETAIL_ID
        ;

Line: 63


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

Line: 68


   SELECT  nvl(max(bkdetails.BKPT_DETAIL_NUM),0)
   INTO    X_BKPT_DETAIL_NUM
   FROM    PN_VAR_BKPTS_DET_ALL      bkdetails
   WHERE   bkdetails.BKPT_HEADER_ID    =  X_BKPT_HEADER_ID;

Line: 79


      SELECT  pn_var_bkpts_det_s.nextval
      INTO    X_BKPT_DETAIL_ID
      FROM    dual;

Line: 98


   INSERT INTO PN_VAR_BKPTS_DET_ALL
   (
      BKPT_DETAIL_ID,
      BKPT_DETAIL_NUM,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_LOGIN,
      BKPT_HEADER_ID,
      BKPT_START_DATE,
      BKPT_END_DATE,
      PERIOD_BKPT_VOL_START,
      PERIOD_BKPT_VOL_END,
      GROUP_BKPT_VOL_START,
      GROUP_BKPT_VOL_END,
      BKPT_RATE,
      BKDT_DEFAULT_ID,
      VAR_RENT_ID,
      COMMENTS,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ORG_ID,
      ANNUAL_BASIS_AMOUNT --03-NOV-2003
   )
   VALUES
   (
      X_BKPT_DETAIL_ID,
      X_BKPT_DETAIL_NUM,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_CREATION_DATE,
      X_CREATED_BY,
      X_LAST_UPDATE_LOGIN,
      X_BKPT_HEADER_ID,
      X_BKPT_START_DATE,
      X_BKPT_END_DATE,
      X_PERIOD_BKPT_VOL_START,
      X_PERIOD_BKPT_VOL_END,
      X_GROUP_BKPT_VOL_START,
      X_GROUP_BKPT_VOL_END,
      X_BKPT_RATE,
      X_BKDT_DEFAULT_ID,
      X_VAR_RENT_ID,
      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,
      X_ANNUAL_BASIS_AMOUNT --03-NOV-2003
   );

Line: 186


      UPDATE pn_var_lines_all
      SET bkpt_update_flag = 'Y'
      WHERE line_item_id IN (SELECT line_item_id
                             FROM pn_var_bkpts_head_all
                             WHERE bkpt_header_id = x_bkpt_header_id);

Line: 193


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

Line: 195


END INSERT_ROW;

Line: 239


      SELECT *
      FROM PN_VAR_BKPTS_DET_ALL
      WHERE BKPT_DETAIL_ID = X_BKPT_DETAIL_ID
      FOR UPDATE OF BKPT_DETAIL_ID nowait;

Line: 448


procedure UPDATE_ROW (
    X_BKPT_DETAIL_ID        in NUMBER,
    X_BKPT_DETAIL_NUM       in NUMBER,
    X_BKPT_HEADER_ID        in NUMBER,
    X_BKPT_START_DATE       in DATE,
    X_BKPT_END_DATE         in DATE,
    X_PERIOD_BKPT_VOL_START in NUMBER,
    X_PERIOD_BKPT_VOL_END   in NUMBER,
    X_GROUP_BKPT_VOL_START  in NUMBER,
    X_GROUP_BKPT_VOL_END    in NUMBER,
    X_BKPT_RATE             in NUMBER,
    X_BKDT_DEFAULT_ID       in NUMBER,
    X_VAR_RENT_ID           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_LAST_UPDATE_DATE      in DATE,
    X_LAST_UPDATED_BY       in NUMBER,
    X_LAST_UPDATE_LOGIN     in NUMBER,
    X_ANNUAL_BASIS_AMOUNT   in NUMBER DEFAULT NULL  --03-NOV-2003
  )
IS

   l_return_status         VARCHAR2(30)    := NULL;

Line: 489


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

Line: 504


   UPDATE PN_VAR_BKPTS_DET_ALL SET
      BKPT_DETAIL_NUM       = X_BKPT_DETAIL_NUM,
      BKPT_HEADER_ID        = X_BKPT_HEADER_ID,
      BKPT_START_DATE       = X_BKPT_START_DATE,
      BKPT_END_DATE         = X_BKPT_END_DATE,
      PERIOD_BKPT_VOL_START = X_PERIOD_BKPT_VOL_START,
      PERIOD_BKPT_VOL_END   = X_PERIOD_BKPT_VOL_END,
      GROUP_BKPT_VOL_START  = X_GROUP_BKPT_VOL_START,
      GROUP_BKPT_VOL_END    = X_GROUP_BKPT_VOL_END,
      BKPT_RATE             = X_BKPT_RATE,
      BKDT_DEFAULT_ID       = X_BKDT_DEFAULT_ID,
      VAR_RENT_ID           = X_VAR_RENT_ID,
      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,
      BKPT_DETAIL_ID        = X_BKPT_DETAIL_ID,
      LAST_UPDATE_DATE      = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY       = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN     = X_LAST_UPDATE_LOGIN,
      ANNUAL_BASIS_AMOUNT   = X_ANNUAL_BASIS_AMOUNT  --03-NOV-2003
   WHERE BKPT_DETAIL_ID = X_BKPT_DETAIL_ID ;

Line: 544


   UPDATE pn_var_lines_all
   SET bkpt_update_flag = 'Y'
   WHERE line_item_id IN (SELECT line_item_id
                          FROM pn_var_bkpts_head_all
                          WHERE bkpt_header_id = x_bkpt_header_id);

Line: 550


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

Line: 552


END UPDATE_ROW;

Line: 561


procedure DELETE_ROW ( X_BKPT_DETAIL_ID in NUMBER)
IS

   CURSOR line_item_cur IS
      SELECT line_item_id
      FROM pn_var_bkpts_head_all
      WHERE Bkpt_Header_id = (SELECT bkpt_header_id
                              FROM pn_var_bkpts_det_all
                              WHERE bkpt_detail_id = x_bkpt_detail_id);

Line: 573


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

Line: 576


      UPDATE pn_var_lines_all
      SET bkpt_update_flag = 'Y'
      WHERE line_item_id =  rec.line_item_id;

Line: 581


   DELETE FROM PN_VAR_BKPTS_DET_ALL
   WHERE BKPT_DETAIL_ID = X_BKPT_DETAIL_ID;

Line: 588


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

Line: 590


END DELETE_ROW;

Line: 611


   SELECT  1
   INTO    l_dummy
   FROM    dual
   WHERE   not exists
     (
         SELECT  1
         FROM    pn_var_bkpts_det_all   bkd
         WHERE   NVL(bkd.PERIOD_BKPT_VOL_END,(x_period_vol_start+1)) > (x_period_vol_start)
         AND     ((x_bkpt_detail_id    is null) or
                  (bkd.bkpt_detail_id  <> x_bkpt_detail_id))
         AND     bkd.bkpt_header_id  = x_bkpt_header_id
     );