1 PACKAGE PA_SCHEDULE_PUB as
2 /* $Header: PARGPUBS.pls 120.3.12010000.3 2008/11/28 08:32:20 rthumma ship $ */
3
4 --EmptyNumTbl PA_SCHEDULE_GLOB.NumTblType;
5 --EmptyNumTbl(1) : = NULL;
6
7 -- Unilog Enhancement BEGIN
8
9 TYPE WORK_PATTERN_REC_TYPE
10 IS RECORD (
11 l_PROJECT_ID PA_WORK_PATTERN_TEMP_TABLE.project_id%TYPE ,
12 l_PROJECT_NAME PA_WORK_PATTERN_TEMP_TABLE.project_name%TYPE ,
13 l_ASSIGNMENT_NAME PA_WORK_PATTERN_TEMP_TABLE.assignment_name%TYPE ,
14 l_START_DATE PA_WORK_PATTERN_TEMP_TABLE.start_date%TYPE ,
15 l_END_DATE PA_WORK_PATTERN_TEMP_TABLE.end_date%TYPE ,
16 l_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.status_name%TYPE ,
17 l_ASSIGNMENT_ID PA_WORK_PATTERN_TEMP_TABLE.assignment_id%TYPE ,
18 l_RESOURCE_ID PA_WORK_PATTERN_TEMP_TABLE.resource_id%TYPE ,
19 l_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.status_code%TYPE ,
20 l_RECORD_VERSION_NUMBER PA_WORK_PATTERN_TEMP_TABLE.record_version_number%TYPE ,
21 l_ASSIGNMENT_TYPE PA_WORK_PATTERN_TEMP_TABLE.assignment_type%TYPE ,
22 l_CALENDAR_ID PA_WORK_PATTERN_TEMP_TABLE.calendar_id%TYPE ,
23 l_CALENDAR_TYPE PA_WORK_PATTERN_TEMP_TABLE.calendar_type%TYPE ,
24 l_PROJECT_ROLE_NAME PA_WORK_PATTERN_TEMP_TABLE.project_role_name%TYPE ,
25 l_APPRVL_STATUS_NAME PA_WORK_PATTERN_TEMP_TABLE.apprvl_status_name%TYPE ,
26 l_ASSIGNMENT_EFFORT PA_WORK_PATTERN_TEMP_TABLE.assignment_effort%TYPE ,
27 l_ASSIGNMENT_DURATION PA_WORK_PATTERN_TEMP_TABLE.assignment_duration%TYPE ,
28 l_PROJECT_SYSTEM_STATUS_CODE PA_WORK_PATTERN_TEMP_TABLE.PROJECT_SYSTEM_STATUS_CODE%TYPE ,
29 l_QTY1 PA_WORK_PATTERN_TEMP_TABLE.QTY1%TYPE ,
30 l_QTY2 PA_WORK_PATTERN_TEMP_TABLE.QTY2%TYPE ,
31 l_QTY3 PA_WORK_PATTERN_TEMP_TABLE.QTY3%TYPE ,
32 l_QTY4 PA_WORK_PATTERN_TEMP_TABLE.QTY4%TYPE ,
33 l_QTY5 PA_WORK_PATTERN_TEMP_TABLE.QTY5%TYPE ,
34 l_QTY6 PA_WORK_PATTERN_TEMP_TABLE.QTY6%TYPE ,
35 l_QTY7 PA_WORK_PATTERN_TEMP_TABLE.QTY7%TYPE ,
36 l_QTY8 PA_WORK_PATTERN_TEMP_TABLE.QTY8%TYPE ,
37 l_QTY9 PA_WORK_PATTERN_TEMP_TABLE.QTY9%TYPE ,
38 l_QTY10 PA_WORK_PATTERN_TEMP_TABLE.QTY10%TYPE ,
39 l_QTY11 PA_WORK_PATTERN_TEMP_TABLE.QTY11%TYPE ,
40 l_QTY12 PA_WORK_PATTERN_TEMP_TABLE.QTY12%TYPE ,
41 l_QTY13 PA_WORK_PATTERN_TEMP_TABLE.QTY13%TYPE ,
42 l_QTY14 PA_WORK_PATTERN_TEMP_TABLE.QTY14%TYPE ,
43 l_DAY1 PA_WORK_PATTERN_TEMP_TABLE.day1%TYPE ,
44 l_DAY2 PA_WORK_PATTERN_TEMP_TABLE.day2%TYPE ,
45 l_DAY3 PA_WORK_PATTERN_TEMP_TABLE.day3%TYPE ,
46 l_DAY4 PA_WORK_PATTERN_TEMP_TABLE.day4%TYPE ,
47 l_DAY5 PA_WORK_PATTERN_TEMP_TABLE.day5%TYPE ,
48 l_DAY6 PA_WORK_PATTERN_TEMP_TABLE.day6%TYPE ,
49 l_DAY7 PA_WORK_PATTERN_TEMP_TABLE.day7%TYPE ,
50 l_DAY8 PA_WORK_PATTERN_TEMP_TABLE.day8%TYPE ,
51 l_DAY9 PA_WORK_PATTERN_TEMP_TABLE.day9%TYPE ,
52 l_DAY10 PA_WORK_PATTERN_TEMP_TABLE.day10%TYPE ,
53 l_DAY11 PA_WORK_PATTERN_TEMP_TABLE.day11%TYPE ,
54 l_DAY12 PA_WORK_PATTERN_TEMP_TABLE.day12%TYPE ,
55 l_DAY13 PA_WORK_PATTERN_TEMP_TABLE.day13%TYPE ,
56 l_DAY14 PA_WORK_PATTERN_TEMP_TABLE.day14%TYPE ,
57 l_row_type_code PA_WORK_PATTERN_TEMP_TABLE.row_type_code%TYPE ,
58 l_read_only_flag PA_WORK_PATTERN_TEMP_TABLE.read_only_flag%TYPE
59 );
60
61 TYPE WORK_PATTERN_TAB_TYPE IS TABLE OF WORK_PATTERN_REC_TYPE
62 INDEX BY BINARY_INTEGER;
63
64 -- Procedure : change_work_pattern_duration
65 -- Purpose : This procedure is called from self service for changing duration and work pattern.
66 -- : It uses existing change_work_pattern and change_duration procedures to do the job.
67 -- : While calling change_duartion and change_work_pattern, it passes newly introduced
68 -- : parameter p_generate_timeline_flag as N, so that they do not call timeline API.
69 -- : Typically this API will get called for a set of assignments of a resource
70 -- : (in a loop or from VORowImpl). So it takes two parameters p_prev_call_timeline_st_date
71 -- : and p_prev_call_timeline_end_date. For first assignment in the loop it will be null.
72 -- : So x_call_timeline_st_date and x_call_timeline_end_date will have the required date ranges
73 -- : for which timeline has to be regenerated. For the second assignment p_prev_call_timeline_st_date
74 -- : and p_prev_call_timeline_end_date will have the first assighnmenmt's x_call_timeline_st_date
75 -- : and x_call_timeline_end_date correspondingly. Then it will again calculate the timeline start date
76 -- : and timeline end date for the second assignment. Then it will compare it with
77 -- : p_prev_call_timeline_st_date and p_prev_call_timeline_end_date and will take
78 -- : min(new timeline start date, p_prev_call_timeline_st_date) and
79 -- : max(new timeline end date, p_prev_call_timeline_end_date). Similarly for other assignments....
80 -- : After this API is called for a set of assignments, you need to call PA_FORECASTITEM_PVT.Create_Forecast_Item
81 -- : with person_id as paremetrer and with the returned dates x_call_timeline_st_date
82 -- : and x_call_timeline_end_date
83 -- Parameters :
84 -- Note : Note that the p_hours_table should have hours quantity starting at p_start_date and
85 -- : ending at p_end_date.
86
87
88 PROCEDURE change_work_pattern_duration(
89 p_record_version_number IN NUMBER ,
90 p_project_id IN NUMBER ,
91 p_calendar_id IN NUMBER ,
92 p_assignment_id IN NUMBER ,
93 p_resource_id IN NUMBER ,
94 p_assignment_type IN VARCHAR2 ,
95 p_asgn_start_date IN DATE := NULL ,
96 p_asgn_end_date IN DATE := NULL ,
97 p_start_date IN DATE := NULL ,
98 -- p_end_date IN DATE := NULL ,
99 p_assignment_status_code IN VARCHAR2 := NULL ,
100 p_hours_table IN SYSTEM.PA_NUM_TBL_TYPE ,
101 p_prev_call_timeline_st_date IN DATE ,
102 p_prev_call_timeline_end_date IN DATE ,
103 x_call_timeline_st_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
104 x_call_timeline_end_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
105 -- x_person_id OUT NUMBER ,
106 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
107 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
108 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
109
110
111
112 -- Procedure : populate_work_pattern_table
113 -- Purpose : This procedure is called from self service for populating the global temp table
114 -- : pa_work_pattern_temp_table for the given assignment start date and assignment
115 -- : end date. The data will be populated for 14 days starting with Global week start day
116 -- : <= p_display_start_date. p_status_code is optional, if it is not given then it will
117 -- : fetch all the assignments irrespective of the assignment schedule status.
118 -- : Finally it returns the actual start date depending on the global week start date
119 -- Parameters :
120 --
121
122 PROCEDURE populate_work_pattern_table(
123 p_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
124 p_assgn_range_start_date IN DATE := NULL ,
125 p_assgn_range_end_date IN DATE := NULL ,
126 p_display_start_date IN DATE ,
127 p_status_code IN VARCHAR2 := NULL ,
128 p_delete_flag IN VARCHAR2 := 'Y' ,
129 x_show_start_date OUT NOCOPY DATE , --File.Sql.39 bug 4440895
130 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
131 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
132 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
133
134 -- Unilog Enhancement : END
135
136 -- procedure : update_schedule
137 -- Purpose : This procedure will change the schedule records of the assignments passed in.
138 -- It can accept either one assignment ID or an assignment ID array.
139 --
140 PROCEDURE update_schedule
141 ( p_project_id IN NUMBER
142 ,p_mass_update_flag IN VARCHAR2 := FND_API.G_FALSE
143 ,p_exception_type_code IN VARCHAR2
144 ,p_record_version_number IN NUMBER := NULL
145 ,p_assignment_id IN NUMBER := NULL
146 ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE := NULL
147 ,p_change_start_date IN DATE := NULL
148 ,p_change_end_date IN DATE := NULL
149 ,p_requirement_status_code IN VARCHAR2 := NULL
150 ,p_assignment_status_code IN VARCHAR2 := NULL
151 ,p_monday_hours IN NUMBER := NULL
152 ,p_tuesday_hours IN NUMBER := NULL
153 ,p_wednesday_hours IN NUMBER := NULL
154 ,p_thursday_hours IN NUMBER := NULL
155 ,p_friday_hours IN NUMBER := NULL
156 ,p_saturday_hours IN NUMBER := NULL
157 ,p_sunday_hours IN NUMBER := NULL
158 ,p_non_working_day_flag IN VARCHAR2 := 'N'
159 ,p_change_hours_type_code IN VARCHAR2 := NULL
160 ,p_hrs_per_day IN NUMBER := NULL
161 ,p_calendar_percent IN NUMBER := NULL
162 ,p_change_calendar_type_code IN VARCHAR2 := NULL
163 ,p_change_calendar_name IN VARCHAR2 := NULL
164 ,p_change_calendar_id IN NUMBER := NULL
165 ,p_duration_shift_type_code IN VARCHAR2 := NULL
166 ,p_duration_shift_unit_code IN VARCHAR2 := NULL
167 ,p_number_of_shift IN NUMBER := NULL
168 ,p_last_row_flag IN VARCHAR2 := 'Y'
169 ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
170 ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
171 ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
172 ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
173 ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
174 ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
175 ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
176 ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
177 ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
178 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
179 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
180 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
181 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
182 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
183
184
185
186 -- procedure : single_update_schedule
187 -- Purpose : This procedure will change the schedule records of a single assignment.
188 --
189 PROCEDURE single_update_schedule
190 ( p_project_id IN NUMBER
191 ,p_exception_type_code IN VARCHAR2
192 ,p_record_version_number IN NUMBER := NULL
193 ,p_assignment_id IN NUMBER := NULL
194 ,p_change_start_date IN DATE := NULL
195 ,p_change_end_date IN DATE := NULL
196 ,p_assignment_status_code IN VARCHAR2 := NULL
197 ,p_monday_hours IN NUMBER := NULL
198 ,p_tuesday_hours IN NUMBER := NULL
199 ,p_wednesday_hours IN NUMBER := NULL
200 ,p_thursday_hours IN NUMBER := NULL
201 ,p_friday_hours IN NUMBER := NULL
202 ,p_saturday_hours IN NUMBER := NULL
203 ,p_sunday_hours IN NUMBER := NULL
204 ,p_non_working_day_flag IN VARCHAR2 := 'N'
205 ,p_change_hours_type_code IN VARCHAR2 := NULL
206 ,p_hrs_per_day IN NUMBER := NULL
207 ,p_calendar_percent IN NUMBER := NULL
208 ,p_change_calendar_type_code IN VARCHAR2 := NULL
209 --,p_change_calendar_name IN VARCHAR2 := NULL
210 ,p_change_calendar_id IN NUMBER := NULL
211 ,p_duration_shift_type_code IN VARCHAR2 := NULL
212 ,p_duration_shift_unit_code IN VARCHAR2 := NULL
213 ,p_number_of_shift IN NUMBER := NULL
214 ,p_last_row_flag IN VARCHAR2 := 'Y'
215 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
216 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
217 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
218 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
219 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
220
221
222
223 -- procedure : mass_update_schedule
224 -- Purpose : This procedure will change the schedule records of the assignments passed in.
225 -- Currently, this procedure will only be called by the Mass Transaction Workflow API.
226 --
227 PROCEDURE mass_update_schedule
228 ( p_project_id IN NUMBER
229 ,p_exception_type_code IN VARCHAR2
230 ,p_assignment_id_array IN SYSTEM.PA_NUM_TBL_TYPE
231 ,p_change_start_date IN DATE := NULL
232 ,p_change_end_date IN DATE := NULL
233 ,p_change_rqmt_status_code IN VARCHAR2 := NULL
234 ,p_change_asgmt_status_code IN VARCHAR2 := NULL
235 ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
236 ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
237 ,p_monday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
238 ,p_tuesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
239 ,p_wednesday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
240 ,p_thursday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
241 ,p_friday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
242 ,p_saturday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
243 ,p_sunday_hours_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
244 ,p_non_working_day_flag IN VARCHAR2 := 'N'
245 ,p_change_hours_type_code IN VARCHAR2 := NULL
246 ,p_hrs_per_day IN NUMBER := NULL
247 ,p_calendar_percent IN NUMBER := NULL
248 ,p_change_calendar_type_code IN VARCHAR2 := NULL
249 ,p_change_calendar_name IN VARCHAR2 := NULL
250 ,p_change_calendar_id IN NUMBER := NULL
251 ,p_duration_shift_type_code IN VARCHAR2 := NULL
252 ,p_duration_shift_unit_code IN VARCHAR2 := NULL
253 ,p_number_of_shift IN NUMBER := NULL
254 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
255 ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
256 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
257 ,x_success_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Added NOCOPY for bug#2674619 */
258 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
259 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
263 --
260 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
261
262
264 -- Procedure : change_duration
265 -- Purpose : Insert record into PA_SCHEDULE_EXCEPTIONS table.
266 -- Parameters :
267 --
268 PROCEDURE change_duration
269 (
270 p_record_version_number IN Number ,
271 p_exception_type_code IN Varchar2 ,
272 p_project_id IN Number ,
273 p_calendar_id IN Number ,
274 p_assignment_id IN Number ,
275 p_assignment_type IN Varchar2 ,
276 p_start_date IN date := NULL,
277 p_end_date IN date := NULL,
278 p_assignment_status_code IN varchar2 := NULL,
279 p_asgn_start_date IN DATE := NULL,
280 p_asgn_end_date IN DATE := NULL,
281 p_duration_shift_type_code IN Varchar2 := NULL,
282 p_duration_shift_unit_code IN VARCHAR2 := NULL,
283 p_number_of_shift IN Varchar2 := NULL,
284 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
285 p_generate_timeline_flag IN VARCHAR2 := 'Y', --Unilog
286 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
287 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
288 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
289
290
291 --
292 -- Procedure : change_hours
293 -- Purpose : Insert records into PA_SCHEDULE_EXCEPTIONS table.
294 -- Parameters :
295 --
296 PROCEDURE change_hours
297 (
298 p_record_version_number IN Number ,
299 p_project_id IN Number ,
300 p_calendar_id IN Number ,
301 p_assignment_id IN Number ,
302 p_assignment_type IN Varchar2 ,
303 p_start_date IN date ,
304 p_end_date IN date ,
305 p_non_working_day_flag IN varchar2 := 'N' , /* bug#2463257 */
306 p_assignment_status_code IN Varchar2 ,
307 p_change_hours_type_code IN varchar2 ,
308 p_hrs_per_day IN Number ,
309 p_calendar_percent IN Number ,
310 p_change_calendar_type_code IN VARCHAR2 ,
311 -- p_change_calendar_name IN VARCHAR2 ,
312 p_change_calendar_id IN VARCHAR2 ,
313 p_asgn_start_date IN DATE ,
314 p_asgn_end_date IN DATE ,
315 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
316 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
317 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
318 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
319
320
321 --
322 -- Procedure : change_work_pattern
323 -- Purpose : Insert records into PA_SCHEDULE_EXCEPTIONS table.
324 -- Parameters :
325 --
326 PROCEDURE change_work_pattern
327 (
328 p_record_version_number IN Number ,
329 p_project_id IN Number ,
330 p_calendar_id IN Number ,
331 p_assignment_id IN Number ,
332 p_assignment_type IN Varchar2 ,
333 p_start_date IN date ,
334 p_end_date IN date ,
335 p_monday_hours IN Number := NULL,
336 p_tuesday_hours IN Number := NULL,
337 p_wednesday_hours IN Number := NULL,
338 p_thursday_hours IN Number := NULL,
339 p_friday_hours IN Number := NULL,
340 p_saturday_hours IN Number := NULL,
341 p_sunday_hours IN Number := NULL,
342 p_asgn_start_date IN DATE ,
343 p_asgn_end_date IN DATE ,
344 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
345 p_remove_conflict_flag IN VARCHAR2 := 'N',
346 p_last_row_flag IN VARCHAR2 := 'Y',
347 p_generate_timeline_flag IN VARCHAR2 := 'Y', --Unilog
348 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
349 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
350 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
351
352
353 --
354 -- Procedure : change_status
355 -- Purpose : Insert records into PA_SCHEDULE_EXCEPTIONS table.
356 -- Parameters :
357 --
358 PROCEDURE change_status
359 (
360 p_record_version_number IN Number ,
361 p_project_id IN Number ,
362 p_calendar_id IN Number ,
363 p_assignment_id IN Number ,
364 p_assignment_type IN Varchar2 ,
365 p_status_type IN Varchar2 ,
366 p_start_date IN date ,
367 p_end_date IN date ,
371 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
368 p_assignment_status_code IN Varchar2 ,
369 p_asgn_start_date IN DATE ,
370 p_asgn_end_date IN DATE ,
372 p_save_to_hist IN VARCHAR2 := FND_API.G_TRUE,
373 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
374 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
375 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
376
377 --
378 -- Procedure : change_calendar
379 -- Purpose : Insert records into PA_SCHEDULE_EXCEPTIONS table.
380 -- Parameters :
381 --
382 PROCEDURE change_calendar
383 (
384 p_record_version_number IN Number ,
385 p_project_id IN Number ,
386 p_calendar_id IN Number ,
387 p_calendar_name IN Varchar2 ,
388 p_assignment_id IN Number ,
389 p_assignment_type IN Varchar2 ,
390 p_start_date IN date ,
391 p_end_date IN date ,
392 p_asgn_start_date IN DATE ,
393 p_asgn_end_date IN DATE ,
394 x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
395 x_msg_count OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
396 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
397
398
399 PROCEDURE change_schedule(x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
400 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
401 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
402 );
403
404 -- Procedure : change_schedule
405 -- Purpose : This procedure is called from periodic process to apply the
406 -- the exceptions on schedule.
407
408
409 PROCEDURE change_asgn_schedule(
410 p_record_version_number IN Number,
411 p_assignment_id IN NUMBER,
412 p_project_id IN NUMBER,
413 p_exception_id IN NUMBER,
414 p_save_to_hist IN VARCHAR2 := FND_API.G_TRUE,
415 p_remove_conflict_flag IN VARCHAR2 := 'N',
416 p_generate_timeline_flag IN VARCHAR2 := 'Y', --Unilog
417 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
418 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
419 x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
420 );
421
422 -- Procedure : change_asgn_schedule
423 -- Purpose : This procedure will be called from each schedule change page via
424 -- workflow. This procedure will apply the exceptions for the team role
425 -- on the team role schedules.
426 -- array processing. This overloaded function.
427
428
429 PROCEDURE create_calendar_schedule ( p_calendar_id IN NUMBER,
430 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
431 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
432 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
433
434 -- Procedure : create_calendar_schedule
435 -- Purpose : This procedure is called from periodic process for creating calendar schedule
436 -- in array processing.
437 -- Parameters :
438 --
439
440 PROCEDURE get_proj_calendar_default ( p_proj_organization IN NUMBER,
441 p_project_id IN NUMBER,
442 x_calendar_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
443 x_calendar_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
444 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
445 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
446 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
447
448 -- Procedure : get_proj_calendar_default
449 -- Purpose : This procedure gets the calendar on the basis of organization id or project id
450 -- Parameters :
451 --
452
453 PROCEDURE create_new_cal_schedules ( p_start_calendar_name IN VARCHAR2,
454 p_end_calendar_name IN VARCHAR2,
455 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
456 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
457 x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
458
459 -- Procedure : create_new_cal_schedules
460 -- Purpose : This procedure is called from periodic process for creating schedule for new calendars
461 -- in array processing.
462 -- Parameters :
463 --
464
465 END PA_SCHEDULE_PUB;