353:
354:
355:
356: PROCEDURE get_summarized_data (
357: p_project_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
358: p_resource_list_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
359: p_struct_ver_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
360: p_start_date IN DATE := NULL,
361: p_end_date IN SYSTEM.pa_date_tbl_type := system.pa_date_tbl_type(),
354:
355:
356: PROCEDURE get_summarized_data (
357: p_project_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
358: p_resource_list_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
359: p_struct_ver_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
360: p_start_date IN DATE := NULL,
361: p_end_date IN SYSTEM.pa_date_tbl_type := system.pa_date_tbl_type(),
362: p_start_period_name IN VARCHAR2 := NULL,
355:
356: PROCEDURE get_summarized_data (
357: p_project_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
358: p_resource_list_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
359: p_struct_ver_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
360: p_start_date IN DATE := NULL,
361: p_end_date IN SYSTEM.pa_date_tbl_type := system.pa_date_tbl_type(),
362: p_start_period_name IN VARCHAR2 := NULL,
363: p_end_period_name IN VARCHAR2 := NULL,
373: l_end_period_id NUMBER;
374: l_period_type_id NUMBER;
375: l_org_id NUMBER;
376: End of workplan progress */
377: l_end_period_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Added for workplan progress */
378: l_currency_mask NUMBER;
379: l_period_type_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();/*Added for workplan progress */
380: l_periodic_flag VARCHAR2(1);
381: l_planres_level_flag VARCHAR2(1);
375: l_org_id NUMBER;
376: End of workplan progress */
377: l_end_period_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); /* Added for workplan progress */
378: l_currency_mask NUMBER;
379: l_period_type_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();/*Added for workplan progress */
380: l_periodic_flag VARCHAR2(1);
381: l_planres_level_flag VARCHAR2(1);
382: l_task_level_flag VARCHAR2(1);
383: l_task_rollup_flag VARCHAR2(1);
384: l_proj_level_flag VARCHAR2(1);
385: l_summarized_flag VARCHAR2(1);
386: l_msg_count NUMBER;
387: l_calendar_type SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
388: l_org_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();/*Added for workplan progress */
389: l_map_resource_list EXCEPTION;
390: l_get_summarized_data varchar2(1) :='Y';
391: l_summ_hasrun varchar2(1) :='N';
392:
2902: p_program_rollup_flag IN VARCHAR2 := 'N',
2903: x_return_status OUT NOCOPY VARCHAR2,
2904: x_msg_code OUT NOCOPY VARCHAR2 ) IS
2905:
2906: l_project_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type ();
2907: l_wk_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2908: l_lpb_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2909: l_base_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2910: l_cal_type_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2903: x_return_status OUT NOCOPY VARCHAR2,
2904: x_msg_code OUT NOCOPY VARCHAR2 ) IS
2905:
2906: l_project_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type ();
2907: l_wk_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2908: l_lpb_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2909: l_base_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2910: l_cal_type_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2911: l_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2904: x_msg_code OUT NOCOPY VARCHAR2 ) IS
2905:
2906: l_project_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type ();
2907: l_wk_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2908: l_lpb_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2909: l_base_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2910: l_cal_type_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2911: l_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2912: l_end_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2905:
2906: l_project_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type ();
2907: l_wk_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2908: l_lpb_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2909: l_base_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2910: l_cal_type_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2911: l_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2912: l_end_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2913:
2907: l_wk_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2908: l_lpb_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2909: l_base_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2910: l_cal_type_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2911: l_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2912: l_end_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2913:
2914: l_org_id NUMBER;
2915: l_return_status VARCHAR2(1);
2908: l_lpb_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2909: l_base_struct_ver_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2910: l_cal_type_tbl SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
2911: l_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2912: l_end_period_id_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
2913:
2914: l_org_id NUMBER;
2915: l_return_status VARCHAR2(1);
2916:
4610: AND fpo.fin_plan_option_level_code = 'PLAN_VERSION'
4611: AND bv.version_type IN ( 'ALL' , 'COST' , 'REVENUE')
4612: AND fpo.RBS_VERSION_ID = l_rbs_version_id;
4613:
4614: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4615: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4616: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4617: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4618:
4611: AND bv.version_type IN ( 'ALL' , 'COST' , 'REVENUE')
4612: AND fpo.RBS_VERSION_ID = l_rbs_version_id;
4613:
4614: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4615: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4616: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4617: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4618:
4619: BEGIN
4612: AND fpo.RBS_VERSION_ID = l_rbs_version_id;
4613:
4614: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4615: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4616: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4617: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4618:
4619: BEGIN
4620:
4613:
4614: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4615: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4616: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4617: l_txn_accum_header_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4618:
4619: BEGIN
4620:
4621: x_msg_count := 0;
4719: x_return_status OUT NOCOPY VARCHAR2,
4720: x_msg_code OUT NOCOPY VARCHAR2) IS
4721:
4722: l_struct_element_id NUMBER;
4723: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4724: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4725: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4726: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type :=
4727: SYSTEM.pa_varchar2_1_tbl_type();
4720: x_msg_code OUT NOCOPY VARCHAR2) IS
4721:
4722: l_struct_element_id NUMBER;
4723: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4724: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4725: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4726: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type :=
4727: SYSTEM.pa_varchar2_1_tbl_type();
4728: l_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
4721:
4722: l_struct_element_id NUMBER;
4723: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4724: l_resource_list_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4725: l_struct_ver_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
4726: l_calendar_type_tab SYSTEM.pa_varchar2_1_tbl_type :=
4727: SYSTEM.pa_varchar2_1_tbl_type();
4728: l_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
4729: