[Home] [Help]
312: print_time ( ' get_summarized_data 0002 ' ) ;
313:
314: SELECT ORG_ID
315: INTO l_org_id
316: FROM pa_projects_all
317: WHERE project_id = p_project_id;
318:
319: IF l_calendar_type ='A' then
320: l_end_period_id :=-1;
478:
479: --Get org for the project
480: SELECT ORG_ID
481: INTO l_org_id(i)
482: FROM pa_projects_all
483: WHERE project_id = p_project_ids(i);
484: print_time ( ' get_summarized_data 0004.1 ' || l_org_id(i) || ' l_calendar_type ' || l_calendar_type(i) ) ;
485:
486: -------------------------------
1669: -- OLAP START
1670:
1671: select nvl(p.pjt_rollup_enabled_flag , 'N' ), p.cbs_enable_flag -- SCOPE_00 Added getting cbs_enabled_flag say l_cbs_enabled_flag
1672: into l_pjt_rollup_enabled_flag, l_cbs_enabled_flag
1673: from pa_projects_all p
1674: where p.project_id = p_project_id;
1675:
1676: -- OLAP END
1677:
1902:
1903: BEGIN
1904: SELECT ORG_ID
1905: INTO l_org_id
1906: FROM pa_projects_all
1907: WHERE project_id = p_project_id ;
1908:
1909: IF L_CAL_TYPE IN ('P', 'G') THEN -- retrieve CAL_PERIOD_ID only if calander_type is 'P' or 'G'
1910: SELECT cal.CAL_PERIOD_ID
2836: 0 TXN_MASK,
2837: decode (p1.project_currency_code , fact.currency_code,1,0) PRJ_MASK,
2838: decode (p1.projfunc_currency_code , fact.currency_code,1,0) POU_MASK
2839: from
2840: pa_projects_all p1 ,
2841: pa_ppr_obj_tmp_view obj1,
2842: pa_pjt_wbs_fact fact
2843: where 1 = 1
2844: AND p1.project_id = p_project_id
2977:
2978: -- since project_id is changed to negative value , the downstream code will not process new ppr enabled projects .
2979:
2980: update pji_plan_extr_tmp t1
2981: set t1.project_id = ( select -1*p.project_id from pa_projects_all p where p.project_id = t1.project_id
2982: and nvl(p.pjt_rollup_enabled_flag,'N') = 'Y' )
2983: where exists
2984: ( select 'x' from pa_projects_all p2 where p2.project_id = t1.project_id and nvl(p2.pjt_rollup_enabled_flag,'N') = 'Y' );
2985:
2980: update pji_plan_extr_tmp t1
2981: set t1.project_id = ( select -1*p.project_id from pa_projects_all p where p.project_id = t1.project_id
2982: and nvl(p.pjt_rollup_enabled_flag,'N') = 'Y' )
2983: where exists
2984: ( select 'x' from pa_projects_all p2 where p2.project_id = t1.project_id and nvl(p2.pjt_rollup_enabled_flag,'N') = 'Y' );
2985:
2986: IF (p_delete_flag = 'Y') THEN -- satya
2987:
2988: PRINT_TIME ( ' populate_workplan_data 0003.10 ' ) ;
3461: sum(decode(p.project_currency_code,
3462: fact.currency_code, decode(fact.plan_version_id, WK_PLAN_VER_ID, fact.ETC_labor_raw_cost, 0 ))) P_ETC_LBR_RAW_COST,
3463: sum(decode(p.project_currency_code,
3464: fact.currency_code,decode(fact.plan_version_id, WK_PLAN_VER_ID, fact.ETC_equip_raw_cost, 0 ))) P_ETC_EQP_RAW_COST
3465: from pji_plan_extr_tmp tmp, pa_pjt_wbs_fact fact, pa_projects_all p
3466: where -1*tmp.project_id = fact.project_id
3467: and tmp.WK_PLAN_VER_ID = fact.plan_version_id
3468: and p.project_id = fact.project_id
3469: and fact.wbs_rollup_flag = 'Y'
3592: SELECT DECODE(NVL(NVL(fp.cost_time_phased_code, fp.revenue_time_phased_code ), fp.all_time_phased_code), 'G', 'G', 'P', 'P', 'A') calendar_type,
3593: pa.ORG_ID
3594: FROM
3595: pa_proj_fp_options fp,
3596: pa_projects_all pa
3597: WHERE 1=1
3598: and pa.project_id=fp.project_id
3599: and pa.project_id=tmp.project_id
3600: and fp.fin_plan_option_level_code = 'PLAN_VERSION'
4452: 'INDIRECT', 'I'),
4453: prj.PROJECT_CURRENCY_CODE,
4454: null
4455: from
4456: PA_PROJECTS_ALL prj,
4457: PA_PROJECT_TYPES_ALL pt
4458: where
4459: -- We cannot depend on extraction start date as it will not be
4460: -- set at the time of upgrade.