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.

APPS.PN_PAY_GROUP_RULES_PKG SQL Statements

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

Line: 5


 | PROCEDURE insert_row
 | DESCRIPTION
 |    inserts row into pn_pay_group_rules
 | SCOPE - PUBLIC
 | MODIFICATION HISTORY
 |
 | 15-DEC-2003  Kiran  o Created.
 | 03-FEB-2003  Kiran  o Removed ORG_ID from insert_row.
 +===========================================================================*/
PROCEDURE insert_row(
 x_GROUPING_RULE_ID    IN OUT NOCOPY NUMBER
,x_NAME                IN            VARCHAR2
,x_DESCRIPTION         IN            VARCHAR2
,x_LAST_UPDATE_DATE    IN            DATE
,x_LAST_UPDATED_BY     IN            NUMBER
,x_CREATION_DATE       IN            DATE
,x_CREATED_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 group_rule IS
  SELECT GROUPING_RULE_ID
  FROM   PN_PAY_GROUP_RULES
  WHERE  GROUPING_RULE_ID = x_GROUPING_RULE_ID;

Line: 47


INSERT INTO PN_PAY_GROUP_RULES
(GROUPING_RULE_ID
,NAME
,DESCRIPTION
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_LOGIN
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15)
VALUES
(NVL(x_GROUPING_RULE_ID, PN_PAY_GROUP_RULES_S.NEXTVAL)
,x_NAME
,x_DESCRIPTION
,x_LAST_UPDATE_DATE
,x_LAST_UPDATED_BY
,x_CREATION_DATE
,x_CREATED_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)
RETURNING GROUPING_RULE_ID INTO x_GROUPING_RULE_ID;

Line: 114


END insert_row;

Line: 117


 | PROCEDURE update_row
 | DESCRIPTION
 |    updates a row in pn_pay_group_rules
 | SCOPE - PUBLIC
 | MODIFICATION HISTORY
 |
 |   15-DEC-2003  Kiran  o Created.
 +===========================================================================*/
PROCEDURE update_row(
 x_GROUPING_RULE_ID    IN            NUMBER
,x_NAME                IN            VARCHAR2
,x_DESCRIPTION         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

BEGIN

UPDATE PN_PAY_GROUP_RULES SET
 NAME                = x_NAME
,DESCRIPTION         = x_DESCRIPTION
,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 GROUPING_RULE_ID = x_GROUPING_RULE_ID;

Line: 183


END update_row;

Line: 242


  SELECT *
  FROM   PN_PAY_GROUP_RULES
  WHERE  GROUPING_RULE_ID = x_GROUPING_RULE_ID
  FOR UPDATE OF GROUPING_RULE_ID NOWAIT;

Line: 361


 | PROCEDURE delete_row
 | DESCRIPTION
 |    deletes a row from pn_pay_group_rules
 | SCOPE - PUBLIC
 | MODIFICATION HISTORY
 |
 |   15-DEC-2003  Kiran  o Created.
 +===========================================================================*/
PROCEDURE delete_row(
 x_GROUPING_RULE_ID    IN            NUMBER) IS

BEGIN

DELETE FROM PN_PAY_GROUP_RULES
WHERE GROUPING_RULE_ID = x_GROUPING_RULE_ID;

Line: 384


END delete_row;