APPS.PN_PAY_GROUP_BYS_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_bys
 | 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_GROUP_BY_ID          IN OUT NOCOPY NUMBER
,x_GROUPING_RULE_ID     IN            NUMBER
,x_GROUP_BY_LOOKUP_CODE 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_by IS
  SELECT GROUP_BY_ID
  FROM   PN_PAY_GROUP_BYS
  WHERE  GROUP_BY_ID = x_GROUP_BY_ID;

Line: 47

INSERT INTO PN_PAY_GROUP_BYS
(GROUP_BY_ID
,GROUPING_RULE_ID
,GROUP_BY_LOOKUP_CODE
,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_GROUP_BY_ID, PN_PAY_GROUP_BYS_S.NEXTVAL)
,x_GROUPING_RULE_ID
,x_GROUP_BY_LOOKUP_CODE
,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 GROUP_BY_ID INTO x_GROUP_BY_ID;

Line: 114

END insert_row;

Line: 117

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

BEGIN

UPDATE PN_PAY_GROUP_BYS SET
 GROUPING_RULE_ID     = x_GROUPING_RULE_ID
,GROUP_BY_LOOKUP_CODE = x_GROUP_BY_LOOKUP_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 GROUP_BY_ID = x_GROUP_BY_ID;

Line: 183

END update_row;

Line: 242

  SELECT *
  FROM   PN_PAY_GROUP_BYS
  WHERE  GROUP_BY_ID = x_GROUP_BY_ID
  FOR UPDATE OF GROUP_BY_ID NOWAIT;

Line: 361

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

BEGIN

DELETE FROM PN_PAY_GROUP_BYS
WHERE GROUP_BY_ID = x_GROUP_BY_ID;

Line: 384

END delete_row;