APPS.PA_ASSIGNMENTS_PUB dependencies on PA_NUM_TBL_TYPE

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

114: ,p_search_exp_start_org_id IN pa_project_assignments.search_exp_start_org_id%TYPE := FND_API.G_MISS_NUM
115: ,p_search_min_candidate_score IN pa_project_assignments.search_min_candidate_score%TYPE := FND_API.G_MISS_NUM
116: ,p_enable_auto_cand_nom_flag IN pa_project_assignments.enable_auto_cand_nom_flag%TYPE := FND_API.G_MISS_CHAR
117: -- 5130421 End
118: ,x_new_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type --File.Sql.39 bug 4440895
119: ,x_new_assignment_id OUT NOCOPY pa_project_assignments.assignment_id%TYPE --File.Sql.39 bug 4440895
120: ,x_assignment_number OUT NOCOPY pa_project_assignments.assignment_number%TYPE --File.Sql.39 bug 4440895
121: ,x_assignment_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
122: ,x_resource_id OUT NOCOPY pa_resources.resource_id%TYPE --File.Sql.39 bug 4440895

Line 419: x_new_assignment_id_tbl:= SYSTEM.pa_num_tbl_type();

415: END IF;
416:
417: -- Bug 3132280 : MOved the following table initialization outside the if
418: -- so that the NPE can be avoided in Java Layer
419: x_new_assignment_id_tbl:= SYSTEM.pa_num_tbl_type();
420:
421: IF PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.count > 0 THEN -- Bug 3132280
422:
423: /*Added the code for bug 3079906*/

Line 425: -- Bug 3132280 x_new_assignment_id_tbl:= SYSTEM.pa_num_tbl_type();

421: IF PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.count > 0 THEN -- Bug 3132280
422:
423: /*Added the code for bug 3079906*/
424: IF p_asgn_creation_mode <> 'MASS' OR (p_asgn_creation_mode = 'MASS' AND p_validate_only = FND_API.G_FALSE) THEN
425: -- Bug 3132280 x_new_assignment_id_tbl:= SYSTEM.pa_num_tbl_type();
426: FOR i in PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.FIRST..PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.LAST LOOP
427: x_new_assignment_id_tbl.extend(1);
428: x_new_assignment_id_tbl(i):=PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id;
429: END LOOP;

Line 2121: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

2117: l_sch_exception_id NUMBER;
2118: l_status_controls_valid VARCHAR2(1) := 'Y';
2119: l_index NUMBER;
2120:
2121: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2122: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2123: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2124: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2125: l_task_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

Line 2122: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

2118: l_status_controls_valid VARCHAR2(1) := 'Y';
2119: l_index NUMBER;
2120:
2121: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2122: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2123: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2124: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2125: l_task_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2126:

Line 2123: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

2119: l_index NUMBER;
2120:
2121: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2122: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2123: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2124: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2125: l_task_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2126:
2127: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

Line 2124: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

2120:
2121: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2122: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2123: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2124: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2125: l_task_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2126:
2127: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2128: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();

Line 2125: l_task_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

2121: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2122: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2123: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2124: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2125: l_task_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2126:
2127: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2128: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2129: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 2127: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2123: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2124: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2125: l_task_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2126:
2127: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2128: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2129: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2130: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2131: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 2130: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2126:
2127: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2128: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2129: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2130: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2131: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2132: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2133: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2134: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

Line 2133: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2129: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2130: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2131: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2132: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2133: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2134: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2135: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2136: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
2137: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

Line 2134: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2130: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2131: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2132: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2133: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2134: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2135: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2136: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
2137: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2138: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();

Line 2137: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2133: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2134: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2135: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2136: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
2137: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2138: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
2139: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2140: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2141: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

Line 2139: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2135: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2136: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
2137: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2138: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
2139: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2140: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2141: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2142: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2143: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 2140: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2136: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
2137: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2138: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
2139: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2140: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2141: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2142: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2143: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2144: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 2141: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2137: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2138: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
2139: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2140: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2141: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2142: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2143: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2144: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2145: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 2142: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2138: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
2139: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2140: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2141: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2142: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2143: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2144: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2145: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2146: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 2148: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2144: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2145: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2146: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2147: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2148: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2149: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2150: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2151: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2152: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();

Line 2149: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2145: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2146: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2147: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2148: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2149: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2150: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2151: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2152: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2153: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 2151: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2147: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2148: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2149: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2150: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2151: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2152: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2153: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2154: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2155: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 2154: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2150: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2151: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2152: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2153: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2154: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2155: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2156: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2157: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2158: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

Line 2156: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2152: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2153: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2154: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2155: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2156: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2157: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2158: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2159: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2160: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

Line 2160: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

