PACKAGE: APPS.PA_STATUSES_PUB

Source

1 PACKAGE PA_STATUSES_PUB AUTHID CURRENT_USER 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;