APPS.PA_ASSIGNMENTS_PUB dependencies on PA_VARCHAR2_2000_TBL_TYPE

Line 3518: p_asgn_update_mode_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3514: /* Bug 8233045: Added the below procedure. This procedure can be invoked in bulk and
3515: further calls Execute_Update_Assignment within loop*/
3516:
3517: PROCEDURE Execute_Update_Assignment_bulk (
3518: p_asgn_update_mode_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3519: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3520: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3521: ,p_assignment_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3522: ,p_assignment_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3521: ,p_assignment_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3517: PROCEDURE Execute_Update_Assignment_bulk (
3518: p_asgn_update_mode_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3519: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3520: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3521: ,p_assignment_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3522: ,p_assignment_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3523: ,p_multiple_status_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3524: ,p_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3525: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

Line 3522: ,p_assignment_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3518: p_asgn_update_mode_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3519: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3520: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3521: ,p_assignment_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3522: ,p_assignment_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3523: ,p_multiple_status_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3524: ,p_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3525: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
3526: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

Line 3523: ,p_multiple_status_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3519: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3520: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3521: ,p_assignment_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3522: ,p_assignment_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3523: ,p_multiple_status_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3524: ,p_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3525: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
3526: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
3527: ,p_staffing_priority_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3524: ,p_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3520: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3521: ,p_assignment_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3522: ,p_assignment_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3523: ,p_multiple_status_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3524: ,p_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3525: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
3526: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
3527: ,p_staffing_priority_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3528: ,p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3527: ,p_staffing_priority_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3523: ,p_multiple_status_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3524: ,p_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3525: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
3526: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
3527: ,p_staffing_priority_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3528: ,p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3529: ,p_assignment_template_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3530: ,p_project_subteam_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3531: ,p_project_subteam_party_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3532: ,p_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3528: ,p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3529: ,p_assignment_template_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3530: ,p_project_subteam_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3531: ,p_project_subteam_party_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3532: ,p_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3533: ,p_extension_possible_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3534: ,p_min_resource_job_level_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3535: ,p_max_resource_job_level_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3536: ,p_additional_information_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3533: ,p_extension_possible_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3529: ,p_assignment_template_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3530: ,p_project_subteam_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3531: ,p_project_subteam_party_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3532: ,p_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3533: ,p_extension_possible_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3534: ,p_min_resource_job_level_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3535: ,p_max_resource_job_level_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3536: ,p_additional_information_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3537: ,p_work_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3536: ,p_additional_information_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3532: ,p_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3533: ,p_extension_possible_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3534: ,p_min_resource_job_level_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3535: ,p_max_resource_job_level_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3536: ,p_additional_information_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3537: ,p_work_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3538: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007
3539: ,p_expense_owner_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3540: ,p_expense_limit_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3539: ,p_expense_owner_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3535: ,p_max_resource_job_level_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3536: ,p_additional_information_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3537: ,p_work_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3538: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007
3539: ,p_expense_owner_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3540: ,p_expense_limit_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3541: ,p_fcst_tp_amount_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3542: ,p_fcst_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3543: ,p_fcst_job_group_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3541: ,p_fcst_tp_amount_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3537: ,p_work_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3538: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007
3539: ,p_expense_owner_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3540: ,p_expense_limit_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3541: ,p_fcst_tp_amount_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3542: ,p_fcst_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3543: ,p_fcst_job_group_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3544: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3545: ,p_exp_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3546: ,p_expenditure_type_class_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3542: ,p_fcst_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3543: ,p_fcst_job_group_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3544: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3545: ,p_exp_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3546: ,p_expenditure_type_class_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3547: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3548: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3549: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3550: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3547: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3543: ,p_fcst_job_group_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3544: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3545: ,p_exp_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3546: ,p_expenditure_type_class_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3547: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3548: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3549: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3550: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3551: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3548: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3544: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3545: ,p_exp_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3546: ,p_expenditure_type_class_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3547: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3548: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3549: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3550: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3551: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3552: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3549: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3545: ,p_exp_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3546: ,p_expenditure_type_class_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3547: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3548: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3549: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3550: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3551: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3552: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3553: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3550: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3546: ,p_expenditure_type_class_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3547: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3548: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3549: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3550: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3551: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3552: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3553: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3554: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3551: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3547: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3548: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3549: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3550: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3551: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3552: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3553: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3554: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3555: ,p_fcst_job_group_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3552: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3548: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3549: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3550: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3551: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3552: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3553: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3554: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3555: ,p_fcst_job_group_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3556: ,p_expenditure_org_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3554: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3550: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3551: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3552: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3553: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3554: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3555: ,p_fcst_job_group_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3556: ,p_expenditure_org_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3557: ,p_exp_organization_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3558: ,p_comp_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3555: ,p_fcst_job_group_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3551: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3552: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3553: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3554: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3555: ,p_fcst_job_group_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3556: ,p_expenditure_org_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3557: ,p_exp_organization_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3558: ,p_comp_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3559: ,p_avail_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3556: ,p_expenditure_org_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3552: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3553: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3554: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3555: ,p_fcst_job_group_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3556: ,p_expenditure_org_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3557: ,p_exp_organization_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3558: ,p_comp_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3559: ,p_avail_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3560: ,p_job_level_match_weight_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3557: ,p_exp_organization_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3553: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3554: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3555: ,p_fcst_job_group_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3556: ,p_expenditure_org_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3557: ,p_exp_organization_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3558: ,p_comp_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3559: ,p_avail_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3560: ,p_job_level_match_weight_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3561: ,p_search_min_availability_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3562: ,p_search_country_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3558: ,p_comp_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3559: ,p_avail_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3560: ,p_job_level_match_weight_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3561: ,p_search_min_availability_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3562: ,p_search_country_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3563: ,p_search_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3564: ,p_search_exp_org_st_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3565: ,p_search_exp_org_hier_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3566: ,p_search_exp_start_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3563: ,p_search_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3559: ,p_avail_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3560: ,p_job_level_match_weight_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3561: ,p_search_min_availability_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3562: ,p_search_country_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3563: ,p_search_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3564: ,p_search_exp_org_st_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3565: ,p_search_exp_org_hier_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3566: ,p_search_exp_start_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3567: ,p_search_exp_start_org_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3565: ,p_search_exp_org_hier_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3561: ,p_search_min_availability_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3562: ,p_search_country_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3563: ,p_search_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3564: ,p_search_exp_org_st_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3565: ,p_search_exp_org_hier_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3566: ,p_search_exp_start_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3567: ,p_search_exp_start_org_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3568: ,p_search_min_candidate_sc_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3569: ,p_enable_auto_cand_nom_flg_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3567: ,p_search_exp_start_org_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3563: ,p_search_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3564: ,p_search_exp_org_st_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3565: ,p_search_exp_org_hier_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3566: ,p_search_exp_start_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3567: ,p_search_exp_start_org_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3568: ,p_search_min_candidate_sc_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3569: ,p_enable_auto_cand_nom_flg_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3570: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3571: ,p_bill_rate_curr_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3569: ,p_enable_auto_cand_nom_flg_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3565: ,p_search_exp_org_hier_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3566: ,p_search_exp_start_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3567: ,p_search_exp_start_org_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3568: ,p_search_min_candidate_sc_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3569: ,p_enable_auto_cand_nom_flg_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3570: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3571: ,p_bill_rate_curr_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3572: ,p_markup_percent_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3573: ,p_discount_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3571: ,p_bill_rate_curr_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3567: ,p_search_exp_start_org_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3568: ,p_search_min_candidate_sc_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3569: ,p_enable_auto_cand_nom_flg_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3570: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3571: ,p_bill_rate_curr_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3572: ,p_markup_percent_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3573: ,p_discount_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3574: ,p_rate_disc_reason_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3575: ,p_tp_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3574: ,p_rate_disc_reason_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3570: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3571: ,p_bill_rate_curr_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3572: ,p_markup_percent_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3573: ,p_discount_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3574: ,p_rate_disc_reason_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3575: ,p_tp_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3576: ,p_tp_currency_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3577: ,p_staffing_owner_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3578: ,p_staffing_owner_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3576: ,p_tp_currency_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3572: ,p_markup_percent_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3573: ,p_discount_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3574: ,p_rate_disc_reason_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3575: ,p_tp_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3576: ,p_tp_currency_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3577: ,p_staffing_owner_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3578: ,p_staffing_owner_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3579: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL--Bug#9108007
3580: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3578: ,p_staffing_owner_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3574: ,p_rate_disc_reason_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3575: ,p_tp_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3576: ,p_tp_currency_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3577: ,p_staffing_owner_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3578: ,p_staffing_owner_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3579: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL--Bug#9108007
3580: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3581: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3582: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3580: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3576: ,p_tp_currency_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3577: ,p_staffing_owner_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3578: ,p_staffing_owner_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3579: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL--Bug#9108007
3580: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3581: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3582: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3583: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3584: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3581: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3577: ,p_staffing_owner_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3578: ,p_staffing_owner_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3579: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL--Bug#9108007
3580: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3581: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3582: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3583: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3584: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3585: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3582: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3578: ,p_staffing_owner_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3579: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL--Bug#9108007
3580: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3581: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3582: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3583: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3584: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3585: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3586: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3583: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3579: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL--Bug#9108007
3580: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3581: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3582: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3583: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3584: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3585: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3586: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3587: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3584: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3580: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3581: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3582: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3583: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3584: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3585: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3586: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3587: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3588: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3585: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3581: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3582: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3583: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3584: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3585: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3586: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3587: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3588: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3589: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3586: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3582: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3583: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3584: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3585: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3586: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3587: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3588: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3589: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3590: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3587: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3583: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3584: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3585: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3586: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3587: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3588: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3589: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3590: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3591: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3588: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3584: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3585: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3586: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3587: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3588: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3589: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3590: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3591: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3592: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3589: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3585: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3586: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3587: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3588: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3589: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3590: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3591: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3592: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3593: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3590: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3586: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3587: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3588: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3589: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3590: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3591: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3592: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3593: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3594: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3591: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3587: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3588: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3589: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3590: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3591: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3592: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3593: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3594: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3595: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3592: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3588: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3589: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3590: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3591: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3592: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3593: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3594: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3595: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3596: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 3593: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3589: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3590: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3591: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3592: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3593: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3594: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3595: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3596: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3597: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3594: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3590: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3591: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3592: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3593: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3594: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3595: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3596: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3597: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3598: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3595: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3591: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3592: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3593: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3594: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3595: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3596: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3597: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3598: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3599: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 3597: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3593: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3594: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3595: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3596: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3597: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3598: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3599: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3600: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3601: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 3598: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3594: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3595: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3596: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3597: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3598: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3599: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3600: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3601: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
3602: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 3599: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3595: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3596: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3597: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3598: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3599: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3600: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3601: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
3602: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
3603: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 3600: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

3596: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
3597: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3598: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3599: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3600: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3601: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
3602: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
3603: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
3604: ,p_bulk_context IN varchar2 := 'N'

Line 3601: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

3597: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3598: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3599: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3600: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3601: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
3602: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
3603: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
3604: ,p_bulk_context IN varchar2 := 'N'
3605: )

Line 3603: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

3599: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3600: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
3601: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
3602: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
3603: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
3604: ,p_bulk_context IN varchar2 := 'N'
3605: )
3606:
3607: IS