2156: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2157: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2158: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2159: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2160: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2161: l_cur_role_flag Varchar2(1);
2162:
2163: CURSOR check_record_version IS
2164: SELECT ROWID

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3602: ,x_msg_count_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

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: )
3606:

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

6386: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
6387: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
6388: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
6389: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
6390: ,p_resource_id_tbl IN system.pa_num_tbl_type := NULL
6391: ,p_resource_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
6392: ,p_resource_source_id_tbl IN system.pa_num_tbl_type := NULL
6393: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
6394: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

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

6388: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
6389: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
6390: ,p_resource_id_tbl IN system.pa_num_tbl_type := NULL
6391: ,p_resource_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
6392: ,p_resource_source_id_tbl IN system.pa_num_tbl_type := NULL
6393: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
6394: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
6395: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
6396: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

Line 6476: l_new_assignment_id_tbl system.pa_num_tbl_type;

6472: l_assignment_number pa_project_assignments.assignment_number%TYPE;
6473: l_assignment_row_id ROWID;
6474: l_status_code pa_project_assignments.status_code%TYPE ; --Bug 7309934
6475:
6476: l_new_assignment_id_tbl system.pa_num_tbl_type;
6477: l_asg_tp_amount_type pa_project_assignments_v.FCST_TP_AMOUNT_TYPE%TYPE;
6478:
6479: BEGIN
6480:

Line 6506: -- l_new_assignment_id_tbl:= SYSTEM.pa_num_tbl_type();

6502:
6503: END IF;
6504:
6505:
6506: -- l_new_assignment_id_tbl:= SYSTEM.pa_num_tbl_type();
6507: --do online validation
6508: PA_ASSIGNMENTS_PUB.Execute_Create_Assignment
6509: ( p_asgn_creation_mode => 'MASS'
6510: ,p_unfilled_assignment_status => p_unfilled_assignment_status

Line 6686: ,p_resource_id_tbl IN system.pa_num_tbl_type

6682: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
6683: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
6684: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
6685: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
6686: ,p_resource_id_tbl IN system.pa_num_tbl_type
6687: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
6688: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
6689: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
6690: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

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

6749: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6750: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6751: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6752: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
6753: ,x_success_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type -- For 1159 mandate changes bug#2674619
6754: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6755: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6756: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6757: )

Line 6761: l_new_assignment_id_tbl system.pa_num_tbl_type := p_resource_id_tbl;

6757: )
6758: IS
6759:
6760: l_new_assignment_id pa_project_assignments.assignment_id%TYPE;
6761: l_new_assignment_id_tbl system.pa_num_tbl_type := p_resource_id_tbl;
6762: l_resource_id pa_resources_denorm.resource_id%TYPE;
6763: l_assignment_number pa_project_assignments.assignment_number%TYPE;
6764: l_assignment_row_id ROWID;
6765: l_new_assignment_tabl system.pa_num_tbl_type;

Line 6765: l_new_assignment_tabl system.pa_num_tbl_type;

6761: l_new_assignment_id_tbl system.pa_num_tbl_type := p_resource_id_tbl;
6762: l_resource_id pa_resources_denorm.resource_id%TYPE;
6763: l_assignment_number pa_project_assignments.assignment_number%TYPE;
6764: l_assignment_row_id ROWID;
6765: l_new_assignment_tabl system.pa_num_tbl_type;
6766: l_return_status VARCHAR2(1);
6767: l_staffing_owner_name PER_PEOPLE_F.full_name%TYPE := null;
6768: l_err_msg_code VARCHAR2(80);
6769: l_staffing_owner_person_id pa_project_assignments.staffing_owner_person_id%TYPE := null;

Line 6916: ,p_assignment_id_tbl IN system.pa_num_tbl_type

6912:
6913:
6914: PROCEDURE Mass_Exec_Update_Assignments
6915: ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
6916: ,p_assignment_id_tbl IN system.pa_num_tbl_type
6917: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
6918: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
6919: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
6920: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

Line 7160: ,p_assignment_id_tbl IN system.pa_num_tbl_type

7156:
7157:
7158: PROCEDURE Mass_Update_Assignments
7159: ( p_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
7160: ,p_assignment_id_tbl IN system.pa_num_tbl_type
7161: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
7162: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
7163: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
7164: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

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

7227: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
7228: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
7229: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
7230: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
7231: ,x_success_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type -- For 1159 mandate changes bug#2674619
7232: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7233: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7234: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7235: )

Line 7239: l_assignment_id_tbl system.pa_num_tbl_type;

7235: )
7236: IS
7237:
7238:
7239: l_assignment_id_tbl system.pa_num_tbl_type;
7240:
7241: l_subteam_party_id NUMBER;
7242: l_description pa_project_assignments.description%TYPE := NULL;
7243: l_additional_info pa_project_assignments.additional_information%TYPE := NULL;