DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_VARCHAR2_2000_TBL_TYPE

Line 1079: p_asgn_update_mode_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

1075: -- procedure : update_schedule
1076: -- Purpose : Same Procedure as above but invoked in bulk mode
1077: --
1078: PROCEDURE Execute_Update_Assignment_bulk (
1079: p_asgn_update_mode_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1080: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1081: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1082: ,p_assignment_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1083: ,p_assignment_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1078: PROCEDURE Execute_Update_Assignment_bulk (
1079: p_asgn_update_mode_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1080: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1081: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1082: ,p_assignment_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1083: ,p_assignment_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1084: ,p_multiple_status_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1085: ,p_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1086: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

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

1079: p_asgn_update_mode_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1080: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1081: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1082: ,p_assignment_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1083: ,p_assignment_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1084: ,p_multiple_status_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1085: ,p_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1086: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1087: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL

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

1080: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1081: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1082: ,p_assignment_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1083: ,p_assignment_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1084: ,p_multiple_status_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1085: ,p_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1086: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1087: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1088: ,p_staffing_priority_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1081: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1082: ,p_assignment_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1083: ,p_assignment_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1084: ,p_multiple_status_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1085: ,p_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1086: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1087: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1088: ,p_staffing_priority_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1089: ,p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1084: ,p_multiple_status_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1085: ,p_status_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1086: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1087: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE := NULL
1088: ,p_staffing_priority_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1089: ,p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1090: ,p_assignment_template_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1091: ,p_project_subteam_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1092: ,p_project_subteam_party_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1089: ,p_project_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1090: ,p_assignment_template_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1091: ,p_project_subteam_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1092: ,p_project_subteam_party_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1093: ,p_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1094: ,p_extension_possible_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1095: ,p_min_resource_job_level_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1096: ,p_max_resource_job_level_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1097: ,p_additional_information_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1090: ,p_assignment_template_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1091: ,p_project_subteam_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1092: ,p_project_subteam_party_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1093: ,p_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1094: ,p_extension_possible_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1095: ,p_min_resource_job_level_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1096: ,p_max_resource_job_level_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1097: ,p_additional_information_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1098: ,p_work_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1093: ,p_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1094: ,p_extension_possible_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1095: ,p_min_resource_job_level_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1096: ,p_max_resource_job_level_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1097: ,p_additional_information_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1098: ,p_work_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1099: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007
1100: ,p_expense_owner_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1101: ,p_expense_limit_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1096: ,p_max_resource_job_level_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1097: ,p_additional_information_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1098: ,p_work_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1099: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007
1100: ,p_expense_owner_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1101: ,p_expense_limit_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1102: ,p_fcst_tp_amount_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1103: ,p_fcst_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1104: ,p_fcst_job_group_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1098: ,p_work_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1099: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007
1100: ,p_expense_owner_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1101: ,p_expense_limit_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1102: ,p_fcst_tp_amount_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1103: ,p_fcst_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1104: ,p_fcst_job_group_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1105: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1106: ,p_exp_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1103: ,p_fcst_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1104: ,p_fcst_job_group_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1105: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1106: ,p_exp_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1107: ,p_expenditure_type_class_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1108: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1109: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1110: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1111: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1104: ,p_fcst_job_group_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1105: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1106: ,p_exp_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1107: ,p_expenditure_type_class_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1108: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1109: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1110: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1111: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1112: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1105: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1106: ,p_exp_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1107: ,p_expenditure_type_class_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1108: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1109: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1110: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1111: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1112: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1113: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1106: ,p_exp_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1107: ,p_expenditure_type_class_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1108: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1109: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1110: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1111: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1112: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1113: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1114: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1107: ,p_expenditure_type_class_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1108: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1109: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1110: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1111: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1112: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1113: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1114: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1115: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1108: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1109: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1110: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1111: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1112: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1113: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1114: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1115: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1116: ,p_fcst_job_group_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1109: ,p_project_subteam_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1110: ,p_location_city_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1111: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1112: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1113: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1114: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1115: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1116: ,p_fcst_job_group_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1117: ,p_expenditure_org_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1111: ,p_location_region_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1112: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1113: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1114: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1115: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1116: ,p_fcst_job_group_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1117: ,p_expenditure_org_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1118: ,p_exp_organization_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1119: ,p_comp_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1112: ,p_location_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1113: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1114: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1115: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1116: ,p_fcst_job_group_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1117: ,p_expenditure_org_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1118: ,p_exp_organization_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1119: ,p_comp_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1120: ,p_avail_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1113: ,p_calendar_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1114: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1115: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1116: ,p_fcst_job_group_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1117: ,p_expenditure_org_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1118: ,p_exp_organization_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1119: ,p_comp_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1120: ,p_avail_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1121: ,p_job_level_match_weight_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1114: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1115: ,p_fcst_job_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1116: ,p_fcst_job_group_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1117: ,p_expenditure_org_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1118: ,p_exp_organization_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1119: ,p_comp_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1120: ,p_avail_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1121: ,p_job_level_match_weight_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1122: ,p_search_min_availability_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1119: ,p_comp_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1120: ,p_avail_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1121: ,p_job_level_match_weight_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1122: ,p_search_min_availability_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1123: ,p_search_country_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1124: ,p_search_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1125: ,p_search_exp_org_st_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1126: ,p_search_exp_org_hier_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1127: ,p_search_exp_start_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1120: ,p_avail_match_weighting_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1121: ,p_job_level_match_weight_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1122: ,p_search_min_availability_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1123: ,p_search_country_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1124: ,p_search_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1125: ,p_search_exp_org_st_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1126: ,p_search_exp_org_hier_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1127: ,p_search_exp_start_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1128: ,p_search_exp_start_org_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1122: ,p_search_min_availability_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1123: ,p_search_country_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1124: ,p_search_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1125: ,p_search_exp_org_st_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1126: ,p_search_exp_org_hier_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1127: ,p_search_exp_start_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1128: ,p_search_exp_start_org_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1129: ,p_search_min_candidate_sc_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1130: ,p_enable_auto_cand_nom_flg_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1124: ,p_search_country_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1125: ,p_search_exp_org_st_ver_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1126: ,p_search_exp_org_hier_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1127: ,p_search_exp_start_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1128: ,p_search_exp_start_org_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1129: ,p_search_min_candidate_sc_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1130: ,p_enable_auto_cand_nom_flg_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1131: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1132: ,p_bill_rate_curr_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1126: ,p_search_exp_org_hier_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1127: ,p_search_exp_start_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1128: ,p_search_exp_start_org_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1129: ,p_search_min_candidate_sc_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1130: ,p_enable_auto_cand_nom_flg_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1131: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1132: ,p_bill_rate_curr_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1133: ,p_markup_percent_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1134: ,p_discount_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1128: ,p_search_exp_start_org_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1129: ,p_search_min_candidate_sc_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1130: ,p_enable_auto_cand_nom_flg_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1131: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1132: ,p_bill_rate_curr_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1133: ,p_markup_percent_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1134: ,p_discount_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1135: ,p_rate_disc_reason_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1136: ,p_tp_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1131: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1132: ,p_bill_rate_curr_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1133: ,p_markup_percent_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1134: ,p_discount_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1135: ,p_rate_disc_reason_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1136: ,p_tp_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1137: ,p_tp_currency_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1138: ,p_staffing_owner_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1139: ,p_staffing_owner_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1133: ,p_markup_percent_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1134: ,p_discount_percentage_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1135: ,p_rate_disc_reason_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1136: ,p_tp_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1137: ,p_tp_currency_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1138: ,p_staffing_owner_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1139: ,p_staffing_owner_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1140: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007
1141: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1135: ,p_rate_disc_reason_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1136: ,p_tp_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1137: ,p_tp_currency_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1138: ,p_staffing_owner_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1139: ,p_staffing_owner_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1140: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007
1141: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1142: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1143: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1137: ,p_tp_currency_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1138: ,p_staffing_owner_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1139: ,p_staffing_owner_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1140: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007
1141: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1142: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1143: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1144: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1145: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1138: ,p_staffing_owner_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1139: ,p_staffing_owner_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1140: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007
1141: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1142: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1143: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1144: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1145: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1146: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1139: ,p_staffing_owner_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1140: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007
1141: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1142: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1143: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1144: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1145: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1146: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1147: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1140: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007
1141: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1142: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1143: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1144: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1145: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1146: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1147: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1148: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1141: ,p_attribute_category_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1142: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1143: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1144: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1145: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1146: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1147: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1148: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1149: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1142: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1143: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1144: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1145: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1146: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1147: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1148: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1149: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1150: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1143: ,p_attribute2_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1144: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1145: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1146: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1147: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1148: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1149: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1150: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1151: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1144: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1145: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1146: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1147: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1148: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1149: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1150: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1151: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1152: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1145: ,p_attribute4_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1146: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1147: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1148: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1149: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1150: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1151: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1152: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1153: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1146: ,p_attribute5_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1147: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1148: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1149: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1150: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1151: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1152: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1153: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1154: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1147: ,p_attribute6_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1148: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1149: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1150: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1151: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1152: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1153: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1154: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1155: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1148: ,p_attribute7_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1149: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1150: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1151: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1152: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1153: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1154: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1155: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1156: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1149: ,p_attribute8_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1150: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1151: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1152: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1153: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1154: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1155: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1156: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1157: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

1150: ,p_attribute9_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1151: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1152: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1153: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1154: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1155: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1156: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1157: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1158: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1151: ,p_attribute10_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1152: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1153: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1154: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1155: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1156: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1157: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1158: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1159: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1152: ,p_attribute11_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1153: ,p_attribute12_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1154: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1155: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1156: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1157: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1158: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1159: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1160: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

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

1154: ,p_attribute13_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1155: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1156: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1157: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1158: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1159: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1160: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1161: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1162: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

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

1155: ,p_attribute14_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1156: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1157: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1158: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1159: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1160: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1161: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1162: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1163: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

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

1156: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1157: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1158: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1159: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1160: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1161: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1162: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1163: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1164: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

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

1157: ,p_api_version_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL
1158: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1159: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1160: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1161: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1162: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1163: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1164: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1165: ,p_bulk_context IN varchar2 := 'N'

Line 1162: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

1158: ,p_init_msg_list_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1159: ,p_commit_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1160: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1161: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1162: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1163: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1164: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1165: ,p_bulk_context IN varchar2 := 'N'
1166: );

Line 1164: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

1160: ,p_validate_only_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1161: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL
1162: ,x_return_status_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1163: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1164: ,x_msg_data_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1165: ,p_bulk_context IN varchar2 := 'N'
1166: );
1167:
1168: