APPS.PN_VAR_BKHD_DEFAULTS_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_BKHD_DEFAULT_ID       in out NOCOPY NUMBER,
  X_BKHD_DETAIL_NUM       in out NOCOPY NUMBER,
  X_LINE_DEFAULT_ID       in NUMBER,
  X_BKPT_HEAD_TEMPLATE_ID in NUMBER,
  X_AGREEMENT_TEMPLATE_ID in NUMBER,
  X_BKHD_START_DATE       in DATE,
  X_BKHD_END_DATE         in DATE,
  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_BREAKPOINT_LEVEL      in VARCHAR2,
  X_PROCESSED_FLAG        in NUMBER,
  X_VAR_RENT_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_ORG_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
) is

  CURSOR C IS
     SELECT ROWID
     FROM pn_var_bkhd_defaults_all
     WHERE bkhd_default_id = x_bkhd_default_id ;

Line: 60

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

Line: 64

   SELECT nvl(max(bkhd.bkhd_detail_num),0)
   INTO   X_BKHD_DETAIL_NUM
   FROM   pn_var_bkhd_defaults_all  bkhd
   WHERE  bkhd.bkhd_default_id = X_BKHD_DEFAULT_ID;

Line: 74

      SELECT  PN_VAR_BKHD_DEFAULTS_S.nextval
      INTO    X_BKHD_DEFAULT_ID
      FROM    dual;

Line: 79

   insert into PN_VAR_BKHD_DEFAULTS_ALL
   (
      BKHD_DEFAULT_ID,
      BKHD_DETAIL_NUM,
      LINE_DEFAULT_ID,
      BKPT_HEAD_TEMPLATE_ID,
      AGREEMENT_TEMPLATE_ID,
      BKHD_START_DATE,
      BKHD_END_DATE,
      BREAK_TYPE,
      BASE_RENT_TYPE,
      NATURAL_BREAK_RATE,
      BASE_RENT,
      BREAKPOINT_TYPE,
      BREAKPOINT_LEVEL,
      PROCESSED_FLAG,
      VAR_RENT_ID,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_LOGIN,
      ORG_ID,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      BKPT_UPDATE_FLAG
   )
   values
   (
      X_BKHD_DEFAULT_ID,
      X_BKHD_DETAIL_NUM,
      X_LINE_DEFAULT_ID,
      X_BKPT_HEAD_TEMPLATE_ID,
      X_AGREEMENT_TEMPLATE_ID,
      X_BKHD_START_DATE,
      X_BKHD_END_DATE,
      X_BREAK_TYPE,
      X_BASE_RENT_TYPE,
      X_NATURAL_BREAK_RATE,
      X_BASE_RENT,
      X_BREAKPOINT_TYPE,
      X_BREAKPOINT_LEVEL,
      X_PROCESSED_FLAG,
      X_VAR_RENT_ID,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_CREATION_DATE,
      X_CREATED_BY,
      X_LAST_UPDATE_LOGIN,
      X_ORG_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,
      'Y'
   );

Line: 170

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

Line: 172

END INSERT_ROW;

Line: 214

  cursor c1 is select
      *
    from PN_VAR_BKHD_DEFAULTS_ALL
    where BKHD_DEFAULT_ID = X_BKHD_DEFAULT_ID
    for update of BKHD_DEFAULT_ID nowait;

Line: 439

procedure UPDATE_ROW (
  X_BKHD_DEFAULT_ID       in NUMBER,
  X_BKHD_DETAIL_NUM       in NUMBER,
  X_LINE_DEFAULT_ID       in NUMBER,
  X_BKPT_HEAD_TEMPLATE_ID in NUMBER,
  X_AGREEMENT_TEMPLATE_ID in NUMBER,
  X_BKHD_START_DATE       in DATE,
  X_BKHD_END_DATE         in DATE,
  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_BREAKPOINT_LEVEL      in VARCHAR2,
  X_PROCESSED_FLAG        in NUMBER,
  X_VAR_RENT_ID           in NUMBER,
  X_LAST_UPDATE_DATE      in DATE,
  X_LAST_UPDATED_BY       in NUMBER,
  X_LAST_UPDATE_LOGIN     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
) IS

BEGIN

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

