[Home] [Help]
PACKAGE: APPS.PA_PROJECT_SUBTEAM_PARTIES_PVT
Source
1 PACKAGE pa_project_subteam_parties_pvt AS
2 --$Header: PARTSPVS.pls 120.1 2005/08/19 17:01:49 mwasowic noship $
3
4 g_error_exists VARCHAR2(1) := FND_API.G_FALSE;
5
6 PROCEDURE Create_Subteam_Party
7 (
8 p_api_version IN NUMBER := 1.0,
9 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
10 p_commit IN VARCHAR2 := FND_API.g_false,
11
12 p_validate_only IN VARCHAR2 := FND_API.g_true,
13
14 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
15
16 p_calling_module IN VARCHAR2
17 := 'SELF_SERVICE',
18
19 p_debug_mode IN VARCHAR2 := 'N',
20
21 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
22
23 p_project_subteam_id IN pa_project_subteams.Project_subteam_id%TYPE := FND_API.g_miss_num,
24
25 p_object_type IN varchar2,
26
27 p_object_id IN NUMBER := fnd_api.g_miss_num,
28
29 p_primary_subteam_flag IN VARCHAR2 := 'Y',
30
31 x_project_subteam_party_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
32 x_project_subteam_party_id OUT NOCOPY pa_project_subteam_parties.project_subteam_party_id%TYPE, --File.Sql.39 bug 4440895
33 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
34 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
35 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
36 );
37
38
39 PROCEDURE Update_Subteam_Party
40 (
41 p_api_version IN NUMBER := 1.0,
42 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
43 p_commit IN VARCHAR2 := FND_API.g_false,
44
45 p_validate_only IN VARCHAR2 := FND_API.g_true,
46
47 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
48
49 p_calling_module IN VARCHAR2
50 := 'SELF_SERVICE',
51
52 p_debug_mode IN VARCHAR2 := 'N',
53
54 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
55
56 p_project_subteam_party_row_id IN ROWID := null,
57
58 p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := FND_API.g_miss_num,
59
60 p_project_subteam_id IN pa_project_subteam_parties.project_subteam_id%TYPE := FND_API.g_miss_num,
61
62 p_object_type IN varchar2,
63
64 p_object_id IN NUMBER := fnd_api.g_miss_num,
65
66 p_primary_subteam_flag IN VARCHAR2 := fnd_api.g_miss_char,
67
68 p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
69
70 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
71 x_record_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
72 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
73 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
74 );
75
76 PROCEDURE Update_SPT_Assgn
77 (
78 p_api_version IN NUMBER := 1.0,
79 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
80 p_commit IN VARCHAR2 := FND_API.g_false,
81
82 p_validate_only IN VARCHAR2 := FND_API.g_true,
83
84 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
85
86 p_calling_module IN VARCHAR2
87 := 'SELF_SERVICE',
88
89 p_debug_mode IN VARCHAR2 := 'N',
90
91 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
92
93 p_project_subteam_party_row_id IN ROWID := null,
94
95 p_project_subteam_party_id IN pa_project_subteam_parties.project_subteam_party_id%TYPE := NULL,
96
97 p_project_subteam_id IN pa_project_subteam_parties.project_subteam_id%TYPE := NULL,
98
99 p_object_type IN varchar2,
100
101 p_object_id IN NUMBER := fnd_api.g_miss_num,
102
103 p_primary_subteam_flag IN VARCHAR2 := fnd_api.g_miss_char,
104
105 p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
106
107 p_get_subteam_party_id_flag IN VARCHAR2 := 'N',
108
109 x_project_subteam_party_id OUT NOCOPY pa_project_subteam_parties.project_subteam_party_id%TYPE, --File.Sql.39 bug 4440895
110 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
111 x_record_version_number OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
112 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
113 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
114 );
115
116 PROCEDURE Delete_Subteam_Party
117 (
118 p_api_version IN NUMBER := 1.0,
119 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
120 p_commit IN VARCHAR2 := FND_API.g_false,
121
122 p_validate_only IN VARCHAR2 := FND_API.g_true,
123
124 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
125
126 p_calling_module IN VARCHAR2
127 := 'SELF_SERVICE',
128
129 p_debug_mode IN VARCHAR2 := 'N',
130
131 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
132
133 p_project_subteam_party_row_id IN ROWID := NULL,
134
135 p_project_subteam_party_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,
136
137 p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
138
139 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
140 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
141 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
142 );
143
144 PROCEDURE Delete_SubteamParty_By_Obj
145 (
146 p_api_version IN NUMBER := 1.0,
147 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
148 p_commit IN VARCHAR2 := FND_API.g_false,
149
150 p_validate_only IN VARCHAR2 := FND_API.g_true,
151
152 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
153
154 p_calling_module IN VARCHAR2
155 := NULL,
156
157 p_debug_mode IN VARCHAR2 := 'N',
158
159 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
160
161 p_object_type IN varchar2,
162
163 p_object_id IN NUMBER := fnd_api.g_miss_num,
164
165 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
166 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
167 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
168
169 );
170
171 --
172 END PA_PROJECT_SUBTEAM_PARTIES_PVT;