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_PPR_ROLLUP_PERIOD_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17


	 -- insert into sri_log values ( fnd_log_messages_s.nextval, p_msg);

Line: 66


 delete from pa_pjt_fact_period;

Line: 503


	SELECT    /*+ ordered  */
		ra.rate_based_flag           billable_flag ,
		to_number(to_char(bl.start_date,'YYYYMMDD'))  wbs_element_id ,
 -- ra.task_id wbs_element_id ,
  ra.resource_class_code resource_class ,
  sum(nvl(bl.project_raw_cost,0))   ,
  sum(nvl(bl.project_burdened_COST,0))   ,
  sum(nvl(bl.project_revenue,0))  ,
  sum(nvl(bl.project_init_raw_cost,0))   ,
  sum(nvl(bl.project_init_burdened_cost,0))   ,
  sum(nvl(bl.project_init_revenue,0))    ,
  sum(  decode( l_version_type,'FINANCIAL', nvl(bl.project_raw_cost,0) -  nvl(bl.project_init_raw_cost,0), 0)  )  ,
  sum(decode( l_version_type,'FINANCIAL', nvl(bl.project_burdened_COST,0) -  nvl(bl.project_init_burdened_cost,0), 0))    ,
  sum(nvl(bl.raw_cost,0) )  func_raw_cost,
  sum(nvl(bl.burdened_COST,0)) func_BRDN_COST ,
  sum(nvl(bl.revenue,0)) func_revenue ,
  sum(nvl(bl.init_raw_cost,0))  func_actual_raw_cost ,
  sum(nvl(bl.init_burdened_cost,0))  func_actual_brdn_cost ,
  sum(nvl(bl.init_revenue,0))  func_actual_revenue ,
  sum(decode( l_version_type,'FINANCIAL', nvl(bl.raw_cost,0) -  nvl(bl.init_raw_cost,0), 0))  func_etc_raw_cost ,
  sum(decode( l_version_type,'FINANCIAL', nvl(bl.burdened_COST,0) -  nvl(bl.init_burdened_cost,0), 0))  func_etc_brdn_cost ,
  sum(nvl(bl.quantity,0) ) quantity,
  sum(nvl(bl.init_quantity,0))  actual_quantity ,
  sum(decode( l_version_type,'FINANCIAL', nvl(bl.quantity,0) -  nvl(bl.init_quantity,0), 0))  etc_quantity ,
'/'||to_number(to_char(bl.start_date,'YYYYMMDD'))  ,
	1 ,
	1  wbs_level
FROM PA_RESOURCE_ASSIGNMENTS ra ,
  PA_BUDGET_LINES bl ,
  pa_ppr_obj_tmp b
WHERE   ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
and ra.budget_version_id = l_budget_version_id
and ra.task_id = b.object_id
group by
ra.rate_based_flag  ,
 to_number(to_char(bl.start_date,'YYYYMMDD')),
   ra.resource_class_code,
  '/'||to_number(to_char(bl.start_date,'YYYYMMDD'))  ;

