eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 384: x_new_assignment_id_tbl:= SYSTEM.pa_num_tbl_type();

380: END IF;
381:
382: -- Bug 3132280 : MOved the following table initialization outside the if
383: -- so that the NPE can be avoided in Java Layer
384: x_new_assignment_id_tbl:= SYSTEM.pa_num_tbl_type();
385:
386: IF PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.count > 0 THEN -- Bug 3132280
387:
388: /*Added the code for bug 3079906*/

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

386: IF PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.count > 0 THEN -- Bug 3132280
387:
388: /*Added the code for bug 3079906*/
389: IF p_asgn_creation_mode <> 'MASS' OR (p_asgn_creation_mode = 'MASS' AND p_validate_only = FND_API.G_FALSE) THEN
390: -- Bug 3132280 x_new_assignment_id_tbl:= SYSTEM.pa_num_tbl_type();
391: FOR i in PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.FIRST..PA_ASSIGNMENTS_PUB.g_assignment_id_tbl.LAST LOOP
392: x_new_assignment_id_tbl.extend(1);
393: x_new_assignment_id_tbl(i):=PA_ASSIGNMENTS_PUB.g_assignment_id_tbl(i).assignment_id;
394: END LOOP;

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

2054: l_sch_exception_id NUMBER;
2055: l_status_controls_valid VARCHAR2(1) := 'Y';
2056: l_index NUMBER;
2057:
2058: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2059: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2060: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2061: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2062: l_task_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();

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

2055: l_status_controls_valid VARCHAR2(1) := 'Y';
2056: l_index NUMBER;
2057:
2058: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2059: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2060: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2061: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2062: l_task_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2063:

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

2056: l_index NUMBER;
2057:
2058: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2059: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2060: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2061: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2062: l_task_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2063:
2064: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

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

2057:
2058: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2059: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2060: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2061: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2062: l_task_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2063:
2064: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2065: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();

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

2058: l_task_assignment_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2059: l_task_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2060: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2061: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2062: l_task_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2063:
2064: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2065: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2066: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

2060: l_budget_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2061: l_struct_version_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2062: l_task_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2063:
2064: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2065: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2066: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2067: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2068: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

2063:
2064: l_resource_list_members_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2065: l_resource_class_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2066: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2067: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2068: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2069: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2070: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2071: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

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

2066: l_resource_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2067: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2068: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2069: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2070: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2071: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2072: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2073: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
2074: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

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

2067: l_resource_class_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2068: l_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2069: l_incur_by_res_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2070: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2071: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2072: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2073: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
2074: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2075: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();

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

2070: l_person_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2071: l_job_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2072: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2073: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
2074: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2075: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
2076: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2077: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2078: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

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

2072: l_person_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2073: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
2074: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2075: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
2076: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2077: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2078: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2079: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2080: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

2073: l_named_role_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE := system.pa_varchar2_80_tbl_type();
2074: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2075: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
2076: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2077: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2078: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2079: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2080: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2081: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

2074: l_bom_resource_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2075: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
2076: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2077: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2078: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2079: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2080: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2081: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2082: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

2075: l_non_labor_resource_tbl SYSTEM.PA_VARCHAR2_20_TBL_TYPE := system.pa_varchar2_20_tbl_type();
2076: l_inventory_item_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2077: l_item_category_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2078: l_project_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2079: l_organization_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2080: l_fc_res_type_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2081: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2082: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2083: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

2081: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2082: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2083: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2084: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2085: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2086: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2087: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2088: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2089: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();

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

2082: l_expenditure_category_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2083: l_event_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2084: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2085: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2086: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2087: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2088: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2089: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2090: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

2084: l_revenue_category_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2085: l_supplier_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2086: l_spread_curve_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2087: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2088: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2089: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2090: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2091: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2092: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

2087: l_etc_method_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2088: l_mfc_cost_type_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2089: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2090: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2091: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2092: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2093: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2094: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2095: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();

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

2089: l_incurred_by_res_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2090: l_incur_by_res_class_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2091: l_incur_by_role_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2092: l_unit_of_measure_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2093: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2094: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2095: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2096: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2097: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();

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

2093: l_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2094: l_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := system.pa_varchar2_1_tbl_type();
2095: l_rate_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2096: l_rate_func_curr_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := system.pa_varchar2_30_tbl_type();
2097: l_rate_incurred_by_org_id_tbl SYSTEM.PA_NUM_TBL_TYPE := system.pa_num_tbl_type();
2098: l_cur_role_flag Varchar2(1);
2099:
2100: CURSOR check_record_version IS
2101: SELECT ROWID

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

5410: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
5411: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
5412: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
5413: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
5414: ,p_resource_id_tbl IN system.pa_num_tbl_type := NULL
5415: ,p_resource_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
5416: ,p_resource_source_id_tbl IN system.pa_num_tbl_type := NULL
5417: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
5418: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR

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

