PACKAGE: APPS.PA_PROJECT_SET_UTILS

Source

1 PACKAGE pa_project_set_utils AUTHID CURRENT_USER AS
2 /*$Header: PAPPSUTS.pls 120.1 2005/08/19 16:44:00 mwasowic noship $*/
3 --+
4 
5 TYPE project_set_lines_tbl_type IS TABLE OF pa_project_set_lines%ROWTYPE
6    INDEX BY BINARY_INTEGER;
7 
8 PROCEDURE getPartyIdName (p_user_id      IN NUMBER
9                          ,x_party_id    OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10                          ,x_party_name  OUT NOCOPY VARCHAR2  --File.Sql.39 bug 4440895
11 );
12 
13 
14 FUNCTION get_project_set_lines(p_project_set_id IN NUMBER)
15 RETURN project_set_lines_tbl_type;
16 
17 FUNCTION do_lines_exist(p_project_set_id  IN  NUMBER)
18 RETURN VARCHAR2;
19 
20 FUNCTION check_projects_in_set(p_project_set_id  IN NUMBER
21                               ,p_project_id      IN NUMBER)
22 RETURN VARCHAR2;
23 
24 FUNCTION check_security_on_set(p_party_id IN NUMBER,
25                                p_user_id NUMBER DEFAULT fnd_global.user_id,
26                                p_resp_id NUMBER DEFAULT fnd_global.resp_id)
27 RETURN VARCHAR2;
28 
29 
30 FUNCTION is_name_unique(p_project_set_name  IN  VARCHAR2
31                        ,p_project_set_id    IN  NUMBER := NULL)
32 RETURN VARCHAR2;
33 
34 FUNCTION get_proj_set_name (p_project_set_id    IN  NUMBER)
35 RETURN VARCHAR2;
36 
37 PROCEDURE add_projects_to_proj_set
38 ( p_project_set_id           IN  pa_project_sets_b.project_set_id%TYPE
39  ,p_project_id_tbl           IN  SYSTEM.pa_num_tbl_type
40  ,p_init_msg_list            IN  VARCHAR2  := FND_API.G_FALSE
41  ,p_commit                   IN  VARCHAR2  := FND_API.G_FALSE
42  ,p_validate_only            IN  VARCHAR2  := FND_API.G_TRUE
43  ,x_return_status           OUT  NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
44  ,x_msg_count               OUT  NOCOPY NUMBER --File.Sql.39 bug 4440895
45  ,x_msg_data                OUT  NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
46  ,x_project_list            OUT  NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
47  ,x_project_set_name        OUT  NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
48 );
49 
50 
51 PROCEDURE Check_PartyName_Or_Id(
52         p_party_id           IN     NUMBER,
53         p_party_name	       IN     VARCHAR2,
54         p_check_id_flag      IN     VARCHAR2,
55         x_party_id           OUT     NOCOPY NUMBER, --File.Sql.39 bug 4440895
56         x_return_status      OUT     NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
57         x_error_msg_code     OUT     NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
58 
59 
60 PROCEDURE Check_ProjectSetName_Or_Id(
61         p_project_set_id         IN     NUMBER
62        ,p_project_set_name	 IN     VARCHAR2
63        ,p_check_id_flag          IN     VARCHAR2   DEFAULT  'A'
64        ,x_project_set_id        OUT     NOCOPY NUMBER --File.Sql.39 bug 4440895
65        ,x_return_status         OUT     NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
66        ,x_error_msg_code        OUT     NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
67 
68 FUNCTION is_party_internal (p_party_id  IN NUMBER) RETURN VARCHAR2;
69 
70 END PA_PROJECT_SET_UTILS;