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.

[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 473: pa_proj_fp_options fpo

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

Line 491: l_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;

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

Line 1789: d_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;

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

Line 1790: d_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;

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

Line 1791: d_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;

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

Line 1792: d_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

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

Line 1793: d_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;

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

Line 1794: d_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

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

Line 1795: d_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

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

Line 1796: d_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

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

Line 1797: d_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

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

Line 1798: d_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

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

Line 1799: d_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

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

Line 1800: d_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

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

Line 1807: l_projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE ;

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

Line 1808: l_projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE;

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

Line 1809: l_projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE ;

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

Line 1811: l_projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE ;

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

Line 1812: l_projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE ;

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

Line 1813: l_projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE ;

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

Line 1815: l_project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE ;

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

Line 1816: l_project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE ;

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

Line 1817: l_project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE ;

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

Line 1819: l_project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE ;

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

Line 1820: l_project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE ;

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

Line 1821: l_project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE ;

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

Line 1885: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)

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

Line 1906: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)

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

Line 2700: FROM pa_proj_fp_options

2696: d_project_rev_rate_date,
2697: d_projfunc_rev_rate_type,
2698: d_projfunc_rev_rate_date_type,
2699: d_projfunc_rev_rate_date
2700: FROM pa_proj_fp_options
2701: WHERE fin_plan_version_id = p_version_info_rec.x_budget_version_id
2702: AND fin_plan_preference_code = 'COST_AND_REV_SAME';
2703: EXCEPTION
2704: WHEN OTHERS THEN

Line 10404: c_prd_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE,

10400: l_prc_rbs_elem_id_tbl SYSTEM.pa_num_tbl_type;
10401: l_prc_cbs_elem_id_tbl SYSTEM.pa_num_tbl_type;-- cbs enhancement changes bug#16445106
10402:
10403: CURSOR l_prd_start_end_date_csr (c_org_id pa_projects_all.org_id%TYPE,
10404: c_prd_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE,
10405: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE,
10406: c_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE)
10407: IS
10408: SELECT glsd.start_date start_date,

Line 10405: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE,

10401: l_prc_cbs_elem_id_tbl SYSTEM.pa_num_tbl_type;-- cbs enhancement changes bug#16445106
10402:
10403: CURSOR l_prd_start_end_date_csr (c_org_id pa_projects_all.org_id%TYPE,
10404: c_prd_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE,
10405: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE,
10406: c_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE)
10407: IS
10408: SELECT glsd.start_date start_date,
10409: gled.end_date end_date

Line 10406: c_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE)