Line: 549


	SELECT    /*+ ordered  */
		ra.rate_based_flag           billable_flag ,
  to_number(to_char(bl.start_date,'YYYYMMDD'))    rbs_element_id ,
  ra.resource_class_code resource_class ,
  sum(nvl(bl.project_raw_cost,0))   ,
  sum(nvl(bl.project_burdened_COST,0))   ,
  sum(nvl(bl.project_revenue,0))  ,
  sum(nvl(bl.project_init_raw_cost,0))   ,
  sum(nvl(bl.project_init_burdened_cost,0))   ,
  sum(nvl(bl.project_init_revenue,0))    ,
 sum(  decode( l_version_type,'FINANCIAL', nvl(bl.project_raw_cost,0) -  nvl(bl.project_init_raw_cost,0), 0)  )  ,
  sum(decode( l_version_type,'FINANCIAL', nvl(bl.project_burdened_COST,0) -  nvl(bl.project_init_burdened_cost,0), 0))    ,
  sum(nvl(bl.raw_cost,0) )  func_raw_cost,
  sum(nvl(bl.burdened_COST,0)) func_BRDN_COST ,
  sum(nvl(bl.revenue,0)) func_revenue ,
  sum(nvl(bl.init_raw_cost,0))  func_actual_raw_cost ,
  sum(nvl(bl.init_burdened_cost,0))  func_actual_brdn_cost ,
  sum(nvl(bl.init_revenue,0))  func_actual_revenue ,
   sum(decode( l_version_type,'FINANCIAL', nvl(bl.raw_cost,0) -  nvl(bl.init_raw_cost,0), 0))  func_etc_raw_cost ,
  sum(decode( l_version_type,'FINANCIAL', nvl(bl.burdened_COST,0) -  nvl(bl.init_burdened_cost,0), 0))  func_etc_brdn_cost ,
  sum(nvl(bl.quantity,0) ) quantity,
  sum(nvl(bl.init_quantity,0))  actual_quantity ,
  sum(decode( l_version_type,'FINANCIAL', nvl(bl.quantity,0) -  nvl(bl.init_quantity,0), 0))  etc_quantity ,
'/'||to_number(to_char(bl.start_date,'YYYYMMDD'))  ,
	1 ,
	1  wbs_level
FROM PA_RESOURCE_ASSIGNMENTS ra ,
  PA_BUDGET_LINES bl ,
  pa_ppr_obj_tmp b
WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
and ra.budget_version_id = l_budget_version_id
and (
    ( p_fact_slice = 'RBS' AND ra.rbs_element_id = b.object_id )
	OR
	( p_fact_slice = 'CBS' AND ra.cbs_element_id = b.object_id )
)
group by
	ra.rate_based_flag,
  to_number(to_char(bl.start_date,'YYYYMMDD')) ,
   ra.resource_class_code,
   '/'||to_number(to_char(bl.start_date,'YYYYMMDD'));

Line: 594


	SELECT    /*+ ordered  */
		ra.rate_based_flag           billable_flag ,
    to_number(to_char(bl.start_date,'YYYYMMDD')) rbs_element_id ,
  ra.resource_class_code resource_class ,
  sum(nvl(bl.project_raw_cost,0))   ,
  sum(nvl(bl.project_burdened_COST,0))   ,
  sum(nvl(bl.project_revenue,0))  ,
  sum(nvl(bl.project_init_raw_cost,0))   ,
  sum(nvl(bl.project_init_burdened_cost,0))   ,
  sum(nvl(bl.project_init_revenue,0))    ,
  sum(nvl(bl.project_raw_cost,0)      - nvl(bl.project_init_raw_cost,0))    ,
  sum(nvl(bl.project_burdened_cost,0) - nvl(bl.project_init_burdened_cost,0))    ,
  sum(nvl(bl.raw_cost,0) )  func_raw_cost,
  sum(nvl(bl.burdened_COST,0)) func_BRDN_COST ,
  sum(nvl(bl.revenue,0)) func_revenue ,
  sum(nvl(bl.init_raw_cost,0))  func_actual_raw_cost ,
  sum(nvl(bl.init_burdened_cost,0))  func_actual_brdn_cost ,
  sum(nvl(bl.init_revenue,0))  func_actual_revenue ,
  sum(nvl(bl.raw_cost,0)      - nvl(bl.init_raw_cost,0))  func_etc_raw_cost ,
  sum(nvl(bl.burdened_cost,0) - nvl(bl.init_burdened_cost,0))  func_etc_brdn_cost ,
  sum(nvl(bl.quantity,0) ) quantity,
  sum(nvl(bl.init_quantity,0))  actual_quantity ,
  sum(nvl(bl.quantity,0) - nvl(bl.init_quantity,0))  etc_quantity ,
 '/'||to_number(to_char(bl.start_date,'YYYYMMDD'))  ,
	1 ,
	1  wbs_level
FROM PA_RESOURCE_ASSIGNMENTS ra ,
  PA_BUDGET_LINES bl ,
  pa_ppr_obj_tmp c,
  pa_ppr_obj_tmp2 b
WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
and ra.budget_version_id = l_budget_version_id
and ra.task_id = c.object_id
and (
       (  p_fact_slice = 'WBS_TO_RBS'   AND ra.rbs_element_id = b.object_id ) OR
	   (  p_fact_slice = 'WBS_TO_CBS'   AND ra.cbs_element_id = b.object_id )
	)
group by
	ra.rate_based_flag  ,
   to_number(to_char(bl.start_date,'YYYYMMDD')),
   ra.resource_class_code,
  '/'||to_number(to_char(bl.start_date,'YYYYMMDD'))  ;

Line: 639


	SELECT    /*+ ordered  */
		ra.rate_based_flag           billable_flag ,
  to_number(to_char(bl.start_date,'YYYYMMDD'))  task_id ,
  ra.resource_class_code resource_class ,
  sum(nvl(bl.project_raw_cost,0))   ,
  sum(nvl(bl.project_burdened_COST,0))   ,
  sum(nvl(bl.project_revenue,0))  ,
  sum(nvl(bl.project_init_raw_cost,0))   ,
  sum(nvl(bl.project_init_burdened_cost,0))   ,
  sum(nvl(bl.project_init_revenue,0))    ,
  sum(nvl(bl.project_raw_cost,0)      - nvl(bl.project_init_raw_cost,0))    ,
  sum(nvl(bl.project_burdened_cost,0) - nvl(bl.project_init_burdened_cost,0))    ,
  sum(nvl(bl.raw_cost,0) )  func_raw_cost,
  sum(nvl(bl.burdened_COST,0)) func_BRDN_COST ,
  sum(nvl(bl.revenue,0)) func_revenue ,
  sum(nvl(bl.init_raw_cost,0))  func_actual_raw_cost ,
  sum(nvl(bl.init_burdened_cost,0))  func_actual_brdn_cost ,
  sum(nvl(bl.init_revenue,0))  func_actual_revenue ,
  sum(nvl(bl.raw_cost,0)      - nvl(bl.init_raw_cost,0))  func_etc_raw_cost ,
  sum(nvl(bl.burdened_cost,0) - nvl(bl.init_burdened_cost,0))  func_etc_brdn_cost ,
  sum(nvl(bl.quantity,0) ) quantity,
  sum(nvl(bl.init_quantity,0))  actual_quantity ,
  sum(nvl(bl.quantity,0) - nvl(bl.init_quantity,0))  etc_quantity ,
'/'||to_number(to_char(bl.start_date,'YYYYMMDD'))  ,
	1 ,
	1  wbs_level
FROM PA_RESOURCE_ASSIGNMENTS ra ,
  PA_BUDGET_LINES bl ,
  pa_ppr_obj_tmp c,
  pa_ppr_obj_tmp2 b
WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
and ra.budget_version_id = l_budget_version_id
and ra.rbs_element_id = c.object_id
and ra.task_id = b.object_id
group by
	ra.rate_based_flag  ,
   to_number(to_char(bl.start_date,'YYYYMMDD')),
   ra.resource_class_code,
  '/'||to_number(to_char(bl.start_date,'YYYYMMDD')) ;

Line: 682


	SELECT    /*+ ordered  */
		ra.rate_based_flag           billable_flag ,
   to_number(to_char(bl.start_date,'YYYYMMDD'))  element_id ,
  ra.resource_class_code resource_class ,
  sum(nvl(bl.project_raw_cost,0))   ,
  sum(nvl(bl.project_burdened_COST,0))   ,
  sum(nvl(bl.project_revenue,0))  ,
  sum(nvl(bl.project_init_raw_cost,0))   ,
  sum(nvl(bl.project_init_burdened_cost,0))   ,
  sum(nvl(bl.project_init_revenue,0))    ,
  sum(nvl(bl.project_raw_cost,0)      - nvl(bl.project_init_raw_cost,0))    ,
  sum(nvl(bl.project_burdened_cost,0) - nvl(bl.project_init_burdened_cost,0))    ,
  sum(nvl(bl.raw_cost,0) )  func_raw_cost,
  sum(nvl(bl.burdened_COST,0)) func_BRDN_COST ,
  sum(nvl(bl.revenue,0)) func_revenue ,
  sum(nvl(bl.init_raw_cost,0))  func_actual_raw_cost ,
  sum(nvl(bl.init_burdened_cost,0))  func_actual_brdn_cost ,
  sum(nvl(bl.init_revenue,0))  func_actual_revenue ,
  sum(nvl(bl.raw_cost,0)      - nvl(bl.init_raw_cost,0))  func_etc_raw_cost ,
  sum(nvl(bl.burdened_cost,0) - nvl(bl.init_burdened_cost,0))  func_etc_brdn_cost ,
  sum(nvl(bl.quantity,0) ) quantity,
  sum(nvl(bl.init_quantity,0))  actual_quantity ,
  sum(nvl(bl.quantity,0) - nvl(bl.init_quantity,0))  etc_quantity ,
