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