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 682: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

678: END assign_flat_element_names;
679: /* --------------------------------------------------------------------- */
680:
681: procedure assign_default_amount
682: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
683: x_default_amount_type_code OUT NOCOPY pa_proj_periods_denorm.amount_type_code%TYPE, --File.Sql.39 bug 4440895
684: x_default_amount_subtype_code OUT NOCOPY pa_proj_periods_denorm.amount_subtype_code%TYPE, --File.Sql.39 bug 4440895
685: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
686: 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: /* Added this new function as part of the changes done for View Plan Enhancement 7514054 */
805:
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 977: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

973: -- p_period_number=0 --> preceding_periods_amount
974: -- p_period_number=14 --> succeeding_periods_amount
975: function get_period_n_value
976: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
977: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
978: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
979: p_project_currency_type IN VARCHAR2,
980: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
981: p_period_number IN NUMBER) return NUMBER

Line 4815: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,

4811: /* --------------------------------------------------------------------- */
4812:
4813: PROCEDURE refresh_period_profile
4814: (p_project_id IN pa_projects_all.project_id%TYPE,
4815: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,
4816: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,
4817: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4818: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4819: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 4816: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,

4812:
4813: PROCEDURE refresh_period_profile
4814: (p_project_id IN pa_projects_all.project_id%TYPE,
4815: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,
4816: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,
4817: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4818: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4819: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4820: is

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

4893: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
4894: END IF;
4895: x_conc_req_id := LTRIM(RTRIM(TO_CHAR(l_rpt_request_id)));
4896:
4897: -- bug 2740907: stamp request_id into pa_budget_versions
4898: -- set locked_by_person_id=-99: locked by processing
4899: update pa_budget_versions
4900: set plan_processing_code = 'PPP',
4901: record_version_number = record_version_number + 1,

Line 4899: update pa_budget_versions

4895: x_conc_req_id := LTRIM(RTRIM(TO_CHAR(l_rpt_request_id)));
4896:
4897: -- bug 2740907: stamp request_id into pa_budget_versions
4898: -- set locked_by_person_id=-99: locked by processing
4899: update pa_budget_versions
4900: set plan_processing_code = 'PPP',
4901: record_version_number = record_version_number + 1,
4902: request_id = x_conc_req_id,
4903: locked_by_person_id = -98

Line 4905: update pa_budget_versions

4901: record_version_number = record_version_number + 1,
4902: request_id = x_conc_req_id,
4903: locked_by_person_id = -98
4904: where budget_version_id = p_budget_version_id1;
4905: update pa_budget_versions
4906: set plan_processing_code = 'PPP',
4907: record_version_number = record_version_number + 1,
4908: request_id = x_conc_req_id,
4909: locked_by_person_id = -98

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

4917: END refresh_period_profile;
4918: /* --------------------------------------------------------------------- */
4919:
4920: FUNCTION has_period_profile_id
4921: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
4922: return VARCHAR2 is
4923: l_return_value VARCHAR2(1);
4924: BEGIN
4925: l_return_value := 'N';

Line 4928: from pa_budget_versions

4924: BEGIN
4925: l_return_value := 'N';
4926: select 'Y'
4927: into l_return_value
4928: from pa_budget_versions
4929: where budget_version_id = p_budget_version_id and
4930: period_profile_id is not null;
4931: return l_return_value;
4932: EXCEPTION

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

4935: END has_period_profile_id;
4936:
4937: /*************************************************************/
4938: procedure roll_up_budget_lines
4939: (p_budget_version_id in pa_budget_versions.budget_version_id%TYPE,
4940: p_cost_or_rev in VARCHAR2)
4941: is
4942:
4943: cursor l_ra_csr is

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

5138: -- have been planned for value 'M' is returned.
5139: -- Both resource group and resource columns are rendered.
5140:
5141: procedure get_plan_version_res_level
5142: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
5143: p_entered_amts_only_flag IN VARCHAR2,
5144: x_resource_level OUT NOCOPY VARCHAR2, -- 'R' = resource, 'G' = resource group, --File.Sql.39 bug 4440895
5145: -- 'M' = mixed, -- 'N' = not applicable (NONE resource list)
5146: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 5155: l_version_type pa_budget_versions.version_type%TYPE;

5151: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE; -- bug 3081511
5152: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
5153: l_prj_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
5154: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5155: l_version_type pa_budget_versions.version_type%TYPE;
5156: l_resource_level VARCHAR2(1); -- used to store temp value of return variable
5157: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
5158:
5159: cursor c1(c_fp_opt_id number,

Line 5188: from pa_budget_versions bv,

5184: rl.resource_list_id
5185: into l_group_resource_type_id,
5186: l_uncategorized_flag,
5187: l_resource_list_id
5188: from pa_budget_versions bv,
5189: pa_resource_lists_all_bg rl
5190: where bv.budget_version_id = p_budget_version_id
5191: and bv.resource_list_id = rl.resource_list_id;
5192:

Line 5217: pa_budget_versions bv

5213: into l_proj_fp_options_id,
5214: l_fin_plan_level_code,
5215: l_version_type
5216: from pa_proj_fp_options po,
5217: pa_budget_versions bv
5218: where bv.budget_version_id = p_budget_version_id and
5219: bv.budget_version_id = po.fin_plan_version_id and
5220: po.fin_plan_option_level_code = 'PLAN_VERSION';
5221: