APPS.PN_VAR_BKPTS_HEAD_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_BKPT_HEADER_ID       in out NOCOPY NUMBER,
                     X_LINE_ITEM_ID         in NUMBER,
                     X_PERIOD_ID            in NUMBER,
                     X_BREAK_TYPE           in VARCHAR2,
                     X_BASE_RENT_TYPE       in VARCHAR2,
                     X_NATURAL_BREAK_RATE   in NUMBER,
                     X_BASE_RENT            in NUMBER,
                     X_BREAKPOINT_TYPE      in VARCHAR2,
                     X_BKHD_DEFAULT_ID      in NUMBER,
                     X_BKHD_START_DATE      in DATE DEFAULT NULL,
                     X_BKHD_END_DATE        in DATE DEFAULT NULL,
                     X_VAR_RENT_ID          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_BKPT_UPDATE_FLAG     in VARCHAR2)
IS
   CURSOR C IS
      SELECT ROWID
      FROM   PN_VAR_BKPTS_HEAD_ALL
      WHERE  BKPT_HEADER_ID = X_BKPT_HEADER_ID;

Line: 55

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

Line: 62

      SELECT  pn_var_bkpts_head_s.nextval
      INTO    X_BKPT_HEADER_ID
      FROM    dual;

Line: 67

   INSERT INTO PN_VAR_BKPTS_HEAD_ALL
   (
      BKPT_HEADER_ID,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_LOGIN,
      LINE_ITEM_ID,
      PERIOD_ID,
      BREAK_TYPE,
      BASE_RENT_TYPE,
      NATURAL_BREAK_RATE,
      BASE_RENT,
      BREAKPOINT_TYPE,
      BKHD_DEFAULT_ID,
      BKHD_START_DATE,
      BKHD_END_DATE,
      VAR_RENT_ID,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ORG_ID
   )
   VALUES
   (
      X_BKPT_HEADER_ID,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_CREATION_DATE,
      X_CREATED_BY,
      X_LAST_UPDATE_LOGIN,
      X_LINE_ITEM_ID,
      X_PERIOD_ID,
      X_BREAK_TYPE,
      X_BASE_RENT_TYPE,
      X_NATURAL_BREAK_RATE,
      X_BASE_RENT,
      X_BREAKPOINT_TYPE,
      X_BKHD_DEFAULT_ID,
      X_BKHD_START_DATE,
      X_BKHD_END_DATE,
      X_VAR_RENT_ID,
      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: 150

   IF NVL(x_bkpt_update_flag, 'Y') = 'Y' THEN
      UPDATE pn_var_lines_all
      SET bkpt_update_flag = 'Y'
      WHERE line_item_id = x_line_item_id;

Line: 156

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

Line: 158

END INSERT_ROW;

Line: 200

      SELECT *
      FROM PN_VAR_BKPTS_HEAD_ALL
      WHERE BKPT_HEADER_ID = X_BKPT_HEADER_ID
      FOR UPDATE OF BKPT_HEADER_ID NOWAIT;

Line: 384

procedure UPDATE_ROW (
    X_BKPT_HEADER_ID     in NUMBER,
    X_LINE_ITEM_ID       in NUMBER,
    X_PERIOD_ID          in NUMBER,
    X_BREAK_TYPE         in VARCHAR2,
    X_BASE_RENT_TYPE     in VARCHAR2,
    X_NATURAL_BREAK_RATE in NUMBER,
    X_BASE_RENT          in NUMBER,
    X_BREAKPOINT_TYPE    in VARCHAR2,
    X_BKHD_DEFAULT_ID    in NUMBER,
    X_BKHD_START_DATE    in DATE,
    X_BKHD_END_DATE      in DATE,
    X_VAR_RENT_ID        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
  )
IS
BEGIN

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

Line: 422

   UPDATE PN_VAR_BKPTS_HEAD_ALL SET
      LINE_ITEM_ID       = X_LINE_ITEM_ID,
      PERIOD_ID          = X_PERIOD_ID,
      BREAK_TYPE         = X_BREAK_TYPE,
      BASE_RENT_TYPE     = X_BASE_RENT_TYPE,
      NATURAL_BREAK_RATE = X_NATURAL_BREAK_RATE,
      BASE_RENT          = X_BASE_RENT,
      BREAKPOINT_TYPE    = X_BREAKPOINT_TYPE,
      BKHD_DEFAULT_ID    = X_BKHD_DEFAULT_ID,
      BKHD_START_DATE    = X_BKHD_START_DATE,
      BKHD_END_DATE      = X_BKHD_END_DATE,
      VAR_RENT_ID        = X_VAR_RENT_ID,
      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
   WHERE BKPT_HEADER_ID = X_BKPT_HEADER_ID;

Line: 459

   UPDATE pn_var_lines_all
   SET bkpt_update_flag = 'Y'
   WHERE line_item_id = x_line_item_id;

Line: 463

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

Line: 465

END UPDATE_ROW;

Line: 475

procedure DELETE_ROW ( X_BKPT_HEADER_ID in NUMBER)
IS
   CURSOR c IS
   SELECT  bkpt_detail_id
   FROM    pn_var_bkpts_det_all
   WHERE   bkpt_header_id = x_bkpt_header_id
   FOR UPDATE OF bkpt_detail_id NOWAIT;

Line: 484

      SELECT line_item_id
      FROM pn_var_bkpts_head_all
      WHERE bkpt_header_id = x_bkpt_header_id;

Line: 490

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

Line: 494

      PN_VAR_BKPTS_DET_PKG.DELETE_ROW ( X_BKPT_DETAIL_ID =>i.bkpt_detail_id );

Line: 498

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

Line: 503

   DELETE FROM PN_VAR_BKPTS_HEAD_ALL
   WHERE BKPT_HEADER_ID = X_BKPT_HEADER_ID;

Line: 510

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

Line: 512

END DELETE_ROW;