2008:
2009: l_version_is_baselined VARCHAR2(1);
2010:
2011: -- bug 4914055: added the followings:
2012: l_budget_line_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2013: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2014: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2015: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2016: l_last_update_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2009: l_version_is_baselined VARCHAR2(1);
2010:
2011: -- bug 4914055: added the followings:
2012: l_budget_line_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2013: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2014: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2015: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2016: l_last_update_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2017: l_last_updated_by_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2010:
2011: -- bug 4914055: added the followings:
2012: l_budget_line_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2013: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2014: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2015: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2016: l_last_update_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2017: l_last_updated_by_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2018: l_creation_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2013: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2014: l_resource_assignment_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2015: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2016: l_last_update_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2017: l_last_updated_by_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2018: l_creation_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2019: l_created_by_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2020: l_last_update_login_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2021: l_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2015: l_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2016: l_last_update_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2017: l_last_updated_by_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2018: l_creation_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2019: l_created_by_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2020: l_last_update_login_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2021: l_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2022: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2023: l_quantity_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2016: l_last_update_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2017: l_last_updated_by_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2018: l_creation_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2019: l_created_by_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2020: l_last_update_login_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2021: l_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2022: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2023: l_quantity_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2024: l_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2019: l_created_by_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2020: l_last_update_login_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2021: l_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2022: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2023: l_quantity_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2024: l_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2025: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2026: l_revenue_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2027: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2020: l_last_update_login_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2021: l_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2022: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2023: l_quantity_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2024: l_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2025: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2026: l_revenue_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2027: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2028: l_description_tbl SYSTEM.pa_varchar2_2000_tbl_type:=SYSTEM.pa_varchar2_2000_tbl_type();
2021: l_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
2022: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2023: l_quantity_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2024: l_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2025: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2026: l_revenue_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2027: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2028: l_description_tbl SYSTEM.pa_varchar2_2000_tbl_type:=SYSTEM.pa_varchar2_2000_tbl_type();
2029: l_attribute_category_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2022: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2023: l_quantity_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2024: l_raw_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2025: l_burdened_cost_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2026: l_revenue_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2027: l_change_reason_code_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2028: l_description_tbl SYSTEM.pa_varchar2_2000_tbl_type:=SYSTEM.pa_varchar2_2000_tbl_type();
2029: l_attribute_category_tbl SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
2030: l_attribute1_tbl SYSTEM.pa_varchar2_150_tbl_type:=SYSTEM.pa_varchar2_150_tbl_type();