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.
PACKAGE: APPS.PA_PLANNING_ELEMENT_UTILS

Source


1 PACKAGE pa_planning_element_utils AUTHID CURRENT_USER AS
2 /* $Header: PAFPPEUS.pls 120.6.12020000.2 2013/03/27 04:40:52 bpottipa ship $
3    Start of Comments
4    Package name     : PA_FIN_PLAN_UTILS
5    Purpose          : utility API's for Org Forecast pages
6    History          :
7    NOTE             :
8    End of Comments
9 */
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
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 
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
32    x_msg_data            OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
33 
34 FUNCTION get_task_name_and_number
35   (p_project_or_task IN VARCHAR2,  -- 'PROJECT' or 'TASK'
36    p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) return VARCHAR2;
37 
38 -- Bug 4057673. Added a parameter p_fin_plan_level_code. It will be either 'P','L' or 'M'
39 --depending on the planning level of the budget version
40 FUNCTION get_project_task_level
41   (p_resource_assignment_id   IN pa_resource_assignments.resource_assignment_id%TYPE,
42    p_fin_plan_level_code      IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE) return VARCHAR2;
43 
44 FUNCTION get_res_class_name
45   (p_res_class_code IN pa_resource_classes_b.resource_class_code%TYPE) return VARCHAR2;
46 
47 FUNCTION get_res_type_name
48   (p_res_type_code IN pa_res_types_b.res_type_code%TYPE) return VARCHAR2;
49 
50 FUNCTION get_project_role_name
51   (p_project_role_id IN pa_project_role_types_b.project_role_id%TYPE) return VARCHAR2;
52 
53 FUNCTION get_supplier_name
54   (p_supplier_id IN po_vendors.vendor_id%TYPE) return VARCHAR2;
55 
56 FUNCTION get_schedule_role_name
57   (p_proj_assignment_id IN pa_project_assignments.assignment_id%TYPE) return VARCHAR2;
58 
59 FUNCTION get_spread_curve_name
60   (p_spread_curve_id IN pa_spread_curves_b.spread_curve_id%TYPE) return VARCHAR2;
61 
62 FUNCTION get_mfc_cost_type_name
63   (p_mfc_cost_type_id IN pa_resource_assignments.mfc_cost_type_id%TYPE) return VARCHAR2;
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,
75    x_budget_version_id       OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
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),
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
80    x_quantity                OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
81    x_revenue_txn_cur         OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
82    x_revenue_proj_cur        OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
83    x_revenue_proj_func_cur   OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
84    x_raw_cost_txn_cur        OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
85    x_raw_cost_proj_cur       OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
86    x_raw_cost_proj_func_cur  OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
87    x_burd_cost_txn_cur       OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
88    x_burd_cost_proj_cur      OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
89    x_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
90 --   x_burd_multiplier         OUT pa_budget_lines.txn_burden_multiplier%TYPE, -- FPM2 data model upgrade
91    x_init_rev_rate           OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
92    x_avg_rev_rate            OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
93    x_init_raw_cost_rate      OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
94    x_avg_raw_cost_rate       OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
95    x_init_burd_cost_rate     OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
96    x_avg_burd_cost_rate      OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
97    x_margin_txn_cur          OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
98    x_margin_proj_cur         OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
99    x_margin_proj_func_cur    OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
100    x_margin_pct              OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
101    x_etc_avg_rev_rate	     OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
102    x_etc_avg_raw_cost_rate   OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
103    x_etc_avg_burd_cost_rate  OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
104    x_return_status           OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
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,
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
121    x_act_quantity            OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
122    x_etc_quantity            OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
123    x_fcst_quantity           OUT NOCOPY pa_resource_assignments.total_plan_quantity%TYPE, --File.Sql.39 bug 4440895
124    x_act_revenue_txn_cur         OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
125    x_act_revenue_proj_cur        OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
126    x_act_revenue_proj_func_cur   OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
127    x_etc_revenue_txn_cur         OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
128    x_etc_revenue_proj_cur        OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
129    x_etc_revenue_proj_func_cur   OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
130    x_fcst_revenue_txn_cur         OUT NOCOPY pa_budget_lines.txn_revenue%TYPE, --File.Sql.39 bug 4440895
131    x_fcst_revenue_proj_cur        OUT NOCOPY pa_resource_assignments.total_project_revenue%TYPE, --File.Sql.39 bug 4440895
132    x_fcst_revenue_proj_func_cur   OUT NOCOPY pa_resource_assignments.total_plan_revenue%TYPE, --File.Sql.39 bug 4440895
133    x_act_raw_cost_txn_cur        OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
137    x_etc_raw_cost_proj_cur       OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
134    x_act_raw_cost_proj_cur       OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
135    x_act_raw_cost_proj_func_cur  OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
136    x_etc_raw_cost_txn_cur        OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
138    x_etc_raw_cost_proj_func_cur  OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
139    x_fcst_raw_cost_txn_cur        OUT NOCOPY pa_budget_lines.txn_raw_cost%TYPE, --File.Sql.39 bug 4440895
140    x_fcst_raw_cost_proj_cur       OUT NOCOPY pa_resource_assignments.total_project_raw_cost%TYPE, --File.Sql.39 bug 4440895
141    x_fcst_raw_cost_proj_func_cur  OUT NOCOPY pa_resource_assignments.total_plan_raw_cost%TYPE, --File.Sql.39 bug 4440895
142    x_act_burd_cost_txn_cur       OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
143    x_act_burd_cost_proj_cur      OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
144    x_act_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
145    x_etc_burd_cost_txn_cur       OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
146    x_etc_burd_cost_proj_cur      OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
147    x_etc_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
148    x_fcst_burd_cost_txn_cur       OUT NOCOPY pa_budget_lines.txn_burdened_cost%TYPE, --File.Sql.39 bug 4440895
149    x_fcst_burd_cost_proj_cur      OUT NOCOPY pa_resource_assignments.total_project_burdened_cost%TYPE, --File.Sql.39 bug 4440895
150    x_fcst_burd_cost_proj_func_cur OUT NOCOPY pa_resource_assignments.total_plan_burdened_cost%TYPE, --File.Sql.39 bug 4440895
151    x_act_rev_rate           OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
152    x_etc_init_rev_rate           OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
153    x_etc_avg_rev_rate            OUT NOCOPY pa_budget_lines.txn_standard_bill_rate%TYPE, --File.Sql.39 bug 4440895
154    x_act_raw_cost_rate      OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
155    x_etc_init_raw_cost_rate      OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
156    x_etc_avg_raw_cost_rate       OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
157    x_act_burd_cost_rate     OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
158    x_etc_init_burd_cost_rate     OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
159    x_etc_avg_burd_cost_rate      OUT NOCOPY pa_budget_lines.txn_standard_cost_rate%TYPE, --File.Sql.39 bug 4440895
160    x_act_margin_txn_cur          OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
161    x_act_margin_proj_cur         OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
162    x_act_margin_proj_func_cur    OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
163    x_etc_margin_txn_cur          OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
164    x_etc_margin_proj_cur         OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
165    x_etc_margin_proj_func_cur    OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
166    x_fcst_margin_txn_cur          OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
167    x_fcst_margin_proj_cur         OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
168    x_fcst_margin_proj_func_cur    OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
169    x_act_margin_pct              OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
170    x_etc_margin_pct              OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
171    x_fcst_margin_pct              OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
172    x_return_status           OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
173    x_msg_count               OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
174    x_msg_data                OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
175 
176 procedure get_initial_budget_line_info
177   (p_resource_assignment_id	IN  pa_resource_assignments.resource_assignment_id%TYPE,
178    P_txn_currency_code		IN  pa_budget_lines.txn_currency_code%TYPE,
179    p_line_start_date            IN  pa_budget_lines.start_date%TYPE := to_date(NULL),
180    p_line_end_date              IN  pa_budget_lines.end_date%TYPE := to_date(NULL),
181    x_start_date			OUT NOCOPY pa_budget_lines.start_date%TYPE, --File.Sql.39 bug 4440895
182    x_end_date			OUT NOCOPY pa_budget_lines.end_date%TYPE, --File.Sql.39 bug 4440895
183    x_period_name		OUT NOCOPY pa_budget_lines.period_name%TYPE, --File.Sql.39 bug 4440895
184    x_quantity			OUT NOCOPY pa_budget_lines.quantity%TYPE, --File.Sql.39 bug 4440895
185    x_txn_raw_cost		OUT NOCOPY pa_budget_lines.raw_cost%TYPE, --File.Sql.39 bug 4440895
186    x_txn_burdened_cost		OUT NOCOPY pa_budget_lines.burdened_cost%TYPE, --File.Sql.39 bug 4440895
187    x_txn_revenue		OUT NOCOPY pa_budget_lines.revenue%TYPE, --File.Sql.39 bug 4440895
188    x_init_quantity		OUT NOCOPY pa_budget_lines.init_quantity%TYPE, --File.Sql.39 bug 4440895
189    x_txn_init_raw_cost		OUT NOCOPY pa_budget_lines.txn_init_raw_cost%TYPE, --File.Sql.39 bug 4440895
190    x_txn_init_burdened_cost	OUT NOCOPY pa_budget_lines.txn_init_burdened_cost%TYPE, --File.Sql.39 bug 4440895
191    x_txn_init_revenue		OUT NOCOPY pa_budget_lines.txn_init_revenue%TYPE, --File.Sql.39 bug 4440895
192    x_init_raw_cost_rate		OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
193    x_init_burd_cost_rate	OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
194    x_init_revenue_rate		OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
195    x_etc_init_raw_cost_rate     OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
196    x_etc_init_burd_cost_rate	OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
200    x_msg_data			OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
197    x_etc_init_revenue_rate	OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
198    x_return_status		OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
199    x_msg_count			OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
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_cbs_element_id_tbl	IN	SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(), --bug#16200605
210    p_quantity_tbl		IN	SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
211    p_currency_code_tbl		IN	SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE(),
212    p_raw_cost_tbl		IN	SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
213    p_burdened_cost_tbl		IN	SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
214    p_revenue_tbl		IN	SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
215    p_cost_rate_tbl		IN	SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
216    p_bill_rate_tbl		IN	SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
217    p_burdened_rate_tbl		IN	SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
218    p_unplanned_flag_tbl		IN	SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE(),
219    p_expenditure_type_tbl    IN  SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(), --added for Enc
220    x_return_status		OUT	NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
221    x_msg_count			OUT	NOCOPY NUMBER, --File.Sql.39 bug 4440895
222    x_msg_data			OUT 	NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
223 
224 /* This procedure is used to retrieve:
225    FND_API.G_MISS_NUM (x_num)
226    FND_API.G_MISS_CHAR (x_char)
227    FND_API.G_MISS_DATE (x_date)
228    so it can be passed to the Java-side for further use
229 */
230 PROCEDURE get_fnd_miss_constants
231    (x_num  OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
232     x_char OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
233     x_date OUT NOCOPY DATE); --File.Sql.39 bug 4440895
234 
235 FUNCTION get_bv_name_from_id
236    (p_budget_version_id  IN pa_budget_versions.budget_version_id%TYPE) return VARCHAR2;
237 
238 --Created for bug 3546208. This function will return the financial structure version id for the project
239 --id passed.
240 FUNCTION get_fin_struct_id(p_project_id        pa_projects_all.project_id%TYPE,
241                            p_budget_version_id pa_budget_versions.budget_Version_id%TYPE)
242 RETURN NUMBER;
243 
244 -- This function returns the wbs element name, either from the wbs_element_version_id
245 -- or from the proj_element_id.  If using proj_element_id, then p_use_element_version_id_flag
246 -- must be set to 'N'
247 FUNCTION get_wbs_element_name_from_id
248    (p_project_id	      IN  pa_projects_all.project_id%TYPE,
249     p_wbs_element_version_id  IN  pa_resource_assignments.wbs_element_version_id%TYPE,
250     p_wbs_project_element_id  IN  pa_proj_element_versions.proj_element_id%TYPE,
251     p_use_element_version_flag IN VARCHAR2) return VARCHAR2;
252 
253 FUNCTION get_proj_element_id
254    (p_wbs_element_version_id  IN  pa_proj_element_versions.element_version_id%TYPE) return NUMBER;
255 
256 FUNCTION get_rbs_element_name_from_id
257     (p_rbs_element_version_id  IN  pa_rbs_elements.rbs_element_id%TYPE) return VARCHAR2;
258 
259 FUNCTION get_task_percent_complete
260     (p_project_id	     IN pa_projects_all.project_id%TYPE,
261      p_budget_version_id     IN pa_budget_versions.budget_version_id%TYPE,
262      p_proj_element_id       IN pa_proj_element_versions.proj_element_id%TYPE,
263      p_calling_context       IN VARCHAR2) return NUMBER;
264 
265 /* Bug 5524803: Added the below function to return the prior forecast version id
266  * to be used by PJI.
267  */
268 FUNCTION get_prior_forecast_version_id
269   (p_plan_version_id   IN  pa_budget_versions.budget_version_id%TYPE,
270    p_project_id          IN  pa_projects_all.project_id%TYPE
271   ) RETURN NUMBER;
272 
273 end pa_planning_element_utils;