The following lines contain the word 'select', 'insert', 'update' or 'delete':
| 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;
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;
END insert_row;
| 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;
END update_row;
SELECT *
FROM PN_PAY_GROUP_BYS
WHERE GROUP_BY_ID = x_GROUP_BY_ID
FOR UPDATE OF GROUP_BY_ID NOWAIT;
| 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;
END delete_row;