APPS.PA_NEXT_ALLOW_STATUSES_PKG dependencies on PA_NEXT_ALLOW_STATUSES

Line 1: PACKAGE BODY PA_NEXT_ALLOW_STATUSES_PKG as

1: PACKAGE BODY PA_NEXT_ALLOW_STATUSES_PKG as
2: /* $Header: PASTANTB.pls 120.1 2005/06/30 12:33:09 appldev noship $ */
3: -- Start of Comments
4: -- Package name : PA_NEXT_ALLOW_STATUSES_PKG
5: -- Purpose : Table handler for PA_NEXT_ALLOW_STATUSES

Line 4: -- Package name : PA_NEXT_ALLOW_STATUSES_PKG

1: PACKAGE BODY PA_NEXT_ALLOW_STATUSES_PKG as
2: /* $Header: PASTANTB.pls 120.1 2005/06/30 12:33:09 appldev noship $ */
3: -- Start of Comments
4: -- Package name : PA_NEXT_ALLOW_STATUSES_PKG
5: -- Purpose : Table handler for PA_NEXT_ALLOW_STATUSES
6: -- History : 07-JUL-2000 Mohnish Created
7: -- NOTE : The procedure in these packages need to be
8: -- : called through the PA_NEXT_ALLOW_STATUSES_PVT

Line 5: -- Purpose : Table handler for PA_NEXT_ALLOW_STATUSES

1: PACKAGE BODY PA_NEXT_ALLOW_STATUSES_PKG as
2: /* $Header: PASTANTB.pls 120.1 2005/06/30 12:33:09 appldev noship $ */
3: -- Start of Comments
4: -- Package name : PA_NEXT_ALLOW_STATUSES_PKG
5: -- Purpose : Table handler for PA_NEXT_ALLOW_STATUSES
6: -- History : 07-JUL-2000 Mohnish Created
7: -- NOTE : The procedure in these packages need to be
8: -- : called through the PA_NEXT_ALLOW_STATUSES_PVT
9: -- : procedures only

Line 8: -- : called through the PA_NEXT_ALLOW_STATUSES_PVT

4: -- Package name : PA_NEXT_ALLOW_STATUSES_PKG
5: -- Purpose : Table handler for PA_NEXT_ALLOW_STATUSES
6: -- History : 07-JUL-2000 Mohnish Created
7: -- NOTE : The procedure in these packages need to be
8: -- : called through the PA_NEXT_ALLOW_STATUSES_PVT
9: -- : procedures only
10: -- End of Comments
11:
12:

Line 13: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PA_NEXT_ALLOW_STATUSES_PKG';

9: -- : procedures only
10: -- End of Comments
11:
12:
13: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PA_NEXT_ALLOW_STATUSES_PKG';
14: G_FILE_NAME CONSTANT VARCHAR2(12) := 'PASTATNB.pls';
15:
16: PROCEDURE Insert_Row(
17: p_STATUS_CODE VARCHAR2,

Line 42: INSERT INTO PA_NEXT_ALLOW_STATUSES(

38: p_ATTRIBUTE14 VARCHAR2,
39: p_ATTRIBUTE15 VARCHAR2)
40: IS
41: BEGIN
42: INSERT INTO PA_NEXT_ALLOW_STATUSES(
43: STATUS_CODE,
44: NEXT_ALLOWABLE_STATUS_CODE,
45: LAST_UPDATE_DATE,
46: LAST_UPDATED_BY,

Line 119: Update PA_NEXT_ALLOW_STATUSES

115: p_ATTRIBUTE14 VARCHAR2,
116: p_ATTRIBUTE15 VARCHAR2)
117: IS
118: BEGIN
119: Update PA_NEXT_ALLOW_STATUSES
120: SET
121: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
122: NEXT_ALLOWABLE_STATUS_CODE = decode( p_NEXT_ALLOWABLE_STATUS_CODE, FND_API.G_MISS_CHAR, NEXT_ALLOWABLE_STATUS_CODE, p_NEXT_ALLOWABLE_STATUS_CODE),
123: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 178: FROM PA_NEXT_ALLOW_STATUSES

174: p_ATTRIBUTE15 VARCHAR2)
175: IS
176: CURSOR C IS
177: SELECT *
178: FROM PA_NEXT_ALLOW_STATUSES
179: WHERE STATUS_CODE = p_STATUS_CODE
180: FOR UPDATE of STATUS_CODE NOWAIT;
181: Recinfo C%ROWTYPE;
182: BEGIN

Line 271: DELETE FROM PA_NEXT_ALLOW_STATUSES

267: PROCEDURE Delete_Row(
268: p_STATUS_CODE VARCHAR2)
269: IS
270: BEGIN
271: DELETE FROM PA_NEXT_ALLOW_STATUSES
272: WHERE STATUS_CODE = p_STATUS_CODE;
273: If (SQL%NOTFOUND) then
274: RAISE NO_DATA_FOUND;
275: End If;

Line 281: End PA_NEXT_ALLOW_STATUSES_PKG;

277: When NO_DATA_FOUND then
278: null;
279: END Delete_Row;
280:
281: End PA_NEXT_ALLOW_STATUSES_PKG;