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_FP_WEBADI_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 472: pa_proj_fp_options fpo

468: Decode(bv.version_type, 'COST', fpo.cost_time_phased_code,
469: 'REVENUE', fpo.revenue_time_phased_code, 'ALL', fpo.all_time_phased_code) time_phased_code
470: FROM pa_budget_versions bv,
471: pa_fin_plan_types_b fpt,
472: pa_proj_fp_options fpo
473: WHERE bv.budget_version_id = c_budget_version_id
474: AND bv.budget_version_id = fpo.fin_plan_version_id
475: AND bv.project_id = fpo.project_id
476: AND bv.fin_plan_type_id = fpt.fin_plan_type_id;

Line 490: l_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;

486: l_prime_cost_fcst_flag pa_budget_versions.primary_cost_forecast_flag%TYPE;
487: l_prime_rev_fcst_flag pa_budget_versions.primary_rev_forecast_flag%TYPE;
488: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
489: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
490: l_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
491: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;
492:
493: is_periodic_layout VARCHAR2(1) := 'N';
494:

Line 1787: d_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;

1783: l_prj_cost_rate_dt_typ_mning pa_lookups.meaning%TYPE;
1784: l_prj_rev_rate_type_mning pa_conversion_types_v.user_conversion_type%TYPE;
1785: l_prj_rev_rate_date_type_mning pa_lookups.meaning%TYPE;
1786:
1787: d_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
1788: d_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
1789: d_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
1790: d_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
1791: d_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;

Line 1788: d_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;

1784: l_prj_rev_rate_type_mning pa_conversion_types_v.user_conversion_type%TYPE;
1785: l_prj_rev_rate_date_type_mning pa_lookups.meaning%TYPE;
1786:
1787: d_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
1788: d_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
1789: d_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
1790: d_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
1791: d_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;
1792: d_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

Line 1789: d_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;

1785: l_prj_rev_rate_date_type_mning pa_lookups.meaning%TYPE;
1786:
1787: d_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
1788: d_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
1789: d_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
1790: d_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
1791: d_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;
1792: d_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
1793: d_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

Line 1790: d_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

1786:
1787: d_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
1788: d_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
1789: d_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
1790: d_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
1791: d_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;
1792: d_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
1793: d_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
1794: d_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

Line 1791: d_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;

1787: d_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
1788: d_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
1789: d_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
1790: d_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
1791: d_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;
1792: d_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
1793: d_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
1794: d_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
1795: d_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

Line 1792: d_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

1788: d_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
1789: d_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
1790: d_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
1791: d_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;
1792: d_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
1793: d_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
1794: d_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
1795: d_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
1796: d_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

Line 1793: d_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

1789: d_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
1790: d_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
1791: d_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;
1792: d_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
1793: d_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
1794: d_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
1795: d_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
1796: d_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
1797: d_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

Line 1794: d_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

1790: d_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
1791: d_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;
1792: d_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
1793: d_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
1794: d_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
1795: d_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
1796: d_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
1797: d_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
1798: d_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

Line 1795: d_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

1791: d_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;
1792: d_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
1793: d_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
1794: d_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
1795: d_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
1796: d_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
1797: d_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
1798: d_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
1799: d_projfunc_cost_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 1796: d_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

1792: d_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
1793: d_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
1794: d_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
1795: d_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
1796: d_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
1797: d_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
1798: d_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
1799: d_projfunc_cost_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1800: d_projfunc_rev_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 1797: d_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

1793: d_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
1794: d_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
1795: d_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
1796: d_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
1797: d_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
1798: d_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
1799: d_projfunc_cost_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1800: d_projfunc_rev_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1801: d_project_cost_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 1798: d_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

1794: d_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
1795: d_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
1796: d_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
1797: d_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
1798: d_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
1799: d_projfunc_cost_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1800: d_projfunc_rev_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1801: d_project_cost_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1802: d_project_rev_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 1805: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;

1801: d_project_cost_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1802: d_project_rev_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1803: d_txn_curr_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1804:
1805: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
1806: l_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
1807: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
1808: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE ;
1809: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

Line 1806: l_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;

1802: d_project_rev_exc_rate_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1803: d_txn_curr_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1804:
1805: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
1806: l_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
1807: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
1808: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE ;
1809: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
1810: l_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;

Line 1807: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;

1803: d_txn_curr_tab SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
1804:
1805: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
1806: l_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
1807: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
1808: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE ;
1809: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
1810: l_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;
1811: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