'/'||to_number(to_char(bl.start_date,'YYYYMMDD'))  ,
	1 ,
	1  wbs_level
FROM PA_RESOURCE_ASSIGNMENTS ra ,
  PA_BUDGET_LINES bl ,
  pa_ppr_obj_tmp c,
  pa_ppr_obj_tmp2 b
WHERE ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
and ra.budget_version_id = l_budget_version_id
and ra.cbs_element_id  = c.object_id
and (
       (  p_fact_slice = 'CBS_TO_RBS'   AND ra.rbs_element_id = b.object_id ) OR
	   (  p_fact_slice = 'CBS_TO_WBS'   AND ra.task_id = b.object_id )
	)
group by
	ra.rate_based_flag  ,
   to_number(to_char(bl.start_date,'YYYYMMDD')),
   ra.resource_class_code,
  '/'||to_number(to_char(bl.start_date,'YYYYMMDD'));

Line: 731


	SELECT   object_id
	  FROM  pa_ppr_obj_tmp  r
	  START WITH  r.parent_object_id = l_object_id CONNECT BY
	  PRIOR  r.object_id =  r.parent_object_id;

Line: 737


	SELECT   object_id
	  FROM  pa_ppr_obj_tmp2  r
	  START WITH  r.parent_object_id  = l_object_id_2	  CONNECT BY
	  PRIOR  r.object_id =  r.parent_object_id ;

Line: 769


	select count(*) into  l_count1
	from pa_pjt_fact_period
	where plan_version_id = p_budget_version_id
	and rownum = 1 ;

Line: 785


	--	 delete from pa_pjt_fact_period;  -- SRI_BUG

Line: 868


       select project_currency_code , projfunc_currency_code
	   into l_project_currency, l_functional_currency
       from pa_projects_All
	   where project_id = l_project_id;

Line: 878


	   select /*+ ordered */ distinct decode(bud.fin_plan_type_id,10,'WORKPLAN','FINANCIAL') ,
	   s.element_version_id, s.proj_element_id
	   into l_version_type , l_struct_ver_id , l_struct_elem_id
	   from pa_budget_versions bud,
	        pa_proj_elem_ver_structure s,
            pa_proj_structure_types ppst,
            pa_structure_types pst
       where
            bud.budget_version_id = l_budget_version_id
	   and  s.proj_element_id = ppst.proj_element_id (+)
	   and ppst.structure_type_id = pst.structure_type_id  (+)
	   and pst.structure_type_class_code (+) = 'WORKPLAN'
	   and bud.project_structure_version_id = s.element_version_id (+);

Line: 897


	   select /*+ ordered */
	   distinct 0, s.proj_element_id
	   into l_struct_ver_id , l_struct_elem_id
	   from
	        pa_proj_elem_ver_structure s,
            pa_proj_structure_types ppst,
            pa_structure_types pst
       where
            s.project_id = l_project_id
	   and  s.proj_element_id = ppst.proj_element_id
	   and ppst.structure_type_id = pst.structure_type_id
	   and   pst.structure_type_class_code   = 'FINANCIAL';

Line: 932


delete from pa_ppr_obj_tmp2;

