APPS.PN_PAY_GROUP_BYS_PKG dependencies on PN_PAY_GROUP_BYS

Line 1: PACKAGE BODY PN_PAY_GROUP_BYS_PKG AS

1: PACKAGE BODY PN_PAY_GROUP_BYS_PKG AS
2: --$Header: PNGRPBYB.pls 115.3 2004/02/12 08:33:29 kkhegde noship $
3:
4: /*===========================================================================+
5: | PROCEDURE insert_row

Line 7: | inserts row into pn_pay_group_bys

3:
4: /*===========================================================================+
5: | PROCEDURE insert_row
6: | DESCRIPTION
7: | inserts row into pn_pay_group_bys
8: | SCOPE - PUBLIC
9: | MODIFICATION HISTORY
10: |
11: | 15-DEC-2003 Kiran o Created.

Line 42: FROM PN_PAY_GROUP_BYS

38: ,x_ATTRIBUTE15 IN VARCHAR2) IS
39:
40: CURSOR group_by IS
41: SELECT GROUP_BY_ID
42: FROM PN_PAY_GROUP_BYS
43: WHERE GROUP_BY_ID = x_GROUP_BY_ID;
44:
45: BEGIN
46:

Line 47: INSERT INTO PN_PAY_GROUP_BYS

43: WHERE GROUP_BY_ID = x_GROUP_BY_ID;
44:
45: BEGIN
46:
47: INSERT INTO PN_PAY_GROUP_BYS
48: (GROUP_BY_ID
49: ,GROUPING_RULE_ID
50: ,GROUP_BY_LOOKUP_CODE
51: ,LAST_UPDATE_DATE

Line 73: (NVL(x_GROUP_BY_ID, PN_PAY_GROUP_BYS_S.NEXTVAL)

69: ,ATTRIBUTE13
70: ,ATTRIBUTE14
71: ,ATTRIBUTE15)
72: VALUES
73: (NVL(x_GROUP_BY_ID, PN_PAY_GROUP_BYS_S.NEXTVAL)
74: ,x_GROUPING_RULE_ID
75: ,x_GROUP_BY_LOOKUP_CODE
76: ,x_LAST_UPDATE_DATE
77: ,x_LAST_UPDATED_BY

Line 119: | updates a row in pn_pay_group_bys

115:
116: /*===========================================================================+
117: | PROCEDURE update_row
118: | DESCRIPTION
119: | updates a row in pn_pay_group_bys
120: | SCOPE - PUBLIC
121: | MODIFICATION HISTORY
122: |
123: | 15-DEC-2003 Kiran o Created.

Line 151: UPDATE PN_PAY_GROUP_BYS SET

147: ,x_ATTRIBUTE15 IN VARCHAR2) IS
148:
149: BEGIN
150:
151: UPDATE PN_PAY_GROUP_BYS SET
152: GROUPING_RULE_ID = x_GROUPING_RULE_ID
153: ,GROUP_BY_LOOKUP_CODE = x_GROUP_BY_LOOKUP_CODE
154: ,LAST_UPDATE_DATE = x_LAST_UPDATE_DATE
155: ,LAST_UPDATED_BY = x_LAST_UPDATED_BY

Line 214: | locks a row in pn_pay_group_bys

210:
211: /*===========================================================================+
212: | PROCEDURE lock_row
213: | DESCRIPTION
214: | locks a row in pn_pay_group_bys
215: | SCOPE - PUBLIC
216: | MODIFICATION HISTORY
217: |
218: | 15-DEC-2003 Kiran o Created.

Line 243: FROM PN_PAY_GROUP_BYS

239: ,x_ATTRIBUTE15 IN VARCHAR2) IS
240:
241: CURSOR group_by IS
242: SELECT *
243: FROM PN_PAY_GROUP_BYS
244: WHERE GROUP_BY_ID = x_GROUP_BY_ID
245: FOR UPDATE OF GROUP_BY_ID NOWAIT;
246:
247: tlinfo group_by%ROWTYPE;

Line 363: | deletes a row from pn_pay_group_bys

359:
360: /*===========================================================================+
361: | PROCEDURE delete_row
362: | DESCRIPTION
363: | deletes a row from pn_pay_group_bys
364: | SCOPE - PUBLIC
365: | MODIFICATION HISTORY
366: |
367: | 15-DEC-2003 Kiran o Created.

Line 374: DELETE FROM PN_PAY_GROUP_BYS

370: x_GROUP_BY_ID IN NUMBER) IS
371:
372: BEGIN
373:
374: DELETE FROM PN_PAY_GROUP_BYS
375: WHERE GROUP_BY_ID = x_GROUP_BY_ID;
376:
377: IF (SQL%NOTFOUND) THEN
378: RAISE NO_DATA_FOUND;

Line 386: END PN_PAY_GROUP_BYS_PKG;

382: WHEN others THEN
383: RAISE;
384: END delete_row;
385:
386: END PN_PAY_GROUP_BYS_PKG;