Line: 480

   UPDATE PN_VAR_BKHD_DEFAULTS_ALL SET
      LINE_DEFAULT_ID       = X_LINE_DEFAULT_ID,
      BKHD_DETAIL_NUM       = X_BKHD_DETAIL_NUM,
      BKPT_HEAD_TEMPLATE_ID = X_BKPT_HEAD_TEMPLATE_ID,
      AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID,
      BKHD_START_DATE       = X_BKHD_START_DATE,
      BKHD_END_DATE         = X_BKHD_END_DATE,
      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,
      BREAKPOINT_LEVEL      = X_BREAKPOINT_LEVEL,
      BKHD_DEFAULT_ID       = X_BKHD_DEFAULT_ID,
      PROCESSED_FLAG        = X_PROCESSED_FLAG,
      VAR_RENT_ID           = X_VAR_RENT_ID,
      LAST_UPDATE_DATE      = sysdate,
      LAST_UPDATED_BY       = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN     = X_LAST_UPDATE_LOGIN,
      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_UPDATE_FLAG      = 'Y'
   WHERE BKHD_DEFAULT_ID = X_BKHD_DEFAULT_ID;

Line: 522

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

Line: 524

END UPDATE_ROW;

Line: 529

procedure DELETE_ROW (  X_BKHD_DEFAULT_ID in NUMBER)
IS

BEGIN

   PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.DELETE_ROW (+)'||X_BKHD_DEFAULT_ID);

Line: 536

   DELETE FROM PN_VAR_BKHD_DEFAULTS_ALL
   WHERE BKHD_DEFAULT_ID = X_BKHD_DEFAULT_ID;

Line: 543

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

Line: 545

END DELETE_ROW;

Line: 570

  X_LAST_UPDATE_DATE      in DATE,
  X_LAST_UPDATED_BY       in NUMBER,
  X_LAST_UPDATE_LOGIN     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
) IS

/* Get the details of breakpoint header default */
CURSOR bkhd_defaults_cur IS
  SELECT *
  FROM pn_var_bkhd_defaults_all
  WHERE bkhd_default_id = x_bkhd_default_id;

Line: 602

      UPDATE pn_var_bkhd_defaults_all SET
         line_default_id       = NVL( x_line_default_id, rec.line_default_id),
         bkhd_detail_num       = NVL( x_bkhd_detail_num, rec.bkhd_detail_num ),
         bkpt_head_template_id = NVL( x_bkpt_head_template_id, rec.bkpt_head_template_id),
         agreement_template_id = NVL( x_agreement_template_id, rec.agreement_template_id ),
         bkhd_start_date       = NVL( x_bkhd_start_date, rec.bkhd_start_date),
         bkhd_end_date         = NVL( x_bkhd_end_date, rec.bkhd_end_date ),
         break_type            = NVL( x_break_type, rec.break_type),
         base_rent_type        = NVL( x_base_rent_type, rec.base_rent_type),
         natural_break_rate    = NVL( x_natural_break_rate, rec.natural_break_rate),
         base_rent             = NVL( x_base_rent, rec.base_rent),
         breakpoint_type       = NVL( x_breakpoint_type, rec.breakpoint_type),
         breakpoint_level      = NVL( x_breakpoint_level, rec.breakpoint_level),
         bkhd_default_id       = NVL( x_bkhd_default_id, rec.bkhd_default_id),
         processed_flag        = NVL( x_processed_flag, rec.processed_flag),
         var_rent_id           = NVL( x_var_rent_id, rec.var_rent_id),
         last_update_date      = NVL( x_last_update_date, rec.last_update_date),
         last_updated_by       = NVL( x_last_updated_by, rec.last_updated_by),
         last_update_login     = NVL( x_last_update_login, rec.last_update_login),
         attribute_category    = NVL( x_attribute_category, rec.attribute_category),
         attribute1            = NVL( x_attribute1, rec.attribute1),
         attribute2            = NVL( x_attribute2, rec.attribute2),
         attribute3            = NVL( x_attribute3, rec.attribute3),
         attribute4            = NVL( x_attribute4, rec.attribute4),
         attribute5            = NVL( x_attribute5, rec.attribute5),
         attribute6            = NVL( x_attribute6, rec.attribute6),
         attribute7            = NVL( x_attribute7, rec.attribute7),
         attribute8            = NVL( x_attribute8, rec.attribute8),
         attribute9            = NVL( x_attribute9, rec.attribute9),
         attribute10           = NVL( x_attribute10, rec.attribute10),
         attribute11           = NVL( x_attribute11, rec.attribute11),
         attribute12           = NVL( x_attribute12, rec.attribute12),
         attribute13           = NVL( x_attribute13, rec.attribute13),
         attribute14           = NVL( x_attribute14, rec.attribute14),
         attribute15           = NVL( x_attribute15, rec.attribute15),
         bkpt_update_flag      = 'Y'
      WHERE bkhd_default_id = x_bkhd_default_id;