[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:
735: ,DECODE(rbs_dummy.rbs_elem_id, 'OLD' , 0-pbl.revenue, 'NEW', pbl.revenue)
736: ,DECODE(rbs_dummy.rbs_elem_id, 'OLD' , 0-pbl.quantity, 'NEW', pbl.quantity)
737: ,pra.resource_class_code
738: ,pra.rate_based_flag
739: FROM pa_projects_all p
740: ,pa_resource_assignments pra
741: ,pa_budget_versions pbv
742: ,pa_proj_fp_options pfo
743: ,pa_rbs_plans_out_tmp tmp
836: ,pbl.revenue
837: ,pbl.quantity
838: ,pra.resource_class_code
839: ,pra.rate_based_flag
840: FROM pa_projects_all p
841: ,pa_resource_assignments pra
842: ,pa_budget_versions pbv
843: ,pa_proj_fp_options pfo
844: ,pa_fp_ra_map_tmp tmp
931: ,p_revenue_tbl(i)
932: ,p_quantity_tbl(i)
933: ,p_res_class_code_tbl(i)
934: ,p_rate_based_flag_tbl(i)
935: FROM pa_projects_all p,
936: pa_proj_fp_options pfo,
937: pa_budget_versions pbv
938: WHERE p.project_id=pbv.project_id
939: AND pbv.budget_version_id=p_budget_version_id
1021: ,pbl.revenue * p_qty_sign
1022: ,pbl.quantity * p_qty_sign
1023: ,pra.resource_class_code
1024: ,pra.rate_based_flag
1025: FROM pa_projects_all p,
1026: pa_proj_fp_options pfo,
1027: pa_budget_versions pbv,
1028: pa_budget_lines pbl,
1029: pa_resource_assignments pra