407: /* Bug 7693634 Start */
408:
409: PROCEDURE update_schedule_bulk
410: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
411: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
412: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
413: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
414: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
415: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
408:
409: PROCEDURE update_schedule_bulk
410: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
411: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
412: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
413: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
414: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
415: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
416: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
413: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
414: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
415: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
416: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
417: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
418: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
419: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
420: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
421: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
414: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
415: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
416: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
417: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
418: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
419: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
420: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
421: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
422: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
415: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
416: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
417: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
418: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
419: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
420: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
421: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
422: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
423: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
416: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
417: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
418: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
419: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
420: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
421: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
422: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
423: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
424: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
417: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
418: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
419: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
420: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
421: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
422: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
423: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
424: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
425: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE ) --File.Sql.39 bug 4440895
418: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
419: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
420: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
421: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
422: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
423: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
424: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
425: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE ) --File.Sql.39 bug 4440895
426: IS
419: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
420: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
421: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
422: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
423: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
424: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
425: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE ) --File.Sql.39 bug 4440895
426: IS
427:
421: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
422: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
423: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
424: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
425: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE ) --File.Sql.39 bug 4440895
426: IS
427:
428: l_err_msg_code fnd_new_messages.message_name%TYPE;
429: l_updated_calendar_id NUMBER;
434: l_valid_assign_start_flag VARCHAR2(1) := 'Y'; -- Bug 6411422
435: l_profile_begin_date DATE; -- Bug 6411422
436:
437: /* 7693634 new variables */
438: l_mass_update_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
439: l_last_row_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
440: l_commit_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_commit_tbl;
441: l_validate_only_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
442:
435: l_profile_begin_date DATE; -- Bug 6411422
436:
437: /* 7693634 new variables */
438: l_mass_update_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
439: l_last_row_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
440: l_commit_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_commit_tbl;
441: l_validate_only_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
442:
443:
436:
437: /* 7693634 new variables */
438: l_mass_update_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
439: l_last_row_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
440: l_commit_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_commit_tbl;
441: l_validate_only_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
442:
443:
444: l_msg_count_tbl SYSTEM.PA_NUM_TBL_TYPE := p_project_id_tbl;
437: /* 7693634 new variables */
438: l_mass_update_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
439: l_last_row_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
440: l_commit_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_commit_tbl;
441: l_validate_only_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
442:
443:
444: l_msg_count_tbl SYSTEM.PA_NUM_TBL_TYPE := p_project_id_tbl;
445: l_return_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
441: l_validate_only_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
442:
443:
444: l_msg_count_tbl SYSTEM.PA_NUM_TBL_TYPE := p_project_id_tbl;
445: l_return_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
446: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
447: --Bug#9817752 start
448: l_assignment_type pa_project_assignments.assignment_type%TYPE :=NULL ;
449: l_assignment_status_code VARCHAR2(50) := NULL;
442:
443:
444: l_msg_count_tbl SYSTEM.PA_NUM_TBL_TYPE := p_project_id_tbl;
445: l_return_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
446: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
447: --Bug#9817752 start
448: l_assignment_type pa_project_assignments.assignment_type%TYPE :=NULL ;
449: l_assignment_status_code VARCHAR2(50) := NULL;
450: --Bug#9817752 end
633:
634:
635: PROCEDURE update_new_schedule_bulk
636: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
637: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
638: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
639: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
640: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
641: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
634:
635: PROCEDURE update_new_schedule_bulk
636: ( p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
637: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
638: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
639: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
640: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
641: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
642: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
639: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
640: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
641: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
642: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
643: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
644: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
645: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
646: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
647: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
640: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
641: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
642: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
643: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
644: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
645: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
646: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
647: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
648: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
641: ,p_change_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
642: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
643: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
644: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
645: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
646: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
647: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
648: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
649: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
642: ,p_change_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
643: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
644: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
645: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
646: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
647: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
648: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
649: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
650: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
643: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
644: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
645: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
646: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
647: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
648: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
649: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
650: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
651: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
644: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
645: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
646: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
647: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
648: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
649: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
650: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
651: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
652: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
645: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'
646: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE
647: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE
648: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
649: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
650: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
651: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
652: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
653: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
648: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
649: ,p_change_hours_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
650: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
651: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
652: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
653: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
654: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
655: )
656:
650: ,p_calendar_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
651: ,p_change_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
652: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
653: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
654: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895
655: )
656:
657: IS
658:
666: l_profile_begin_date DATE; -- Bug 6411422
667: l_change_calendar_type_code VARCHAR2(20);
668:
669: /* 7693634 new variables */
670: l_mass_update_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
671: l_last_row_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
672: l_commit_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_commit_tbl;
673: l_validate_only_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
674:
667: l_change_calendar_type_code VARCHAR2(20);
668:
669: /* 7693634 new variables */
670: l_mass_update_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
671: l_last_row_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
672: l_commit_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_commit_tbl;
673: l_validate_only_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
674:
675:
668:
669: /* 7693634 new variables */
670: l_mass_update_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
671: l_last_row_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
672: l_commit_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_commit_tbl;
673: l_validate_only_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
674:
675:
676: l_msg_count_tbl SYSTEM.PA_NUM_TBL_TYPE := p_project_id_tbl;
669: /* 7693634 new variables */
670: l_mass_update_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
671: l_last_row_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;
672: l_commit_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_commit_tbl;
673: l_validate_only_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
674:
675:
676: l_msg_count_tbl SYSTEM.PA_NUM_TBL_TYPE := p_project_id_tbl;
677: l_return_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
673: l_validate_only_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
674:
675:
676: l_msg_count_tbl SYSTEM.PA_NUM_TBL_TYPE := p_project_id_tbl;
677: l_return_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
678: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
679:
680:
681:
674:
675:
676: l_msg_count_tbl SYSTEM.PA_NUM_TBL_TYPE := p_project_id_tbl;
677: l_return_status_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
678: l_msg_data_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_tbl;
679:
680:
681:
682: BEGIN