[Home] [Help]
PACKAGE: APPS.PA_PROJECT_SUBTEAMS_PVT
Source
1 PACKAGE pa_project_subteams_pvt AUTHID CURRENT_USER AS
2 --$Header: PARTSTVS.pls 120.1 2005/08/19 17:02:13 mwasowic noship $
3
4 PROCEDURE Create_Subteam
5 (
6 p_api_version IN NUMBER := 1.0,
7 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
8 p_commit IN VARCHAR2 := FND_API.g_false,
9
10 p_validate_only IN VARCHAR2 := FND_API.g_true,
11
12 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
13
14 p_calling_module IN VARCHAR2
15 := 'SELF_SERVICE',
16
17 p_debug_mode IN VARCHAR2 := 'N',
18
19 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
20
21 p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
22 p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
23
24 p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
25
26 p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
27
28 p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
29
30 p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
31
32 p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
33
34 p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
35
36 p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
37
38 p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
39
40
41 p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
42
43
44 p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
45
46
47 p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
48
49
50 p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
51
52
53 p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
54
55
56 p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
57
58
59 p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
60
61
62 p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
63
64
65 p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
66
67
68 p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
69
70
71 p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
72
73
74 x_subteam_row_id OUT NOCOPY ROWID, --File.Sql.39 bug 4440895
75 x_new_subteam_id OUT NOCOPY pa_project_subteams.project_subteam_id%TYPE, --File.Sql.39 bug 4440895
76 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
77 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
78 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
79 )
80 ;
81
82 PROCEDURE Update_Subteam
83 (
84 p_api_version IN NUMBER := 1.0,
85 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
86 p_commit IN VARCHAR2 := FND_API.g_false,
87
88 p_validate_only IN VARCHAR2 := FND_API.g_true,
89
90 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
91
92 p_calling_module IN VARCHAR2
93 := 'SELF_SERVICE',
94
95 p_debug_mode IN VARCHAR2 := 'N',
96
97 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
98
99 p_subteam_row_id IN ROWID := null,
100
101 p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.g_miss_num,
102
103 p_subteam_name IN pa_project_subteams.name%TYPE := FND_API.g_miss_char,
104 p_object_type IN pa_project_subteams.object_type%TYPE := FND_API.g_miss_char,
105
106 p_object_id IN pa_project_subteams.object_id%TYPE := FND_API.g_miss_num,
107
108 p_description IN pa_project_subteams.description%TYPE := FND_API.g_miss_char,
109
110 p_record_version_number IN pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
111
112 p_attribute_category IN pa_project_subteams.attribute_category%TYPE := FND_API.g_miss_char,
113
114 p_attribute1 IN pa_project_subteams.attribute1%TYPE := FND_API.G_MISS_CHAR,
115
116 p_attribute2 IN pa_project_subteams.attribute2%TYPE := FND_API.G_MISS_CHAR,
117
118 p_attribute3 IN pa_project_subteams.attribute3%TYPE := FND_API.G_MISS_CHAR,
119
120 p_attribute4 IN pa_project_subteams.attribute4%TYPE := FND_API.G_MISS_CHAR,
121
122
123 p_attribute5 IN pa_project_subteams.attribute5%TYPE := FND_API.G_MISS_CHAR,
124
125
126 p_attribute6 IN pa_project_subteams.attribute6%TYPE := FND_API.G_MISS_CHAR,
127
128
129 p_attribute7 IN pa_project_subteams.attribute7%TYPE := FND_API.G_MISS_CHAR,
130
131
132 p_attribute8 IN pa_project_subteams.attribute8%TYPE := FND_API.G_MISS_CHAR,
133
134
135 p_attribute9 IN pa_project_subteams.attribute9%TYPE := FND_API.G_MISS_CHAR,
136
137
138 p_attribute10 IN pa_project_subteams.attribute10%TYPE := FND_API.G_MISS_CHAR,
139
140
141 p_attribute11 IN pa_project_subteams.attribute11%TYPE := FND_API.G_MISS_CHAR,
142
143
144 p_attribute12 IN pa_project_subteams.attribute12%TYPE := FND_API.G_MISS_CHAR,
145
146
147 p_attribute13 IN pa_project_subteams.attribute13%TYPE := FND_API.G_MISS_CHAR,
148
149
150 p_attribute14 IN pa_project_subteams.attribute14%TYPE := FND_API.G_MISS_CHAR,
151
152
153 p_attribute15 IN pa_project_subteams.attribute15%TYPE := FND_API.G_MISS_CHAR,
154 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
155 -- x_record_version_number OUT NUMBER ,
156 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
157 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
158 );
159
160
161
162 PROCEDURE Delete_Subteam
163 (
164 p_api_version IN NUMBER := 1.0,
165 p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
166 p_commit IN VARCHAR2 := FND_API.g_false,
167
168 p_validate_only IN VARCHAR2 := FND_API.g_true,
169
170 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
171
172 p_calling_module IN VARCHAR2
173 := 'SELF_SERVICE',
174
175 p_debug_mode IN VARCHAR2 := 'N',
176
177 p_max_msg_count IN NUMBER := FND_API.g_miss_num,
178
179 p_subteam_row_id IN ROWID := NULL,
180
181 p_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,
182
183 p_record_version_number IN NUMBER := FND_API.G_MISS_NUM,
184
185 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
186 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
187 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
188
189 ) ;
190
191 PROCEDURE Get_Subteam_Id
192 (
193 p_subteam_name IN pa_project_subteams.name%TYPE := fnd_api.g_miss_char,
194 p_object_type IN pa_project_subteams.object_type%TYPE := fnd_api.g_miss_char,
195 p_object_id IN pa_project_subteams.object_id%TYPE := fnd_api.g_miss_num,
196 x_subteam_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
197 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
198 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
199 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
200
201 ) ;
202
203 END pa_project_subteams_pvt;