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_VIEW_PLANS_UTIL dependencies on PA_FIN_PLAN_AMOUNT_SETS

Line 687: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

683: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
684: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
685: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
686: is
687: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
688: l_budget_version_type VARCHAR2(30); -- used for determining how to rank the amount types
689: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE;
690: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
691: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE;

Line 689: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE;

685: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
686: is
687: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
688: l_budget_version_type VARCHAR2(30); -- used for determining how to rank the amount types
689: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE;
690: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
691: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE;
692: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;
693: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE;

Line 690: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;

686: is
687: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
688: l_budget_version_type VARCHAR2(30); -- used for determining how to rank the amount types
689: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE;
690: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
691: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE;
692: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;
693: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE;
694:

Line 691: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE;

687: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
688: l_budget_version_type VARCHAR2(30); -- used for determining how to rank the amount types
689: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE;
690: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
691: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE;
692: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;
693: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE;
694:
695: l_default_amount_type_code pa_proj_periods_denorm.amount_type_code%TYPE;

Line 692: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;

688: l_budget_version_type VARCHAR2(30); -- used for determining how to rank the amount types
689: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE;
690: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
691: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE;
692: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;
693: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE;
694:
695: l_default_amount_type_code pa_proj_periods_denorm.amount_type_code%TYPE;
696: l_default_amount_subtype_code pa_proj_periods_denorm.amount_subtype_code%TYPE;

Line 693: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE;

689: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE;
690: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
691: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE;
692: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE;
693: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE;
694:
695: l_default_amount_type_code pa_proj_periods_denorm.amount_type_code%TYPE;
696: l_default_amount_subtype_code pa_proj_periods_denorm.amount_subtype_code%TYPE;
697: l_msg_count NUMBER := 0;

Line 742: from pa_fin_plan_amount_sets

738: l_burdened_cost_flag,
739: l_cost_qty_flag,
740: l_revenue_flag,
741: l_revenue_qty_flag
742: from pa_fin_plan_amount_sets
743: where fin_plan_amount_set_id = l_amount_set_id;
744: -- determine the top_ranking amount type, based on the budget version type
745: if l_budget_version_type = 'COST' then
746: if l_raw_cost_flag = 'Y' then