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_PLANNING_ELEMENT_UTILS dependencies on PA_BUDGET_VERSIONS

Line 14: (p_project_id IN pa_budget_versions.project_id%TYPE,

10:
11: /* This procedure should be used for the Workplan Task Details page ONLY!
12: */
13: PROCEDURE get_workplan_bvids
14: (p_project_id IN pa_budget_versions.project_id%TYPE,
15: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
16: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
17: x_baselined_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
18: x_published_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 16: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

12: */
13: PROCEDURE get_workplan_bvids
14: (p_project_id IN pa_budget_versions.project_id%TYPE,
15: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
16: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
17: x_baselined_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
18: x_published_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
19: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
20: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 17: x_baselined_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

13: PROCEDURE get_workplan_bvids
14: (p_project_id IN pa_budget_versions.project_id%TYPE,
15: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
16: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
17: x_baselined_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
18: x_published_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
19: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
20: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
21: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 18: x_published_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

14: (p_project_id IN pa_budget_versions.project_id%TYPE,
15: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
16: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
17: x_baselined_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
18: x_published_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
19: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
20: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
21: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
22:

Line 24: (p_project_id IN pa_budget_versions.project_id%TYPE,

20: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
21: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
22:
23: PROCEDURE get_finplan_bvids
24: (p_project_id IN pa_budget_versions.project_id%TYPE,
25: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
26: p_view_plan_flag IN VARCHAR2 default 'N',
27: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
28: x_original_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 25: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

21: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
22:
23: PROCEDURE get_finplan_bvids
24: (p_project_id IN pa_budget_versions.project_id%TYPE,
25: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
26: p_view_plan_flag IN VARCHAR2 default 'N',
27: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
28: x_original_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
29: x_prior_fcst_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 27: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

23: PROCEDURE get_finplan_bvids
24: (p_project_id IN pa_budget_versions.project_id%TYPE,
25: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
26: p_view_plan_flag IN VARCHAR2 default 'N',
27: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
28: x_original_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
29: x_prior_fcst_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
30: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
31: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 28: x_original_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

24: (p_project_id IN pa_budget_versions.project_id%TYPE,
25: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
26: p_view_plan_flag IN VARCHAR2 default 'N',
27: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
28: x_original_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
29: x_prior_fcst_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
30: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
31: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
32: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895

Line 29: x_prior_fcst_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

25: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
26: p_view_plan_flag IN VARCHAR2 default 'N',
27: x_current_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
28: x_original_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
29: x_prior_fcst_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
30: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
31: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
32: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
33:

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

64:
65: FUNCTION get_project_uncat_rlmid return NUMBER;
66:
67: PROCEDURE get_common_budget_version_info
68: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
69: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
70: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
71: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
72: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

Line 75: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

71: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
72: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
73: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
74: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
75: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
76: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
77: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
78: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
79: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895

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

105: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
106: x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
107:
108: PROCEDURE get_common_bv_info_fcst
109: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
110: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
111: p_project_currency_code IN pa_projects_all.project_currency_code%TYPE,
112: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
113: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

Line 116: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

112: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,
113: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
114: p_line_start_date IN pa_budget_lines.start_date%TYPE := to_date(NULL),
115: p_line_end_date IN pa_budget_lines.end_date%TYPE := to_date(NULL),
116: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
117: x_planning_start_date OUT NOCOPY pa_resource_assignments.planning_start_date%TYPE, --File.Sql.39 bug 4440895
118: x_planning_end_date OUT NOCOPY pa_resource_assignments.planning_end_date%TYPE, --File.Sql.39 bug 4440895
119: x_schedule_start_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895
120: x_schedule_end_date OUT NOCOPY pa_resource_assignments.schedule_start_date%TYPE, --File.Sql.39 bug 4440895

Line 205: p_project_id IN pa_budget_versions.project_id%TYPE,

201:
202:
203: PROCEDURE add_new_resource_assignments
204: (p_context IN VARCHAR2,
205: p_project_id IN pa_budget_versions.project_id%TYPE,
206: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
207: p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
208: p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
209: p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

Line 206: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

202:
203: PROCEDURE add_new_resource_assignments
204: (p_context IN VARCHAR2,
205: p_project_id IN pa_budget_versions.project_id%TYPE,
206: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
207: p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
208: p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
209: p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
210: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE(),

Line 234: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) return VARCHAR2;

230: x_char OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
231: x_date OUT NOCOPY DATE); --File.Sql.39 bug 4440895
232:
233: FUNCTION get_bv_name_from_id
234: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) return VARCHAR2;
235:
236: --Created for bug 3546208. This function will return the financial structure version id for the project
237: --id passed.
238: FUNCTION get_fin_struct_id(p_project_id pa_projects_all.project_id%TYPE,

Line 239: p_budget_version_id pa_budget_versions.budget_Version_id%TYPE)

235:
236: --Created for bug 3546208. This function will return the financial structure version id for the project
237: --id passed.
238: FUNCTION get_fin_struct_id(p_project_id pa_projects_all.project_id%TYPE,
239: p_budget_version_id pa_budget_versions.budget_Version_id%TYPE)
240: RETURN NUMBER;
241:
242: -- This function returns the wbs element name, either from the wbs_element_version_id
243: -- or from the proj_element_id. If using proj_element_id, then p_use_element_version_id_flag

Line 259: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

255: (p_rbs_element_version_id IN pa_rbs_elements.rbs_element_id%TYPE) return VARCHAR2;
256:
257: FUNCTION get_task_percent_complete
258: (p_project_id IN pa_projects_all.project_id%TYPE,
259: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
260: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE,
261: p_calling_context IN VARCHAR2) return NUMBER;
262:
263: /* Bug 5524803: Added the below function to return the prior forecast version id

Line 267: (p_plan_version_id IN pa_budget_versions.budget_version_id%TYPE,

263: /* Bug 5524803: Added the below function to return the prior forecast version id
264: * to be used by PJI.
265: */
266: FUNCTION get_prior_forecast_version_id
267: (p_plan_version_id IN pa_budget_versions.budget_version_id%TYPE,
268: p_project_id IN pa_projects_all.project_id%TYPE
269: ) RETURN NUMBER;
270:
271: end pa_planning_element_utils;