1 PACKAGE pa_fin_plan_pvt AUTHID CURRENT_USER AS
2 /* $Header: PAFPPVTS.pls 120.3.12020000.2 2013/04/04 07:25:46 djambhek 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 TYPE ci_rec IS RECORD (
12 ci_id pa_control_items.ci_id%TYPE,
13 ci_plan_version_id pa_budget_versions.budget_version_id%TYPE,
14 ci_impact_id pa_ci_impacts.ci_impact_id%TYPE,
15 record_version_number pa_ci_impacts.record_version_number%TYPE,
16 version_type pa_fp_merged_ctrl_items.version_type%TYPE,
17 impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE,
18 impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE,
19 impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE,
20 impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE,
21 impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE,
22 impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE,
23 impl_cost_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE,
24 impl_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
25 impl_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE,
26 impl_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
27 impl_agr_revenue pa_fp_merged_ctrl_items.impl_agr_revenue%TYPE,
28 rev_partially_impl_flag pa_budget_versions.rev_partially_impl_flag%TYPE);
29
30
31 /* Table definition for constituents of the budget_lines_tab starts */
32
33 TYPE task_id_tab is TABLE of pa_tasks.task_id%TYPE INDEX BY BINARY_INTEGER;
34 TYPE resource_list_member_id_tab is TABLE of pa_resource_assignments.resource_list_member_id%TYPE INDEX BY BINARY_INTEGER;
35 TYPE cbs_element_id_tab is TABLE of pa_resource_assignments.cbs_element_id%TYPE INDEX BY BINARY_INTEGER; -- Added for CBS 16598322
36 TYPE description_tab is TABLE of pa_budget_lines.description%TYPE INDEX BY BINARY_INTEGER;
37 TYPE start_date_tab is TABLE of pa_budget_lines.start_date%TYPE INDEX BY BINARY_INTEGER;
38 TYPE end_date_tab is TABLE of pa_budget_lines.end_date%TYPE INDEX BY BINARY_INTEGER;
39 TYPE period_name_tab is TABLE of pa_budget_lines.period_name%TYPE INDEX BY BINARY_INTEGER;
40 TYPE quantity_tab is TABLE of pa_budget_lines.quantity%TYPE INDEX BY BINARY_INTEGER;
41 TYPE unit_of_measure_tab is TABLE of pa_resource_assignments.unit_of_measure%TYPE INDEX BY BINARY_INTEGER;
42 TYPE track_as_labor_flag_tab is TABLE of pa_resource_assignments.track_as_labor_flag%TYPE INDEX BY BINARY_INTEGER;
43 TYPE txn_currency_code_tab is TABLE of pa_budget_lines.txn_currency_code%TYPE INDEX BY BINARY_INTEGER;
44 TYPE raw_cost_tab is TABLE of pa_budget_lines.raw_cost%TYPE INDEX BY BINARY_INTEGER;
45 TYPE burdened_cost_tab is TABLE of pa_budget_lines.burdened_cost%TYPE INDEX BY BINARY_INTEGER;
46 TYPE revenue_tab is TABLE of pa_budget_lines.revenue%TYPE INDEX BY BINARY_INTEGER;
47 TYPE txn_raw_cost_tab is TABLE of pa_budget_lines.txn_raw_cost%TYPE INDEX BY BINARY_INTEGER;
48 TYPE txn_burdened_cost_tab is TABLE of pa_budget_lines.txn_burdened_cost%TYPE INDEX BY BINARY_INTEGER;
49 TYPE txn_revenue_tab is TABLE of pa_budget_lines.txn_revenue%TYPE INDEX BY BINARY_INTEGER;
50 TYPE project_raw_cost_tab is TABLE of pa_budget_lines.project_raw_cost%TYPE INDEX BY BINARY_INTEGER;
51 TYPE project_burdened_cost_tab is TABLE of pa_budget_lines.project_burdened_cost%TYPE INDEX BY BINARY_INTEGER;
52 TYPE project_revenue_tab is TABLE of pa_budget_lines.project_revenue%TYPE INDEX BY BINARY_INTEGER;
53 TYPE change_reason_code_tab is TABLE of pa_budget_lines.change_reason_code%TYPE INDEX BY BINARY_INTEGER;
54 TYPE attribute_category_tab is TABLE of pa_budget_lines.attribute_category%TYPE INDEX BY BINARY_INTEGER;
55 TYPE attribute1_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
56 TYPE attribute2_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
57 TYPE attribute3_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
58 TYPE attribute4_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
59 TYPE attribute5_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
60 TYPE attribute6_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
61 TYPE attribute7_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
62 TYPE attribute8_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
63 TYPE attribute9_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
64 TYPE attribute10_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
65 TYPE attribute11_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
66 TYPE attribute12_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
67 TYPE attribute13_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
68 TYPE attribute14_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
69 TYPE attribute15_tab is TABLE of pa_budget_lines.attribute1%TYPE INDEX BY BINARY_INTEGER;
70 TYPE PF_COST_RATE_TYPE_tab is TABLE of pa_budget_lines.PROJFUNC_COST_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
71 TYPE PF_COST_RATE_DATE_TYPE_tab is TABLE of pa_budget_lines.PROJFUNC_COST_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
72 TYPE PF_COST_RATE_DATE_tab is TABLE of pa_budget_lines.PROJFUNC_COST_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
73 TYPE PF_COST_RATE_tab is TABLE of pa_budget_lines.PROJFUNC_COST_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
74 TYPE PF_REV_RATE_TYPE_tab is TABLE of pa_budget_lines.PROJFUNC_REV_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
75 TYPE PF_REV_RATE_DATE_TYPE_tab is TABLE of pa_budget_lines.PROJFUNC_REV_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
76 TYPE PF_REV_RATE_DATE_tab is TABLE of pa_budget_lines.PROJFUNC_REV_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
77 TYPE PF_REV_RATE_tab is TABLE of pa_budget_lines.PROJFUNC_REV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
78 TYPE PJ_COST_RATE_TYPE_tab is TABLE of pa_budget_lines.PROJECT_COST_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
79 TYPE PJ_COST_RATE_DATE_TYPE_tab is TABLE of pa_budget_lines.PROJECT_COST_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
80 TYPE PJ_COST_RATE_DATE_tab is TABLE of pa_budget_lines.PROJECT_COST_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
81 TYPE PJ_COST_RATE_tab is TABLE of pa_budget_lines.PROJECT_COST_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
82 TYPE PJ_REV_RATE_TYPE_tab is TABLE of pa_budget_lines.PROJECT_REV_RATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
83 TYPE PJ_REV_RATE_DATE_TYPE_tab is TABLE of pa_budget_lines.PROJECT_REV_RATE_DATE_TYPE%TYPE INDEX BY BINARY_INTEGER;
84 TYPE PJ_REV_RATE_DATE_tab is TABLE of pa_budget_lines.PROJECT_REV_RATE_DATE%TYPE INDEX BY BINARY_INTEGER;
85 TYPE PJ_REV_RATE_tab is TABLE of pa_budget_lines.PROJECT_REV_EXCHANGE_RATE%TYPE INDEX BY BINARY_INTEGER;
86 TYPE pm_product_code_tab is TABLE of pa_budget_lines.pm_product_code%TYPE INDEX BY BINARY_INTEGER;
87 TYPE pm_budget_line_reference_tab is TABLE of pa_budget_lines.pm_budget_line_reference%TYPE INDEX BY BINARY_INTEGER;
88 TYPE quantity_source_tab is TABLE of pa_budget_lines.quantity_source%TYPE INDEX BY BINARY_INTEGER;
89 TYPE raw_cost_source_tab is TABLE of pa_budget_lines.raw_cost_source%TYPE INDEX BY BINARY_INTEGER;
90 TYPE burdened_cost_source_tab is TABLE of pa_budget_lines.burdened_cost_source%TYPE INDEX BY BINARY_INTEGER;
91 TYPE revenue_source_tab is TABLE of pa_budget_lines.revenue_source%TYPE INDEX BY BINARY_INTEGER;
92 TYPE resource_assignment_id_tab is TABLE of pa_budget_lines.resource_assignment_id%TYPE INDEX BY BINARY_INTEGER;
93
94 /* Table definition for constituents of the budget_lines_tab ends */
95
96 TYPE budget_lines_tab is TABLE of pa_fp_rollup_tmp%ROWTYPE INDEX BY BINARY_INTEGER;
97
98 TYPE ci_rec_tab is TABLE of ci_rec INDEX BY BINARY_INTEGER;
99
100 TYPE number_type_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
101
102 TYPE date_type_tab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
103
104 TYPE char240_type_tab IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
105
106 check_wf_error EXCEPTION;
107 start_wf_error EXCEPTION;
108 baseline_finplan_error EXCEPTION;
109 --g_ci_rec_tab pa_fin_plan_pvt.ci_rec_tab; Commented for bug 2672654
110
111
112 PROCEDURE lock_unlock_version
113 (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
114 p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
115 p_action IN VARCHAR2, -- 'L' for lock, 'U' for unlock
116 p_user_id IN NUMBER,
117 p_person_id IN NUMBER, -- can be null
118 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
119 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
120 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
121 p_unlock_locked_ver_flag IN VARCHAR2 DEFAULT NULL);
122
123
124 PROCEDURE Baseline_FinPlan
128 p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE default null,
125 (p_project_id IN pa_budget_versions.project_id%TYPE,
126 p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
127 p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
129 p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE default null,
130 p_verify_budget_rules IN VARCHAR2 DEFAULT 'Y',
131 x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
132 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
133 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
134 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
135
136 PROCEDURE Submit_Current_Working_FinPlan
137 (p_project_id IN pa_budget_versions.project_id%TYPE,
138 p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
139 p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
140 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
141 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
142 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
143
144 PROCEDURE Get_Included_Ci
145 ( p_from_bv_id IN pa_budget_versions.budget_version_id%TYPE
146 ,p_to_bv_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
147 ,p_impact_status IN pa_ci_impacts.status_code%TYPE DEFAULT NULL
148 ,x_ci_rec_tab OUT NOCOPY pa_fin_plan_pvt.ci_rec_tab
149 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
150 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
151 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
152
153 PROCEDURE handle_ci_links
154 ( p_source_bv_id IN pa_budget_versions.budget_version_id%TYPE
155 ,p_target_bv_id IN pa_budget_versions.budget_version_id%TYPE
156 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
157 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
158 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
159
160 PROCEDURE CREATE_DRAFT
161 ( p_project_id IN pa_budget_versions.project_id%TYPE
162 ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
163 ,p_version_type IN pa_budget_versions.version_type%TYPE
164 -- Bug Fix: 4569365. Removed MRC code.
165 --,p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
166 ,p_calling_context IN VARCHAR2
167 ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
168 ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
169 ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
170 ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
171 ,p_version_name IN pa_budget_versions.version_name%TYPE
172 ,p_description IN pa_budget_versions.description%TYPE
173 ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
174 ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE
175 ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE
176 ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE
177 ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE
178 ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE
179 ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE
180 ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
181 ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
182 ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
183 ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
184 ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
185 ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
186 ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
187 ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
188 ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
189 ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
190 ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
191 ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
192 ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
193 ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
194 ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
195 ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
196 ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
197 ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
198 ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
199 ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
200 ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
201 ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE
205 ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
202 ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE
203 ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE
204 ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
206 ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
207 ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
208 ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
209 ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
210 ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
211 -- Start of additional columns for Bug :- 2634900
212 ,p_ci_id IN pa_budget_versions.ci_id%TYPE := NULL
213 ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE := NULL
214 ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE:= NULL
215 ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE := NULL
216 ,p_est_qty IN pa_budget_versions.est_quantity%TYPE := NULL
217 ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE := NULL
218 ,p_impacted_task_id IN pa_tasks.task_id%TYPE := NULL
219 ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE := NULL
220 -- End of additional columns for Bug :- 2634900
221 --Added the two flags below as part of changes to AMG for finplan model
222 ,p_create_new_curr_working_flag IN VARCHAR2
223 ,p_replace_current_working_flag IN VARCHAR2
224 ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
225 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
226 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
227 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
228 );
229
230 /* Bug# 2674353 - Added p_calling_context */
231
232 PROCEDURE CREATE_FINPLAN_LINES
233 ( -- Bug Fix: 4569365. Removed MRC code.
234 -- p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
235 p_calling_context IN VARCHAR2
236 ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
237 ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
238 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
239 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
240 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
241
242 FUNCTION Fetch_Plan_Type_Id
243 (p_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE) RETURN NUMBER ;
244
245 PROCEDURE convert_plan_type_name_to_id
246 ( p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
247 ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE
248 ,x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
249 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
250 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
251 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
252 );
253
254 /*=====================================================================
255 Procedure Name: DELETE_WP_OPTION
256 This procedure is added as part of FPM Development. Trackinb Bug - 3354518.
257 Purpose: This api Deletes the proj fp options data pertaining
258 to the workplan type attached to the project for
259 the passed project id.
260 Deletes data from the following tables -
261 1) pa_proj_fp_options
262 2) pa_fp_txn_currencies
263 3) pa_proj_period_profiles
264 4) pa_fp_upgrade_audit
265
266 Please note that all validations before calling this API shall be done
267 in the calling entity.
268
269 Parameters:
270 IN 1) p_project_id - project id.
271 =======================================================================*/
272 PROCEDURE Delete_wp_option
273 (p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE
274 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
275 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
276 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
277
278
279
280 /*=====================================================================
281 Procedure Name: DELETE_WP_BUDGET_VERSIONS
282 This procedure is added as part of FPM Development. Trackinb Bug - 3354518.
283 Purpose: This API deletes the budget_versions for all the
284 workplan structure version ids passed.
285
286 Parameters:
287 IN 1)p_struct_elem_version_id_tbl IN SYSTEM.pa_num_tbl_typ
288 =======================================================================*/
289 PROCEDURE Delete_wp_budget_versions
290 (p_struct_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type
291 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
292 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
293 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
294
295 /*=====================================================================
296 Procedure Name: ADD_FIN_PLAN_LINES
297 This procedure is added as part of B and F AMG API changes. Tracking Bug - 3507156.
298 Purpose: This API calls the following apis :
299 1) PA_FIN_PLAN_PVT.CREATE_FINPLAN_LINES
300 2) PA_FP_CALC_PLAN_PKG.CALCULATE
301 3) PJI_FM_XBS_ACCUM_MAINT.PLAN_CREATE
302 Parameters:
303 IN 1)p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
304 2)p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
305 3)p_finplan_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
306 =======================================================================*/
307 PROCEDURE ADD_FIN_PLAN_LINES
308 ( -- Bug Fix: 4569365. Removed MRC code.
309 -- p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
310 p_calling_context IN VARCHAR2
311 ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
312 ,p_finplan_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
313 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
314 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
315 ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
316
317 END pa_fin_plan_pvt;