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
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
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:
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
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:
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
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
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
260: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
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
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:
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
367: p_end_date IN date ,
368: p_assignment_status_code IN Varchar2 ,
369: p_asgn_start_date IN DATE ,
370: p_asgn_end_date IN DATE ,
371: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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
368: p_assignment_status_code IN Varchar2 ,
369: p_asgn_start_date IN DATE ,
370: p_asgn_end_date IN DATE ,
371: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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:
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