Line: 933


delete from pa_ppr_obj_tmp;

Line: 939


       insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
      select  /*+ ordered */
	  a.proj_element_id , nvl(c.proj_element_id,l_struct_elem_id)
       from PA_PROJ_ELEMENT_VERSIONS a   ,  pa_object_relationships b  ,  PA_PROJ_ELEMENT_VERSIONS  c
        where a.project_id = l_project_id
		and a.object_type  = 'PA_TASKS'  -- SRI_BUG2
		and a.parent_structure_version_id = l_struct_ver_id
		and a.element_version_id = b.object_id_to1  (+)
         and b.object_type_From (+)  = 'PA_TASKS'
		 and b.relationship_type (+) = 'S'
     and b.object_id_from1 = c.element_version_id (+) ;

Line: 956


       insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
      select  /*+ ordered */
	   p.task_id , nvl(p.parent_task_id, l_struct_elem_id )
       from pa_tasks p
        where p.project_id = l_project_id ;

Line: 991


    insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
		 select rbs_element_id , nvl(parent_element_id,l_rbs_cbs_version_id)
         from pa_rbs_elements
	     where rbs_version_id = l_rbs_cbs_version_id_2;

Line: 1010


	    insert into pa_ppr_obj_tmp ( object_id , parent_object_id )
		 select rbs_element_id , nvl(parent_element_id,l_rbs_cbs_version_id_2)
         from pa_rbs_elements
	     where rbs_version_id = l_rbs_cbs_version_id ;

Line: 1025


       insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
      select  /*+ ordered */
	  a.proj_element_id , nvl(c.proj_element_id,l_struct_elem_id)
       from PA_PROJ_ELEMENT_VERSIONS a   ,  pa_object_relationships b  ,  PA_PROJ_ELEMENT_VERSIONS  c
        where a.project_id = l_project_id
		and a.object_type  = 'PA_TASKS'  -- SRI_BUG2
		and a.parent_structure_version_id = l_struct_ver_id
		and a.element_version_id = b.object_id_to1  (+)
         and b.object_type_From (+)  = 'PA_TASKS'
		 and b.relationship_type (+) = 'S'
     and b.object_id_from1 = c.element_version_id (+) ;

Line: 1042


       insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
      select  /*+ ordered */
	   p.task_id , nvl(p.parent_task_id, l_struct_elem_id )
       from pa_tasks p
        where p.project_id = l_project_id ;

Line: 1064


	  insert into pa_ppr_obj_tmp2 ( object_id , parent_object_id )
		 select rbs_element_id , nvl(parent_element_id,l_rbs_cbs_version_id_2)
         from pa_rbs_elements
	     where rbs_version_id = l_rbs_cbs_version_id_2 ;

Line: 1076


		l_task_arr.delete;

Line: 1087


         delete from pa_ppr_obj_tmp ;

Line: 1090


	      INSERT INTO pa_ppr_obj_tmp ( object_id ) values ( l_task_arr(i) ) ;

Line: 1100


		   INSERT INTO pa_ppr_obj_tmp ( object_id ) values ( l_object_id ) ;

Line: 1103


         l_task_arr.delete;

Line: 1114


         delete from pa_ppr_obj_tmp2 ;

Line: 1117


	      INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_task_arr(i) ) ;

Line: 1127


		   INSERT INTO pa_ppr_obj_tmp2 ( object_id ) values ( l_object_id_2 ) ;

Line: 1131


        l_task_arr.delete;

Line: 1132


		l_task_level_arr.delete;

Line: 1133


		l_connect_path_arr.delete;

Line: 1134


		l_leaf_node_arr.delete;

Line: 1243


	l_out_qty1_arr.delete;l_out_qty2_arr.delete;l_out_qty3_arr.delete;l_out_labor_qty1_arr.delete;

Line: 1244


	l_out_labor_qty2_arr.delete;l_out_labor_qty3_arr.delete;

Line: 1246


	l_out_equip_qty1_arr.delete;l_out_equip_qty2_arr.delete;l_out_equip_qty3_arr.delete;