Line 1809: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

1805: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;
1806: l_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
1807: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
1808: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE ;
1809: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
1810: l_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;
1811: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
1812: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE ;
1813: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

Line 1810: l_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;

1806: l_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;
1807: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
1808: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE ;
1809: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
1810: l_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;
1811: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
1812: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE ;
1813: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
1814: l_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

Line 1811: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

1807: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;
1808: l_projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE ;
1809: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
1810: l_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;
1811: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
1812: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE ;
1813: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
1814: l_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
1815: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

Line 1813: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

1809: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;
1810: l_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;
1811: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
1812: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE ;
1813: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
1814: l_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
1815: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
1816: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE ;
1817: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

Line 1814: l_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

1810: l_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;
1811: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
1812: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE ;
1813: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
1814: l_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
1815: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
1816: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE ;
1817: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
1818: l_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

Line 1815: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

1811: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;
1812: l_projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE ;
1813: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
1814: l_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
1815: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
1816: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE ;
1817: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
1818: l_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
1819: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

Line 1817: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

1813: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;
1814: l_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
1815: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
1816: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE ;
1817: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
1818: l_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
1819: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
1820: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE ;
1821: l_change_reason_code pa_budget_lines.change_reason_code%TYPE ;

Line 1818: l_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

1814: l_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;
1815: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
1816: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE ;
1817: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
1818: l_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
1819: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
1820: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE ;
1821: l_change_reason_code pa_budget_lines.change_reason_code%TYPE ;
1822:

Line 1819: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

1815: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;
1816: l_project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE ;
1817: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;
1818: l_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;
1819: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;
1820: l_project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE ;
1821: l_change_reason_code pa_budget_lines.change_reason_code%TYPE ;
1822:
1823: l_rc_rate NUMBER;

Line 1881: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)

1877:
1878: -- cursor to get the start/end date of the first period before the first period displayed in the period mask
1879: CURSOR l_first_pd_st_en_dt_csr (c_org_id pa_projects_all.org_id%TYPE,
1880: c_first_prd_st_dt DATE,
1881: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)
1882: IS
1883: SELECT gl.start_date start_date,
1884: gl.end_date end_date,
1885: gl.period_name period_name

Line 1902: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)

1898:
1899: -- cursor to get the start/end date of the last period before the last period displayed in the period mask
1900: CURSOR l_last_pd_st_en_dt_csr (c_org_id pa_projects_all.org_id%TYPE,
1901: c_last_prd_en_dt DATE,
1902: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)
1903: IS
1904: SELECT gl.start_date start_date,
1905: gl.end_date end_date,
1906: gl.period_name period_name

Line 2652: FROM pa_proj_fp_options

2648: d_project_rev_rate_date,
2649: d_projfunc_rev_rate_type,
2650: d_projfunc_rev_rate_date_type,
2651: d_projfunc_rev_rate_date
2652: FROM pa_proj_fp_options
2653: WHERE fin_plan_version_id = p_version_info_rec.x_budget_version_id
2654: AND fin_plan_preference_code = 'COST_AND_REV_SAME';
2655: EXCEPTION
2656: WHEN OTHERS THEN

Line 10223: c_prd_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE,

10219: l_prc_rate_based_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE;
10220: l_prc_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;
10221:
10222: CURSOR l_prd_start_end_date_csr (c_org_id pa_projects_all.org_id%TYPE,
10223: c_prd_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE,
10224: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE,
10225: c_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE)
10226: IS
10227: SELECT glsd.start_date start_date,

Line 10224: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE,

10220: l_prc_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;
10221:
10222: CURSOR l_prd_start_end_date_csr (c_org_id pa_projects_all.org_id%TYPE,
10223: c_prd_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE,
10224: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE,
10225: c_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE)
10226: IS
10227: SELECT glsd.start_date start_date,
10228: gled.end_date end_date

Line 10225: c_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE)