10402:
10403: CURSOR l_prd_start_end_date_csr (c_org_id pa_projects_all.org_id%TYPE,
10404: c_prd_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE,
10405: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE,
10406: c_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE)
10407: IS
10408: SELECT glsd.start_date start_date,
10409: gled.end_date end_date
10410: FROM (SELECT ROW_NUMBER() OVER(PARTITION BY gl.period_set_name,gl.period_type

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

11795: /*This api is a private api which is called to calculate the Group Period information
11796: of the budget version based on the period mask of the budget version.The calculated
11797: Group Periods are stored in the OUT parameter x_periods_tbl.*/
11798:
11799: PROCEDURE GET_PERIOD_INFORMATION(p_period_mask_id IN pa_proj_fp_options.cost_period_mask_id%TYPE,
11800: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
11801: p_org_id IN pa_projects_all.org_id%TYPE,
11802: p_current_planning_period IN pa_proj_fp_options.cost_current_planning_period%TYPE,
11803: x_periods_tbl OUT NOCOPY periods_tbl,

Line 11800: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,

11796: of the budget version based on the period mask of the budget version.The calculated
11797: Group Periods are stored in the OUT parameter x_periods_tbl.*/
11798:
11799: PROCEDURE GET_PERIOD_INFORMATION(p_period_mask_id IN pa_proj_fp_options.cost_period_mask_id%TYPE,
11800: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
11801: p_org_id IN pa_projects_all.org_id%TYPE,
11802: p_current_planning_period IN pa_proj_fp_options.cost_current_planning_period%TYPE,
11803: x_periods_tbl OUT NOCOPY periods_tbl,
11804: x_return_status OUT NOCOPY VARCHAR2,

Line 11802: p_current_planning_period IN pa_proj_fp_options.cost_current_planning_period%TYPE,

11798:
11799: PROCEDURE GET_PERIOD_INFORMATION(p_period_mask_id IN pa_proj_fp_options.cost_period_mask_id%TYPE,
11800: p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE,
11801: p_org_id IN pa_projects_all.org_id%TYPE,
11802: p_current_planning_period IN pa_proj_fp_options.cost_current_planning_period%TYPE,
11803: x_periods_tbl OUT NOCOPY periods_tbl,
11804: x_return_status OUT NOCOPY VARCHAR2,
11805: x_msg_count OUT NOCOPY NUMBER,
11806: x_msg_data OUT NOCOPY NUMBER)

Line 11838: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)

11834: CURSOR period_grouping_cur(c_period_set_name gl_periods.period_set_name%TYPE,
11835: c_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE,
11836: c_org_id pa_implementations_all.org_id%TYPE,
11837: c_pa_period_type pa_implementations_all.pa_period_type%TYPE,
11838: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)
11839: IS
11840: SELECT ROW_NUMBER() OVER( PARTITION BY gl.period_set_name,gl.period_type ORDER BY gl.start_date ) row_num,
11841: gl.start_date start_date,
11842: gl.end_Date end_date,

Line 12075: c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE)

12071: --This Cursor is used to get Resource Assignment information associated with the budget version.
12072: CURSOR res_ass_cur(c_budget_version_id pa_budget_versions.budget_version_id%TYPE,
12073: c_project_id pa_projects_all.project_id%TYPE,
12074: c_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE,
12075: c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE)
12076: IS
12077: SELECT pra.resource_assignment_id resource_assignment_id,
12078: nvl(pe.name,ppa.long_name) task_name,
12079: nvl(pe.element_number,ppa.segment1) task_number,

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

12142: 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.
12143: -- INDEX BY PLS_INTEGER;
12144:
12145: --This Record is used to store the Plan Settings level information of the budget version.
12146: Type proj_fp_options_rec is record(fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
12147: projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE,
12148: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,
12149: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
12150: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,

Line 12147: projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE,

12143: -- INDEX BY PLS_INTEGER;
12144:
12145: --This Record is used to store the Plan Settings level information of the budget version.
12146: Type proj_fp_options_rec is record(fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
12147: projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE,
12148: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,
12149: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
12150: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
12151: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,

Line 12148: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,

12144:
12145: --This Record is used to store the Plan Settings level information of the budget version.
12146: Type proj_fp_options_rec is record(fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
12147: projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE,
12148: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,
12149: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
12150: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
12151: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
12152: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,

Line 12149: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,

12145: --This Record is used to store the Plan Settings level information of the budget version.
12146: Type proj_fp_options_rec is record(fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
12147: projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE,
12148: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,
12149: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
12150: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
12151: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
12152: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
12153: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,

Line 12150: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,

12146: Type proj_fp_options_rec is record(fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
12147: projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE,
12148: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,
12149: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
12150: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
12151: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
12152: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
12153: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
12154: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,

Line 12151: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,

12147: projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE,
12148: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,
12149: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
12150: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
12151: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
12152: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
12153: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
12154: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
12155: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,

Line 12152: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,

12148: projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE,
12149: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
12150: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
12151: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
12152: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
12153: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
12154: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
12155: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,
12156: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,

Line 12153: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,

12149: projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE,
12150: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
12151: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
12152: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
12153: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
12154: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
12155: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,
12156: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,
12157: project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE,

Line 12154: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,

12150: project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE,
12151: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
12152: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
12153: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
12154: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
12155: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,
12156: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,
12157: project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE,
12158: project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE);

Line 12155: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,

12151: project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE,
12152: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
12153: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
12154: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
12155: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,
12156: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,
12157: project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE,
12158: project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE);
12159: l_proj_fp_options_rec proj_fp_options_rec;

Line 12156: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,

12152: project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE,
12153: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
12154: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
12155: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,
12156: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,
12157: project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE,
12158: project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE);
12159: l_proj_fp_options_rec proj_fp_options_rec;
12160:

Line 12157: project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE,

12153: projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE,
12154: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
12155: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,
12156: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,
12157: project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE,
12158: project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE);
12159: l_proj_fp_options_rec proj_fp_options_rec;
12160:
12161: --This Cursor is used to get the Amount Type and Conversion Attribute information of the budget version.

Line 12158: project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE);

12154: projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE,
12155: projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE,
12156: project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE,
12157: project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE,
12158: project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE);
12159: l_proj_fp_options_rec proj_fp_options_rec;
12160:
12161: --This Cursor is used to get the Amount Type and Conversion Attribute information of the budget version.
12162: CURSOR amt_type_cur(c_project_id pa_fp_proj_xl_amt_types.project_id%TYPE,

Line 12280: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

12276: l_ci_id pa_budget_versions.ci_id%TYPE;
12277: l_AR_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
12278: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
12279: l_agr_conv_reqd_flag VARCHAR2(1);
12280: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
12281: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12282: l_version_type pa_budget_versions.version_type%TYPE;
12283: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12284: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

Line 12281: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

12277: l_AR_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
12278: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
12279: l_agr_conv_reqd_flag VARCHAR2(1);
12280: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
12281: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12282: l_version_type pa_budget_versions.version_type%TYPE;
12283: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12284: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12285: l_org_id pa_projects_all.org_id%TYPE;

Line 12283: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;

12279: l_agr_conv_reqd_flag VARCHAR2(1);
12280: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
12281: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12282: l_version_type pa_budget_versions.version_type%TYPE;
12283: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12284: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12285: l_org_id pa_projects_all.org_id%TYPE;
12286: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12287: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 12284: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;

12280: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
12281: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12282: l_version_type pa_budget_versions.version_type%TYPE;
12283: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12284: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12285: l_org_id pa_projects_all.org_id%TYPE;
12286: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12287: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12288: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

Line 12286: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;

12282: l_version_type pa_budget_versions.version_type%TYPE;
12283: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12284: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12285: l_org_id pa_projects_all.org_id%TYPE;
12286: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12287: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12288: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12289: l_project_name pa_projects_all.name%TYPE;
12290: l_project_number pa_projects_all.segment1%TYPE;

Line 12287: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

12283: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12284: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12285: l_org_id pa_projects_all.org_id%TYPE;
12286: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;
12287: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
12288: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
12289: l_project_name pa_projects_all.name%TYPE;
12290: l_project_number pa_projects_all.segment1%TYPE;
12291: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;

Line 12294: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

12290: l_project_number pa_projects_all.segment1%TYPE;
12291: l_txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE;
12292: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
12293: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
12294: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
12295: l_start_date DATE;
12296: l_end_date DATE;
12297: l_preceding_date DATE;
12298: l_succeeding_date DATE;

Line 12508: FROM pa_proj_fp_options

12504: project_rev_rate_type,
12505: project_rev_rate_date_type,
12506: project_rev_rate_date
12507: INTO l_proj_fp_options_rec
12508: FROM pa_proj_fp_options
12509: WHERE proj_fp_options_id = l_proj_fp_options_id;
12510: EXCEPTION
12511: WHEN NO_DATA_FOUND THEN
12512: IF l_debug_mode = 'Y' THEN