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