[Home] [Help]
PACKAGE: APPS.PA_STATUSES_PUB
Source
1 PACKAGE PA_STATUSES_PUB as
2 /* $Header: PARSTAPS.pls 120.1 2005/08/19 17:00:39 mwasowic noship $ */
3 -- Start of Comments
4 -- Package name : PA_STATUSES_PUB
5 -- Purpose : Public Package for table PA_PROJECT_STATUSES
6 -- History : 07-JUL-2000 Mohnish Created
7 -- NOTE :
8 -- : Subprogram Name Type
9 -- : ------------------ -----------------------
10 -- : delete_status PL/SQL procedure
11 -- End of Comments
12
13 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
14
15 --Locking exception
16 ROW_ALREADY_LOCKED EXCEPTION;
17 PRAGMA EXCEPTION_INIT(ROW_ALREADY_LOCKED, -54);
18
19
20 PROCEDURE delete_status
21 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
22 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
24 ,p_validate_only IN VARCHAR2 := FND_API.G_FALSE
25 ,p_max_msg_count IN NUMBER
26 ,p_pa_project_status_code IN VARCHAR2
27 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
28 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
29 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
30 ,x_allow_deletion_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
31 );
32
33 end PA_STATUSES_PUB;