APPS.PN_VAR_LINE_TEMPLATES_PKG SQL Statements

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

Line: 7

procedure INSERT_ROW (
   X_ROWID                    in out NOCOPY VARCHAR2,
   X_LINE_TEMPLATE_ID         in out NOCOPY NUMBER,
   X_LINE_DETAIL_NUM          in out NOCOPY NUMBER,
   X_AGREEMENT_TEMPLATE_ID    in NUMBER,
   X_SALES_TYPE_CODE          in VARCHAR2,
   X_ITEM_CATEGORY_CODE       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_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_LINE_TEMPLATES_ALL
              where  LINE_TEMPLATE_ID = X_LINE_TEMPLATE_ID
              ;

Line: 48

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

Line: 53

        select  nvl(max(bkdetails.LINE_DETAIL_NUM),0)
        into    X_LINE_DETAIL_NUM
        from    PN_VAR_LINE_TEMPLATES_ALL      bkdetails
        where   bkdetails.AGREEMENT_TEMPLATE_ID    =  X_AGREEMENT_TEMPLATE_ID;

Line: 64

                select  PN_VAR_LINE_TEMPLATES_S.nextval
                into    X_LINE_TEMPLATE_ID
                from    dual;

Line: 69

    insert into PN_VAR_LINE_TEMPLATES_ALL
    (
            LINE_TEMPLATE_ID,
            LINE_DETAIL_NUM,
            AGREEMENT_TEMPLATE_ID,
            SALES_TYPE_CODE,
            ITEM_CATEGORY_CODE,
            ORG_ID,
            CREATION_DATE,
            CREATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
    )
    values
    (
            X_LINE_TEMPLATE_ID,
            X_LINE_DETAIL_NUM,
            X_AGREEMENT_TEMPLATE_ID,
            X_SALES_TYPE_CODE,
            X_ITEM_CATEGORY_CODE,
            X_ORG_ID,
            X_CREATION_DATE,
            X_CREATED_BY,
            X_LAST_UPDATE_DATE,
            X_LAST_UPDATED_BY,
            X_LAST_UPDATE_LOGIN,
            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
    );

Line: 138

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

Line: 140

END INSERT_ROW;

Line: 170

        select *
            from PN_VAR_LINE_TEMPLATES_ALL
            where  LINE_TEMPLATE_ID = X_LINE_TEMPLATE_ID
            for update of  LINE_TEMPLATE_ID nowait;

Line: 349

procedure UPDATE_ROW (
    X_LINE_TEMPLATE_ID         in NUMBER,
    X_LINE_DETAIL_NUM          in NUMBER,
    X_AGREEMENT_TEMPLATE_ID    in NUMBER,
    X_SALES_TYPE_CODE          in VARCHAR2,
    X_ITEM_CATEGORY_CODE       in VARCHAR2,
    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

    l_return_status         VARCHAR2(30)    := NULL;

Line: 380

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

Line: 383

  update PN_VAR_LINE_TEMPLATES_ALL set
    LINE_TEMPLATE_ID         = X_LINE_TEMPLATE_ID,
    LINE_DETAIL_NUM          = X_LINE_DETAIL_NUM,
    AGREEMENT_TEMPLATE_ID    = X_AGREEMENT_TEMPLATE_ID,
    SALES_TYPE_CODE          = X_SALES_TYPE_CODE,
    ITEM_CATEGORY_CODE       = X_ITEM_CATEGORY_CODE,
    LAST_UPDATE_DATE         = X_LAST_UPDATE_DATE,
    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
  where LINE_TEMPLATE_ID = X_LINE_TEMPLATE_ID
  ;

Line: 415

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

Line: 417

END UPDATE_ROW;

Line: 422

procedure DELETE_ROW (
  X_LINE_TEMPLATE_ID    in NUMBER
) is

BEGIN

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

Line: 430

  delete from PN_VAR_LINE_TEMPLATES_ALL
  where LINE_TEMPLATE_ID = X_LINE_TEMPLATE_ID;

Line: 437

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

Line: 439

END DELETE_ROW;