[Home] [Help]
81: - Add/Update Planning Transactions API
82:
83: =======================================================================*/
84: PROCEDURE Get_Res_Class_Rlm_Ids
85: (p_project_id IN pa_projects_all.project_id%TYPE,
86: p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE,
87: x_people_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
88: x_equip_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
89: x_fin_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
245: -- Added New I/p params p_planning_start_date_tbl and x_planning_end_date_tbl -- 3793623
246: -- Dates will not be defaulted if they are passed to the API at a particular index.
247:
248: PROCEDURE get_default_planning_dates
249: ( p_project_id IN pa_projects_all.project_id%TYPE
250: ,p_element_version_id_tbl IN SYSTEM.pa_num_tbl_type
251: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
252: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
253: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
448:
449: */
450: SELECT start_date,decode(start_date, null, to_Date(null), completion_date)
451: INTO l_parent_struct_st_dt ,l_parent_struct_end_dt
452: FROM pa_projects_all
453: where project_id = p_project_id;
454:
455: IF l_parent_struct_st_dt IS NULL AND l_parent_struct_end_dt IS NULL THEN
456:
738: ,DECODE(rbs_dummy.rbs_elem_id, 'OLD' , 0-pbl.quantity, 'NEW', pbl.quantity)
739: ,pra.resource_class_code
740: ,pra.rate_based_flag
741: ,pra.CBS_ELEMENT_ID
742: FROM pa_projects_all p
743: ,pa_resource_assignments pra
744: ,pa_budget_versions pbv
745: ,pa_proj_fp_options pfo
746: ,pa_rbs_plans_out_tmp tmp
841: ,pbl.quantity
842: ,pra.resource_class_code
843: ,pra.rate_based_flag
844: ,pra.CBS_ELEMENT_ID
845: FROM pa_projects_all p
846: ,pa_resource_assignments pra
847: ,pa_budget_versions pbv
848: ,pa_proj_fp_options pfo
849: ,pa_fp_ra_map_tmp tmp
971: ,p_quantity_tbl(i)
972: ,p_res_class_code_tbl(i)
973: ,p_rate_based_flag_tbl(i)
974: ,p_cbs_element_id_tbl(i)
975: FROM pa_projects_all p,
976: pa_proj_fp_options pfo,
977: pa_budget_versions pbv
978: WHERE p.project_id=pbv.project_id
979: AND pbv.budget_version_id=p_budget_version_id
1064: ,pbl.quantity * p_qty_sign
1065: ,pra.resource_class_code
1066: ,pra.rate_based_flag
1067: ,pra.CBS_ELEMENT_ID
1068: FROM pa_projects_all p,
1069: pa_proj_fp_options pfo,
1070: pa_budget_versions pbv,
1071: pa_budget_lines pbl,
1072: pa_resource_assignments pra