DBA Data[Home] [Help]

PACKAGE: APPS.PA_STATUSES_PVT

Source


1 PACKAGE PA_STATUSES_PVT as
2 /* $Header: PARSTAVS.pls 120.1 2005/08/19 17:00:47 mwasowic noship $ */
3 -- Start of Comments
4 -- Package name     : PA_STATUSES_PVT
5 -- Purpose          : Private 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 
14 ROW_ALREADY_LOCKED  EXCEPTION;
15 G_API_VERSION_NUMBER    CONSTANT NUMBER := 1.0;
16 
17 
18 PROCEDURE delete_status_pvt
19 ( p_api_version_number      IN NUMBER   := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20  ,p_init_msg_list           IN VARCHAR2 := FND_API.G_FALSE
21  ,p_commit                  IN VARCHAR2 := FND_API.G_FALSE
22  ,p_validate_only           IN VARCHAR2 := FND_API.G_FALSE
23  ,p_max_msg_count           IN NUMBER
24  ,p_pa_project_status_code  IN VARCHAR2
25  ,x_return_status          OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26  ,x_msg_count              OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
27  ,x_msg_data               OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
28  ,x_allow_deletion_flag    OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
29 );
30 
31 end PA_STATUSES_PVT;