APPS.PA_PROJECT_STATUSES_PKG dependencies on PA_PROJECT_STATUSES

Line 1: PACKAGE BODY PA_PROJECT_STATUSES_PKG as

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

Line 4: -- Package name : PA_PROJECT_STATUSES_PKG

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

Line 5: -- Purpose : Table handler for PA_PROJECT_STATUSES

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

Line 8: -- : called through the PA_PROJECT_STATUSES_PVT

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

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

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

Line 54: CURSOR C2 IS SELECT PA_PROJECT_STATUSES_S.nextval FROM sys.dual;

50: p_ATTRIBUTE15 VARCHAR2,
51: p_STATUS_TYPE VARCHAR2,
52: p_NEXT_ALLOWABLE_STATUS_FLAG VARCHAR2)
53: IS
54: CURSOR C2 IS SELECT PA_PROJECT_STATUSES_S.nextval FROM sys.dual;
55: v_project_status_code VARCHAR2(30);
56: BEGIN
57: If (v_project_status_code IS NULL) OR (v_project_status_code = FND_API.G_MISS_CHAR) then
58: OPEN C2;

Line 62: INSERT INTO PA_PROJECT_STATUSES(

58: OPEN C2;
59: FETCH C2 INTO v_project_status_code;
60: CLOSE C2;
61: End If;
62: INSERT INTO PA_PROJECT_STATUSES(
63: PROJECT_STATUS_CODE,
64: PROJECT_STATUS_NAME,
65: PROJECT_SYSTEM_STATUS_CODE,
66: DESCRIPTION,

Line 178: Update PA_PROJECT_STATUSES

174: p_STATUS_TYPE VARCHAR2,
175: p_NEXT_ALLOWABLE_STATUS_FLAG VARCHAR2)
176: IS
177: BEGIN
178: Update PA_PROJECT_STATUSES
179: SET
180: PROJECT_STATUS_NAME = decode( p_PROJECT_STATUS_NAME, FND_API.G_MISS_CHAR, PROJECT_STATUS_NAME, p_PROJECT_STATUS_NAME),
181: PROJECT_SYSTEM_STATUS_CODE = decode( p_PROJECT_SYSTEM_STATUS_CODE, FND_API.G_MISS_CHAR, PROJECT_SYSTEM_STATUS_CODE, p_PROJECT_SYSTEM_STATUS_CODE),
182: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),

Line 262: FROM PA_PROJECT_STATUSES

258: p_NEXT_ALLOWABLE_STATUS_FLAG VARCHAR2)
259: IS
260: CURSOR C IS
261: SELECT *
262: FROM PA_PROJECT_STATUSES
263: WHERE PROJECT_STATUS_CODE = p_PROJECT_STATUS_CODE
264: FOR UPDATE of PROJECT_STATUS_CODE NOWAIT;
265: Recinfo C%ROWTYPE;
266: BEGIN

Line 391: DELETE FROM PA_PROJECT_STATUSES

387: PROCEDURE Delete_Row(
388: p_PROJECT_STATUS_CODE VARCHAR2)
389: IS
390: BEGIN
391: DELETE FROM PA_PROJECT_STATUSES
392: WHERE PROJECT_STATUS_CODE = p_PROJECT_STATUS_CODE;
393: If (SQL%NOTFOUND) then
394: RAISE NO_DATA_FOUND;
395: End If;

Line 398: End PA_PROJECT_STATUSES_PKG;

394: RAISE NO_DATA_FOUND;
395: End If;
396: END Delete_Row;
397:
398: End PA_PROJECT_STATUSES_PKG;