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