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_DEDUCTIONS_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_DEDUCTION_ID        in out NOCOPY NUMBER,
   X_DEDUCTION_NUM       in out NOCOPY NUMBER,
   X_EXPORTED_CODE       in VARCHAR2,
   X_LINE_ITEM_ID        in NUMBER,
   X_PERIOD_ID           in NUMBER,
   X_START_DATE          in DATE,
   X_END_DATE            in DATE,
   X_GRP_DATE_ID         in NUMBER,
   X_GROUP_DATE          in DATE,
   X_INVOICING_DATE      in DATE,
   X_GL_ACCOUNT_ID       in NUMBER,
   X_DEDUCTION_TYPE_CODE in VARCHAR2,
   X_DEDUCTION_AMOUNT    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
)
IS
   CURSOR C IS
      SELECT ROWID
      FROM PN_VAR_DEDUCTIONS_ALL
      WHERE DEDUCTION_ID = X_DEDUCTION_ID;

Line: 58


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

Line: 64


   SELECT NVL(max(deduction_num),0)
   INTO X_DEDUCTION_NUM
   FROM PN_VAR_DEDUCTIONS_ALL
   WHERE LINE_ITEM_ID = X_LINE_ITEM_ID;

Line: 76


      SELECT PN_VAR_DEDUCTIONS_S.nextval
      INTO X_DEDUCTION_ID
      FROM dual;

Line: 82


   INSERT INTO PN_VAR_DEDUCTIONS_ALL
   (
      DEDUCTION_ID,
      DEDUCTION_NUM,
      EXPORTED_CODE,
      LINE_ITEM_ID,
      PERIOD_ID,
      START_DATE,
      END_DATE,
      GRP_DATE_ID,
      GROUP_DATE,
      INVOICING_DATE,
      GL_ACCOUNT_ID,
      DEDUCTION_TYPE_CODE,
      DEDUCTION_AMOUNT,
      COMMENTS,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ORG_ID,
      CREATION_DATE,
      CREATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN
   )
   VALUES
   (
      X_DEDUCTION_ID,
      X_DEDUCTION_NUM,
      X_EXPORTED_CODE,
      X_LINE_ITEM_ID,
      X_PERIOD_ID,
      X_START_DATE,
      X_END_DATE,
      X_GRP_DATE_ID,
      X_GROUP_DATE,
      X_INVOICING_DATE,
      X_GL_ACCOUNT_ID,
      X_DEDUCTION_TYPE_CODE,
      X_DEDUCTION_AMOUNT,
      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_CREATION_DATE,
      X_CREATED_BY,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN
   );

Line: 169


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

Line: 171


END INSERT_ROW;

Line: 214


      SELECT *
      FROM PN_VAR_DEDUCTIONS_ALL
      WHERE DEDUCTION_ID = X_DEDUCTION_ID
      FOR UPDATE OF DEDUCTION_ID NOWAIT;

Line: 449


procedure UPDATE_ROW (
   X_DEDUCTION_ID        in NUMBER,
   X_DEDUCTION_NUM       in NUMBER,
   X_EXPORTED_CODE       in VARCHAR2,
   X_LINE_ITEM_ID        in NUMBER,
   X_PERIOD_ID           in NUMBER,
   X_START_DATE          in DATE,
   X_END_DATE            in DATE,
   X_GRP_DATE_ID         in NUMBER,
   X_GROUP_DATE          in DATE,
   X_INVOICING_DATE      in DATE,
   X_GL_ACCOUNT_ID       in NUMBER,
   X_DEDUCTION_TYPE_CODE in VARCHAR2,
   X_DEDUCTION_AMOUNT    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
  )
IS
BEGIN

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

Line: 489


   UPDATE PN_VAR_DEDUCTIONS_ALL
   SET
      DEDUCTION_ID        = X_DEDUCTION_ID,
      DEDUCTION_NUM       = X_DEDUCTION_NUM,
      EXPORTED_CODE       = X_EXPORTED_CODE,
      LINE_ITEM_ID        = X_LINE_ITEM_ID,
      PERIOD_ID           = X_PERIOD_ID,
      START_DATE          = X_START_DATE,
      END_DATE            = X_END_DATE,
      GRP_DATE_ID         = X_GRP_DATE_ID,
      GROUP_DATE          = X_GROUP_DATE,
      INVOICING_DATE      = X_INVOICING_DATE,
      GL_ACCOUNT_ID       = X_GL_ACCOUNT_ID,
      DEDUCTION_TYPE_CODE = X_DEDUCTION_TYPE_CODE,
      DEDUCTION_AMOUNT    = X_DEDUCTION_AMOUNT,
      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,
      LAST_UPDATE_DATE    = X_LAST_UPDATE_DATE,
      LAST_UPDATED_BY     = X_LAST_UPDATED_BY,
      LAST_UPDATE_LOGIN   = X_LAST_UPDATE_LOGIN
   WHERE DEDUCTION_ID = X_DEDUCTION_ID;

Line: 529


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

Line: 531


END UPDATE_ROW;

Line: 541


procedure DELETE_ROW (
   X_DEDUCTION_ID in NUMBER
)
IS
BEGIN

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

Line: 549


   DELETE FROM PN_VAR_DEDUCTIONS_ALL
   WHERE DEDUCTION_ID = X_DEDUCTION_ID;

Line: 556


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

Line: 558


END DELETE_ROW;