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_BUDGET_VERSIONS

Line 680: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

676: END assign_flat_element_names;
677: /* --------------------------------------------------------------------- */
678:
679: procedure assign_default_amount
680: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
681: x_default_amount_type_code OUT NOCOPY pa_proj_periods_denorm.amount_type_code%TYPE, --File.Sql.39 bug 4440895
682: x_default_amount_subtype_code OUT NOCOPY pa_proj_periods_denorm.amount_subtype_code%TYPE, --File.Sql.39 bug 4440895
683: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
684: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 808: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

804: -- p_period_number=0 --> preceding_periods_amount
805: -- p_period_number=14 --> succeeding_periods_amount
806: function get_period_n_value
807: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
808: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
809: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
810: p_project_currency_type IN VARCHAR2,
811: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
812: p_period_number IN NUMBER) return NUMBER

Line 4645: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,

4641: /* --------------------------------------------------------------------- */
4642:
4643: PROCEDURE refresh_period_profile
4644: (p_project_id IN pa_projects_all.project_id%TYPE,
4645: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,
4646: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,
4647: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4648: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4649: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 4646: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,

4642:
4643: PROCEDURE refresh_period_profile
4644: (p_project_id IN pa_projects_all.project_id%TYPE,
4645: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,
4646: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,
4647: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4648: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4649: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4650: is

Line 4727: -- bug 2740907: stamp request_id into pa_budget_versions

4723: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
4724: END IF;
4725: x_conc_req_id := LTRIM(RTRIM(TO_CHAR(l_rpt_request_id)));
4726:
4727: -- bug 2740907: stamp request_id into pa_budget_versions
4728: -- set locked_by_person_id=-99: locked by processing
4729: update pa_budget_versions
4730: set plan_processing_code = 'PPP',
4731: record_version_number = record_version_number + 1,

Line 4729: update pa_budget_versions

4725: x_conc_req_id := LTRIM(RTRIM(TO_CHAR(l_rpt_request_id)));
4726:
4727: -- bug 2740907: stamp request_id into pa_budget_versions
4728: -- set locked_by_person_id=-99: locked by processing
4729: update pa_budget_versions
4730: set plan_processing_code = 'PPP',
4731: record_version_number = record_version_number + 1,
4732: request_id = x_conc_req_id,
4733: locked_by_person_id = -98

Line 4735: update pa_budget_versions

4731: record_version_number = record_version_number + 1,
4732: request_id = x_conc_req_id,
4733: locked_by_person_id = -98
4734: where budget_version_id = p_budget_version_id1;
4735: update pa_budget_versions
4736: set plan_processing_code = 'PPP',
4737: record_version_number = record_version_number + 1,
4738: request_id = x_conc_req_id,
4739: locked_by_person_id = -98

Line 4751: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

4747: END refresh_period_profile;
4748: /* --------------------------------------------------------------------- */
4749:
4750: FUNCTION has_period_profile_id
4751: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
4752: return VARCHAR2 is
4753: l_return_value VARCHAR2(1);
4754: BEGIN
4755: l_return_value := 'N';

Line 4758: from pa_budget_versions

4754: BEGIN
4755: l_return_value := 'N';
4756: select 'Y'
4757: into l_return_value
4758: from pa_budget_versions
4759: where budget_version_id = p_budget_version_id and
4760: period_profile_id is not null;
4761: return l_return_value;
4762: EXCEPTION

Line 4769: (p_budget_version_id in pa_budget_versions.budget_version_id%TYPE,

4765: END has_period_profile_id;
4766:
4767: /*************************************************************/
4768: procedure roll_up_budget_lines
4769: (p_budget_version_id in pa_budget_versions.budget_version_id%TYPE,
4770: p_cost_or_rev in VARCHAR2)
4771: is
4772:
4773: cursor l_ra_csr is

Line 4972: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

4968: -- have been planned for value 'M' is returned.
4969: -- Both resource group and resource columns are rendered.
4970:
4971: procedure get_plan_version_res_level
4972: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4973: p_entered_amts_only_flag IN VARCHAR2,
4974: x_resource_level OUT NOCOPY VARCHAR2, -- 'R' = resource, 'G' = resource group, --File.Sql.39 bug 4440895
4975: -- 'M' = mixed, -- 'N' = not applicable (NONE resource list)
4976: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 4985: l_version_type pa_budget_versions.version_type%TYPE;

4981: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE; -- bug 3081511
4982: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
4983: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
4984: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4985: l_version_type pa_budget_versions.version_type%TYPE;
4986: l_resource_level VARCHAR2(1); -- used to store temp value of return variable
4987: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
4988:
4989: cursor c1(c_fp_opt_id number,

Line 5018: from pa_budget_versions bv,

5014: rl.resource_list_id
5015: into l_group_resource_type_id,
5016: l_uncategorized_flag,
5017: l_resource_list_id
5018: from pa_budget_versions bv,
5019: pa_resource_lists_all_bg rl
5020: where bv.budget_version_id = p_budget_version_id
5021: and bv.resource_list_id = rl.resource_list_id;
5022:

Line 5047: pa_budget_versions bv

5043: into l_proj_fp_options_id,
5044: l_fin_plan_level_code,
5045: l_version_type
5046: from pa_proj_fp_options po,
5047: pa_budget_versions bv
5048: where bv.budget_version_id = p_budget_version_id and
5049: bv.budget_version_id = po.fin_plan_version_id and
5050: po.fin_plan_option_level_code = 'PLAN_VERSION';
5051: