1 package PA_BUDGET_PUB AUTHID DEFINER as
2 /*$Header: PAPMBUPS.pls 120.13 2007/11/30 15:59:43 rthumma ship $*/
3 /*#
4 * This package contains the public APIs for budgets.
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname Create Budget
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PA_BUDGET
11 * @rep:category BUSINESS_ENTITY PA_PROJECT
12 * @rep:category BUSINESS_ENTITY PA_FORECAST
13 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
14 */
15
16 --Global constants to be used in error messages
17 G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_BUDGET_PUB';
18 G_BUDGET_CODE CONSTANT VARCHAR2(6) := 'BUDGET';
19 G_PROJECT_CODE CONSTANT VARCHAR2(7) := 'PROJECT';
20 G_TASK_CODE CONSTANT VARCHAR2(4) := 'TASK';
21 G_RESOURCE_CODE CONSTANT VARCHAR2(8) := 'RESOURCE';
22
23 --Locking exception
24 ROW_ALREADY_LOCKED EXCEPTION;
25 PRAGMA EXCEPTION_INIT(ROW_ALREADY_LOCKED, -54);
26
27 --Package constant used for package version validation
28
29 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
30
31
32 --Record and table type definitions
33 TYPE budget_line_in_rec_type IS RECORD
34 (pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
35 ,pm_task_reference VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
36 ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --Bug # 3507156 : Patchset M: B and F impact changes : AMG
37 ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
38 ,budget_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
39 ,budget_end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
40 ,period_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
41 ,description VARCHAR2(255) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
42 ,raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
43 ,burdened_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
44 ,revenue NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
45 ,quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
46 ,pm_product_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
47 ,pm_budget_line_reference pa_budget_lines.pm_budget_line_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --Bug 3231587
48 ,attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
49 ,attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50 ,attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
51 ,attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
52 ,attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
53 ,attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
54 ,attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
55 ,attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
56 ,attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
57 ,attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
58 ,attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
59 ,attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
60 ,attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
61 ,attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
62 ,attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
63 ,attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
64
65 --Additional parameters for finplan model in FP L
66 --Changes the default of the following parameters from NULL to G_PA_MISS_XXX 24-APR-03 by Xin Liu
67 ,txn_currency_code pa_fp_txn_currencies.txn_currency_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
68 ,projfunc_cost_rate_type pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
69 ,projfunc_cost_rate_date_type pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE:=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
70 ,projfunc_cost_rate_date pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
71 ,projfunc_cost_exchange_rate pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
72 ,projfunc_rev_rate_type pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
73 ,projfunc_rev_rate_date_type pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
74 ,projfunc_rev_rate_date pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
75 ,projfunc_rev_exchange_rate pa_budget_lines.projfunc_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
76 ,project_cost_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
77 ,project_cost_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
78 ,project_cost_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
79 ,project_cost_exchange_rate pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
80 ,project_rev_rate_type pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
81 ,project_rev_rate_date_type pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
82 ,project_rev_rate_date pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
83 ,project_rev_exchange_rate pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
84 ,change_reason_code pa_budget_lines.change_reason_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
85 );
86
87 TYPE budget_line_in_tbl_type IS TABLE OF budget_line_in_rec_type
88 INDEX BY BINARY_INTEGER;
89
90 TYPE row_id_tbl_type IS TABLE OF rowid
91 INDEX BY BINARY_INTEGER;
92 TYPE budget_line_id_tbl_type IS TABLE OF pa_budget_lines.budget_line_id%TYPE
93 INDEX BY BINARY_INTEGER;
94 TYPE res_assignment_id_tbl_type IS TABLE OF pa_budget_lines.resource_assignment_id%TYPE
95 INDEX BY BINARY_INTEGER;
96 TYPE date_tbl_type IS TABLE OF pa_budget_lines.start_date%TYPE
97 INDEX BY BINARY_INTEGER;
98 TYPE txn_currency_code_tbl_type IS TABLE OF pa_budget_lines.txn_currency_code%TYPE
99 INDEX BY BINARY_INTEGER;
100 TYPE period_name_tbl_type IS TABLE OF pa_budget_lines.period_name%TYPE
101 INDEX BY BINARY_INTEGER;
102 TYPE quantity_tbl_type IS TABLE OF pa_budget_lines.quantity%TYPE
103 INDEX BY BINARY_INTEGER;
104 TYPE display_quantity_tbl_type IS TABLE OF pa_budget_lines.display_quantity%TYPE --IPM Arch Enhancement Bug 4865563
105 INDEX BY BINARY_INTEGER;
106 TYPE raw_cost_tbl_type IS TABLE OF pa_budget_lines.raw_cost%TYPE
107 INDEX BY BINARY_INTEGER;
108 TYPE burdened_cost_tbl_type IS TABLE OF pa_budget_lines.burdened_cost%TYPE
109 INDEX BY BINARY_INTEGER;
110 TYPE revenue_tbl_type IS TABLE OF pa_budget_lines.revenue%TYPE
111 INDEX BY BINARY_INTEGER;
112 TYPE task_id_tbl_type IS TABLE OF pa_tasks.task_id%TYPE
113 INDEX BY BINARY_INTEGER;
114 TYPE resource_list_id_tbl_type IS TABLE OF pa_resource_list_members.resource_list_id%TYPE
115 INDEX BY BINARY_INTEGER;
116 TYPE res_list_member_id_tbl_type IS TABLE OF pa_resource_list_members.resource_list_member_id%TYPE
117 INDEX BY BINARY_INTEGER;
118 TYPE resource_id_tbl_type IS TABLE OF pa_resource_list_members.resource_id%TYPE
119 INDEX BY BINARY_INTEGER;
120 TYPE resource_name_tbl_type IS TABLE OF pa_resources.name%TYPE
121 INDEX BY BINARY_INTEGER;
122
123 TYPE rate_based_flag_tbl_type IS TABLE OF pa_resource_assignments.rate_based_flag%TYPE
124 INDEX BY BINARY_INTEGER;
125
126
127
128
129 TYPE calc_budget_line_out_rec_type IS RECORD
130 (pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
131 ,pm_task_reference VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
132 ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --Bug # 3507156 : Patchset M: B and F impact changes : AMG
133 ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134 ,budget_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
135 ,budget_end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
136 ,period_name VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
137 ,calculated_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
138 ,calculated_burdened_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
139 ,calculated_revenue NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
140 ,quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
141 ,return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
142 -- for Bug 2863564 the following columns have been added
143 --Changes the default of the following parameters from NULL to G_PA_MISS_XXX 24-APR-03 by Xin Liu
144 ,txn_currency_code VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
145 ,project_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
146 ,project_burdened_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
147 ,project_revenue NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
148 ,projfunc_raw_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
149 ,projfunc_burdened_cost NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
150 ,projfunc_revenue NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
151 ,display_quantity NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --IPM Arch Enhancement Bug 4865563
152 );
153
154 TYPE calc_budget_line_out_tbl_type IS TABLE OF calc_budget_line_out_rec_type
155 INDEX BY BINARY_INTEGER;
156
157 TYPE budget_line_out_rec_type IS RECORD
158 (return_status VARCHAR2(1) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
159 );
160 TYPE budget_line_out_tbl_type IS TABLE OF budget_line_out_rec_type
161 INDEX BY BINARY_INTEGER;
162
163 TYPE FINPLAN_TRANS_REC IS RECORD (
164 PM_PRODUCT_CODE PA_BUDGET_VERSIONS.PM_PRODUCT_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
165 ,TASK_ID NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
166 ,PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
167 ,PM_RES_ASGMT_REFERENCE VARCHAR2(30) DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
168 ,RESOURCE_ALIAS PA_RESOURCE_LIST_MEMBERS.ALIAS%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --bug 3711693
169 ,CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
170 ,UNIT_OF_MEASURE_CODE PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
171 ,START_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_START_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
172 ,END_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_END_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
173 ,QUANTITY NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
174 ,RAW_COST NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
175 ,BURDENED_COST NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
176 ,REVENUE NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
177 ,RESOURCE_LIST_MEMBER_ID NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
178 ,ATTRIBUTE_CATEGORY PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE_CATEGORY%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
179 ,ATTRIBUTE1 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE1%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
180 ,ATTRIBUTE2 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE2%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
181 ,ATTRIBUTE3 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE3%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
182 ,ATTRIBUTE4 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE4%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
183 ,ATTRIBUTE5 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE5%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
184 ,ATTRIBUTE6 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE6%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
185 ,ATTRIBUTE7 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE7%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
186 ,ATTRIBUTE8 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE8%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
187 ,ATTRIBUTE9 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE9%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
188 ,ATTRIBUTE10 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE10%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
189 ,ATTRIBUTE11 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE11%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
190 ,ATTRIBUTE12 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE12%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
191 ,ATTRIBUTE13 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE13%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
192 ,ATTRIBUTE14 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE14%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
193 ,ATTRIBUTE15 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE15%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
194 ,ATTRIBUTE16 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE16%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
195 ,ATTRIBUTE17 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE17%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
196 ,ATTRIBUTE18 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE18%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
197 ,ATTRIBUTE19 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE19%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
198 ,ATTRIBUTE20 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE20%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
199 ,ATTRIBUTE21 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE21%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
200 ,ATTRIBUTE22 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE22%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
201 ,ATTRIBUTE23 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE23%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
202 ,ATTRIBUTE24 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE24%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
203 ,ATTRIBUTE25 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE25%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
204 ,ATTRIBUTE26 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE26%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
205 ,ATTRIBUTE27 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE27%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
206 ,ATTRIBUTE28 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE28%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
207 ,ATTRIBUTE29 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE29%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
208 ,ATTRIBUTE30 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE30%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
209 );
210 TYPE Finplan_trans_tab IS TABLE OF FINPLAN_TRANS_REC INDEX BY BINARY_INTEGER;
211
212
213 --Bug 5509192
214 TYPE planning_element_rec_type IS RECORD
215 (pa_task_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
216 ,pm_task_reference VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
217 ,resource_alias VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
218 ,resource_list_member_id NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
219 ,planning_start_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
220 ,planning_end_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
221 ,etc_method_name VARCHAR2(80) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
222 ,spread_curve VARCHAR2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
223 ,fixed_date DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
224 ,assignment_description varchar2(240) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
225 ,attribute_category VARCHAR2(30) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
226 ,attribute1 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
227 ,attribute2 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
228 ,attribute3 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
229 ,attribute4 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
230 ,attribute5 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
231 ,attribute6 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
235 ,attribute10 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
232 ,attribute7 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
233 ,attribute8 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
234 ,attribute9 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
236 ,attribute11 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
237 ,attribute12 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
238 ,attribute13 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
239 ,attribute14 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
240 ,attribute15 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
241 ,attribute16 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
242 ,attribute17 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
243 ,attribute18 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
244 ,attribute19 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
245 ,attribute20 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
246 ,attribute21 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
247 ,attribute22 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
248 ,attribute23 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
249 ,attribute24 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
250 ,attribute25 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
251 ,attribute26 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
252 ,attribute27 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
253 ,attribute28 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
254 ,attribute29 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
255 ,attribute30 VARCHAR2(150) := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
256 );
257
258 TYPE planning_element_rec_tbl_type IS TABLE OF planning_element_rec_type
259 INDEX BY BINARY_INTEGER;
260 --Bug 5509192
261
262
263 G_PM_PRODUCT_CODE_TBL SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
264 G_TASK_ID_TBL SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE();
265 G_PM_TASK_REFERENCE_TBL SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
266 G_PM_RES_ASGMT_REFERENCE_TBL SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
267 G_RESOURCE_ALIAS_TBL SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
268 G_CURRENCY_CODE_TBL SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
269 G_UNIT_OF_MEASURE_CODE_TBL SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
270 G_START_DATE_TBL SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE();
271 G_END_DATE_TBL SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE();
272 G_QUANTITY_TBL SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE();
273 G_DISPLAY_QUANTITY_TBL SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE(); --IPM Arch Enhancement Bug 4865563
274 G_RAW_COST_TBL SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE();
275 G_BURDENED_COST_TBL SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE();
276 G_REVENUE_TBL SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE();
277 G_RESOURCE_LIST_MEMBER_ID_TBL SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE();
278 G_ATTRIBUTE_CATEGORY_TBL SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
279 G_ATTRIBUTE1_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
280 G_ATTRIBUTE2_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
281 G_ATTRIBUTE3_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
282 G_ATTRIBUTE4_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
283 G_ATTRIBUTE5_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
284 G_ATTRIBUTE6_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
285 G_ATTRIBUTE7_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
286 G_ATTRIBUTE8_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
287 G_ATTRIBUTE9_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
288 G_ATTRIBUTE10_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
289 G_ATTRIBUTE11_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
290 G_ATTRIBUTE12_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
291 G_ATTRIBUTE13_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
292 G_ATTRIBUTE14_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
293 G_ATTRIBUTE15_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
294 G_ATTRIBUTE16_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
295 G_ATTRIBUTE17_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
296 G_ATTRIBUTE18_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
297 G_ATTRIBUTE19_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
298 G_ATTRIBUTE20_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
302 G_ATTRIBUTE24_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
299 G_ATTRIBUTE21_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
300 G_ATTRIBUTE22_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
301 G_ATTRIBUTE23_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
303 G_ATTRIBUTE25_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
304 G_ATTRIBUTE26_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
305 G_ATTRIBUTE27_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
306 G_ATTRIBUTE28_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
307 G_ATTRIBUTE29_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
308 G_ATTRIBUTE30_TBL SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE();
309
310 --Globals to be used by the LOAD/EXECUTE/FETCH process
311 --IN types
312 G_budget_lines_in_tbl budget_line_in_tbl_type;
313
314 --Counters
315 G_budget_lines_tbl_count NUMBER:=0;
316 G_calc_budget_lines_tbl_count NUMBER:=0;
317
318 --OUT types
319 G_budget_lines_out_tbl budget_line_out_tbl_type;
320 G_calc_budget_lines_out_tbl calc_budget_line_out_tbl_type;
321
322
323 --Added by Xin Liu.24-APR-03
324 /* The following global variable can be set by calling get_project_id
325 procedure with project_id parameter. The value set in the global
326 variable is returned by get_project_id function.
327 As of now, the set_project_id procedure is set by the project
328 connect team to set the global variable and get_project_id is used
329 by pa_finplan_types_v view which is inturn used by project
330 connect team */
331
332 G_Project_Id pa_projects_all.project_id%type;
333
334
335 -- Bug 4588279, 27-SEP-05, jwhite ----------------------------------
336 -- Add global G_Latest_Encumbrance_Year for conditional
337 -- budget line budgetary control processing.
338
339 G_Latest_Encumbrance_Year gl_ledgers.Latest_Encumbrance_Year%TYPE := -99;
340
341
342 -- -----------------------------------------------------------------
343
344
345 /*#
346 * This API is used to return the PROJECT_ID for the project in context used by the public view
347 * PA_FINPLAN_TYPES_V.
348 * @return The project id for the project
349 * @rep:scope public
350 * @rep:lifecycle active
351 * @rep:displayname Get Project ID
352 * @rep:compatibility S
353 */
354 FUNCTION get_project_id return pa_projects_all.project_id%type;
355
356 /*#
357 * This API is used to set the public variable G_PROJECT_ID which is used by public view PA_FINPLAN_TYPES_V.
358 * @param p_project_id The identifier of the project for which the public view PA_FINPLAN_TYPES_V is created
359 * @rep:paraminfo {@rep:required}
360 * @rep:scope public
361 * @rep:lifecycle active
362 * @rep:displayname Set Project ID
363 * @rep:compatibility S
364 */
365 PROCEDURE set_project_id(p_project_id pa_projects_all.project_id%type);
366
367 /*#
368 * This API is used to create a draft budget and its budget lines in Oracle Projects for a project using a selected budget type and budget entry method.
369 * @param p_api_version_number API standard: version number
370 * @rep:paraminfo {@rep:required}
371 * @param p_commit API standard (default = F): indicates if the transaction will be committed
372 * @rep:paraminfo {@rep:precision 1}
373 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
374 * @param p_msg_count API standard: number of error messages
375 * @rep:paraminfo {@rep:required}
376 * @param p_msg_data API standard: error message
377 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
378 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
379 * @rep:paraminfo {@rep:required}
380 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
381 * @rep:paraminfo {@rep:required}
382 * @param p_pm_budget_reference The reference code that uniquely identifies the budget in the external system
383 * @param p_budget_version_name The user-defined name for the budget version
384 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects
385 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
386 * @param p_budget_type_code The identifier of the budget type
387 * @rep:paraminfo {@rep:required}
388 * @param p_change_reason_code The identifier of the change reason
389 * @param p_description Description of the budget
390 * @param p_entry_method_code The identifier of the budget entry method
391 * @param p_resource_list_name Name of the resource list
392 * @param p_resource_list_id The identifier of the resource list
393 * @param p_attribute_category Descriptive flexfield category
394 * @param p_attribute1 Descriptive flexfield segment
395 * @param p_attribute2 Descriptive flexfield segment
396 * @param p_attribute3 Descriptive flexfield segment
397 * @param p_attribute4 Descriptive flexfield segment
398 * @param p_attribute5 Descriptive flexfield segment
399 * @param p_attribute6 Descriptive flexfield segment
400 * @param p_attribute7 Descriptive flexfield segment
401 * @param p_attribute8 Descriptive flexfield segment
402 * @param p_attribute9 Descriptive flexfield segment
403 * @param p_attribute10 Descriptive flexfield segment
404 * @param p_attribute11 Descriptive flexfield segment
408 * @param p_attribute15 Descriptive flexfield segment
405 * @param p_attribute12 Descriptive flexfield segment
406 * @param p_attribute13 Descriptive flexfield segment
407 * @param p_attribute14 Descriptive flexfield segment
409 * @param p_budget_lines_in Input budget lines
410 * @rep:paraminfo {@rep:required}
411 * @param p_budget_lines_out Output budget lines
412 * @rep:paraminfo {@rep:required}
413 * @param p_fin_plan_type_id Financial plan type identifier. You must supply a valid value for either p_fin_plan_type_name or p_fin_plan_type_id for budget or forecast versions created for financial plan types.
414 * @param p_fin_plan_type_name Financial plan type name in Oracle Projects. You must specify a value for this parameter or p_fin_plan_type_id.
415 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. Valid values are COST, REVENUE, and ALL.
416 * @param p_fin_plan_level_code The planning level for the plan version. Valid values are P (project-level planning), T (top task-level planning), M (mixed-level planning - top and lowest tasks), and L (lowest task-level planning).
417 * @param p_time_phased_code The indicator of the time periods to be used, if applicable, when planning for cost and revenue amounts together
418 * @param p_plan_in_multi_curr_flag Flag indicating whether the plan amounts can be entered in any currency
419 * @param p_projfunc_cost_rate_type Rate type used to convert costs from transaction currency to project functional currency
420 * @param p_projfunc_cost_rate_date_typ The rate date type for converting cost amounts from transaction currency to project functional currency
421 * @param p_projfunc_cost_rate_date The rate date for converting cost amounts from transaction currency to project functional currency
422 * @param p_projfunc_rev_rate_type The rate type for converting revenue amounts from the transaction currency to the project functional currency
423 * @param p_projfunc_rev_rate_date_typ The rate date type for converting revenue amounts from transaction currency to project functional currency
424 * @param p_projfunc_rev_rate_date The rate date for converting revenue amounts from transaction currency to project functional currency
425 * @param p_project_cost_rate_type The rate type for converting cost amounts from the transaction currency to the project currency
426 * @param p_project_cost_rate_date_typ The rate date type for converting cost amounts from transaction currency to project currency
427 * @param p_project_cost_rate_date The rate date for converting cost amounts from transaction currency to project currency
428 * @param p_project_rev_rate_type The rate type for converting revenue amounts from the transaction currency to the project currency
429 * @param p_project_rev_rate_date_typ The rate date type for converting revenue amounts from transaction currency to project currency
430 * @param p_project_rev_rate_date The rate date for converting revenue amounts from transaction currency to project currency
431 * @param p_raw_cost_flag Flag indicating whether raw cost can be entered
432 * @rep:paraminfo {@rep:precision 1}
433 * @param p_burdened_cost_flag Flag indicating whether burdened cost can be entered
434 * @rep:paraminfo {@rep:precision 1}
435 * @param p_revenue_flag Flag indicating whether revenue can be entered
436 * @rep:paraminfo {@rep:precision 1}
437 * @param p_cost_qty_flag Flag indicating whether cost quantity can be entered
438 * @rep:paraminfo {@rep:precision 1}
439 * @param p_revenue_qty_flag Flag indicating whether revenue quantity can be entered
440 * @rep:paraminfo {@rep:precision 1}
441 * @param p_all_qty_flag Flag indicating whether quantity can be entered when planning for cost and revenue together
442 * @rep:paraminfo {@rep:precision 1}
443 * @param p_create_new_curr_working_flag Flag indicating whether a current working version should be created
444 * @param p_replace_current_working_flag Flag indicating whether the current working version should be deleted and the newly created version marked as the current working version
445 * @param p_using_resource_lists_flag Flag indicating whether resource lists are used
446 * @rep:scope public
447 * @rep:lifecycle active
448 * @rep:displayname Create Draft Budget
449 * @rep:compatibility S
450 */
451 PROCEDURE create_draft_budget
452 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
453 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
454 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
455 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
456 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
457 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
458 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
459 ,p_pm_budget_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
460 , p_budget_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
461 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
462 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
463 ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
464 ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
465 ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
466 ,p_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
467 ,p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
468 ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
469 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
470 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
474 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
471 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
472 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
473 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
475 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
476 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
477 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
478 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
479 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
480 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
481 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
482 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
483 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
484 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
485 ,p_budget_lines_in IN budget_line_in_tbl_type
486 ,p_budget_lines_out OUT NOCOPY budget_line_out_tbl_type
487
488 --The following parameters are added because of changes to due to finplan model
489 --Changes the default of the following parameters from NULL to G_PA_MISS_XXX 24-APR-03 by Xin Liu
490 ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
491 ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
492 ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
493 ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
494 ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
495 ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
496 ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
497 ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
498 ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
499 ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
500 ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
501 ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
502 ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
503 ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
504 ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
505 ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
506 ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
507 ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
508 ,p_raw_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
509 ,p_burdened_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
510 ,p_revenue_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
511 ,p_cost_qty_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
512 ,p_revenue_qty_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
513 ,P_all_qty_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
514 ,p_create_new_curr_working_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
515 ,p_replace_current_working_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
516 ,p_using_resource_lists_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
517 );
518
519
520 /*#
521 * This API is used to set up the global data structures that other Load-Execute-Fetch procedures use to create a new or update an existing draft budget in Oracle Projects.
522 * In order to execute this API, the following list of APIs should be executed in order of sequence.
523 * INIT_BUDGET
524 * INIT_CALCULATE_AMOUNTS
525 * LOAD_BUDGET_LINE
526 * EXECUTE_CALCULATE_AMOUNTS
527 * EXECUTE_CREATE_DRAFT_BUDGET/EXECUTE_UPDATE_BUDGET
528 * FETCH_CALCULATE_AMOUNTS
529 * FETCH_BUDGET_LINE
530 * CLEAR_BUDGET
531 * @rep:scope public
532 * @rep:lifecycle active
533 * @rep:displayname Create Multiple Budgets-Initialize
534 * @rep:compatibility S
535 */
536 PROCEDURE init_budget;
537
538 /*#
539 * This API is used to load a budget line to a global PL/SQL table.
540 * In order to execute this API, the following list of APIs should be executed in order of sequence.
541 * INIT_BUDGET
542 * INIT_CALCULATE_AMOUNTS
543 * LOAD_BUDGET_LINE
544 * EXECUTE_CALCULATE_AMOUNTS
545 * EXECUTE_CREATE_DRAFT_BUDGET/EXECUTE_UPDATE_BUDGET
546 * FETCH_CALCULATE_AMOUNTS
547 * FETCH_BUDGET_LINE
548 * CLEAR_BUDGET
552 * @rep:paraminfo {@rep:precision 1}
549 * @param p_api_version_number API standard: version number
550 * @rep:paraminfo {@rep:required}
551 * @param p_commit API standard (default = F): indicates if the transaction will be committed
553 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
554 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
555 * @rep:paraminfo {@rep:required}
556 * @param p_pa_task_id The reference code that uniquely identifies the task within a project in Oracle Projects
557 * @param p_pm_task_reference The unique reference code that identifies the task's parent task
558 * @param p_resource_alias Alias of the resource
559 * @param p_resource_list_member_id The identifier of the resource
560 * @param p_budget_start_date Start date of budget line
561 * @param p_budget_end_date End date of budget line
562 * @param p_period_name PA or GL period name
563 * @param p_description Description of the budget
564 * @param p_raw_cost Budgeted raw cost amount
565 * @param p_burdened_cost Budgeted burdened cost amount
566 * @param p_revenue Budgeted revenue amount
567 * @param p_quantity The quantity in the budget line
568 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
569 * @param p_pm_budget_line_reference The identifier of the budget in the external project management system from
570 * which the budget was imported
571 * @param p_attribute_category Descriptive flexfield category
572 * @param p_attribute1 Descriptive flexfield segment
573 * @param p_attribute2 Descriptive flexfield segment
574 * @param p_attribute3 Descriptive flexfield segment
575 * @param p_attribute4 Descriptive flexfield segment
576 * @param p_attribute5 Descriptive flexfield segment
577 * @param p_attribute6 Descriptive flexfield segment
578 * @param p_attribute7 Descriptive flexfield segment
579 * @param p_attribute8 Descriptive flexfield segment
580 * @param p_attribute9 Descriptive flexfield segment
581 * @param p_attribute10 Descriptive flexfield segment
582 * @param p_attribute11 Descriptive flexfield segment
583 * @param p_attribute12 Descriptive flexfield segment
584 * @param p_attribute13 Descriptive flexfield segment
585 * @param p_attribute14 Descriptive flexfield segment
586 * @param p_attribute15 Descriptive flexfield segment
587 * @param p_txn_currency_code The transaction currency code
588 * @rep:paraminfo {@rep:required}
589 * @param p_projfunc_cost_rate_type Rate type used to convert costs from transaction currency to project functional currency
590 * @param p_projfunc_cost_rate_date_type The rate date type for converting cost amounts from transaction currency to project functional currency
591 * @param p_projfunc_cost_rate_date The rate date for converting cost amounts from transaction currency to project functional currency
592 * @param p_projfunc_cost_exchange_rate Exchange rate used to convert costs from the transaction currency to the project functional currency if the exchange rate type is User
593 * @param p_projfunc_rev_rate_type The rate type for converting revenue amounts from the transaction currency to the project functional currency
594 * @param p_projfunc_rev_rate_date_type The rate date type for converting revenue amounts from transaction currency to project functional currency
595 * @param p_projfunc_rev_rate_date The rate date for converting revenue amounts from transaction currency to project functional currency
596 * @param p_projfunc_rev_exchange_rate Exchange rate used to convert revenue from the transaction currency to the project functional currency if the exchange rate type is User
597 * @param p_project_cost_rate_type The rate type for converting cost amounts from the transaction currency to the project currency
598 * @param p_project_cost_rate_date_type The rate date type for converting cost amounts from transaction currency to project currency
599 * @param p_project_cost_rate_date The rate date for converting cost amounts from transaction currency to project currency
600 * @param p_project_cost_exchange_rate Exchange rate used to convert costs from the transaction currency to the project currency if the exchange rate type is User
601 * @param p_project_rev_rate_type The rate type for converting revenue amounts from the transaction currency to the project currency
602 * @param p_project_rev_rate_date_type The rate date type for converting revenue amounts from transaction currency to project currency
603 * @param p_project_rev_rate_date The rate date for converting revenue amounts from transaction currency to project currency
604 * @param p_project_rev_exchange_rate Exchange rate used to convert revenue from the transaction currency to the project currency if the exchange rate type is User
605 * @param p_change_reason_code The identifier of the change reason
606 * @rep:scope public
607 * @rep:lifecycle active
608 * @rep:displayname Create Multiple Budgets- Load Budget Line
609 * @rep:compatibility S
610 */
611 PROCEDURE load_budget_line
612 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
613 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
614 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
615 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
616 ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
617 ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
618 ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
619 ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
620 ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
624 ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
621 ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
622 ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
623 ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
625 ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
626 ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
627 ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
628 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
629 ,p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
630 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
631 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
632 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
633 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
634 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
635 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
636 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
637 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
638 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
639 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
640 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
641 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
642 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
643 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
644 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
645 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
646
647 --Parameters for fin plan model
648 --Changes the default of the following parameters from NULL to G_PA_MISS_XXX 24-APR-03 by Xin Liu
649 ,p_txn_currency_code IN pa_fp_txn_currencies.txn_currency_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
650 ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
651 ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
652 ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
653 ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
654 ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
655 ,p_projfunc_rev_rate_date_type IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
656 ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
657 ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
658 ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
659 ,p_project_cost_rate_date_type IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
660 ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
661 ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
662 ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
663 ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
664 ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
665 ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
666 ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
667 );
668
669 /*#
670 * This API is used to create a budget and its budget lines using the data stored in the global tables during the load process.
671 * In order to execute this API, the following list of APIs should be executed in order of sequence.
672 * INIT_BUDGET
673 * INIT_CALCULATE_AMOUNTS
674 * LOAD_BUDGET_LINE
675 * EXECUTE_CALCULATE_AMOUNTS
676 * EXECUTE_CREATE_DRAFT_BUDGET/EXECUTE_UPDATE_BUDGET
677 * FETCH_CALCULATE_AMOUNTS
678 * FETCH_BUDGET_LINE
679 * CLEAR_BUDGET
680 * @param p_api_version_number API standard: version number
681 * @rep:paraminfo {@rep:required}
682 * @param p_commit API standard (default = F): indicates if the transaction will be committed
683 * @rep:paraminfo {@rep:precision 1}
684 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
685 * @param p_msg_count API standard: number of error messages
686 * @rep:paraminfo {@rep:required}
687 * @param p_msg_data API standard: error message
688 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
689 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
693 * @param p_pm_budget_reference The reference code that uniquely identifies the budget in the external system
690 * @rep:paraminfo {@rep:required}
691 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
692 * @rep:paraminfo {@rep:required}
694 * @param p_budget_version_name The user-defined name for the budget version
695 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects
696 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
697 * @param p_budget_type_code The identifier of the budget type
698 * @param p_change_reason_code The identifier of the change reason
699 * @param p_description Description of the budget
700 * @param p_entry_method_code The identifier of the budget entry method
701 * @param p_resource_list_name Name of the resource list
702 * @param p_resource_list_id The identifier of the resource list
703 * @param p_attribute_category Descriptive flexfield category
704 * @param p_attribute1 Descriptive flexfield segment
705 * @param p_attribute2 Descriptive flexfield segment
706 * @param p_attribute3 Descriptive flexfield segment
707 * @param p_attribute4 Descriptive flexfield segment
708 * @param p_attribute5 Descriptive flexfield segment
709 * @param p_attribute6 Descriptive flexfield segment
710 * @param p_attribute7 Descriptive flexfield segment
711 * @param p_attribute8 Descriptive flexfield segment
712 * @param p_attribute9 Descriptive flexfield segment
713 * @param p_attribute10 Descriptive flexfield segment
714 * @param p_attribute11 Descriptive flexfield segment
715 * @param p_attribute12 Descriptive flexfield segment
716 * @param p_attribute13 Descriptive flexfield segment
717 * @param p_attribute14 Descriptive flexfield segment
718 * @param p_attribute15 Descriptive flexfield segment
719 * @param p_fin_plan_type_name Financial plan type name in Oracle Projects. You must specify a value for this parameter or p_fin_plan_type_id.
720 * @param p_fin_plan_type_id Financial plan type identifier. You must supply a valid value for either p_fin_plan_type_name or p_fin_plan_type_id for budget or forecast versions created for financial plan types.
721 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. Valid values are COST, REVENUE, and ALL.
722 * @param p_fin_plan_level_code The planning level for the plan version. Valid values are P (project-level planning), T (top task-level planning), M (mixed-level planning - top and lowest tasks), and L (lowest task-level planning).
723 * @param p_time_phased_code The time phasing option. Valid values are P (planning by PA periods), G (planning by GL periods), and N (None: planning is done for the duration of the project or task).
724 * @param p_plan_in_multi_curr_flag Flag indicating whether the plan amounts can be entered in any currency
725 * @param p_projfunc_cost_rate_type Rate type used to convert costs from transaction currency to project functional currency
726 * @param p_projfunc_cost_rate_date_typ The rate date type for converting cost amounts from transaction currency to project functional currency
727 * @param p_projfunc_cost_rate_date The rate date for converting cost amounts from transaction currency to project functional currency
728 * @param p_projfunc_rev_rate_type The rate type for converting revenue amounts from the transaction currency to the project functional currency
729 * @param p_projfunc_rev_rate_date_typ The rate date type for converting revenue amounts from transaction currency to project functional currency
730 * @param p_projfunc_rev_rate_date The rate date for converting revenue amounts from transaction currency to project functional currency
731 * @param p_project_cost_rate_type The rate type for converting cost amounts from the transaction currency to the project currency
732 * @param p_project_cost_rate_date_typ The rate date type for converting cost amounts from transaction currency to project currency
733 * @param p_project_cost_rate_date The rate date for converting cost amounts from transaction currency to project currency
734 * @param p_project_rev_rate_type The rate type for converting revenue amounts from the transaction currency to the project currency
735 * @param p_project_rev_rate_date_typ The rate date type for converting revenue amounts from transaction currency to project currency
736 * @param p_project_rev_rate_date The rate date for converting revenue amounts from transaction currency to project currency
737 * @param p_raw_cost_flag Flag indicating whether raw cost can be entered
738 * @rep:paraminfo {@rep:precision 1}
739 * @param p_burdened_cost_flag Flag indicating whether burdened cost can be entered
740 * @rep:paraminfo {@rep:precision 1}
741 * @param p_revenue_flag Flag indicating whether revenue can be entered
742 * @rep:paraminfo {@rep:precision 1}
743 * @param p_cost_qty_flag Flag indicating whether cost quantity can be entered
744 * @rep:paraminfo {@rep:precision 1}
745 * @param p_revenue_qty_flag Flag indicating whether revenue quantity can be entered
746 * @rep:paraminfo {@rep:precision 1}
747 * @param p_all_qty_flag Flag indicating whether quantity can be entered when planning for cost and revenue together
748 * @rep:paraminfo {@rep:precision 1}
749 * @param p_create_new_curr_working_flag Flag indicating whether a current working version should be created
750 * @param p_replace_current_working_flag Flag indicating whether the current working version should be deleted and the newly created version marked as the current working version
751 * @param p_using_resource_lists_flag Flag indicating whether resource lists are used
752 * @rep:scope public
753 * @rep:lifecycle active
754 * @rep:displayname Create Multiple Budgets-Create Draft Budget
755 * @rep:compatibility S
756 */
757 PROCEDURE execute_create_draft_budget
758 ( p_api_version_number IN NUMBER
759 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
763 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
760 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
761 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
762 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
764 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
765 ,p_pm_budget_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
766 , p_budget_version_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
767 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
768 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
769 ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
770 ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
771 ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
772 ,p_entry_method_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
773 ,p_resource_list_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
774 ,p_resource_list_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
775 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
776 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
777 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
778 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
779 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
780 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
781 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
782 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
783 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
784 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
785 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
786 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
787 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
788 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
789 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
790 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
791
792 --Added the following parameters for changes in AMG due to finplan model
793 --Changes the default of the following parameters from NULL to G_PA_MISS_XXX 24-APR-03 by Xin Liu
794 ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
795 ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
796 ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
797 ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
798 ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
799 ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
800 ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
801 ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
802 ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
803 ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
804 ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
805 ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
809 ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
806 ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
807 ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
808 ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
810 ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
811 ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
812 ,p_raw_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
813 ,p_burdened_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
814 ,p_revenue_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
815 ,p_cost_qty_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
816 ,p_revenue_qty_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
817 ,P_all_qty_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
818 ,p_create_new_curr_working_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
819 ,p_replace_current_working_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
820 ,p_using_resource_lists_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
821 );
822
823 /*#
824 * This API is used to retrieve the return status determined during the creation of a budget line from a global PL/SQL table.
825 * In order to execute this API, the following list of APIs should be executed in order of sequence.
826 * INIT_BUDGET
827 * INIT_CALCULATE_AMOUNTS
828 * LOAD_BUDGET_LINE
829 * EXECUTE_CALCULATE_AMOUNTS
830 * EXECUTE_CREATE_DRAFT_BUDGET/EXECUTE_UPDATE_BUDGET
831 * FETCH_CALCULATE_AMOUNTS
832 * FETCH_BUDGET_LINE
833 * CLEAR_BUDGET
834 * @param p_api_version_number API standard: version number
835 * @rep:paraminfo {@rep:required}
836 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
837 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
838 * @rep:paraminfo {@rep:required}
839 * @param p_line_index Pointer to the budget line
840 * @rep:paraminfo {@rep:required}
841 * @param p_line_return_status Return status for the budget line
842 * @rep:scope public
843 * @rep:lifecycle active
844 * @rep:displayname Create Multiple Budgets-Load Fetch Line
845 * @rep:compatibility S
846 */
847 PROCEDURE fetch_budget_line
848 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
849 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
850 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
851 ,p_line_index IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
852 ,p_line_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
853
854 /*#
855 * This API is used clear the global data structures set up during the Initialize step.
856 * In order to execute this API, the following list of APIs should be executed in order of sequence.
857 * INIT_BUDGET
858 * INIT_CALCULATE_AMOUNTS
859 * LOAD_BUDGET_LINE
860 * EXECUTE_CALCULATE_AMOUNTS
861 * EXECUTE_CREATE_DRAFT_BUDGET/EXECUTE_UPDATE_BUDGET
862 * FETCH_CALCULATE_AMOUNTS
863 * FETCH_BUDGET_LINE
864 * CLEAR_BUDGET
865 * @rep:scope public
866 * @rep:lifecycle active
867 * @rep:displayname Create Multiple Budgets-Clear
868 * @rep:compatibility S
869 */
870 PROCEDURE clear_budget;
871
872 /*#
873 * This API is used to set an existing budget as the baseline budget in Oracle Projects.
874 * @param p_api_version_number API standard: version number
875 * @rep:paraminfo {@rep:required}
876 * @param p_commit API standard (default = F): indicates if the transaction will be committed
877 * @rep:paraminfo {@rep:precision 1}
878 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
879 * @param p_msg_count API standard: number of error messages
883 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
880 * @rep:paraminfo {@rep:required}
881 * @param p_msg_data API standard: error message
882 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
884 * @rep:paraminfo {@rep:required}
885 * @param p_workflow_started Flag indicating whether a workflow has been started
886 * @rep:paraminfo {@rep:required}
887 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
888 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects
889 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
890 * @param p_budget_type_code The identifier of the budget type
891 * @rep:paraminfo {@rep:required}
892 * @param p_mark_as_original Flag indicating whether to mark the budget as original
893 * @param p_fin_plan_type_name Financial plan type name in Oracle Projects. You must specify a value for this parameter or p_fin_plan_type_id.
894 * @param p_fin_plan_type_id Financial plan type identifier. You must supply a valid value for either p_fin_plan_type_name or p_fin_plan_type_id for budget or forecast versions created for financial plan types.
895 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. Valid values are COST, REVENUE, and ALL.
896 * @rep:scope public
897 * @rep:lifecycle active
898 * @rep:displayname Verify Budget Amounts
899 * @rep:compatibility S
900 */
901 PROCEDURE Baseline_Budget
902 ( p_api_version_number IN NUMBER
903 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
904 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
905 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
906 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
907 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
908 ,p_workflow_started OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
909 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
910 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
911 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
912 ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
913 ,p_mark_as_original IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
914 ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
915 ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
916 ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR);
917
918 /*#
919 * This API is used to add a budget line to a working budget in Oracle Projects for a given project and budget type.
920 * @param p_api_version_number API standard: version number
921 * @rep:paraminfo {@rep:required}
922 * @param p_commit API standard (default = F): indicates if the transaction will be committed
923 * @rep:paraminfo {@rep:precision 1}
924 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
925 * @param p_msg_count API standard: number of error messages
926 * @rep:paraminfo {@rep:required}
927 * @param p_msg_data API standard: error message
928 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
929 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
930 * @rep:paraminfo {@rep:required}
931 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
932 * @rep:paraminfo {@rep:required}
933 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects
934 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
935 * @param p_budget_type_code The identifier of the budget type
936 * @param p_pa_task_id The reference code that uniquely identifies the task within a project in Oracle Projects
937 * @param p_pm_task_reference The reference code that uniquely identifies the task in the external system
938 * @param p_resource_alias Alias of the resource
939 * @param p_resource_list_member_id The identifier of the resource
940 * @param p_budget_start_date Start date of budget line
941 * @param p_budget_end_date End date of budget line
942 * @param p_period_name PA or GL period name
943 * @param p_description Plan line description
944 * @param p_raw_cost Budgeted raw cost amount
945 * @param p_burdened_cost Budgeted burdened cost amount
946 * @param p_revenue Budgeted revenue amount
947 * @param p_quantity The quantity entered into the budget line
948 * @param p_pm_budget_line_reference The identifier of the budget in the external project management system from
949 * which the budget was imported
950 * @param p_attribute_category Descriptive flexfield category
951 * @param p_attribute1 Descriptive flexfield segment
952 * @param p_attribute2 Descriptive flexfield segment
953 * @param p_attribute3 Descriptive flexfield segment
954 * @param p_attribute4 Descriptive flexfield segment
955 * @param p_attribute5 Descriptive flexfield segment
956 * @param p_attribute6 Descriptive flexfield segment
957 * @param p_attribute7 Descriptive flexfield segment
958 * @param p_attribute8 Descriptive flexfield segment
959 * @param p_attribute9 Descriptive flexfield segment
960 * @param p_attribute10 Descriptive flexfield segment
961 * @param p_attribute11 Descriptive flexfield segment
962 * @param p_attribute12 Descriptive flexfield segment
963 * @param p_attribute13 Descriptive flexfield segment
967 * @param p_fin_plan_type_name Financial plan type name in Oracle Projects. You must specify a value for this parameter or p_fin_plan_type_id.
964 * @param p_attribute14 Descriptive flexfield segment
965 * @param p_attribute15 Descriptive flexfield segment
966 * @param p_fin_plan_type_id Financial plan type identifier. You must supply a valid value for either p_fin_plan_type_name or p_fin_plan_type_id for budget or forecast versions created for financial plan types.
968 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. Valid values are COST, REVENUE, and ALL.
969 * @param p_version_number Financial plan version number. Required to add a plan line to a version other than the current working version.
970 * @param p_currency_code Financial plan currency identifier. Required if planning in multiple transaction currencies
971 * @param p_change_reason_code The reference code that identifies the change reason
972 * @rep:scope public
973 * @rep:lifecycle active
974 * @rep:displayname Create Budget Line
975 * @rep:compatibility S
976 */
977 PROCEDURE add_budget_line
978 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
979 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
980 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
981 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
982 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
983 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
984 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
985 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
986 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
987 ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
988 ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
989 ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
990 ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
991 ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
992 ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
993 ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
994 ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
995 ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
996 ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
997 ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
998 ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
999 ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1000 , p_pm_budget_line_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1001 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1002 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1003 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1004 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1005 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1006 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1007 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1008 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1009 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1010 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1011 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1012 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1013 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1014 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1015 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1016 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1017 --Parameters added for FP.M
1018 ,p_fin_plan_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1019 ,p_fin_plan_type_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1020 ,p_version_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1021 ,p_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1022 ,p_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1023 ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );
1024
1025 /*#
1026 * This API is used to delete a working budget in Oracle Projects for a given project and budget type.
1027 * @param p_api_version_number API standard: version number
1028 * @rep:paraminfo {@rep:required}
1029 * @param p_commit API standard (default = F): indicates if the transaction will be committed
1030 * @rep:paraminfo {@rep:precision 1}
1031 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
1032 * @param p_msg_count API standard: number of error messages
1033 * @rep:paraminfo {@rep:required}
1034 * @param p_msg_data API standard: error message
1038 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
1035 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
1036 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
1037 * @rep:paraminfo {@rep:required}
1039 * @rep:paraminfo {@rep:required}
1040 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects
1041 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
1042 * @param p_budget_type_code The identifier of the budget type
1043 * @param p_fin_plan_type_name Financial plan type name in Oracle Projects. You must specify a value for this parameter or p_fin_plan_type_id.
1044 * @param p_fin_plan_type_id Financial plan type identifier. You must supply a valid value for either p_fin_plan_type_name or p_fin_plan_type_id for budget or forecast versions created for financial plan types.
1045 * @param p_version_number Financial plan version number. Required to delete a plan version other than the current working version
1046 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. Valid values are COST, REVENUE, and ALL.
1047 * @rep:scope public
1048 * @rep:lifecycle active
1049 * @rep:displayname Delete Draft Budget
1050 * @rep:compatibility S
1051 */
1052 PROCEDURE delete_draft_budget
1053 ( p_api_version_number IN NUMBER
1054 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1055 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1056 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1057 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1058 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1059 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1060 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1061 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1062 ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1063
1064 -- Parameters required for Fin Plan Model
1065 -- Changes by Xin Liu, change the default to G_PA_MISS_XXX
1066 ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1067 ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1068 ,p_version_number IN pa_budget_versions.version_number%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1069 ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1070 ) ;
1071
1072 /*#
1073 * This API is used to delete a budget line from a working budget in Oracle Projects for a given project and budget type.
1074 * @param p_api_version_number API standard: version number
1075 * @rep:paraminfo {@rep:required}
1076 * @param p_commit API standard (default = F): indicates if the transaction will be committed
1077 * @rep:paraminfo {@rep:precision 1}
1078 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
1079 * @param p_msg_count API standard: number of error messages
1080 * @rep:paraminfo {@rep:required}
1081 * @param p_msg_data API standard: error message
1082 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
1083 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
1084 * @rep:paraminfo {@rep:required}
1085 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
1086 * @rep:paraminfo {@rep:required}
1087 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects
1088 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
1089 * @param p_budget_type_code The identifier of the budget type
1090 * @param p_pa_task_id The reference code that uniquely identifies the task within a project in Oracle Projects
1091 * @param p_pm_task_reference The unique reference code that identifies the task's parent task
1092 * @param p_resource_alias Alias of the resource
1093 * @param p_resource_list_member_id The identifier of the resource
1094 * @param p_start_date Start date of budget line
1095 * @param p_period_name PA or GL period name
1096 * @param p_fin_plan_type_id Financial plan type identifier. You must supply a valid value for either p_fin_plan_type_name or p_fin_plan_type_id for budget or forecast versions created for financial plan types.
1097 * @param p_fin_plan_type_name Financial plan type name in Oracle Projects. You must specify a value for this parameter or p_fin_plan_type_id.
1098 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. Valid values are COST, REVENUE, and ALL.
1099 * @param p_version_number Financial plan version number. Required to delete a plan line from a version other than the current working version
1100 * @param p_currency_code Financial plan currency identifier. Required if planning in multiple transaction currencies
1101 * @rep:scope public
1102 * @rep:lifecycle active
1103 * @rep:displayname Delete Budget Line
1104 * @rep:compatibility S
1105 */
1106 PROCEDURE delete_budget_line
1107 ( p_api_version_number IN NUMBER
1108 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1109 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1110 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1111 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1112 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1113 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1117 ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1114 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1115 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1116 ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1118 ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1119 ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1120 ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1121 ,p_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1122 ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1123 --Parameters added for FP.M
1124 ,p_fin_plan_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1125 ,p_fin_plan_type_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1126 ,p_version_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1127 ,p_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1128 ,p_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR );
1129
1130 /*#
1131 * This API is used to update a working budget.
1132 * @param p_api_version_number API standard: version number
1133 * @rep:paraminfo {@rep:required}
1134 * @param p_commit API standard (default = F): indicates if the transaction will be committed
1135 * @rep:paraminfo {@rep:precision 1}
1136 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
1137 * @param p_msg_count API standard: number of error messages
1138 * @rep:paraminfo {@rep:required}
1139 * @param p_msg_data API standard: error message
1140 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
1141 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
1142 * @rep:paraminfo {@rep:required}
1143 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
1144 * @rep:paraminfo {@rep:required}
1145 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects
1146 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
1147 * @param p_budget_type_code The identifier of the budget type
1148 * @param p_change_reason_code The identifier of the change reason
1149 * @param p_description Description of the budget
1150 * @param p_attribute_category Descriptive flexfield category
1151 * @param p_attribute1 Descriptive flexfield segment
1152 * @param p_attribute2 Descriptive flexfield segment
1153 * @param p_attribute3 Descriptive flexfield segment
1154 * @param p_attribute4 Descriptive flexfield segment
1155 * @param p_attribute5 Descriptive flexfield segment
1156 * @param p_attribute6 Descriptive flexfield segment
1157 * @param p_attribute7 Descriptive flexfield segment
1158 * @param p_attribute8 Descriptive flexfield segment
1159 * @param p_attribute9 Descriptive flexfield segment
1160 * @param p_attribute10 Descriptive flexfield segment
1161 * @param p_attribute11 Descriptive flexfield segment
1162 * @param p_attribute12 Descriptive flexfield segment
1163 * @param p_attribute13 Descriptive flexfield segment
1164 * @param p_attribute14 Descriptive flexfield segment
1165 * @param p_attribute15 Descriptive flexfield segment
1166 * @param p_budget_lines_in Input budget lines
1167 * @param p_budget_lines_out Output budget lines
1168 * @param p_resource_list_id The identifier of the resource list
1169 * @param p_set_current_working_flag Flag indicating whether to set the plan as the current working version
1170 * @param p_budget_version_number Budget version number
1171 * @param p_budget_version_name Budget version name
1172 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. Valid values are COST, REVENUE, and ALL.
1173 * @param p_finplan_type_id Financial plan type identifier. You must supply a valid value for either p_fin_plan_type_name or p_fin_plan_type_id for budget or forecast versions created for financial plan types.
1174 * @param p_finplan_type_name Financial plan type name in Oracle Projects. You must specify a value for this parameter or P_FIN_PLAN_TYPE_ID.
1175 * @param p_plan_in_multi_curr_flag Flag indicating whether the plan allows multi currency transactions
1176 * @param p_time_phased_code The time phasing option. Valid values are P (planning by PA periods), G (planning by GL periods), and N (None: planning is done for the duration of the project or task).
1177 * @param p_projfunc_cost_rate_type Rate type used to convert costs from transaction currency to project functional currency
1178 * @param p_projfunc_cost_rate_date_typ The rate date type for converting cost amounts from transaction currency to project functional currency
1179 * @param p_projfunc_cost_rate_date The rate date for converting cost amounts from transaction currency to project functional currency
1180 * @param p_projfunc_cost_exchange_rate Exchange rate used to convert costs from the transaction currency to the project functional currency if the exchange rate type is User
1181 * @param p_projfunc_rev_rate_type The rate type for converting revenue amounts from the transaction currency to the project functional currency
1182 * @param p_projfunc_rev_rate_date_typ The rate date type for converting revenue amounts from transaction currency to project functional currency
1183 * @param p_projfunc_rev_rate_date The rate date for converting revenue amounts from transaction currency to project functional currency
1184 * @param p_projfunc_rev_exchange_rate Exchange rate used to convert revenue from the transaction currency to the project functional currency if the exchange rate type is User
1188 * @param p_project_cost_exchange_rate Exchange rate used to convert costs from the transaction currency to the project currency if the exchange rate type is User
1185 * @param p_project_cost_rate_type The rate type for converting cost amounts from the transaction currency to the project currency
1186 * @param p_project_cost_rate_date_typ The rate date type for converting cost amounts from transaction currency to project currency
1187 * @param p_project_cost_rate_date The rate date for converting cost amounts from transaction currency to project currency
1189 * @param p_project_rev_rate_type The rate type for converting revenue amounts from the transaction currency to the project currency
1190 * @param p_project_rev_rate_date_typ The rate date type for converting revenue amounts from transaction currency to project currency
1191 * @param p_project_rev_rate_date The rate date for converting revenue amounts from transaction currency to project currency
1192 * @param p_project_rev_exchange_rate Exchange rate used to convert revenue from the transaction currency to the project currency if the exchange rate type is User
1193 * @param p_raw_cost_flag Flag that indicates whether raw cost is enterable
1194 * @rep:paraminfo {@rep:precision 1}
1195 * @param p_burdened_cost_flag Flag that indicates whether burdened cost is enterable
1196 * @rep:paraminfo {@rep:precision 1}
1197 * @param p_revenue_flag Flag that indicates whether revenue is enterable
1198 * @rep:paraminfo {@rep:precision 1}
1199 * @param p_cost_qty_flag Indicates whether cost quantity could be entered
1200 * @rep:paraminfo {@rep:precision 1}
1201 * @param p_revenue_qty_flag Indicates whether revenue quantity could be entered
1202 * @rep:paraminfo {@rep:precision 1}
1203 * @param p_all_qty_flag Indicates whether quantity can be entered when planning for Cost and Revenue together
1204 * @rep:paraminfo {@rep:precision 1}
1205 * @param p_bill_rate_flag Indicates whether bill rate could be entered
1206 * @rep:paraminfo {@rep:precision 1}
1207 * @param p_cost_rate_flag Indicates whether cost rate could be entered
1208 * @rep:paraminfo {@rep:precision 1}
1209 * @param p_burden_rate_flag Indicates whether burden rate could be entered
1210 * @rep:paraminfo {@rep:precision 1}
1211 * @rep:scope public
1212 * @rep:lifecycle active
1213 * @rep:displayname Update Budget
1214 * @rep:compatibility S
1215 */
1216 PROCEDURE update_budget
1217 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1218 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1219 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1220 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1221 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1222 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1223 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1224 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1225 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1226 ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1227 ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1228 ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1229 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1230 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1231 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1232 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1233 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1234 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1235 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1236 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1237 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1238 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1239 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1240 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1241 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1242 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1243 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1244 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1245 ,p_budget_lines_in IN budget_line_in_tbl_type
1246 ,p_budget_lines_out OUT NOCOPY budget_line_out_tbl_type
1247 --Added for bug 4224464(this fix is available on 44 branch)
1248 --Added for the bug 3453650
1249 ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1250 ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1251 ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1252 ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1253 ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
1254 ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1258 ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1255 ,p_finplan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1256 ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1257 ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1259 ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1260 ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1261 ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1262 ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1263 ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1264 ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1265 ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1266 ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1267 ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1268 ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1269 ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1270 ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1271 ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1272 ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1273 ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1274 /* Plan Amount Entry flags introduced by bug 6408139 */
1275 ,p_raw_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1276 ,p_burdened_cost_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1277 ,p_revenue_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1278 ,p_cost_qty_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1279 ,p_revenue_qty_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1280 ,p_all_qty_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1281 ,p_bill_rate_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1282 ,p_cost_rate_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1283 ,p_burden_rate_flag IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1284 );
1285
1286 /*#
1287 * This API is used to update a budget and its budget lines using the data stored in the global tables during the load process.
1288 * In order to execute this API, the following list of APIs should be executed in order of sequence.
1289 * INIT_BUDGET
1290 * INIT_CALCULATE_AMOUNTS
1291 * LOAD_BUDGET_LINE
1292 * EXECUTE_CALCULATE_AMOUNTS
1293 * EXECUTE_CREATE_DRAFT_BUDGET/EXECUTE_UPDATE_BUDGET
1294 * FETCH_CALCULATE_AMOUNTS
1295 * FETCH_BUDGET_LINE
1296 * CLEAR_BUDGET
1297 * @param p_api_version_number API standard: version number
1298 * @rep:paraminfo {@rep:required}
1299 * @param p_commit API standard (default = F): indicates if the transaction will be committed
1300 * @rep:paraminfo {@rep:precision 1}
1301 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
1302 * @param p_msg_count API standard: number of error messages
1303 * @rep:paraminfo {@rep:required}
1304 * @param p_msg_data API standard: error message
1305 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
1306 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
1307 * @rep:paraminfo {@rep:required}
1308 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
1309 * @rep:paraminfo {@rep:required}
1310 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects
1311 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
1312 * @param p_budget_type_code The identifier of the budget type
1313 * @rep:paraminfo {@rep:required}
1314 * @param p_change_reason_code The identifier of the change reason
1315 * @param p_description Description of the budget
1316 * @param p_attribute_category Descriptive flexfield category
1317 * @param p_attribute1 Descriptive flexfield segment
1318 * @param p_attribute2 Descriptive flexfield segment
1319 * @param p_attribute3 Descriptive flexfield segment
1320 * @param p_attribute4 Descriptive flexfield segment
1321 * @param p_attribute5 Descriptive flexfield segment
1322 * @param p_attribute6 Descriptive flexfield segment
1323 * @param p_attribute7 Descriptive flexfield segment
1324 * @param p_attribute8 Descriptive flexfield segment
1325 * @param p_attribute9 Descriptive flexfield segment
1326 * @param p_attribute10 Descriptive flexfield segment
1327 * @param p_attribute11 Descriptive flexfield segment
1328 * @param p_attribute12 Descriptive flexfield segment
1329 * @param p_attribute13 Descriptive flexfield segment
1330 * @param p_attribute14 Descriptive flexfield segment
1331 * @param p_attribute15 Descriptive flexfield segment
1335 * @param p_budget_version_name Budget version Name
1332 * @param p_resource_list_id Resource list identifier
1333 * @param p_set_current_working_flag Flag indicating whether to set the plan as the current working version
1334 * @param p_budget_version_number Budget version number
1336 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. Valid values are COST, REVENUE, and ALL.
1337 * @param p_finplan_type_id The identifier of financial plan type
1338 * @param p_plan_in_multi_curr_flag Flag indicating if the version can be planned in multiple transaction currencies
1339 * @param p_time_phased_code The time phasing option. Valid values are P (planning by PA periods), G (planning by GL periods), and N (None: planning is done for the duration of the project or task).
1340 * @param p_projfunc_cost_rate_type Rate type used to convert costs from transaction currency to project functional currency
1341 * @param p_projfunc_cost_rate_date_typ The rate date type for converting cost amounts from transaction currency to project functional currency
1342 * @param p_projfunc_cost_rate_date The rate date for converting cost amounts from transaction currency to project functional currency
1343 * @param p_projfunc_cost_exchange_rate Exchange rate used to convert costs from the transaction currency to the project functional currency if the exchange rate type is User
1344 * @param p_projfunc_rev_rate_type The rate type for converting revenue amounts from the transaction currency to the project functional currency
1345 * @param p_projfunc_rev_rate_date_typ The rate date type for converting revenue amounts from transaction currency to project functional currency
1346 * @param p_projfunc_rev_rate_date The rate date for converting revenue amounts from transaction currency to project functional currency
1347 * @param p_projfunc_rev_exchange_rate Exchange rate used to convert revenue from the transaction currency to the project functional currency if the exchange rate type is User
1348 * @param p_project_cost_rate_type The rate type for converting cost amounts from the transaction currency to the project currency
1349 * @param p_project_cost_rate_date_typ The rate date type for converting cost amounts from transaction currency to project currency
1350 * @param p_project_cost_rate_date The rate date for converting cost amounts from transaction currency to project currency
1351 * @param p_project_cost_exchange_rate Exchange rate used to convert costs from the transaction currency to the project currency if the exchange rate type is User
1352 * @param p_project_rev_rate_type The rate type for converting revenue amounts from the transaction currency to the project currency
1353 * @param p_project_rev_rate_date_typ The rate date type for converting revenue amounts from transaction currency to project currency
1354 * @param p_project_rev_rate_date The rate date for converting revenue amounts from transaction currency to project currency
1355 * @param p_project_rev_exchange_rate Exchange rate used to convert revenue from the transaction currency to the project currency if the exchange rate type is User
1356 * @rep:scope public
1357 * @rep:lifecycle active
1358 * @rep:displayname Update Multiple Budgets
1359 * @rep:compatibility S
1360 */
1361 PROCEDURE execute_update_budget
1362 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1363 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1364 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1365 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1366 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1367 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1368 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1369 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1370 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1371 ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1372 ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1373 ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1374 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1375 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1376 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1377 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1378 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1379 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1380 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1381 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1382 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1383 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1384 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1385 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1386 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1387 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1388 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1389 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1390 --Added for bug 4224464(this fix is available on 44 branch)
1391 --Added for the bug 3453650
1392 ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1396 ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- 3453650
1393 ,p_set_current_working_flag IN pa_budget_versions.current_working_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1394 ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1395 ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1397 ,p_finplan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1398 ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1399 ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1400 ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1401 ,p_projfunc_cost_rate_date_typ IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1402 ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1403 ,p_projfunc_cost_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1404 ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1405 ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1406 ,p_projfunc_rev_rate_date IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1407 ,p_projfunc_rev_exchange_rate IN pa_budget_lines.projfunc_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1408 ,p_project_cost_rate_type IN pa_proj_fp_options.project_cost_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1409 ,p_project_cost_rate_date_typ IN pa_proj_fp_options.project_cost_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1410 ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1411 ,p_project_cost_exchange_rate IN pa_budget_lines.project_cost_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1412 ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1413 ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1414 ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1415 ,p_project_rev_exchange_rate IN pa_budget_lines.project_rev_exchange_rate%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM );
1416
1417 /*#
1418 * This API is used to update an existing budget line of a working budget in Oracle Projects for a given project and budget type.
1419 * @param p_api_version_number API standard: version number
1420 * @rep:paraminfo {@rep:required}
1421 * @param p_commit API standard (default = F): indicates if the transaction will be committed
1422 * @rep:paraminfo {@rep:precision 1}
1423 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
1424 * @param p_msg_count API standard: number of error messages
1425 * @rep:paraminfo {@rep:required}
1426 * @param p_msg_data API standard: error message
1427 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
1428 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
1429 * @rep:paraminfo {@rep:required}
1430 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
1431 * @rep:paraminfo {@rep:required}
1432 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects
1433 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
1434 * @param p_budget_type_code The identifier of the budget type
1435 * @param p_pa_task_id The reference code that uniquely identifies the task within a project in Oracle Projects
1436 * @param p_pm_task_reference The unique reference code that identifies the task's parent task
1437 * @param p_resource_alias Alias of the resource
1438 * @param p_resource_list_member_id The identifier of the resource
1439 * @param p_budget_start_date Start date of budget line
1440 * @param p_budget_end_date End date of budget line
1441 * @param p_period_name PA or GL period name
1442 * @param p_description Description of the budget line
1443 * @param p_raw_cost Budgeted raw cost amount
1444 * @param p_burdened_cost Budgeted burdened cost amount
1445 * @param p_revenue Budgeted revenue amount
1446 * @param p_quantity Budgeted quantity
1447 * @param p_attribute_category Descriptive flexfield category
1448 * @param p_attribute1 Descriptive flexfield segment
1449 * @param p_attribute2 Descriptive flexfield segment
1450 * @param p_attribute3 Descriptive flexfield segment
1451 * @param p_attribute4 Descriptive flexfield segment
1452 * @param p_attribute5 Descriptive flexfield segment
1453 * @param p_attribute6 Descriptive flexfield segment
1454 * @param p_attribute7 Descriptive flexfield segment
1455 * @param p_attribute8 Descriptive flexfield segment
1456 * @param p_attribute9 Descriptive flexfield segment
1457 * @param p_attribute10 Descriptive flexfield segment
1458 * @param p_attribute11 Descriptive flexfield segment
1459 * @param p_attribute12 Descriptive flexfield segment
1460 * @param p_attribute13 Descriptive flexfield segment
1461 * @param p_attribute14 Descriptive flexfield segment
1462 * @param p_attribute15 Descriptive flexfield segment
1466 * @param p_version_number Financial plan version number. Required to update a plan line to a version other than the current working version
1463 * @param p_fin_plan_type_id Financial plan type identifier. You must supply a valid value for either p_fin_plan_type_name or p_fin_plan_type_id for budget or forecast versions created for financial plan types.
1464 * @param p_fin_plan_type_name Financial plan type name in Oracle Projects. You must specify a value for this parameter or p_fin_plan_type_id.
1465 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. Valid values are COST, REVENUE, and ALL.
1467 * @param p_currency_code Financial plan currency identifier. Required if planning in multiple transaction currencies
1468 * @param p_change_reason_code The identifier of the change reason
1469 * @param p_projfunc_cost_rate_type Rate type used to convert costs from transaction currency to project functional currency
1470 * @param p_projfunc_cost_rate_date_typ The rate date type for converting cost amounts from transaction currency to project functional currency
1471 * @param p_projfunc_cost_rate_date The rate date for converting cost amounts from transaction currency to project functional currency
1472 * @param p_projfunc_cost_exchange_rate Exchange rate used to convert costs from the transaction currency to the project functional currency if the exchange rate type is User
1473 * @param p_projfunc_rev_rate_type Rate type used to convert revenue from transaction currency to project functional currency
1474 * @param p_projfunc_rev_rate_date_typ The rate date type for converting revenue amounts from transaction currency to project functional currency
1475 * @param p_projfunc_rev_rate_date The rate date for converting revenue amounts from transaction currency to project functional currency
1476 * @param p_projfunc_rev_exchange_rate Exchange rate used to convert revenue from the transaction currency to the project functional currency if the exchange rate type is User
1477 * @param p_project_cost_rate_type Rate type used to convert costs from transaction currency to project currency
1478 * @param p_project_cost_rate_date_typ The rate date type for converting cost amounts from transaction currency to project currency
1479 * @param p_project_cost_rate_date The rate date for converting cost amounts from transaction currency to project currency
1480 * @param p_project_cost_exchange_rate Exchange rate used to convert costs from the transaction currency to the project currency if the exchange rate type is User
1481 * @param p_project_rev_rate_type Rate type used to convert revenue from transaction currency to project currency
1482 * @param p_project_rev_rate_date_typ The rate date type for converting revenue amounts from transaction currency to project currency
1483 * @param p_project_rev_rate_date The rate date for converting revenue amounts from transaction currency to project currency
1484 * @param p_project_rev_exchange_rate Exchange rate used to convert revenue from the transaction currency to the project currency if the exchange rate type is User
1485 * @rep:scope public
1486 * @rep:lifecycle active
1487 * @rep:displayname Update Budget Line
1488 * @rep:compatibility S
1489 */
1490 PROCEDURE update_budget_line
1491 ( p_api_version_number IN NUMBER
1492 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1493 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1494 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1495 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1496 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1497 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1498 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1499 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1500 ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1501 ,p_pa_task_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1502 ,p_pm_task_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1503 ,p_resource_alias IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1504 ,p_resource_list_member_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1505 ,p_budget_start_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1506 ,p_budget_end_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1507 ,p_period_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1508 ,p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1509 ,p_raw_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1510 ,p_burdened_cost IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1511 ,p_revenue IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1512 ,p_quantity IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1513 ,p_attribute_category IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1514 ,p_attribute1 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1515 ,p_attribute2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1516 ,p_attribute3 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1517 ,p_attribute4 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1518 ,p_attribute5 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1519 ,p_attribute6 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1520 ,p_attribute7 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1521 ,p_attribute8 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1522 ,p_attribute9 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1523 ,p_attribute10 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1527 ,p_attribute14 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1524 ,p_attribute11 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1525 ,p_attribute12 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1526 ,p_attribute13 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1528 ,p_attribute15 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1529 --Parameters added for FP.M
1530 ,p_fin_plan_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1531 ,p_fin_plan_type_name IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1532 ,p_version_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1533 ,p_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1534 ,p_currency_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1535 ,p_change_reason_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1536 ,p_projfunc_cost_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1537 ,p_projfunc_cost_rate_date_typ IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1538 ,p_projfunc_cost_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1539 ,p_projfunc_cost_exchange_rate IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1540 ,p_projfunc_rev_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1541 ,p_projfunc_rev_rate_date_typ IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1542 ,p_projfunc_rev_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1543 ,p_projfunc_rev_exchange_rate IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1544 ,p_project_cost_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1545 ,p_project_cost_rate_date_typ IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1546 ,p_project_cost_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1547 ,p_project_cost_exchange_rate IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1548 ,p_project_rev_rate_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1549 ,p_project_rev_rate_date_typ IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1550 ,p_project_rev_rate_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
1551 ,p_project_rev_exchange_rate IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1552 );
1553
1554 /*#
1555 * Using the PA_CLIENT_EXTN_BUDGET extension, you can use this API to recalculate raw cost, burdened cost, and revenue amounts for existing budget lines.
1556 * @param p_api_version_number API standard: version number
1557 * @param p_commit API standard (default = F): indicates if the transaction will be committed
1558 * @rep:paraminfo {@rep:precision 1}
1559 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
1560 * @param p_msg_count API standard: number of error messages
1561 * @rep:paraminfo {@rep:required}
1562 * @param p_msg_data API standard: error message
1563 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
1564 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
1565 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1566 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
1567 * @rep:paraminfo {@rep:required}
1568 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects
1569 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
1570 * @param p_budget_type_code The identifier of the budget type
1571 * @param p_calc_raw_cost_yn Flag indicating whether to calculate raw cost
1572 * @param p_calc_burdened_cost_yn Flag indicating whether to calculate burden cost
1573 * @param p_calc_revenue_yn Flag indicating whether to calculate revenue
1574 * @param p_update_db_flag Flag indicating whether to update the database
1575 * @param p_calc_budget_lines_out Calculated budget lines
1576 * @rep:paraminfo {@rep:required}
1577 * @param p_budget_version_id The identifier of the budget version
1578 * @param p_fin_plan_type_id Financial plan type identifier. You must supply a valid value for either p_fin_plan_type_name or p_fin_plan_type_id for budget or forecast versions created for financial plan types.
1579 * @param p_fin_plan_type_name Financial plan type name in Oracle Projects. You must specify a value for this parameter or p_fin_plan_type_id.
1580 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. Valid values are COST, REVENUE, and ALL.
1581 * @param p_budget_version_number Budget version number
1582 * @rep:scope public
1583 * @rep:lifecycle active
1584 * @rep:displayname Get Budget Amounts
1585 * @rep:compatibility S
1586 */
1587 PROCEDURE Calculate_Amounts
1588 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1589 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1590 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1591 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1592 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1593 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1594 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1595 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1596 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1597 ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1598 ,p_calc_raw_cost_yn IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1599 ,p_calc_burdened_cost_yn IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1603 -- Bug 2863564 Parameters required for new Fin Plan Model
1600 ,p_calc_revenue_yn IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1601 ,p_update_db_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1602 ,p_calc_budget_lines_out OUT NOCOPY calc_budget_line_out_tbl_type
1604 ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1605 ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1606 ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1607 ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1608 ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1609 );
1610
1611 /*#
1612 * This API is used to set up the global data structures used by the CALCULATE_AMOUNTS API.
1613 * In order to execute this API, the following list of APIs should be executed in order of sequence.
1614 * INIT_BUDGET
1615 * INIT_CALCULATE_AMOUNTS
1616 * LOAD_BUDGET_LINE
1617 * EXECUTE_CALCULATE_AMOUNTS
1618 * EXECUTE_CREATE_DRAFT_BUDGET/EXECUTE_UPDATE_BUDGET
1619 * FETCH_CALCULATE_AMOUNTS
1620 * FETCH_BUDGET_LINE
1621 * CLEAR_BUDGET
1622 * @rep:scope public
1623 * @rep:lifecycle active
1624 * @rep:displayname Create Multiple Budgets-Initialize Calculate Amounts
1625 * @rep:compatibility S
1626 */
1627 PROCEDURE Init_Calculate_Amounts ;
1628
1629 /*#
1630 * This API is used to calculate the raw cost, burdened cost, and revenue amounts using existing budget lines for a given project and budget type.
1631 * In order to execute this API, the following list of APIs should be executed in order of sequence.
1632 * INIT_BUDGET
1633 * INIT_CALCULATE_AMOUNTS
1634 * LOAD_BUDGET_LINE
1635 * EXECUTE_CALCULATE_AMOUNTS
1636 * EXECUTE_CREATE_DRAFT_BUDGET/EXECUTE_UPDATE_BUDGET
1637 * FETCH_CALCULATE_AMOUNTS
1638 * FETCH_BUDGET_LINE
1639 * CLEAR_BUDGET
1640 * @param p_api_version_number API standard: version number
1641 * @rep:paraminfo {@rep:required}
1642 * @param p_commit API standard (default = F): indicates if the transaction will be committed
1643 * @rep:paraminfo {@rep:precision 1}
1644 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
1645 * @param p_msg_count API standard: number of error messages
1646 * @rep:paraminfo {@rep:required}
1647 * @param p_msg_data API standard: error message
1648 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
1649 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
1650 * @rep:paraminfo {@rep:precision 1} {@rep:required}
1651 * @param p_tot_budget_lines_calculated Indicates the total number of budget lines calculated and determines how many times to call the API FETCH_CALCULATE_AMOUNTS
1652 * @rep:paraminfo {@rep:required}
1653 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
1654 * @rep:paraminfo {@rep:required}
1655 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects
1656 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system
1657 * @param p_budget_type_code The identifier of the budget type
1658 * @rep:paraminfo {@rep:required}
1659 * @param p_calc_raw_cost_yn Flag indicating whether raw cost should be calculated
1660 * @param p_calc_burdened_cost_yn Flag indicating whether burden cost should be calculated
1661 * @param p_calc_revenue_yn Flag indicating whether revenue should be calculated
1662 * @param p_update_db_flag Flag indicating whether to update changes to database
1663 * @param p_budget_version_id The identifier of the budget version
1664 * @param p_fin_plan_type_id Financial plan type identifier. You must supply a valid value for either p_fin_plan_type_name or p_fin_plan_type_id for budget or forecast versions created for financial plan types.
1665 * @param p_fin_plan_type_name Financial plan type name in Oracle Projects. You must specify a value for this parameter or p_fin_plan_type_id.
1666 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. Valid values are COST, REVENUE, and ALL.
1667 * @param p_budget_version_number Budget version number
1668 * @rep:scope public
1669 * @rep:lifecycle active
1670 * @rep:displayname Create Multiple Budgets-Execute Calculate Amounts
1671 * @rep:compatibility S
1672 */
1673 PROCEDURE Execute_Calculate_Amounts
1674 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1675 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1676 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1677 ,p_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1678 ,p_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1679 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1680 ,p_tot_budget_lines_calculated OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1681 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1682 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1683 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1684 ,p_budget_type_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1685 ,p_calc_raw_cost_yn IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1686 ,p_calc_burdened_cost_yn IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1687 ,p_calc_revenue_yn IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1691 ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1688 ,p_update_db_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1689 -- Bug 2863564 Parameters required for new Fin Plan Model
1690 ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1692 ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1693 ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1694 ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1695 );
1696
1697 /*#
1698 * This API is used to get the raw cost, burdened cost, and revenue amounts by budget line from global records.
1699 * In order to execute this API, the following list of APIs should be executed in order of sequence.
1700 * INIT_BUDGET
1701 * INIT_CALCULATE_AMOUNTS
1702 * LOAD_BUDGET_LINE
1703 * EXECUTE_CALCULATE_AMOUNTS
1704 * EXECUTE_CREATE_DRAFT_BUDGET/EXECUTE_UPDATE_BUDGET
1705 * FETCH_CALCULATE_AMOUNTS
1706 * FETCH_BUDGET_LINE
1707 * CLEAR_BUDGET
1708 * @param p_api_version_number API standard: version number
1709 * @rep:paraminfo {@rep:required}
1710 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
1711 * @param p_line_index Pointer to the budget line
1712 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
1713 * @rep:paraminfo {@rep:required}
1714 * @param p_pa_task_id The reference code that uniquely identifies the task within a project in Oracle Projects
1715 * @rep:paraminfo {@rep:required}
1716 * @param p_pm_task_reference The unique reference code that identifies the task's parent task
1717 * @rep:paraminfo {@rep:required}
1718 * @param p_budget_start_date Start date of budget line
1719 * @rep:paraminfo {@rep:required}
1720 * @param p_budget_end_date End date of budget line
1721 * @rep:paraminfo {@rep:required}
1722 * @param p_period_name PA or GL period name
1723 * @rep:paraminfo {@rep:required}
1724 * @param p_resource_list_member_id The identifier of the resource
1725 * @rep:paraminfo {@rep:required}
1726 * @param p_quantity The quantity in the budget line
1727 * @rep:paraminfo {@rep:required}
1728 * @param p_resource_alias Alias of the resource
1729 * @rep:paraminfo {@rep:required}
1730 * @param p_calculated_raw_cost Calculated raw cost
1731 * @rep:paraminfo {@rep:required}
1732 * @param p_calculated_burdened_cost Calculated burdened cost
1733 * @rep:paraminfo {@rep:required}
1734 * @param p_calculated_revenue Calculated revenue
1735 * @rep:paraminfo {@rep:required}
1736 * @param p_line_return_status Return status for the budget line
1737 * @rep:paraminfo {@rep:required}
1738 * @rep:primaryinstance
1739 * @rep:scope public
1740 * @rep:lifecycle active
1741 * @rep:displayname Create Multiple Budgets-Fetch Calculate Amounts
1742 * @rep:compatibility S
1743 */
1744 PROCEDURE fetch_calculate_amounts
1745 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1746 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1747 ,p_line_index IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1748 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1749 ,p_pa_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1750 ,p_pm_task_reference OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1751 ,p_budget_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
1752 ,p_budget_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
1753 ,p_period_name OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1754 ,p_resource_list_member_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1755 ,p_quantity OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1756 ,p_resource_alias OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1757 ,p_calculated_raw_cost OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1758 ,p_calculated_burdened_cost OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1759 ,p_calculated_revenue OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1760 ,p_line_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
1761
1762 -- Bug 2863564
1763 -- The following is an overloaded api created to support new financial planning model
1764 -- The requirement is that extra new 'OUT' parameters be added.
1765 -- By overloading, dependencies have been avoided.
1766
1767 /*#
1768 * This API is used to get the raw cost, burdened cost, and revenue amounts by budget line from global records updated by the API EXECUTE_CALCULATE_AMOUNTS.
1769 * In order to execute this API, the following list of APIs should be executed in order of sequence.
1770 * INIT_BUDGET
1771 * INIT_CALCULATE_AMOUNTS
1772 * LOAD_BUDGET_LINE
1773 * EXECUTE_CALCULATE_AMOUNTS
1774 * EXECUTE_CREATE_DRAFT_BUDGET/EXECUTE_UPDATE_BUDGET
1775 * FETCH_CALCULATE_AMOUNTS
1776 * FETCH_BUDGET_LINE
1777 * CLEAR_BUDGET
1778 * @param p_api_version_number API standard: version number
1779 * @rep:paraminfo {@rep:required}
1780 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
1781 * @param p_line_index Pointer to the budget line
1782 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
1783 * @rep:paraminfo {@rep:required}
1784 * @param p_pa_task_id The reference code that uniquely identifies the task within a project in Oracle Projects
1785 * @rep:paraminfo {@rep:required}
1789 * @rep:paraminfo {@rep:required}
1786 * @param p_pm_task_reference The unique reference code that identifies the task's parent task
1787 * @rep:paraminfo {@rep:required}
1788 * @param p_budget_start_date Start date of budget line
1790 * @param p_budget_end_date End date of budget line
1791 * @rep:paraminfo {@rep:required}
1792 * @param p_period_name PA or GL period name
1793 * @rep:paraminfo {@rep:required}
1794 * @param p_resource_list_member_id The identifier of the resource
1795 * @rep:paraminfo {@rep:required}
1796 * @param p_quantity API The quantity in the budget line
1797 * @rep:paraminfo {@rep:required}
1798 * @param p_resource_alias Alias of the resource
1799 * @rep:paraminfo {@rep:required}
1800 * @param p_calculated_raw_cost Calculated raw cost
1801 * @rep:paraminfo {@rep:required}
1802 * @param p_calculated_burdened_cost Calculated burdened cost
1803 * @rep:paraminfo {@rep:required}
1804 * @param p_calculated_revenue Calculated revenue
1805 * @rep:paraminfo {@rep:required}
1806 * @param p_line_return_status Return status for a specific line
1807 * @rep:paraminfo {@rep:required}
1808 * @param p_txn_currency_code The transaction currency code.
1809 * @param p_project_raw_cost The raw cost in project currency
1810 * @param p_project_burdened_cost The burdened cost in project currency
1811 * @param p_project_revenue The revenue in project currency
1812 * @param p_projfunc_raw_cost The raw cost in project functional currency
1813 * @param p_projfunc_burdened_cost The burdened cost in project functional currency
1814 * @param p_projfunc_revenue The revenue in project functional currency
1815 * @rep:scope public
1816 * @rep:lifecycle active
1817 * @rep:displayname Create Multiple Budgets-Fetch Calculate Amounts
1818 * @rep:compatibility S
1819 */
1820 PROCEDURE fetch_calculate_amounts
1821 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1822 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1823 ,p_line_index IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1824 ,p_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1825 ,p_pa_task_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1826 ,p_pm_task_reference OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1827 ,p_budget_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
1828 ,p_budget_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
1829 ,p_period_name OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1830 ,p_resource_list_member_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1831 ,p_quantity OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1832 ,p_resource_alias OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1833 ,p_calculated_raw_cost OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1834 ,p_calculated_burdened_cost OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1835 ,p_calculated_revenue OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1836 ,p_line_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1837 ,p_txn_currency_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1838 ,p_project_raw_cost OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1839 ,p_project_burdened_cost OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1840 ,p_project_revenue OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1841 ,p_projfunc_raw_cost OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1842 ,p_projfunc_burdened_cost OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1843 ,p_projfunc_revenue OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1844 ,p_display_quantity OUT NOCOPY NUMBER --IPM Arch Enhancement Bug 4865563
1845 );
1846
1847 /*#
1848 * This API is used to reset the global data structures used by the Load-Execute-Fetch procedure CALCULATE_AMOUNTS.
1849 * @rep:scope public
1850 * @rep:lifecycle active
1851 * @rep:displayname Clear Calculate Amounts
1852 * @rep:compatibility S
1853 */
1854 PROCEDURE Clear_Calculate_Amounts ;
1855
1856 /*#
1857 * This API is used to create draft budgets and forecasts for financial plan types. This API accepts summary
1858 * data at the project, task, resource, and currency levels. For budget and forecast versions that are
1859 * time-phased by PA or GL period, the API also spreads the data, including quantities and amounts, across
1860 * periods based on the spread curve associated with a resource. This API does not perform any edits to the data.
1861 * @param p_api_version_number API standard: version number
1862 * @param p_commit API standard (default = F): indicates if the transaction will be committed
1863 * @rep:paraminfo {@rep:precision 1}
1864 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
1865 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
1866 * @rep:paraminfo {@rep:required}
1867 * @param p_pm_finplan_reference The reference code that uniquely identifies the financial plan in the external system
1868 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system. You must specify a value for either this parameter or P_PA_PROJECT_ID.
1869 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects. You must specify a value for this parameter or P_PM_PROJECT_REFERENCE.
1870 * @param p_fin_plan_type_id Financial plan type identifier. You must provide a valid value for either P_FIN_PLAN_TYPE_NAME or P_FIN_PLAN_TYPE_ID for budget or forecast versions created for the financial plan types.
1871 * @param p_fin_plan_type_name Financial plan type name in Oracle Projects. You must specify a value for this parameter or P_FIN_PLAN_TYPE_ID.
1875 * @param p_resource_list_id Resource list identifier
1872 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. The valid values are COST, REVENUE, and ALL.
1873 * @param p_time_phased_code The time phasing option. Valid values are P (planning by PA periods), G (planning by GL periods), and N (None: planning is done for the duration of the project or task).
1874 * @param p_resource_list_name Resource list name
1876 * @param p_fin_plan_level_code Planning level identifier. Valid values are P (project level), T (top task level), and L (lowest task level).
1877 * @param P_PLAN_IN_MULTI_CURR_FLAG Flag indicating if the version can be planned in multiple transaction currencies
1878 * @param p_budget_version_name Budget version name
1879 * @rep:paraminfo {@rep:required}
1880 * @param p_description Financial plan description
1881 * @param p_change_reason_code Reference code that identifies a change reason
1882 * @param p_raw_cost_flag Flag indicating whether raw cost can be planned for the plan version
1883 * @param p_burdened_cost_flag Flag indicating whether burdened cost can be planned for the plan version
1884 * @param p_revenue_flag Flag indicating whether revenue can be planned for the plan version
1885 * @param p_cost_qty_flag Flag indicating whether cost quantity can be planned for a cost plan version
1886 * @param p_revenue_qty_flag Flag indicating whether revenue quantity can be planned for a revenue plan version
1887 * @param p_all_qty_flag Flag indicating whether quantity can be planned when cost and revenue are planned together in the same plan version
1888 * @param p_create_new_curr_working_flag Flag indicating whether a current working version should be created
1889 * @param p_replace_current_working_flag Flag indicating whether the current working version should be deleted and the newly created version marked as the current working version
1890 * @param p_using_resource_lists_flag Flag indicating whether a resource list is used. Required for budgets and forecasts created for financial plan types. If plan amounts are not classified using resource lists, then the value must be N.
1891 * @param p_finplan_trans_tab PL/SQL table containing planning transaction information for the financial plan version
1892 * @param p_attribute_category Descriptive flexfield category for a budget version
1893 * @param p_attribute1 Descriptive flexfield segment for a budget version
1894 * @param p_attribute2 Descriptive flexfield segment for a budget version
1895 * @param p_attribute3 Descriptive flexfield segment for a budget version
1896 * @param p_attribute4 Descriptive flexfield segment for a budget version
1897 * @param p_attribute5 Descriptive flexfield segment for a budget version
1898 * @param p_attribute6 Descriptive flexfield segment for a budget version
1899 * @param p_attribute7 Descriptive flexfield segment for a budget version
1900 * @param p_attribute8 Descriptive flexfield segment for a budget version
1901 * @param p_attribute9 Descriptive flexfield segment for a budget version
1902 * @param p_attribute10 Descriptive flexfield segment for a budget version
1903 * @param p_attribute11 Descriptive flexfield segment for a budget version
1904 * @param p_attribute12 Descriptive flexfield segment for a budget version
1905 * @param p_attribute13 Descriptive flexfield segment for a budget version
1906 * @param p_attribute14 Descriptive flexfield segment for a budget version
1907 * @param p_attribute15 Descriptive flexfield segment for a budget version
1908 * @param x_finplan_version_id Financial plan version identifier of the plan version created using the API
1909 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
1910 * @rep:paraminfo {@rep:precision 1}
1911 * @param x_msg_count API standard: number of error messages
1912 * @param x_msg_data API standard: error message
1913 * @rep:paraminfo {@rep:precision 2000}
1914 * @rep:scope public
1915 * @rep:lifecycle active
1916 * @rep:displayname Create Draft Financial Plan
1917 * @rep:compatibility S
1918 */
1919 PROCEDURE CREATE_DRAFT_FINPLAN
1920 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1921 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1922 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1923 ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1924 ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1925 ,p_pm_project_reference IN pa_projects_all. PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1926 ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1927 ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1928 ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1929 ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1930 ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1931 ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1932 ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1933 ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1934 ,P_PLAN_IN_MULTI_CURR_FLAG IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1935 ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1936 ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1940 ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1937 ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1938 ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1939 ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1941 ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1942 ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1943 ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1944 ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1945 ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1946 ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'
1947 ,p_finplan_trans_tab IN pa_budget_pub.FinPlan_Trans_Tab
1948 ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1949 ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1950 ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1951 ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1952 ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1953 ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1954 ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1955 ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1956 ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1957 ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1958 ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1959 ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1960 ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1961 ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1962 ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1963 ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
1964 ,x_finplan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1965 ,x_return_status OUT NOCOPY VARCHAR2
1966 ,x_msg_count OUT NOCOPY NUMBER
1967 ,x_msg_data OUT NOCOPY VARCHAR2
1968 );
1969
1970 /*#
1971 * This API is used to load the resource information along with summary amounts required to create
1972 * a budget or forecast, to a global PL/SQL table used by the EXECUTE_CREATE_DRAFT_FINPLAN API.
1973 * @param P_PM_PRODUCT_CODE The identifier of the external project management system from which the project was imported
1974 * @param P_TASK_ID Task identifier in Oracle Projects. If not planning at the project level, you must specify a value for this parameter or P_PM_TASK_REFERENCE.
1975 * @param P_PM_TASK_REFERENCE Task identifier in the external system. If not planning at the project level, you must specify a value for this parameter or P_TASK_ID.
1976 * @param P_PM_RES_ASGMT_REFERENCE Identifier of the resource assignment in the external system
1977 * @param P_RESOURCE_ALIAS The resource alias. If the resource list is categorized, you must specify a value for either this parameter or P_RESOURCE_LIST_MEMBER_ID.
1978 * @param P_CURRENCY_CODE The currency identifier. Required if planning in multiple transaction currencies.
1979 * @param P_UNIT_OF_MEASURE_CODE The unit of measure
1980 * @param P_START_DATE Start date of budget line
1981 * @param P_END_DATE Indicates the budget line end date for budgets and forecasts that are time-phased by PA or GL periods
1982 * @param P_QUANTITY The quantity entered into the budget line
1983 * @param P_RAW_COST Raw cost amount
1984 * @param P_BURDENED_COST Burdened cost amount
1985 * @param P_REVENUE Revenue amount
1986 * @param P_RESOURCE_LIST_MEMBER_ID Resource list member identifier. If the resource list is categorized, you must specify a value for this parameter or P_RESOURCE_ALIAS.
1987 * @param P_ATTRIBUTE_CATEGORY Descriptive flexfield category for a resource assignment
1988 * @param P_ATTRIBUTE1 Descriptive flexfield segment for a resource assignment
1989 * @param P_ATTRIBUTE2 Descriptive flexfield segment for a resource assignment
1990 * @param P_ATTRIBUTE3 Descriptive flexfield segment for a resource assignment
1991 * @param P_ATTRIBUTE4 Descriptive flexfield segment for a resource assignment
1992 * @param P_ATTRIBUTE5 Descriptive flexfield segment for a resource assignment
1993 * @param P_ATTRIBUTE6 Descriptive flexfield segment for a resource assignment
1994 * @param P_ATTRIBUTE7 Descriptive flexfield segment for a resource assignment
1995 * @param P_ATTRIBUTE8 Descriptive flexfield segment for a resource assignment
1996 * @param P_ATTRIBUTE9 Descriptive flexfield segment for a resource assignment
1997 * @param P_ATTRIBUTE10 Descriptive flexfield segment for a resource assignment
2001 * @param P_ATTRIBUTE14 Descriptive flexfield segment for a resource assignment
1998 * @param P_ATTRIBUTE11 Descriptive flexfield segment for a resource assignment
1999 * @param P_ATTRIBUTE12 Descriptive flexfield segment for a resource assignment
2000 * @param P_ATTRIBUTE13 Descriptive flexfield segment for a resource assignment
2002 * @param P_ATTRIBUTE15 Descriptive flexfield segment for a resource assignment
2003 * @param P_ATTRIBUTE16 Descriptive flexfield segment for a resource assignment
2004 * @param P_ATTRIBUTE17 Descriptive flexfield segment for a resource assignment
2005 * @param P_ATTRIBUTE18 Descriptive flexfield segment for a resource assignment
2006 * @param P_ATTRIBUTE19 Descriptive flexfield segment for a resource assignment
2007 * @param P_ATTRIBUTE20 Descriptive flexfield segment for a resource assignment
2008 * @param P_ATTRIBUTE21 Descriptive flexfield segment for a resource assignment
2009 * @param P_ATTRIBUTE22 Descriptive flexfield segment for a resource assignment
2010 * @param P_ATTRIBUTE23 Descriptive flexfield segment for a resource assignment
2011 * @param P_ATTRIBUTE24 Descriptive flexfield segment for a resource assignment
2012 * @param P_ATTRIBUTE25 Descriptive flexfield segment for a resource assignment
2013 * @param P_ATTRIBUTE26 Descriptive flexfield segment for a resource assignment
2014 * @param P_ATTRIBUTE27 Descriptive flexfield segment for a resource assignment
2015 * @param P_ATTRIBUTE28 Descriptive flexfield segment for a resource assignment
2016 * @param P_ATTRIBUTE29 Descriptive flexfield segment for a resource assignment
2017 * @param P_ATTRIBUTE30 Descriptive flexfield segment for a resource assignment
2018 * @rep:scope public
2019 * @rep:lifecycle active
2020 * @rep:displayname Load Resource Information
2021 * @rep:compatibility S
2022 */
2023 PROCEDURE load_resource_info(
2024 P_PM_PRODUCT_CODE PA_BUDGET_VERSIONS.PM_PRODUCT_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2025 ,P_TASK_ID PA_TASKS.TASK_ID%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2026 ,P_PM_TASK_REFERENCE PA_TASKS.PM_TASK_REFERENCE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2027 ,P_PM_RES_ASGMT_REFERENCE VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2028 ,P_RESOURCE_ALIAS VARCHAR2 DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2029 ,P_CURRENCY_CODE PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2030 ,P_UNIT_OF_MEASURE_CODE PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2031 ,P_START_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_START_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2032 ,P_END_DATE PA_RESOURCE_ASSIGNMENTS.PLANNING_END_DATE%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
2033 ,P_QUANTITY NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2034 ,P_RAW_COST NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2035 ,P_BURDENED_COST NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2036 ,P_REVENUE NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2037 ,P_RESOURCE_LIST_MEMBER_ID NUMBER DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2038 ,P_ATTRIBUTE_CATEGORY PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE_CATEGORY%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2039 ,P_ATTRIBUTE1 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE1%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2040 ,P_ATTRIBUTE2 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE2%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2041 ,P_ATTRIBUTE3 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE3%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2042 ,P_ATTRIBUTE4 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE4%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2043 ,P_ATTRIBUTE5 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE5%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2044 ,P_ATTRIBUTE6 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE6%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2045 ,P_ATTRIBUTE7 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE7%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2046 ,P_ATTRIBUTE8 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE8%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2047 ,P_ATTRIBUTE9 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE9%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2048 ,P_ATTRIBUTE10 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE10%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2049 ,P_ATTRIBUTE11 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE11%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2050 ,P_ATTRIBUTE12 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE12%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2051 ,P_ATTRIBUTE13 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE13%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2052 ,P_ATTRIBUTE14 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE14%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2053 ,P_ATTRIBUTE15 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE15%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2054 ,P_ATTRIBUTE16 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE16%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2055 ,P_ATTRIBUTE17 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE17%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2056 ,P_ATTRIBUTE18 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE18%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2057 ,P_ATTRIBUTE19 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE19%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2058 ,P_ATTRIBUTE20 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE20%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2059 ,P_ATTRIBUTE21 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE21%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2060 ,P_ATTRIBUTE22 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE22%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2061 ,P_ATTRIBUTE23 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE23%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2062 ,P_ATTRIBUTE24 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE24%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2063 ,P_ATTRIBUTE25 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE25%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2064 ,P_ATTRIBUTE26 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE26%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2065 ,P_ATTRIBUTE27 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE27%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2066 ,P_ATTRIBUTE28 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE28%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2070
2067 ,P_ATTRIBUTE29 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE29%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2068 ,P_ATTRIBUTE30 PA_RESOURCE_ASSIGNMENTS.ATTRIBUTE30%TYPE DEFAULT PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2069 );
2071 /*#
2072 * This API is used to create budgets and forecasts using the data stored in the global tables during
2073 * the load process.
2074 * In order to execute this API, the following API should be executed.
2075 * LOAD_RESOURCE_INFO
2076 * @param p_api_version_number API standard: version number
2077 * @param p_commit API standard (default = F): indicates if the transaction will be committed
2078 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
2079 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
2080 * @rep:paraminfo {@rep:required}
2081 * @param p_pm_finplan_reference The reference code that uniquely identifies the financial plan in the external system
2082 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system. You must specify a value for this parameter or P_PA_PROJECT_ID.
2083 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects. You must specify a value for this parameter or P_PM_PROJECT_REFERENCE.
2084 * @param p_fin_plan_type_id Financial plan type identifier. You must supply a valid value for either P_FIN_PLAN_TYPE_NAME or P_FIN_PLAN_TYPE_ID for budget or forecast versions created for financial plan types.
2085 * @param p_fin_plan_type_name Financial plan type name in Oracle Projects. You must specify a value for this parameter or P_FIN_PLAN_TYPE_ID.
2086 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. The valid values are COST, REVENUE, and ALL.
2087 * @param p_time_phased_code The time phasing option. The valid values are P (planning by PA periods), G (planning by GL periods), and N (None: planning is done for the duration of the project or task).
2088 * @param p_resource_list_name Resource list name
2089 * @param p_resource_list_id Resource list identifier
2090 * @param p_fin_plan_level_code Financial planning level code identifier. The valid values are P (project level), T (top task level), and L (lowest task level).
2091 * @param P_PLAN_IN_MULTI_CURR_FLAG Flag indicating if the version can be planned in multiple transaction currencies
2092 * @param p_budget_version_name Budget version name
2093 * @rep:paraminfo {@rep:required}
2094 * @param p_description Financial plan description
2095 * @param p_change_reason_code Reference code that identifies a change reason
2096 * @param p_raw_cost_flag Flag indicating whether raw cost can be planned for the plan version
2097 * @param p_burdened_cost_flag Flag indicating whether burdened cost can be planned for the plan version
2098 * @param p_revenue_flag Flag indicating whether revenue can be planned for the plan version
2099 * @param p_cost_qty_flag Flag indicating whether cost quantity can be planned for a cost plan version
2100 * @param p_revenue_qty_flag Flag indicating whether revenue quantity can be planned for a revenue plan version
2101 * @param p_all_qty_flag Flag indicating whether quantity can be planned when cost and revenue are planned together in the same plan version
2102 * @param p_attribute_category Descriptive flexfield category for a budget version
2103 * @param p_attribute1 Descriptive flexfield segment for a budget version
2104 * @param p_attribute2 Descriptive flexfield segment for a budget version
2105 * @param p_attribute3 Descriptive flexfield segment for a budget version
2106 * @param p_attribute4 Descriptive flexfield segment for a budget version
2107 * @param p_attribute5 Descriptive flexfield segment for a budget version
2108 * @param p_attribute6 Descriptive flexfield segment for a budget version
2109 * @param p_attribute7 Descriptive flexfield segment for a budget version
2110 * @param p_attribute8 Descriptive flexfield segment for a budget version
2111 * @param p_attribute9 Descriptive flexfield segment for a budget version
2112 * @param p_attribute10 Descriptive flexfield segment for a budget version
2113 * @param p_attribute11 Descriptive flexfield segment for a budget version
2114 * @param p_attribute12 Descriptive flexfield segment for a budget version
2115 * @param p_attribute13 Descriptive flexfield segment for a budget version
2116 * @param p_attribute14 Descriptive flexfield segment for a budget version
2117 * @param p_attribute15 Descriptive flexfield segment for a budget version
2118 * @param p_create_new_curr_working_flag Flag indicating whether a current working version should be created
2119 * @param p_replace_current_working_flag Flag indicating whether the current working version should be deleted and the newly created version marked as the current working version
2120 * @param p_using_resource_lists_flag Flag indicating whether a resource list is used. Required for budgets and forecasts created for financial plan types. If plan amounts are not classified using resource lists, then the value must be N.
2121 * @param x_finplan_version_id Financial plan version identifier of the plan version created using the API
2122 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
2123 * @param x_msg_count API standard: number of error messages
2124 * @param x_msg_data API standard: error message
2125 * @rep:paraminfo {@rep:precision 2000}
2126 * @rep:scope public
2127 * @rep:lifecycle active
2128 * @rep:displayname Execute Create Draft Financial Plan
2129 * @rep:compatibility S
2130 */
2131 PROCEDURE EXECUTE_CREATE_DRAFT_FINPLAN
2132 ( p_api_version_number IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2133 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2134 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2135 ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2139 ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2136 ,p_pm_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2137 ,p_pm_project_reference IN pa_projects_all.PM_PROJECT_REFERENCE%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2138 ,p_pa_project_id IN pa_budget_versions.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2140 ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2141 ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2142 ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2143 ,p_resource_list_name IN pa_resource_lists.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2144 ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2145 ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2146 ,P_PLAN_IN_MULTI_CURR_FLAG IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2147 ,p_budget_version_name IN pa_budget_versions.version_name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2148 ,p_description IN pa_budget_versions.description%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2149 ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2150 ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2151 ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2152 ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2153 ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2154 ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2155 ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2156 ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2157 ,p_attribute1 IN pa_budget_versions.attribute1%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2158 ,p_attribute2 IN pa_budget_versions.attribute2%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2159 ,p_attribute3 IN pa_budget_versions.attribute3%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2160 ,p_attribute4 IN pa_budget_versions.attribute4%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2161 ,p_attribute5 IN pa_budget_versions.attribute5%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2162 ,p_attribute6 IN pa_budget_versions.attribute6%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2163 ,p_attribute7 IN pa_budget_versions.attribute7%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2164 ,p_attribute8 IN pa_budget_versions.attribute8%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2165 ,p_attribute9 IN pa_budget_versions.attribute9%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2166 ,p_attribute10 IN pa_budget_versions.attribute10%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2167 ,p_attribute11 IN pa_budget_versions.attribute11%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2168 ,p_attribute12 IN pa_budget_versions.attribute12%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2169 ,p_attribute13 IN pa_budget_versions.attribute13%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2170 ,p_attribute14 IN pa_budget_versions.attribute14%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2171 ,p_attribute15 IN pa_budget_versions.attribute15%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2172 ,p_create_new_curr_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2173 ,p_replace_current_working_flag IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2174 ,p_using_resource_lists_flag IN VARCHAR2 DEFAULT 'N'
2175 ,x_finplan_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2176 ,x_return_status OUT NOCOPY VARCHAR2
2177 ,x_msg_count OUT NOCOPY NUMBER
2178 ,x_msg_data OUT NOCOPY VARCHAR2
2179 );
2180
2181 /*#
2182 * This API is used to delete an existing baseline budget version and the corresponding budget lines
2183 * in Oracle Projects for a given project and budget type or a project and financial plan type.
2184 * @param p_api_version_number API standard: version number
2185 * @rep:paraminfo {@rep:required}
2186 * @param p_commit API standard (default = F): indicates if the transaction will be committed
2187 * @rep:paraminfo {@rep:precision 1}
2188 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
2189 * @param p_msg_count API standard: number of error messages
2190 * @rep:paraminfo {@rep:required}
2191 * @param p_msg_data API standard: error message
2192 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
2193 * @param p_return_status API standard: return status of the API (success/failure/unexpected error)
2194 * @rep:paraminfo {@rep:required}
2195 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
2199 * @param p_budget_type_code Budget type code identifier in Oracle Projects
2196 * @rep:paraminfo {@rep:required}
2197 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects. You must specify a value for this parameter or P_PM_PROJECT_REFERENCE.
2198 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system. You must specify a value for this parameter or P_PA_PROJECT_ID.
2200 * @param p_fin_plan_type_id Financial plan type identifier. You must provide a valid value for either P_FIN_PLAN_TYPE_NAME or P_FIN_PLAN_TYPE_ID for budget or forecast versions created for financial plan types.
2201 * @param p_fin_plan_type_name Financial plan type name in Oracle Projects. You must specify a value for this parameter or P_FIN_PLAN_TYPE_ID
2202 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. The valid values are COST, REVENUE, and ALL.
2203 * @param p_version_number Baseline plan version number
2204 * @rep:paraminfo {@rep:required}
2205 * @rep:scope public
2206 * @rep:lifecycle active
2207 * @rep:displayname Delete Baseline Budget
2208 * @rep:compatibility S
2209 */
2210 PROCEDURE delete_baseline_budget
2211 ( p_api_version_number IN NUMBER
2212 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2213 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2214 ,p_msg_count OUT NOCOPY NUMBER
2215 ,p_msg_data OUT NOCOPY VARCHAR2
2216 ,p_return_status OUT NOCOPY VARCHAR2
2217 ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2218 ,p_pa_project_id IN pa_projects_all.project_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2219 ,p_pm_project_reference IN pa_projects_all.pm_project_reference%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2220 ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2221 ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2222 ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2223 ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2224 ,p_version_number IN pa_budget_versions.version_number%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2225 ) ;
2226
2227
2228 --bug 5509192
2229 /*#
2230 * This API is used to update the existing planning element
2231 * attributes: Planning Start Date, Planning End Date,Etc Method, Spread Curve, Description, Attribute Category,
2232 * attribute1 thru attribute30 in a plan version.
2233 * @param p_api_version_number API standard: version number
2234 * @rep:paraminfo {@rep:required}
2235 * @param p_commit API standard (default = F): indicates if the transaction will be committed
2236 * @rep:paraminfo {@rep:precision 1}
2237 * @param p_init_msg_list API standard (default = F): indicates if message stack will be initialized
2238 * @param x_msg_count API standard: number of error messages
2239 * @rep:paraminfo {@rep:required}
2240 * @param x_msg_data API standard: error message
2241 * @rep:paraminfo {@rep:precision 2000} {@rep:required}
2242 * @param x_return_status API standard: return status of the API (success/failure/unexpected error)
2243 * @rep:paraminfo {@rep:required}
2244 * @param p_pm_product_code The identifier of the external project management system from which the project was imported
2245 * @rep:paraminfo {@rep:required}
2246 * @param p_pa_project_id The reference code that uniquely identifies the project in the Oracle Projects. You must specify a value for this parameter or P_PM_PROJECT_REFERENCE.
2247 * @param p_pm_project_reference The reference code that uniquely identifies the project in the external system. You must specify a value for this parameter or P_PA_PROJECT_ID.
2248 * @param p_fin_plan_type_id Financial plan type identifier. You must provide a valid value for either P_FIN_PLAN_TYPE_NAME or P_FIN_PLAN_TYPE_ID for budget or forecast versions created for financial plan types.
2249 * @param p_fin_plan_type_name The financial plan type name
2250 * @param p_version_type Financial plan version type. Required if planning separately for cost and revenue. The valid values are COST, REVENUE, and ALL.
2251 * @param p_budget_version_number Budget version number
2255 * @rep:lifecycle active
2252 * @param p_planning_element_rec_tbl Planning Elements Attributes Input Record
2253 * @rep:paraminfo {@rep:required}
2254 * @rep:scope public
2256 * @rep:displayname Update Planning Element Attributes
2257 * @rep:compatibility S
2258 */
2259
2260 PROCEDURE update_plannning_element_attr
2261 (p_api_version_number IN NUMBER
2262 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2263 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2267 ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2264 ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2265 ,p_pa_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2266 ,p_pm_project_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2268 ,p_fin_plan_type_name IN pa_fin_plan_types_tl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2269 ,p_budget_version_number IN pa_budget_versions.version_number%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2270 ,p_version_type IN pa_budget_versions.version_type%TYPE :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
2271 ,p_planning_element_rec_tbl IN planning_element_rec_tbl_type
2272 ,x_msg_count OUT NOCOPY NUMBER
2273 ,x_msg_data OUT NOCOPY VARCHAR2
2274 ,x_return_status OUT NOCOPY VARCHAR2);
2275 --bug 5509192
2276
2277
2278 end PA_BUDGET_PUB;