1 PACKAGE PA_PROJ_TEMPLATE_SETUP_PVT AS
2 /* $Header: PATMSTVS.pls 120.2 2005/08/19 17:04:30 mwasowic noship $ */
3
4 -- API name : Create_Project_Template
5 -- Type : Private API
6 -- Pre-reqs : None
7 -- Return Value :
8 --
9 -- Parameters
10 --p_project_number IN VARCHAR2
11 --p_project_name IN VARCHAR2
12 --p_project_type IN VARCHAR2
13 --p_organization_id IN NUMBER
14 --p_organization_name IN VARCHAR2
15 --p_effective_from_date IN DATE
16 --p_effective_to_date IN DATE
17 --p_description IN VARCHAR2
18 --
19 -- History
20 --
21 -- 15-FEB-02 Majid Ansari -Created
22 --
23 --
24
25 PROCEDURE Create_Project_Template(
26 p_api_version IN NUMBER :=1.0,
27 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
28 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
29 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
30 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
31 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
32 p_debug_mode IN VARCHAR2 :='N',
33 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
34 p_project_number IN VARCHAR2,
35 p_project_name IN VARCHAR2,
36 p_project_type IN VARCHAR2,
37 p_organization_id IN NUMBER := -9999,
38 p_effective_from_date IN DATE := TO_DATE( '01-01-1000', 'DD-MM-YYYY' ),
39 p_effective_to_date IN DATE := TO_DATE( '01-01-1000', 'DD-MM-YYYY' ),
40 p_description IN VARCHAR2 := 'JUNK_CHARS',
41 p_security_level IN NUMBER := 0,
42 -- anlee
43 -- Project Long Name changes
44 p_long_name IN VARCHAR2 DEFAULT NULL,
45 -- End of changes
46 p_operating_unit_id IN NUMBER, -- 4363092 MOAC changes
47 x_template_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
48 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
49 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
50 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
51 );
52
53 -- API name : Update_Project_Template
54 -- Type : Private API
55 -- Pre-reqs : None
56 -- Return Value :
57 --
58 -- Parameters
59 --p_project_number IN VARCHAR2
60 --p_project_name IN VARCHAR2
61 --p_project_type IN VARCHAR2
62 --p_organization_id IN NUMBER
63 --p_organization_name IN VARCHAR2
64 --p_effective_from_date IN DATE
65 --p_effective_to_date IN DATE
66 --p_description IN VARCHAR2
67 --
68 -- History
69 --
70 -- 15-FEB-02 Majid Ansari -Created
71 --
72 --
73
74 PROCEDURE Update_Project_Template(
75 p_api_version IN NUMBER :=1.0,
76 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
77 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
78 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
79 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
80 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
81 p_debug_mode IN VARCHAR2 :='N',
82 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
83 p_project_id IN NUMBER,
84 p_project_number IN VARCHAR2 := 'JUNK_CHARS',
85 p_project_name IN VARCHAR2 := 'JUNK_CHARS',
86 p_project_type IN VARCHAR2 := 'JUNK_CHARS',
87 p_organization_id IN NUMBER := -9999,
88 p_effective_from_date IN DATE := TO_DATE( '01-01-1000', 'DD-MM-YYYY' ),
89 p_effective_to_date IN DATE := TO_DATE( '01-01-1000', 'DD-MM-YYYY' ),
90 p_description IN VARCHAR2 := 'JUNK_CHARS',
91 p_security_level IN NUMBER := 0,
92 -- anlee
93 -- Project Long Name changes
94 p_long_name IN VARCHAR2 DEFAULT NULL,
95 -- End of changes
96 p_record_version_number IN NUMBER,
97 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
98 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
99 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
100 );
101
102 -- API name : Delete_Project_Template
103 -- Type : Private API
104 -- Pre-reqs : None
105 -- Return Value :
106 --
107 -- Parameters
108 -- p_project_id IN NUMBER,
109 --
110 -- History
111 --
112 -- 15-FEB-02 Majid Ansari -Created
113 --
114 --
115
116 PROCEDURE Delete_Project_Template(
117 p_api_version IN NUMBER :=1.0,
118 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
119 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
120 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
121 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
122 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
123 p_debug_mode IN VARCHAR2 :='N',
124 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
125 p_project_id IN NUMBER,
126 p_record_version_number IN NUMBER,
127 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
128 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
129 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
130 );
131
132
133 -- API name : Add_Project_Options
134 -- Type : Private API
135 -- Pre-reqs : None
136 -- Return Value :
137 --
138 -- Parameters
139 -- p_project_id IN NUMBER,
140 --
141 -- History
142 --
143 -- 15-FEB-02 Majid Ansari -Created
144 --
145 --
146
147 PROCEDURE Add_Project_Options(
148 p_api_version IN NUMBER :=1.0,
149 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
150 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
151 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
152 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
153 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
154 p_debug_mode IN VARCHAR2 :='N',
155 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
156 p_project_id IN NUMBER,
157 p_option_code IN VARCHAR2,
158 p_action IN VARCHAR2 := 'ENABLE',
159 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
160 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
161 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
162 );
163
164 -- API name : Delete_Project_Options
165 -- Type : Private API
166 -- Pre-reqs : None
167 -- Return Value :
168 --
169 -- Parameters
170 -- p_project_id IN NUMBER,
171 --
172 -- History
173 --
174 -- 15-FEB-02 Majid Ansari -Created
175 --
176 --
177
178 PROCEDURE Delete_Project_Options(
179 p_api_version IN NUMBER :=1.0,
180 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
181 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
182 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
183 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
184 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
185 p_debug_mode IN VARCHAR2 :='N',
186 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
187 p_project_id IN NUMBER,
188 p_option_code IN VARCHAR2,
189 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
190 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
191 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
192 );
193
194 -- API name : Add_Quick_Entry_Field
195 -- Type : Private API
196 -- Pre-reqs : None
197 -- Return Value :
198 --
199 -- Parameters
200 --p_project_id IN NUMBER No Not Null
201 --p_sort_order IN NUMBER No Not null
202 --p_field_name IN VARCHAR2 No Not null
203 --p_specification IN VARCHAR2 No FND_API.G_MISS_CHAR
204 --p_prompt IN VARCHAR2 No not null
205 --p_required_flag IN VARCHAR2 No not null 'N'
206 --
207 -- History
208 --
209 -- 15-FEB-02 Majid Ansari -Created
210 --
211 --
212
213 PROCEDURE Add_Quick_Entry_Field(
214 p_api_version IN NUMBER :=1.0,
215 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
216 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
217 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
218 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
219 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
220 p_debug_mode IN VARCHAR2 :='N',
221 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
222 p_project_id IN NUMBER ,
223 p_sort_order IN NUMBER ,
224 p_field_name IN VARCHAR2 := 'JUNK_CHARS',
225 p_limiting_value IN VARCHAR2 := 'JUNK_CHARS',
226 p_prompt IN VARCHAR2 ,
227 p_required_flag IN VARCHAR2 := 'N',
228 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
229 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
230 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
231 );
232
233
234 -- API name : Update_Quick_Entry_Field
235 -- Type : Private API
236 -- Pre-reqs : None
237 -- Return Value :
238 --
239 -- Parameters
240 --p_project_id IN NUMBER No Not Null
241 --p_sort_order IN NUMBER No FND_API.G_MISS_NUM
242 --p_field_name IN VARCHAR2 No FND_API.G_MISS_CHAR
243 --p_specification IN VARCHAR2 No FND_API.G_MISS_CHAR
244 --p_prompt IN VARCHAR2 No FND_API.G_MISS_CHAR
245 --p_required_flag IN VARCHAR2 No not null 'N'
246 --p_record_version_number IN NUMBER No not null
247 --
248 -- History
249 --
250 -- 15-FEB-02 Majid Ansari -Created
251 --
252 --
253
254 PROCEDURE Update_Quick_Entry_Field(
255 p_api_version IN NUMBER :=1.0,
256 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
257 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
258 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
259 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
260 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
261 p_debug_mode IN VARCHAR2 :='N',
262 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
263 p_project_id IN NUMBER,
264 p_row_id IN VARCHAR2,
265 p_sort_order IN NUMBER,
266 p_field_name IN VARCHAR2 := 'JUNK_CHARS',
267 p_limiting_value IN VARCHAR2 := 'JUNK_CHARS',
268 p_prompt IN VARCHAR2,
269 p_required_flag IN VARCHAR2 :='N', -- bug 2463257
270 p_record_version_number IN NUMBER,
271 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
272 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
273 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
274 );
275
276 -- API name : Delete_Quick_Entry_Field
277 -- Type : Private API
278 -- Pre-reqs : None
279 -- Return Value :
280 --
281 -- Parameters
282 --p_project_id IN NUMBER No Not Null
283 --p_field_name IN VARCHAR2 No FND_API.G_MISS_CHAR
284 --p_record_version_number IN NUMBER No not null
285 --
286 -- History
287 --
288 -- 15-FEB-02 Majid Ansari -Created
289 --
290 --
291
292 PROCEDURE Delete_Quick_Entry_Field(
293 p_api_version IN NUMBER :=1.0,
294 p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE,
295 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
296 p_validate_only IN VARCHAR2 :=FND_API.G_TRUE,
297 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
298 p_calling_module IN VARCHAR2 :='SELF_SERVICE',
299 p_debug_mode IN VARCHAR2 :='N',
300 p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
301 p_project_id IN NUMBER,
302 p_row_id IN VARCHAR2,
303 p_record_version_number IN NUMBER,
304 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
305 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
306 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
307 );
308
309 PROCEDURE enable_disbale_proj_opt(
310 p_project_id NUMBER,
311 p_option_code VARCHAR2,
312 p_action VARCHAR2
313 );
314
315 END PA_PROJ_TEMPLATE_SETUP_PVT;