DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PUB dependencies on PA_VARCHAR2_2000_TBL_TYPE

Line 411: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE

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

Line 412: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

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

Line 417: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_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

Line 418: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_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
422: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 419: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'

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

Line 420: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE

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

Line 421: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE

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

Line 422: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

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

Line 423: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895

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:

Line 425: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE ) --File.Sql.39 bug 4440895

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;

Line 438: l_mass_update_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;

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:

Line 439: l_last_row_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;

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:

Line 440: l_commit_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_commit_tbl;

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;

Line 441: l_validate_only_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_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;

Line 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;

Line 446: l_msg_data_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;
450: --Bug#9817752 end

Line 637: ,p_mass_update_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE

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

Line 638: ,p_exception_type_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

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

Line 643: ,p_requirement_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_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

Line 644: ,p_assignment_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_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
648: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 645: ,p_last_row_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := 'Y'

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

Line 646: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_FALSE

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

Line 647: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE -- := FND_API.G_TRUE

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

Line 648: ,p_msg_data_in_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

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

Line 649: ,p_change_hours_type_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
653: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

Line 652: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_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:

Line 654: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE --File.Sql.39 bug 4440895

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:

Line 670: l_mass_update_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;

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:

Line 671: l_last_row_flag_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_mass_update_flag_tbl;

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:

Line 672: l_commit_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_commit_tbl;

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;

Line 673: l_validate_only_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := p_validate_only_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;

Line 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:

Line 678: l_msg_data_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:
682: BEGIN