APPS.PN_VAR_LINES_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_LINE_ITEM_ID          in out NOCOPY NUMBER,
   X_LINE_ITEM_NUM         in out NOCOPY NUMBER,
   X_PERIOD_ID             in NUMBER,
   X_SALES_TYPE_CODE       in VARCHAR2,
   X_ITEM_CATEGORY_CODE    in VARCHAR2,
   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_LINE_TEMPLATE_ID      in NUMBER,
   X_AGREEMENT_TEMPLATE_ID in NUMBER,
   X_LINE_DEFAULT_ID       in NUMBER,
   X_VAR_RENT_ID           in NUMBER
   )
IS
   CURSOR C IS
      SELECT ROWID
      FROM   PN_VAR_LINES_ALL
      WHERE  LINE_ITEM_ID = X_LINE_ITEM_ID;

Line: 53

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

Line: 58

   SELECT  nvl(max(lines.LINE_ITEM_NUM),0)
   INTO    X_LINE_ITEM_NUM
   FROM    PN_VAR_LINES_ALL      lines
   WHERE   lines.PERIOD_ID    =  X_PERIOD_ID;

Line: 69

      SELECT  pn_var_lines_s.nextval
      INTO    X_LINE_ITEM_ID
      FROM    dual;

Line: 74

   INSERT INTO PN_VAR_LINES_ALL
   (
      LINE_ITEM_ID,
      LINE_ITEM_NUM,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_LOGIN,
      PERIOD_ID,
      SALES_TYPE_CODE,
      ITEM_CATEGORY_CODE,
      COMMENTS,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ORG_ID,
      LINE_TEMPLATE_ID ,
      AGREEMENT_TEMPLATE_ID,
      LINE_DEFAULT_ID,
      VAR_RENT_ID,
      BKPT_UPDATE_FLAG
   )
   VALUES
   (
      X_LINE_ITEM_ID,
      X_LINE_ITEM_NUM,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_CREATION_DATE,
      X_CREATED_BY,
      X_LAST_UPDATE_LOGIN,
      X_PERIOD_ID,
      X_SALES_TYPE_CODE,
      X_ITEM_CATEGORY_CODE,
      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_LINE_TEMPLATE_ID ,
      X_AGREEMENT_TEMPLATE_ID,
      X_LINE_DEFAULT_ID,
      X_VAR_RENT_ID,
      'Y'
   ) ;

Line: 155

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

Line: 157

END INSERT_ROW;

Line: 196

      SELECT *
      FROM PN_VAR_LINES_ALL
      WHERE LINE_ITEM_ID = X_LINE_ITEM_ID
      FOR UPDATE OF LINE_ITEM_ID NOWAIT;

Line: 381

procedure UPDATE_ROW (
   X_LINE_ITEM_ID          in NUMBER,
   X_LINE_ITEM_NUM         in NUMBER,
   X_PERIOD_ID             in NUMBER,
   X_SALES_TYPE_CODE       in VARCHAR2,
   X_ITEM_CATEGORY_CODE    in VARCHAR2,
   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_LINE_TEMPLATE_ID      in NUMBER,
   X_AGREEMENT_TEMPLATE_ID in NUMBER,
   X_LINE_DEFAULT_ID       in NUMBER,
   X_VAR_RENT_ID           in NUMBER
)
IS
BEGIN

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

Line: 417

   UPDATE PN_VAR_LINES_ALL
   SET
      LINE_ITEM_NUM         = X_LINE_ITEM_NUM,
      PERIOD_ID             = X_PERIOD_ID,
      SALES_TYPE_CODE       = X_SALES_TYPE_CODE,
      ITEM_CATEGORY_CODE    = X_ITEM_CATEGORY_CODE,
      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,
      LAST_UPDATE_DATE      = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY       = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN     = X_LAST_UPDATE_LOGIN,
      LINE_TEMPLATE_ID      = X_LINE_TEMPLATE_ID ,
      AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID,
      LINE_DEFAULT_ID       = X_LINE_DEFAULT_ID,
      VAR_RENT_ID           = X_VAR_RENT_ID
   WHERE LINE_ITEM_ID   = X_LINE_ITEM_ID;

Line: 453

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

Line: 455

END UPDATE_ROW;

Line: 464

procedure DELETE_ROW ( X_LINE_ITEM_ID in NUMBER)
IS
   -- Get the details of
   CURSOR line_info_cur IS
     SELECT period_id, var_rent_id
       FROM pn_var_lines_all
      WHERE line_item_id = x_line_item_id;

Line: 474

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

Line: 476

   /* Delete the transaction records for this line item */
   FOR rec IN line_info_cur LOOP
      NULL;

Line: 482

   DELETE from PN_VAR_LINES_ALL
   WHERE LINE_ITEM_ID = X_LINE_ITEM_ID;

Line: 489

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

Line: 491

END DELETE_ROW;