[Home] [Help]
PACKAGE: APPS.PA_FP_BUDGET_LINES_PKG
Source
1 PACKAGE pa_fp_budget_lines_pkg AUTHID CURRENT_USER as
2 /* $Header: PAFPBLTS.pls 120.2 2005/09/23 14:53:09 rnamburi noship $ */
3 -- Start of Comments
4 -- Package name : PA_FP_BUDGET_LINES_PKG
5 -- Purpose :
6 -- History :
7 -- 26-OCT-2002 Vejayara Included columns to be in table for FP.K
8 -- 05-DEC-2002 Rravipat Added new column p_mrc_flag to insert_row
9 -- 10-DEC-2002 Added new column p_mrc_flag to update_row
10 -- Modified Delte_row signature for B4 changes
11 --
12 -- 23-SEP-2005 Ram Namburi
13 -- Bug Fix: 4569365. Removed MRC code.
14 -- NOTE :
15 -- End of Comments
16
17 PROCEDURE Insert_Row
18 ( p_resource_assignment_id IN pa_budget_lines.resource_assignment_id%TYPE
19 := FND_API.G_MISS_NUM
20 ,p_start_date IN pa_budget_lines.start_date%TYPE
21 := FND_API.G_MISS_DATE
22 ,p_end_date IN pa_budget_lines.end_date%TYPE
23 := FND_API.G_MISS_DATE
24 ,p_period_name IN pa_budget_lines.period_name%TYPE
25 := FND_API.G_MISS_CHAR
26 ,p_quantity IN pa_budget_lines.quantity%TYPE
27 := FND_API.G_MISS_NUM
28 ,p_raw_cost IN pa_budget_lines.raw_cost%TYPE
29 := FND_API.G_MISS_NUM
30 ,p_burdened_cost IN pa_budget_lines.burdened_cost%TYPE
31 := FND_API.G_MISS_NUM
32 ,p_revenue IN pa_budget_lines.revenue%TYPE
33 := FND_API.G_MISS_NUM
34 ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
35 := FND_API.G_MISS_CHAR
36 ,p_description IN pa_budget_lines.description%TYPE
37 := FND_API.G_MISS_CHAR
38 ,p_attribute_category IN pa_budget_lines.attribute_category%TYPE
39 := FND_API.G_MISS_CHAR
40 ,p_attribute1 IN pa_budget_lines.attribute1%TYPE
41 := FND_API.G_MISS_CHAR
42 ,p_attribute2 IN pa_budget_lines.attribute2%TYPE
43 := FND_API.G_MISS_CHAR
44 ,p_attribute3 IN pa_budget_lines.attribute3%TYPE
45 := FND_API.G_MISS_CHAR
46 ,p_attribute4 IN pa_budget_lines.attribute4%TYPE
47 := FND_API.G_MISS_CHAR
48 ,p_attribute5 IN pa_budget_lines.attribute5%TYPE
49 := FND_API.G_MISS_CHAR
50 ,p_attribute6 IN pa_budget_lines.attribute6%TYPE
51 := FND_API.G_MISS_CHAR
52 ,p_attribute7 IN pa_budget_lines.attribute7%TYPE
53 := FND_API.G_MISS_CHAR
54 ,p_attribute8 IN pa_budget_lines.attribute8%TYPE
55 := FND_API.G_MISS_CHAR
56 ,p_attribute9 IN pa_budget_lines.attribute9%TYPE
57 := FND_API.G_MISS_CHAR
58 ,p_attribute10 IN pa_budget_lines.attribute10%TYPE
59 := FND_API.G_MISS_CHAR
60 ,p_attribute11 IN pa_budget_lines.attribute11%TYPE
61 := FND_API.G_MISS_CHAR
62 ,p_attribute12 IN pa_budget_lines.attribute12%TYPE
63 := FND_API.G_MISS_CHAR
64 ,p_attribute13 IN pa_budget_lines.attribute13%TYPE
65 := FND_API.G_MISS_CHAR
66 ,p_attribute14 IN pa_budget_lines.attribute14%TYPE
67 := FND_API.G_MISS_CHAR
68 ,p_attribute15 IN pa_budget_lines.attribute15%TYPE
69 := FND_API.G_MISS_CHAR
70 ,p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE
71 := FND_API.G_MISS_CHAR
72 ,p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE
73 := FND_API.G_MISS_CHAR
74 ,p_quantity_source IN pa_budget_lines.quantity_source%TYPE
75 := FND_API.G_MISS_CHAR
76 ,p_revenue_source IN pa_budget_lines.revenue_source%TYPE
77 := FND_API.G_MISS_CHAR
78 ,p_pm_product_code IN pa_budget_lines.pm_product_code%TYPE
79 := FND_API.G_MISS_CHAR
80 ,p_pm_budget_line_reference IN pa_budget_lines.pm_budget_line_reference%TYPE
81 := FND_API.G_MISS_CHAR
82 ,p_cost_rejection_code IN pa_budget_lines.cost_rejection_code%TYPE
83 := FND_API.G_MISS_CHAR
84 ,p_revenue_rejection_code IN pa_budget_lines.revenue_rejection_code%TYPE
85 := FND_API.G_MISS_CHAR
86 ,p_burden_rejection_code IN pa_budget_lines.burden_rejection_code%TYPE
87 := FND_API.G_MISS_CHAR
88 ,p_other_rejection_code IN pa_budget_lines.other_rejection_code%TYPE
89 := FND_API.G_MISS_CHAR
90 ,p_code_combination_id IN pa_budget_lines.code_combination_id%TYPE
91 := FND_API.G_MISS_NUM
92 ,p_ccid_gen_status_code IN pa_budget_lines.ccid_gen_status_code%TYPE
93 := FND_API.G_MISS_CHAR
94 ,p_ccid_gen_rej_message IN pa_budget_lines.ccid_gen_rej_message%TYPE
95 := FND_API.G_MISS_CHAR
96 ,p_request_id IN pa_budget_lines.request_id%TYPE
97 := FND_API.G_MISS_NUM
98 ,p_borrowed_revenue IN pa_budget_lines.borrowed_revenue%TYPE
99 := FND_API.G_MISS_NUM
100 ,p_tp_revenue_in IN pa_budget_lines.tp_revenue_in%TYPE
101 := FND_API.G_MISS_NUM
102 ,p_tp_revenue_out IN pa_budget_lines.tp_revenue_out%TYPE
103 := FND_API.G_MISS_NUM
104 ,p_revenue_adj IN pa_budget_lines.revenue_adj%TYPE
105 := FND_API.G_MISS_NUM
106 ,p_lent_resource_cost IN pa_budget_lines.lent_resource_cost%TYPE
107 := FND_API.G_MISS_NUM
108 ,p_tp_cost_in IN pa_budget_lines.tp_cost_in%TYPE
109 := FND_API.G_MISS_NUM
110 ,p_tp_cost_out IN pa_budget_lines.tp_cost_out%TYPE
111 := FND_API.G_MISS_NUM
112 ,p_cost_adj IN pa_budget_lines.cost_adj%TYPE
113 := FND_API.G_MISS_NUM
114 ,p_unassigned_time_cost IN pa_budget_lines.unassigned_time_cost%TYPE
115 := FND_API.G_MISS_NUM
116 ,p_utilization_percent IN pa_budget_lines.utilization_percent%TYPE
117 := FND_API.G_MISS_NUM
118 ,p_utilization_hours IN pa_budget_lines.utilization_hours%TYPE
119 := FND_API.G_MISS_NUM
120 ,p_utilization_adj IN pa_budget_lines.utilization_adj%TYPE
121 := FND_API.G_MISS_NUM
122 ,p_capacity IN pa_budget_lines.capacity%TYPE
123 := FND_API.G_MISS_NUM
124 ,p_head_count IN pa_budget_lines.head_count%TYPE
125 := FND_API.G_MISS_NUM
126 ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE
127 := FND_API.G_MISS_NUM,
128 p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,
129 p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
130 p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
131 p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
132 p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
133 p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
134 p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
135 p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
136 p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
137 p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
138 p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
139 p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
140 p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
141 p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
142 p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
143 p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
144 p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
145 p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
146 p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
147 p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
148 p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
149 p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
150 p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
151 p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
152 p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
153 p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,
154 px_budget_line_id in out NOCOPY pa_budget_lines.budget_line_id%type, --File.Sql.39 bug 4440895
155 p_budget_version_id in pa_budget_lines.budget_version_id%type := FND_API.G_MISS_NUM,
156 -- Bug Fix: 4569365. Removed MRC code.
157 -- p_mrc_flag in VARCHAR2 DEFAULT 'N'
158 x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
159 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
160
161 PROCEDURE Update_Row
162 ( p_resource_assignment_id IN pa_budget_lines.resource_assignment_id%TYPE
163 := FND_API.G_MISS_NUM
164 ,p_start_date IN pa_budget_lines.start_date%TYPE
165 := FND_API.G_MISS_DATE
166 ,p_end_date IN pa_budget_lines.end_date%TYPE
167 := FND_API.G_MISS_DATE
168 ,p_period_name IN pa_budget_lines.period_name%TYPE
169 := FND_API.G_MISS_CHAR
170 ,p_quantity IN pa_budget_lines.quantity%TYPE
171 := FND_API.G_MISS_NUM
172 ,p_raw_cost IN pa_budget_lines.raw_cost%TYPE
173 := FND_API.G_MISS_NUM
174 ,p_burdened_cost IN pa_budget_lines.burdened_cost%TYPE
175 := FND_API.G_MISS_NUM
176 ,p_revenue IN pa_budget_lines.revenue%TYPE
177 := FND_API.G_MISS_NUM
178 ,p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
179 := FND_API.G_MISS_CHAR
180 ,p_description IN pa_budget_lines.description%TYPE
181 := FND_API.G_MISS_CHAR
182 ,p_attribute_category IN pa_budget_lines.attribute_category%TYPE
183 := FND_API.G_MISS_CHAR
184 ,p_attribute1 IN pa_budget_lines.attribute1%TYPE
185 := FND_API.G_MISS_CHAR
186 ,p_attribute2 IN pa_budget_lines.attribute2%TYPE
187 := FND_API.G_MISS_CHAR
188 ,p_attribute3 IN pa_budget_lines.attribute3%TYPE
189 := FND_API.G_MISS_CHAR
190 ,p_attribute4 IN pa_budget_lines.attribute4%TYPE
191 := FND_API.G_MISS_CHAR
192 ,p_attribute5 IN pa_budget_lines.attribute5%TYPE
193 := FND_API.G_MISS_CHAR
194 ,p_attribute6 IN pa_budget_lines.attribute6%TYPE
195 := FND_API.G_MISS_CHAR
196 ,p_attribute7 IN pa_budget_lines.attribute7%TYPE
197 := FND_API.G_MISS_CHAR
198 ,p_attribute8 IN pa_budget_lines.attribute8%TYPE
199 := FND_API.G_MISS_CHAR
200 ,p_attribute9 IN pa_budget_lines.attribute9%TYPE
201 := FND_API.G_MISS_CHAR
202 ,p_attribute10 IN pa_budget_lines.attribute10%TYPE
203 := FND_API.G_MISS_CHAR
204 ,p_attribute11 IN pa_budget_lines.attribute11%TYPE
205 := FND_API.G_MISS_CHAR
206 ,p_attribute12 IN pa_budget_lines.attribute12%TYPE
207 := FND_API.G_MISS_CHAR
208 ,p_attribute13 IN pa_budget_lines.attribute13%TYPE
209 := FND_API.G_MISS_CHAR
210 ,p_attribute14 IN pa_budget_lines.attribute14%TYPE
211 := FND_API.G_MISS_CHAR
212 ,p_attribute15 IN pa_budget_lines.attribute15%TYPE
213 := FND_API.G_MISS_CHAR
214 ,p_raw_cost_source IN pa_budget_lines.raw_cost_source%TYPE
215 := FND_API.G_MISS_CHAR
216 ,p_burdened_cost_source IN pa_budget_lines.burdened_cost_source%TYPE
217 := FND_API.G_MISS_CHAR
218 ,p_quantity_source IN pa_budget_lines.quantity_source%TYPE
219 := FND_API.G_MISS_CHAR
220 ,p_revenue_source IN pa_budget_lines.revenue_source%TYPE
221 := FND_API.G_MISS_CHAR
222 ,p_pm_product_code IN pa_budget_lines.pm_product_code%TYPE
223 := FND_API.G_MISS_CHAR
224 ,p_pm_budget_line_reference IN pa_budget_lines.pm_budget_line_reference%TYPE
225 := FND_API.G_MISS_CHAR
226 ,p_cost_rejection_code IN pa_budget_lines.cost_rejection_code%TYPE
227 := FND_API.G_MISS_CHAR
228 ,p_revenue_rejection_code IN pa_budget_lines.revenue_rejection_code%TYPE
229 := FND_API.G_MISS_CHAR
230 ,p_burden_rejection_code IN pa_budget_lines.burden_rejection_code%TYPE
231 := FND_API.G_MISS_CHAR
232 ,p_other_rejection_code IN pa_budget_lines.other_rejection_code%TYPE
233 := FND_API.G_MISS_CHAR
234 ,p_code_combination_id IN pa_budget_lines.code_combination_id%TYPE
235 := FND_API.G_MISS_NUM
236 ,p_ccid_gen_status_code IN pa_budget_lines.ccid_gen_status_code%TYPE
237 := FND_API.G_MISS_CHAR
238 ,p_ccid_gen_rej_message IN pa_budget_lines.ccid_gen_rej_message%TYPE
239 := FND_API.G_MISS_CHAR
240 ,p_request_id IN pa_budget_lines.request_id%TYPE
241 := FND_API.G_MISS_NUM
242 ,p_borrowed_revenue IN pa_budget_lines.borrowed_revenue%TYPE
243 := FND_API.G_MISS_NUM
244 ,p_tp_revenue_in IN pa_budget_lines.tp_revenue_in%TYPE
245 := FND_API.G_MISS_NUM
246 ,p_tp_revenue_out IN pa_budget_lines.tp_revenue_out%TYPE
247 := FND_API.G_MISS_NUM
248 ,p_revenue_adj IN pa_budget_lines.revenue_adj%TYPE
249 := FND_API.G_MISS_NUM
253 := FND_API.G_MISS_NUM
250 ,p_lent_resource_cost IN pa_budget_lines.lent_resource_cost%TYPE
251 := FND_API.G_MISS_NUM
252 ,p_tp_cost_in IN pa_budget_lines.tp_cost_in%TYPE
254 ,p_tp_cost_out IN pa_budget_lines.tp_cost_out%TYPE
255 := FND_API.G_MISS_NUM
256 ,p_cost_adj IN pa_budget_lines.cost_adj%TYPE
257 := FND_API.G_MISS_NUM
258 ,p_unassigned_time_cost IN pa_budget_lines.unassigned_time_cost%TYPE
259 := FND_API.G_MISS_NUM
260 ,p_utilization_percent IN pa_budget_lines.utilization_percent%TYPE
261 := FND_API.G_MISS_NUM
262 ,p_utilization_hours IN pa_budget_lines.utilization_hours%TYPE
263 := FND_API.G_MISS_NUM
264 ,p_utilization_adj IN pa_budget_lines.utilization_adj%TYPE
265 := FND_API.G_MISS_NUM
266 ,p_capacity IN pa_budget_lines.capacity%TYPE
267 := FND_API.G_MISS_NUM
268 ,p_head_count IN pa_budget_lines.head_count%TYPE
269 := FND_API.G_MISS_NUM
270 ,p_head_count_adj IN pa_budget_lines.head_count_adj%TYPE
271 := FND_API.G_MISS_NUM,
272 p_projfunc_currency_code in pa_budget_lines.projfunc_currency_code%type := FND_API.G_MISS_CHAR,
273 p_projfunc_cost_rate_type in pa_budget_lines.projfunc_cost_rate_type%type := FND_API.G_MISS_CHAR,
274 p_projfunc_cost_exchange_rate in pa_budget_lines.projfunc_cost_exchange_rate%type := FND_API.G_MISS_NUM,
275 p_projfunc_cost_rate_date_type in pa_budget_lines.projfunc_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
276 p_projfunc_cost_rate_date in pa_budget_lines.projfunc_cost_rate_date%type := FND_API.G_MISS_DATE,
277 p_projfunc_rev_rate_type in pa_budget_lines.projfunc_rev_rate_type%type := FND_API.G_MISS_CHAR,
278 p_projfunc_rev_rate_date_type in pa_budget_lines.projfunc_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
279 p_projfunc_rev_exchange_rate in pa_budget_lines.projfunc_rev_exchange_rate%type := FND_API.G_MISS_NUM,
280 p_projfunc_rev_rate_date in pa_budget_lines.projfunc_rev_rate_date%type := FND_API.G_MISS_DATE,
281 p_project_currency_code in pa_budget_lines.project_currency_code%type := FND_API.G_MISS_CHAR,
282 p_project_cost_rate_type in pa_budget_lines.project_cost_rate_type%type := FND_API.G_MISS_CHAR,
283 p_project_cost_exchange_rate in pa_budget_lines.project_cost_exchange_rate%type := FND_API.G_MISS_NUM,
284 p_project_cost_rate_date_type in pa_budget_lines.project_cost_rate_date_type%type := FND_API.G_MISS_CHAR,
285 p_project_cost_rate_date in pa_budget_lines.project_cost_rate_date%type := FND_API.G_MISS_DATE,
286 p_project_raw_cost in pa_budget_lines.project_raw_cost%type := FND_API.G_MISS_NUM,
287 p_project_burdened_cost in pa_budget_lines.project_burdened_cost%type := FND_API.G_MISS_NUM,
288 p_project_revenue in pa_budget_lines.project_revenue%type := FND_API.G_MISS_NUM,
289 p_txn_raw_cost in pa_budget_lines.txn_raw_cost%type := FND_API.G_MISS_NUM,
290 p_txn_burdened_cost in pa_budget_lines.txn_burdened_cost%type := FND_API.G_MISS_NUM,
291 p_txn_revenue in pa_budget_lines.txn_revenue%type := FND_API.G_MISS_NUM,
292 p_txn_currency_code in pa_budget_lines.txn_currency_code%type := FND_API.G_MISS_CHAR,
293 p_bucketing_period_code in pa_budget_lines.bucketing_period_code%type := FND_API.G_MISS_CHAR,
294 p_project_rev_rate_type in pa_budget_lines.project_rev_rate_type%type := FND_API.G_MISS_CHAR,
295 p_project_rev_exchange_rate in pa_budget_lines.project_rev_exchange_rate%type := FND_API.G_MISS_NUM,
296 p_project_rev_rate_date_type in pa_budget_lines.project_rev_rate_date_type%type := FND_API.G_MISS_CHAR,
297 p_project_rev_rate_date in pa_budget_lines.project_rev_rate_date%type := FND_API.G_MISS_DATE,
298 p_budget_line_id in pa_budget_lines.budget_line_id%type := FND_API.G_MISS_NUM,
299 p_budget_version_id in pa_budget_lines.budget_version_id%type := FND_API.G_MISS_NUM,
300 -- Bug Fix: 4569365. Removed MRC code.
301 -- p_mrc_flag in VARCHAR2 DEFAULT 'N'
302 p_row_id IN ROWID
303 := NULL
304 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
305
306 PROCEDURE Lock_Row
307 ( p_resource_assignment_id IN pa_budget_lines.resource_assignment_id%TYPE
308 := FND_API.G_MISS_NUM
309 ,p_start_date IN pa_budget_lines.start_date%TYPE
310 := FND_API.G_MISS_DATE
311 ,p_row_id IN ROWID
312 := NULL
313 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
314
315 PROCEDURE Delete_Row
316 ( p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE := NULL
317 ,p_row_id IN ROWID := NULL
318 -- Bug Fix: 4569365. Removed MRC code.
319 -- ,p_mrc_flag IN VARCHAR2 DEFAULT 'N'
320 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
321
322 END pa_fp_budget_lines_pkg;