Line: 1248


	l_out_amount1_arr.delete;l_out_amount2_arr.delete;l_out_amount3_arr.delete;

Line: 1249


	l_out_amount4_arr.delete;l_out_amount5_arr.delete;l_out_amount6_arr.delete;

Line: 1250


	l_out_amount7_arr.delete;l_out_amount8_arr.delete;

Line: 1253


	l_out_bill_labor_Qty1_arr.delete;l_out_bill_equip_Qty1_arr.delete;l_out_bill_labor_Qty2_arr.delete;

Line: 1254


	l_out_bill_equip_Qty2_arr.delete;l_out_bill_labor_Qty3_arr.delete;l_out_bill_equip_Qty3_arr.delete;

Line: 1255


	l_out_bill_amt1_arr.delete;l_out_bill_amt2_arr.delete;l_out_bill_labor_amt1_arr.delete;

Line: 1256


	l_out_bill_labor_amt2_arr.delete;l_out_equip_amt1_arr.delete;l_out_equip_amt2_arr.delete;

Line: 1257


	l_out_capit_amt1_arr.delete;l_out_capit_amt2_arr.delete;l_out_labor_amt1_arr.delete;

Line: 1258


	l_out_labor_amt2_arr.delete;

Line: 1260


	l_out_labor_amt3_arr.delete;l_out_labor_amt4_arr.delete;l_out_labor_amt5_arr.delete;l_out_labor_amt6_arr.delete;

Line: 1261


	l_out_labor_amt7_arr.delete;l_out_labor_amt8_arr.delete;

Line: 1264


	l_out_equip_amt3_arr.delete;l_out_equip_amt4_arr.delete;

Line: 1265


	l_out_equip_amt5_arr.delete;l_out_equip_amt6_arr.delete;

Line: 1266


	l_out_equip_amt7_arr.delete;l_out_equip_amt8_arr.delete;

Line: 1432


	l_out_qty1_arr.delete;l_out_qty2_arr.delete;l_out_qty3_arr.delete;l_out_labor_qty1_arr.delete;

Line: 1433


	l_out_labor_qty2_arr.delete;l_out_labor_qty3_arr.delete;

Line: 1435


	l_out_equip_qty1_arr.delete;l_out_equip_qty2_arr.delete;l_out_equip_qty3_arr.delete;

Line: 1437


	l_out_amount1_arr.delete;l_out_amount2_arr.delete;l_out_amount3_arr.delete;

Line: 1438


	l_out_amount4_arr.delete;l_out_amount5_arr.delete;l_out_amount6_arr.delete;

Line: 1439


	l_out_amount7_arr.delete;l_out_amount8_arr.delete;

Line: 1442


	l_out_bill_labor_Qty1_arr.delete;l_out_bill_equip_Qty1_arr.delete;l_out_bill_labor_Qty2_arr.delete;

Line: 1443


	l_out_bill_equip_Qty2_arr.delete;l_out_bill_labor_Qty3_arr.delete;l_out_bill_equip_Qty3_arr.delete;

Line: 1444


	l_out_bill_amt1_arr.delete;l_out_bill_amt2_arr.delete;l_out_bill_labor_amt1_arr.delete;

Line: 1445


	l_out_bill_labor_amt2_arr.delete;l_out_equip_amt1_arr.delete;l_out_equip_amt2_arr.delete;

Line: 1446


	l_out_capit_amt1_arr.delete;l_out_capit_amt2_arr.delete;l_out_labor_amt1_arr.delete;

Line: 1447


	l_out_labor_amt2_arr.delete;

Line: 1449


	l_out_labor_amt3_arr.delete;l_out_labor_amt4_arr.delete;l_out_labor_amt5_arr.delete;l_out_labor_amt6_arr.delete;

Line: 1450


	l_out_labor_amt7_arr.delete;l_out_labor_amt8_arr.delete;

Line: 1453


	l_out_equip_amt3_arr.delete;l_out_equip_amt4_arr.delete;

Line: 1454


	l_out_equip_amt5_arr.delete;l_out_equip_amt6_arr.delete;

