APPS.PA_ASSIGNMENTS_PUB dependencies on PA_NUM_TBL_TYPE

Line 357: ,x_new_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type --File.Sql.39 bug 4440895

353: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
354: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
355: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
356: -- 5130421 End
357: ,x_new_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type --File.Sql.39 bug 4440895
358: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
359: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
360: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
361: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895

Line 1080: ,p_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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
1084: ,p_multiple_status_flag_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 1081: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

Line 1089: ,p_project_id_tbl IN SYSTEM.PA_NUM_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
1093: ,p_description_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 1090: ,p_assignment_template_id_tbl IN SYSTEM.PA_NUM_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
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

Line 1091: ,p_project_subteam_id_tbl IN SYSTEM.PA_NUM_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
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

Line 1092: ,p_project_subteam_party_id_tbl IN SYSTEM.PA_NUM_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
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

Line 1095: ,p_min_resource_job_level_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
1099: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007

Line 1096: ,p_max_resource_job_level_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
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

Line 1098: ,p_work_type_id_tbl IN SYSTEM.PA_NUM_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
1102: ,p_fcst_tp_amount_type_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 1099: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007

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

Line 1101: ,p_expense_limit_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
1105: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 1103: ,p_fcst_job_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
1107: ,p_expenditure_type_class_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 1104: ,p_fcst_job_group_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

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

Line 1105: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_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
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

Line 1106: ,p_exp_organization_id_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
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

Line 1114: ,p_calendar_id_tbl IN SYSTEM.PA_NUM_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
1118: ,p_exp_organization_name_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 1119: ,p_comp_match_weighting_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
1123: ,p_search_country_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 1120: ,p_avail_match_weighting_tbl IN SYSTEM.PA_NUM_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
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

Line 1121: ,p_job_level_match_weight_tbl IN SYSTEM.PA_NUM_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
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

Line 1122: ,p_search_min_availability_tbl IN SYSTEM.PA_NUM_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
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

Line 1125: ,p_search_exp_org_st_ver_id_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
1129: ,p_search_min_candidate_sc_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 1127: ,p_search_exp_start_org_id_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
1131: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 1129: ,p_search_min_candidate_sc_tbl IN SYSTEM.PA_NUM_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
1133: ,p_markup_percent_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL

Line 1131: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_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
1135: ,p_rate_disc_reason_code_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 1133: ,p_markup_percent_override_tbl IN SYSTEM.PA_NUM_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
1137: ,p_tp_currency_override_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 1134: ,p_discount_percentage_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
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

Line 1136: ,p_tp_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
1140: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007

Line 1138: ,p_staffing_owner_person_id_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
1142: ,p_attribute1_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 1140: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := NULL --Bug#9108007

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
1144: ,p_attribute3_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 1157: ,p_api_version_tbl IN SYSTEM.PA_NUM_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
1161: ,p_context_tbl IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE := NULL

Line 1163: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

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: );
1167:

Line 1411: ,p_resource_id_tbl IN system.pa_num_tbl_type := NULL

1407: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1408: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
1409: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
1410: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
1411: ,p_resource_id_tbl IN system.pa_num_tbl_type := NULL
1412: ,p_resource_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
1413: ,p_resource_source_id_tbl IN system.pa_num_tbl_type := NULL
1414: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1415: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

Line 1413: ,p_resource_source_id_tbl IN system.pa_num_tbl_type := NULL

1409: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
1410: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
1411: ,p_resource_id_tbl IN system.pa_num_tbl_type := NULL
1412: ,p_resource_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
1413: ,p_resource_source_id_tbl IN system.pa_num_tbl_type := NULL
1414: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1415: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1416: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1417: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

Line 1498: ,p_resource_id_tbl IN system.pa_num_tbl_type

1494: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
1495: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
1496: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
1497: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
1498: ,p_resource_id_tbl IN system.pa_num_tbl_type
1499: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
1500: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
1501: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
1502: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

Line 1565: ,x_success_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type -- For 1159 mandate changes bug#2674619

1561: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1562: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1563: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1564: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1565: ,x_success_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type -- For 1159 mandate changes bug#2674619
1566: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1567: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1568: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1569: );

Line 1575: ,p_assignment_id_tbl IN system.pa_num_tbl_type

1571:
1572:
1573: PROCEDURE Mass_Exec_Update_Assignments
1574: ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
1575: ,p_assignment_id_tbl IN system.pa_num_tbl_type
1576: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
1577: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1578: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1579: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

Line 1655: ,p_assignment_id_tbl IN system.pa_num_tbl_type

1651:
1652:
1653: PROCEDURE Mass_Update_Assignments
1654: ( p_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
1655: ,p_assignment_id_tbl IN system.pa_num_tbl_type
1656: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
1657: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
1658: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
1659: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

Line 1726: ,x_success_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type -- For 1159 mandate changes bug#2674619

1722: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
1723: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1724: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1725: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
1726: ,x_success_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type -- For 1159 mandate changes bug#2674619
1727: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1728: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1729: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1730: );