DBA Data[Home] [Help]

PACKAGE: APPS.PON_PROJECTS_INTEGRATION_GRP

Source


1 PACKAGE  PON_PROJECTS_INTEGRATION_GRP AS
2 --$Header: PONGPRJS.pls 120.0 2005/11/08 14:49:42 smhanda noship $
3 
4 
5 -- Start of comments
6 --      API name  : CHECK_DELETE_PROJECT_OK
7 --
8 --      Type      : Group
9 --
10 --
11 --      Function  : Checks if the passed in project id is refrenced in any
12 --                  auction header, line or payment.This API is called by
13 --                  Oracle Projects before deleting any project in Oracle Projects
14 --
15 --     Parameters:
16 --     IN   :      p_api_version       NUMBER   Required
17 --     IN   :      p_init_msg_list     VARCHAR2   DEFAULT   FND_API.G_TRUE Optional
18 --     IN   :      p_project_id        NUMBER Required, project id which needs to be checked
19 --
20 --     OUT  :      x_return_status          VARCHAR2, flag to indicate if the copy procedure
21 --                                                       was successful or not; It can have
22 --                                                      following values -
23 --                                                         FND_API.G_RET_STS_SUCCESS (Success)
24 --                                                         FND_API.G_RET_STS_ERROR  (Success with warning)
25 --                                                         FND_API.G_RET_STS_UNEXP_ERROR (Failed due to error)
26 --
27 --     OUT  :      x_msg_count              NUMBER,   the number of warning of error messages due
28 --                                                       to this procedure call. It will have following
29 --                                                       values  -
30 --                                                       0 (for Success without warning)
31 --                                                       1 (for failure with error, check the
32 --                                                       x_return_status if it is error or waring)
33 --                                                       1 or more (for Success with warning, check the x_return_status)
34 --
35 --     OUT  :      x_msg_data               VARCHAR2,  the standard message data output parameter
36 --                                                       used to return the first message of the stack
37 --
38 --    Version    : Current version    1.0
39 --                 Previous version   1.0
40 --                 Initial version    1.0
41 --
42 -- End of comments
43 PROCEDURE CHECK_DELETE_PROJECT_OK(
44                     p_api_version                 IN          NUMBER,
45                     p_init_msg_list               IN          VARCHAR2,
46                     p_project_id                  IN         NUMBER,
47                     x_return_status               OUT NOCOPY  VARCHAR2,
48                     x_msg_count                   OUT NOCOPY  NUMBER,
49                     x_msg_data                    OUT NOCOPY  VARCHAR2
50                     );
51 
52 
53 END PON_PROJECTS_INTEGRATION_GRP;