10221:
10222: CURSOR l_prd_start_end_date_csr (c_org_id pa_projects_all.org_id%TYPE,
10223: c_prd_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE,
10224: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE,
10225: c_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE)
10226: IS
10227: SELECT glsd.start_date start_date,
10228: gled.end_date end_date
10229: FROM (SELECT ROW_NUMBER() OVER(PARTITION BY gl.period_set_name,gl.period_type

Line 11568: PROCEDURE GET_PERIOD_INFORMATION(p_period_mask_id IN pa_proj_fp_options.cost_period_mask_id%TYPE,

11564: /*This api is a private api which is called to calculate the Group Period information
11565: of the budget version based on the period mask of the budget version.The calculated
11566: Group Periods are stored in the OUT parameter x_periods_tbl.*/
11567:
11568: PROCEDURE GET_PERIOD_INFORMATION(p_period_mask_id IN pa_proj_fp_options.cost_period_mask_id%TYPE,
11569: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
11570: p_org_id IN pa_projects_all.org_id%TYPE,
11571: p_current_planning_period IN pa_proj_fp_options.cost_current_planning_period%TYPE,
11572: x_periods_tbl OUT NOCOPY periods_tbl,

Line 11569: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,

11565: of the budget version based on the period mask of the budget version.The calculated
11566: Group Periods are stored in the OUT parameter x_periods_tbl.*/
11567:
11568: PROCEDURE GET_PERIOD_INFORMATION(p_period_mask_id IN pa_proj_fp_options.cost_period_mask_id%TYPE,
11569: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
11570: p_org_id IN pa_projects_all.org_id%TYPE,
11571: p_current_planning_period IN pa_proj_fp_options.cost_current_planning_period%TYPE,
11572: x_periods_tbl OUT NOCOPY periods_tbl,
11573: x_return_status OUT NOCOPY VARCHAR2,

Line 11571: p_current_planning_period IN pa_proj_fp_options.cost_current_planning_period%TYPE,

11567:
11568: PROCEDURE GET_PERIOD_INFORMATION(p_period_mask_id IN pa_proj_fp_options.cost_period_mask_id%TYPE,
11569: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
11570: p_org_id IN pa_projects_all.org_id%TYPE,
11571: p_current_planning_period IN pa_proj_fp_options.cost_current_planning_period%TYPE,
11572: x_periods_tbl OUT NOCOPY periods_tbl,
11573: x_return_status OUT NOCOPY VARCHAR2,
11574: x_msg_count OUT NOCOPY NUMBER,
11575: x_msg_data OUT NOCOPY NUMBER)

Line 11607: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)

11603: CURSOR period_grouping_cur(c_period_set_name gl_periods.period_set_name%TYPE,
11604: c_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE,
11605: c_org_id pa_implementations_all.org_id%TYPE,
11606: c_pa_period_type pa_implementations_all.pa_period_type%TYPE,
11607: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)
11608: IS
11609: SELECT ROW_NUMBER() OVER( PARTITION BY gl.period_set_name,gl.period_type ORDER BY gl.start_date ) row_num,
11610: gl.start_date start_date,
11611: gl.end_Date end_date,

Line 11844: c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE)

11840: --This Cursor is used to get Resource Assignment information associated with the budget version.
11841: CURSOR res_ass_cur(c_budget_version_id pa_budget_versions.budget_version_id%TYPE,
11842: c_project_id pa_projects_all.project_id%TYPE,
11843: c_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE,
11844: c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE)
11845: IS
11846: SELECT pra.resource_assignment_id resource_assignment_id,
11847: nvl(pe.name,ppa.long_name) task_name,
11848: nvl(pe.element_number,ppa.segment1) task_number,

Line 11913: Type proj_fp_options_rec is record(fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,

11909: TYPE res_ass_tbl IS TABLE OF res_ass_cur%ROWTYPE; --Bug 5641300: Converted the index by pl/sql table to ordinary pl/sql table.
11910: -- INDEX BY PLS_INTEGER;
11911:
11912: --This Record is used to store the Plan Settings level information of the budget version.
11913: Type proj_fp_options_rec is record(fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
11914: projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE,
11915: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,
11916: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
11917: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,

Line 11914: projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE,

11910: -- INDEX BY PLS_INTEGER;
11911:
11912: --This Record is used to store the Plan Settings level information of the budget version.
11913: Type proj_fp_options_rec is record(fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
11914: projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE,
11915: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,
11916: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
11917: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
11918: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,

Line 11915: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,

11911:
11912: --This Record is used to store the Plan Settings level information of the budget version.
11913: Type proj_fp_options_rec is record(fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
11914: projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE,
11915: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,
11916: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
11917: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
11918: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
11919: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,

Line 11916: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,

11912: --This Record is used to store the Plan Settings level information of the budget version.
11913: Type proj_fp_options_rec is record(fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
11914: projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE,
11915: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,
11916: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
11917: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
11918: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
11919: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
11920: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,

Line 11917: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,

11913: Type proj_fp_options_rec is record(fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
11914: projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE,
11915: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,
11916: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
11917: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
11918: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
11919: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
11920: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
11921: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,

Line 11918: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,

11914: projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE,
11915: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,
11916: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
11917: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
11918: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
11919: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
11920: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
11921: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
11922: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,

Line 11919: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,

11915: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,
11916: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
11917: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
11918: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
11919: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
11920: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
11921: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
11922: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,
11923: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,

Line 11920: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,

11916: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
11917: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
11918: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
11919: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
11920: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
11921: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
11922: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,
11923: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,
11924: project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE,

Line 11921: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,

11917: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
11918: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
11919: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
11920: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
11921: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
11922: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,
11923: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,
11924: project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE,
11925: project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE);

Line 11922: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,

11918: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
11919: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
11920: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
11921: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
11922: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,
11923: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,
11924: project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE,
11925: project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE);
11926: l_proj_fp_options_rec proj_fp_options_rec;

Line 11923: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,

11919: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
11920: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
11921: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
11922: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,
11923: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,
11924: project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE,
11925: project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE);
11926: l_proj_fp_options_rec proj_fp_options_rec;
11927:

Line 11924: project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE,

11920: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
11921: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
11922: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,
11923: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,
11924: project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE,
11925: project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE);
11926: l_proj_fp_options_rec proj_fp_options_rec;
11927:
11928: --This Cursor is used to get the Amount Type and Conversion Attribute information of the budget version.

Line 11925: project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE);

11921: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
11922: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,
11923: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,
11924: project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE,
11925: project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE);
11926: l_proj_fp_options_rec proj_fp_options_rec;
11927:
11928: --This Cursor is used to get the Amount Type and Conversion Attribute information of the budget version.
11929: CURSOR amt_type_cur(c_project_id pa_fp_proj_xl_amt_types.project_id%TYPE,

Line 12047: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

12043: l_ci_id pa_budget_versions.ci_id%TYPE;
12044: l_AR_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
12045: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
12046: l_agr_conv_reqd_flag VARCHAR2(1);
12047: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
12048: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12049: l_version_type pa_budget_versions.version_type%TYPE;
12050: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12051: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 12048: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

12044: l_AR_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
12045: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
12046: l_agr_conv_reqd_flag VARCHAR2(1);
12047: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
12048: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12049: l_version_type pa_budget_versions.version_type%TYPE;
12050: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12051: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12052: l_org_id pa_projects_all.org_id%TYPE;

Line 12050: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;

12046: l_agr_conv_reqd_flag VARCHAR2(1);
12047: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
12048: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12049: l_version_type pa_budget_versions.version_type%TYPE;
12050: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12051: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12052: l_org_id pa_projects_all.org_id%TYPE;
12053: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12054: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 12051: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

12047: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
12048: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12049: l_version_type pa_budget_versions.version_type%TYPE;
12050: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12051: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12052: l_org_id pa_projects_all.org_id%TYPE;
12053: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12054: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12055: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

Line 12053: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;

12049: l_version_type pa_budget_versions.version_type%TYPE;
12050: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12051: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12052: l_org_id pa_projects_all.org_id%TYPE;
12053: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12054: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12055: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12056: l_project_name pa_projects_all.name%TYPE;
12057: l_project_number pa_projects_all.segment1%TYPE;

Line 12054: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

12050: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12051: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12052: l_org_id pa_projects_all.org_id%TYPE;
12053: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12054: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12055: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12056: l_project_name pa_projects_all.name%TYPE;
12057: l_project_number pa_projects_all.segment1%TYPE;
12058: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;

Line 12061: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

12057: l_project_number pa_projects_all.segment1%TYPE;
12058: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
12059: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
12060: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
12061: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
12062: l_start_date DATE;
12063: l_end_date DATE;
12064: l_preceding_date DATE;
12065: l_succeeding_date DATE;

Line 12268: FROM pa_proj_fp_options

12264: project_rev_rate_type,
12265: project_rev_rate_date_type,
12266: project_rev_rate_date
12267: INTO l_proj_fp_options_rec
12268: FROM pa_proj_fp_options
12269: WHERE proj_fp_options_id = l_proj_fp_options_id;
12270: EXCEPTION
12271: WHEN NO_DATA_FOUND THEN
12272: IF l_debug_mode = 'Y' THEN