Line: 1455


	l_out_equip_amt7_arr.delete;l_out_equip_amt8_arr.delete;

Line: 2176


 l_upd_task_flag_arr.delete;

Line: 2177


	 l_upd_task_arr.delete;

Line: 2178


 l_upd_task_arr_2.delete;

Line: 2186


	  INSERT INTO pa_pjt_fact_period (
	  ----
       PROJECT_ID , PERIOD_ID
     , PLAN_VERSION_ID   , CURRENCY_CODE
	  ----
	  ,RAW_COST, BRDN_COST, REVENUE
	  , bill_RAW_COST, bill_BRDN_COST, bill_LABOR_RAW_COST, bill_LABOR_BRDN_COST
     , bill_LABOR_HRS, EQUIPMENT_RAW_COST, EQUIPMENT_BRDN_COST
	 --------
	 , CAPITALIZABLE_RAW_COST, CAPITALIZABLE_BRDN_COST
     , LABOR_RAW_COST, LABOR_BRDN_COST, LABOR_HRS, LABOR_REVENUE
	 , EQUIPMENT_HOURS, BILLABLE_EQUIPMENT_HOURS
	 ----
     , SUP_INV_COMMITTED_COST, PO_COMMITTED_COST, PR_COMMITTED_COST, OTH_COMMITTED_COST
	 , ACT_LABOR_HRS, ACT_EQUIP_HRS, ACT_LABOR_BRDN_COST
	 , ACT_EQUIP_BRDN_COST, ACT_BRDN_COST, ACT_RAW_COST
	 -------
     , ACT_REVENUE, ACT_LABOR_RAW_COST,ACT_EQUIP_RAW_COST
	 , ETC_LABOR_HRS, ETC_EQUIP_HRS, ETC_LABOR_BRDN_COST
	 ----
     , ETC_EQUIP_BRDN_COST, ETC_BRDN_COST, ETC_RAW_COST
	 , ETC_LABOR_RAW_COST, ETC_EQUIP_RAW_COST
	 -----
     , START_DATE
	 ----
  )
SELECT
          p_project_id ,p_fact_task_arr(i)
		 ,p_budget_version_id   , p_currency_code
		 ----
		 ----
		 , p_fact_amount1_arr(i),p_fact_amount2_arr(i),p_fact_amount3_arr(i)
		 ,p_fact_bill_amt1_arr(i),p_fact_bill_amt2_arr(i),p_fact_bill_labor_amt1_arr(i),p_fact_bill_labor_amt2_arr(i)
		 ,p_fact_bill_labor_Qty1_arr(i),p_fact_equip_amt1_arr(i),p_fact_equip_amt2_arr(i)
		 -----
		 ,p_fact_capit_amt1_arr(i),p_fact_capit_amt2_arr(i)
		 ,p_fact_labor_amt1_arr(i),p_fact_labor_amt2_arr(i),p_fact_labor_qty1_arr(i), p_fact_labor_amt3_arr(i)
		 , p_fact_equip_qty1_arr(i),p_fact_bill_equip_Qty1_arr(i)
		 ----
		 ,0,0,0,0
		 ,p_fact_labor_qty2_arr(i),p_fact_equip_qty2_arr(i),p_fact_labor_amt5_arr(i)
		 ,p_fact_equip_amt5_arr(i) ,p_fact_amount5_arr(i),p_fact_amount4_arr(i)
		 -------
		 ,p_fact_amount6_arr(i),p_fact_labor_amt4_arr(i),p_fact_equip_amt4_arr(i)
		 ,p_fact_labor_qty3_arr(i),p_fact_equip_qty3_arr(i),p_fact_labor_amt8_arr(i)
		 ----
		 ,p_fact_equip_amt8_arr(i),p_fact_amount8_arr(i),p_fact_amount7_arr(i)
		 , p_fact_labor_amt7_arr(i),p_fact_equip_amt7_arr(i)
		 -------
		 -------
		 ,to_date( to_char(p_fact_task_arr(i)),'YYYYMMDD')
       from dual ;