5412: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
5413: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
5414: ,p_resource_id_tbl IN system.pa_num_tbl_type := NULL
5415: ,p_resource_name_tbl IN system.pa_varchar2_240_tbl_type := NULL
5416: ,p_resource_source_id_tbl IN system.pa_num_tbl_type := NULL
5417: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
5418: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
5419: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
5420: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

Line 5500: l_new_assignment_id_tbl system.pa_num_tbl_type;

5496: l_assignment_number pa_project_assignments.assignment_number%TYPE;
5497: l_assignment_row_id ROWID;
5498: l_status_code pa_project_assignments.status_code%TYPE ; --Bug 7309934
5499:
5500: l_new_assignment_id_tbl system.pa_num_tbl_type;
5501: l_asg_tp_amount_type pa_project_assignments_v.FCST_TP_AMOUNT_TYPE%TYPE;
5502:
5503: BEGIN
5504:

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

5526:
5527: END IF;
5528:
5529:
5530: -- l_new_assignment_id_tbl:= SYSTEM.pa_num_tbl_type();
5531: --do online validation
5532: PA_ASSIGNMENTS_PUB.Execute_Create_Assignment
5533: ( p_asgn_creation_mode => 'MASS'
5534: ,p_unfilled_assignment_status => p_unfilled_assignment_status

Line 5710: ,p_resource_id_tbl IN system.pa_num_tbl_type

5706: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
5707: ,p_assignment_template_id IN pa_project_assignments.assignment_template_id%TYPE := FND_API.G_MISS_NUM
5708: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
5709: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
5710: ,p_resource_id_tbl IN system.pa_num_tbl_type
5711: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
5712: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
5713: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
5714: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

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

5773: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
5774: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
5775: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
5776: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
5777: ,x_success_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type -- For 1159 mandate changes bug#2674619
5778: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5779: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5780: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5781: )

Line 5785: l_new_assignment_id_tbl system.pa_num_tbl_type := p_resource_id_tbl;

5781: )
5782: IS
5783:
5784: l_new_assignment_id pa_project_assignments.assignment_id%TYPE;
5785: l_new_assignment_id_tbl system.pa_num_tbl_type := p_resource_id_tbl;
5786: l_resource_id pa_resources_denorm.resource_id%TYPE;
5787: l_assignment_number pa_project_assignments.assignment_number%TYPE;
5788: l_assignment_row_id ROWID;
5789: l_new_assignment_tabl system.pa_num_tbl_type;

Line 5789: l_new_assignment_tabl system.pa_num_tbl_type;

5785: l_new_assignment_id_tbl system.pa_num_tbl_type := p_resource_id_tbl;
5786: l_resource_id pa_resources_denorm.resource_id%TYPE;
5787: l_assignment_number pa_project_assignments.assignment_number%TYPE;
5788: l_assignment_row_id ROWID;
5789: l_new_assignment_tabl system.pa_num_tbl_type;
5790: l_return_status VARCHAR2(1);
5791: l_staffing_owner_name PER_PEOPLE_F.full_name%TYPE := null;
5792: l_err_msg_code VARCHAR2(80);
5793: l_staffing_owner_person_id pa_project_assignments.staffing_owner_person_id%TYPE := null;

Line 5940: ,p_assignment_id_tbl IN system.pa_num_tbl_type

5936:
5937:
5938: PROCEDURE Mass_Exec_Update_Assignments
5939: ( p_asgn_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
5940: ,p_assignment_id_tbl IN system.pa_num_tbl_type
5941: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
5942: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
5943: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
5944: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

Line 6184: ,p_assignment_id_tbl IN system.pa_num_tbl_type

6180:
6181:
6182: PROCEDURE Mass_Update_Assignments
6183: ( p_update_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
6184: ,p_assignment_id_tbl IN system.pa_num_tbl_type
6185: ,p_assignment_type IN pa_project_assignments.assignment_type%TYPE := FND_API.G_MISS_CHAR
6186: ,p_assignment_name IN pa_project_assignments.assignment_name%TYPE := FND_API.G_MISS_CHAR
6187: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
6188: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM

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

6251: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
6252: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
6253: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
6254: ,p_max_msg_count IN NUMBER := FND_API.G_MISS_NUM
6255: ,x_success_assignment_id_tbl OUT NOCOPY system.pa_num_tbl_type -- For 1159 mandate changes bug#2674619
6256: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6257: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6258: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6259: )

Line 6263: l_assignment_id_tbl system.pa_num_tbl_type;

6259: )
6260: IS
6261:
6262:
6263: l_assignment_id_tbl system.pa_num_tbl_type;
6264:
6265: l_subteam_party_id NUMBER;
6266: l_description pa_project_assignments.description%TYPE := NULL;
6267: l_additional_info pa_project_assignments.additional_information%TYPE := NULL;