194: -- Purpose : Same Procedure as above bu invoked in bulk mode
195: --
196: PROCEDURE update_schedule_bulk
197: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
198: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
199: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
200: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
201: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
202: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
195: --
196: PROCEDURE update_schedule_bulk
197: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
198: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
199: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
200: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
201: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
202: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
203: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
201: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
202: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
203: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
204: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
205: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
206: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
207: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
208: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
209: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
202: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
203: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
204: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
205: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
206: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
207: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
208: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
209: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
210: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
203: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
204: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
205: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
206: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
207: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
208: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
209: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
210: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
211: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
204: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
205: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
206: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
207: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
208: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
209: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
210: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
211: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
212: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
205: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
206: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
207: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
208: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
209: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
210: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
211: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
212: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
213: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE );
206: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
207: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
208: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
209: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
210: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
211: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
212: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
213: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE );
214:
207: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
208: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
209: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
210: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
211: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
212: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
213: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE );
214:
215:
209: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
210: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
211: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
212: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
213: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE );
214:
215:
216:
217:
216:
217:
218: PROCEDURE update_new_schedule_bulk
219: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
220: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
221: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
222: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
223: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
224: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
217:
218: PROCEDURE update_new_schedule_bulk
219: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
220: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
221: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
222: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
223: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
224: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
225: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
223: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
224: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
225: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
226: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
227: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
228: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
229: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
230: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
231: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
224: -- ,p_assignment_id_array_tbl IN PA_NUM_TBL_TBL_TYPE --:= NULL
225: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
226: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
227: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
228: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
229: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
230: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
231: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
232: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
225: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
226: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
227: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
228: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
229: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
230: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
231: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
232: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
233: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
226: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
227: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
228: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
229: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
230: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
231: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
232: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
233: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
234: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
227: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
228: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
229: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
230: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
231: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
232: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
233: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
234: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
235: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
228: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
229: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
230: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
231: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
232: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
233: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
234: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
235: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
236: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
229: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
230: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
231: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
232: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
233: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
234: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
235: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
236: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
237: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
232: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
233: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
234: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
235: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
236: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
237: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
238: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
239:
240:
234: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
235: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
236: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
237: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
238: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
239:
240:
241: );
242: