[Home] [Help]
PACKAGE: APPS.PA_PROJ_FP_OPTIONS_PKG
Source
1 PACKAGE pa_proj_fp_options_pkg AUTHID CURRENT_USER as
2 /* $Header: PAFPPOTS.pls 120.5 2012/01/03 14:50:38 a5sharma ship $ */
3 -- Start of Comments
4 -- Package name : PA_PROJ_FP_OPTIONS_PKG
5 -- Purpose :
6 -- History :
7 -- 15-May-2002 Vejayara Added parameters for columns factor_by_code
8 -- and plan_in_multi_curr_flag
9 -- 14-Aug-2002 Vejayara Added parameters for financial planning in all
10 -- procedures
11 -- 23-Apr-2003 Rravipat Bug 2920954 Added parameters to insert_row and
12 -- update_row apis for new coulmns:
13 -- select_cost_res_auto_flag
14 -- cost_res_planning_level
15 -- select_rev_res_auto_flag
16 -- revenue_res_planning_level
17 -- select_all_res_auto_flag
18 -- all_res_planning_level
19 --
20 -- 26-JUN-2003 jwhite - Plannable Task Dev Effort:
21 -- For the Insert_Row procedure, add the
22 -- following IN-parameters:
23 -- 1) p_refresh_required_flag
24 -- 2) p_request_id
25 -- 3) p_processing_code
26
27 -- r11.5 FP.M Developement ----------------------------------
28 --
29 -- 08-JAN-2004 jwhite - Bug 3362316
30 -- Extensively rewrote
31 -- 1) Insert_Row
32 -- 2) Update_Row
33 --
34 -- Please Note:
35 -- Some of the table column names
36 -- are 30-charaters long. So, they
37 -- must be abbreviated to include the
38 -- "p_" prefix (PLS-00114).
39 --
40 -- 'P_COST_NON_LABOR_RES_RATE_SCH_ID' -> P_CST_NON_LABR_RES_RATE_SCH_ID
41 -- 'P_REV_NON_LABOR_RES_RATE_SCH_ID' -> P_REV_NON_LABR_RES_RATE_SCH_ID
42 -- 'P_ALL_NON_LABOR_RES_RATE_SCH_ID' -> P_ALL_NON_LABR_RES_RATE_SCH_ID
43 -- 'P_GEN_COST_INCL_CHANGE_DOC_FLAG' -> P_GN_COST_INCL_CHANGE_DOC_FLAG
44 -- 'P_GEN_COST_RET_MANUAL_LINE_FLAG' -> P_GN_COST_RET_MANUAL_LINE_FLAG
45 -- 'P_GEN_COST_INCL_UNSPENT_AMT_FLAG' -> P_GN_CST_INCL_UNSPENT_AMT_FLAG
46 -- 'P_GEN_REV_INCL_UNSPENT_AMT_FLAG' -> P_GN_REV_INCL_UNSPENT_AMT_FLAG
47 -- 'P_GEN_ALL_INCL_UNSPENT_AMT_FLAG' -> P_GN_ALL_INCL_UNSPENT_AMT_FLAG
48 -- 'P_GEN_COST_ACTUAL_AMTS_THRU_CODE' -> P_GN_CST_ACTUAL_AMTS_THRU_CODE
49 -- 'P_GEN_REV_ACTUAL_AMTS_THRU_CODE' -> P_GN_REV_ACTUAL_AMTS_THRU_CODE
50 -- 'P_GEN_ALL_ACTUAL_AMTS_THRU_CODE' -> P_GN_ALL_ACTUAL_AMTS_THRU_CODE
51 --
52
53 -- 26-jan-2004 rravipat - Bug 3354518 (IDC)
54 -- Included new column track_workplan_costs_flag
55 -- in the apis insert_row and update_row
56
57 -- 27-jan-2004 rravipat - Bug 3354518 (IDC)
58 -- Removed referenced to column RES_CLASS_BURDEN_SCH_ID
59 -- in apis insert_row and update_row as this
60 -- column has been removed.
61
62 -- 20-MAR-2004 rravipat - Bug 3519062
63 -- Impact of new columns to pa_proj_fp_options
64 -- New columns have been included to hold workplan
65 -- version details if workplan is the source of
66 -- generation
67
68 -- 23-APR-2004 rravipat - Bug 3580727
69 -- The following column should be dropped
70 -- ALL_EMP_RATE_SCH_ID
71 -- ALL_JOB_RATE_SCH_ID
72 -- ALL_NON_LABOR_RES_RATE_SCH_ID
73 -- ALL_RES_CLASS_RATE_SCH_ID
74 -- ALL_BURDEN_RATE_SCH_ID
75 -- GEN_REV_INCL_UNSPENT_AMT_FLAG
76 -- 01-SEP-2004 nkumbi - Bug 5462471
77 -- Included parameter revenue_derivation_method in Insert_Row, update_row
78
79
80 -- NOTE :
81 -- End of Comments
82
83
84
85
86 PROCEDURE Insert_Row
87 ( px_proj_fp_options_id
88 IN OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
89 ,p_project_id
90 IN pa_proj_fp_options.project_id%TYPE := FND_API.G_MISS_NUM
91 ,p_fin_plan_option_level_code
92 IN pa_proj_fp_options.fin_plan_option_level_code%TYPE := FND_API.G_MISS_CHAR
93 ,p_fin_plan_type_id
94 IN pa_proj_fp_options.fin_plan_type_id%TYPE := FND_API.G_MISS_NUM
95 ,p_fin_plan_start_date
96 IN pa_proj_fp_options.fin_plan_start_date%TYPE := FND_API.G_MISS_DATE
97 ,p_fin_plan_end_date
98 IN pa_proj_fp_options.fin_plan_end_date%TYPE := FND_API.G_MISS_DATE
99 ,p_fin_plan_preference_code
100 IN pa_proj_fp_options.fin_plan_preference_code%TYPE := FND_API.G_MISS_CHAR
101 ,p_cost_amount_set_id
102 IN pa_proj_fp_options.cost_amount_set_id%TYPE := FND_API.G_MISS_NUM
103 ,p_revenue_amount_set_id
104 IN pa_proj_fp_options.revenue_amount_set_id%TYPE := FND_API.G_MISS_NUM
105 ,p_all_amount_set_id
106 IN pa_proj_fp_options.all_amount_set_id%TYPE := FND_API.G_MISS_NUM
107 ,p_cost_fin_plan_level_code
108 IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
109 ,p_cost_time_phased_code
110 IN pa_proj_fp_options.cost_time_phased_code%TYPE := FND_API.G_MISS_CHAR
111 ,p_cost_resource_list_id
112 IN pa_proj_fp_options.cost_resource_list_id%TYPE := FND_API.G_MISS_NUM
113 ,p_revenue_fin_plan_level_code
114 IN pa_proj_fp_options.revenue_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
115 ,p_revenue_time_phased_code
116 IN pa_proj_fp_options.revenue_time_phased_code%TYPE := FND_API.G_MISS_CHAR
117 ,p_revenue_resource_list_id
118 IN pa_proj_fp_options.revenue_resource_list_id%TYPE := FND_API.G_MISS_NUM
119 ,p_all_fin_plan_level_code
120 IN pa_proj_fp_options.all_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
121 ,p_all_time_phased_code
122 IN pa_proj_fp_options.all_time_phased_code%TYPE := FND_API.G_MISS_CHAR
123 ,p_all_resource_list_id
124 IN pa_proj_fp_options.all_resource_list_id%TYPE := FND_API.G_MISS_NUM
125 ,p_report_labor_hrs_from_code
126 IN pa_proj_fp_options.report_labor_hrs_from_code%TYPE := FND_API.G_MISS_CHAR
127 ,p_fin_plan_version_id
128 IN pa_proj_fp_options.fin_plan_version_id%TYPE := FND_API.G_MISS_NUM
129 /* added for financial planning */
130 ,p_plan_in_multi_curr_flag
131 IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := FND_API.G_MISS_CHAR
132 ,p_factor_by_code
133 IN pa_proj_fp_options.factor_by_code%TYPE := FND_API.G_MISS_CHAR
134 ,p_default_amount_type_code
135 IN pa_proj_fp_options.default_amount_type_code%TYPE := FND_API.G_MISS_CHAR
136 ,p_default_amount_subtype_code
137 IN pa_proj_fp_options.default_amount_subtype_code%TYPE := FND_API.G_MISS_CHAR
138 ,p_approved_cost_plan_type_flag
139 IN pa_proj_fp_options.approved_cost_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
140 ,p_approved_rev_plan_type_flag
141 IN pa_proj_fp_options.approved_rev_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
142 ,p_projfunc_cost_rate_type
143 IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
144 ,p_projfunc_cost_rate_date_type
145 IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
146 ,p_projfunc_cost_rate_date
147 IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := FND_API.G_MISS_DATE
148 ,p_projfunc_rev_rate_type
149 IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
150 ,p_projfunc_rev_rate_date_type
151 IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
152 ,p_projfunc_rev_rate_date
153 IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := FND_API.G_MISS_DATE
154 ,p_project_cost_rate_type
155 IN pa_proj_fp_options.project_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
156 ,p_project_cost_rate_date_type
157 IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
158 ,p_project_cost_rate_date
159 IN pa_proj_fp_options.project_cost_rate_date%TYPE := FND_API.G_MISS_DATE
160 ,p_project_rev_rate_type
161 IN pa_proj_fp_options.project_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
162 ,p_project_rev_rate_date_type
163 IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
164 ,p_project_rev_rate_date
165 IN pa_proj_fp_options.project_rev_rate_date%TYPE := FND_API.G_MISS_DATE
166 ,p_margin_derived_from_code
167 IN pa_proj_fp_options.margin_derived_from_code%TYPE := FND_API.G_MISS_CHAR
168 /* ended additions for fin plan */
169 /* Bug 2920954 start of additional parameters for post FP-k one off */
170 ,p_select_cost_res_auto_flag
171 IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
172 ,p_cost_res_planning_level
173 IN pa_proj_fp_options.cost_res_planning_level%TYPE := FND_API.G_MISS_CHAR
174 ,p_select_rev_res_auto_flag
175 IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
176 ,p_revenue_res_planning_level
177 IN pa_proj_fp_options.revenue_res_planning_level%TYPE := FND_API.G_MISS_CHAR
178 ,p_select_all_res_auto_flag
179 IN pa_proj_fp_options.select_all_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
180 ,p_all_res_planning_level
181 IN pa_proj_fp_options.all_res_planning_level%TYPE := FND_API.G_MISS_CHAR
182 ,p_refresh_required_flag
183 IN pa_budget_versions.PROCESS_UPDATE_WBS_FLAG%TYPE := FND_API.G_MISS_CHAR
184 ,p_request_id
185 IN pa_budget_versions.REQUEST_ID%TYPE := FND_API.G_MISS_NUM
186 ,p_processing_code
187 IN pa_budget_versions.PLAN_PROCESSING_CODE%TYPE := FND_API.G_MISS_CHAR
188 /* Bug 2920954 end of additional parameters for post FP-k one off */
189 ,p_primary_cost_forecast_flag
190 IN PA_PROJ_FP_OPTIONS.primary_cost_forecast_flag%TYPE := FND_API.G_MISS_CHAR
191 ,p_primary_rev_forecast_flag
192 IN PA_PROJ_FP_OPTIONS.primary_rev_forecast_flag%TYPE := FND_API.G_MISS_CHAR
193 ,p_use_planning_rates_flag
194 IN PA_PROJ_FP_OPTIONS.use_planning_rates_flag%TYPE := FND_API.G_MISS_CHAR
195 ,p_rbs_version_id
196 IN PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE := FND_API.G_MISS_NUM
197 ,p_res_class_raw_cost_sch_id
198 IN PA_PROJ_FP_OPTIONS.res_class_raw_cost_sch_id%TYPE := FND_API.G_MISS_NUM
199 ,p_res_class_bill_rate_sch_id
200 IN PA_PROJ_FP_OPTIONS.res_class_bill_rate_sch_id%TYPE := FND_API.G_MISS_NUM
201 ,p_cost_emp_rate_sch_id
202 IN PA_PROJ_FP_OPTIONS.cost_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
203 ,p_cost_job_rate_sch_id
204 IN PA_PROJ_FP_OPTIONS.cost_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
205 ,p_cst_non_labr_res_rate_sch_id
206 IN PA_PROJ_FP_OPTIONS.cost_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
207 ,p_cost_res_class_rate_sch_id
208 IN PA_PROJ_FP_OPTIONS.cost_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
209 ,p_cost_burden_rate_sch_id
210 IN PA_PROJ_FP_OPTIONS.cost_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
211 ,p_cost_current_planning_period
212 IN PA_PROJ_FP_OPTIONS.cost_current_planning_period%TYPE := FND_API.G_MISS_CHAR
213 ,p_cost_period_mask_id
214 IN PA_PROJ_FP_OPTIONS.cost_period_mask_id%TYPE := FND_API.G_MISS_NUM
215 ,p_rev_emp_rate_sch_id
216 IN PA_PROJ_FP_OPTIONS.rev_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
217 ,p_rev_job_rate_sch_id
218 IN PA_PROJ_FP_OPTIONS.rev_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
219 ,p_rev_non_labr_res_rate_sch_id
220 IN PA_PROJ_FP_OPTIONS.rev_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
221 ,p_rev_res_class_rate_sch_id
222 IN PA_PROJ_FP_OPTIONS.rev_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
223 ,p_rev_current_planning_period
224 IN PA_PROJ_FP_OPTIONS.rev_current_planning_period%TYPE := FND_API.G_MISS_CHAR
225 ,p_rev_period_mask_id
226 IN PA_PROJ_FP_OPTIONS.rev_period_mask_id%TYPE := FND_API.G_MISS_NUM
227 /** Bug 3580727 Columns have been dropped
228 ,p_all_emp_rate_sch_id
229 IN PA_PROJ_FP_OPTIONS.all_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
230 ,p_all_job_rate_sch_id
231 IN PA_PROJ_FP_OPTIONS.all_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
232 ,p_all_non_labr_res_rate_sch_id
233 IN PA_PROJ_FP_OPTIONS.all_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
234 ,p_all_res_class_rate_sch_id
235 IN PA_PROJ_FP_OPTIONS.all_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
236 ,p_all_burden_rate_sch_id
237 IN PA_PROJ_FP_OPTIONS.all_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
238 **/
239 ,p_all_current_planning_period
240 IN PA_PROJ_FP_OPTIONS.all_current_planning_period%TYPE := FND_API.G_MISS_CHAR
241 ,p_all_period_mask_id
242 IN PA_PROJ_FP_OPTIONS.all_period_mask_id%TYPE := FND_API.G_MISS_NUM
243 ,p_gen_cost_src_code
244 IN PA_PROJ_FP_OPTIONS.gen_cost_src_code%TYPE := FND_API.G_MISS_CHAR
245 ,p_gen_cost_etc_src_code
246 IN PA_PROJ_FP_OPTIONS.gen_cost_etc_src_code%TYPE := FND_API.G_MISS_CHAR
247 ,p_gn_cost_incl_change_doc_flag
248 IN PA_PROJ_FP_OPTIONS.gen_cost_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
249 ,p_gen_cost_incl_open_comm_flag
250 IN PA_PROJ_FP_OPTIONS.gen_cost_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
251 ,p_gn_cost_ret_manual_line_flag
252 IN PA_PROJ_FP_OPTIONS.gen_cost_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
253 ,p_gn_cst_incl_unspent_amt_flag
254 IN PA_PROJ_FP_OPTIONS.gen_cost_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
255 ,p_gen_rev_src_code
256 IN PA_PROJ_FP_OPTIONS.gen_rev_src_code%TYPE := FND_API.G_MISS_CHAR
257 ,p_gen_rev_etc_src_code
258 IN PA_PROJ_FP_OPTIONS.gen_rev_etc_src_code%TYPE := FND_API.G_MISS_CHAR
259 ,p_gen_rev_incl_change_doc_flag
263 ,p_gen_rev_ret_manual_line_flag
260 IN PA_PROJ_FP_OPTIONS.gen_rev_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
261 ,p_gen_rev_incl_bill_event_flag
262 IN PA_PROJ_FP_OPTIONS.gen_rev_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
264 IN PA_PROJ_FP_OPTIONS.gen_rev_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
265 /** Bug 3580727 this column has been dropped
266 ,p_gn_rev_incl_unspent_amt_flag
267 IN PA_PROJ_FP_OPTIONS.gen_rev_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
268 **/
269 ,p_gen_src_cost_plan_type_id
270 IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_type_id%TYPE := FND_API.G_MISS_NUM
271 ,p_gen_src_cost_plan_version_id
272 IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_version_id%TYPE := FND_API.G_MISS_NUM
273 ,p_gen_src_cost_plan_ver_code
274 IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
275 ,p_gen_src_rev_plan_type_id
276 IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_type_id%TYPE := FND_API.G_MISS_NUM
277 ,p_gen_src_rev_plan_version_id
278 IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_version_id%TYPE := FND_API.G_MISS_NUM
279 ,p_gen_src_rev_plan_ver_code
280 IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
281 ,p_gen_src_all_plan_type_id
282 IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_type_id%TYPE := FND_API.G_MISS_NUM
283 ,p_gen_src_all_plan_version_id
284 IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_version_id%TYPE := FND_API.G_MISS_NUM
285 ,p_gen_src_all_plan_ver_code
286 IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
287 ,p_gen_all_src_code
288 IN PA_PROJ_FP_OPTIONS.gen_all_src_code%TYPE := FND_API.G_MISS_CHAR
289 ,p_gen_all_etc_src_code
290 IN PA_PROJ_FP_OPTIONS.gen_all_etc_src_code%TYPE := FND_API.G_MISS_CHAR
291 ,p_gen_all_incl_change_doc_flag
292 IN PA_PROJ_FP_OPTIONS.gen_all_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
293 ,p_gen_all_incl_open_comm_flag
294 IN PA_PROJ_FP_OPTIONS.gen_all_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
295 ,p_gen_all_ret_manual_line_flag
296 IN PA_PROJ_FP_OPTIONS.gen_all_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
297 ,p_gen_all_incl_bill_event_flag
298 IN PA_PROJ_FP_OPTIONS.gen_all_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
299 ,p_gn_all_incl_unspent_amt_flag
300 IN PA_PROJ_FP_OPTIONS.gen_all_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
301 ,p_gn_cst_actual_amts_thru_code
302 IN PA_PROJ_FP_OPTIONS.gen_cost_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
303 ,p_gn_rev_actual_amts_thru_code
304 IN PA_PROJ_FP_OPTIONS.gen_rev_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
305 ,p_gn_all_actual_amts_thru_code
306 IN PA_PROJ_FP_OPTIONS.gen_all_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
307 ,p_track_workplan_costs_flag
308 IN PA_PROJ_FP_OPTIONS.track_workplan_costs_flag%TYPE := FND_API.G_MISS_CHAR
309 -- bug 3519062 start of workplan gen source related columns
310 ,p_gen_src_cost_wp_version_id
311 IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_version_id%TYPE := FND_API.G_MISS_NUM
312 ,p_gen_src_cost_wp_ver_code
313 IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
314 ,p_gen_src_rev_wp_version_id
315 IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_version_id%TYPE := FND_API.G_MISS_NUM
316 ,p_gen_src_rev_wp_ver_code
317 IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
318 ,p_gen_src_all_wp_version_id
319 IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_version_id%TYPE := FND_API.G_MISS_NUM
320 ,p_gen_src_all_wp_ver_code
321 IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
322 -- bug 3519062 end of workplan gen source related columns
323
324 --Added for webAdi changes for the amount types to be displayed
325 ,p_cost_layout_code
326 IN PA_PROJ_FP_OPTIONS.cost_layout_code%TYPE := FND_API.G_MISS_CHAR
327 ,p_revenue_layout_code
328 IN PA_PROJ_FP_OPTIONS.revenue_layout_code%TYPE := FND_API.G_MISS_CHAR
329 ,p_all_layout_code
330 IN PA_PROJ_FP_OPTIONS.all_layout_code%TYPE := FND_API.G_MISS_CHAR
331 ,p_revenue_derivation_method
332 IN PA_PROJ_FP_OPTIONS.revenue_derivation_method%TYPE := FND_API.G_MISS_CHAR -- Bug 5462471
333 , p_copy_etc_from_plan_flag
334 IN PA_PROJ_FP_OPTIONS.copy_etc_from_plan_flag%TYPE := FND_API.G_MISS_CHAR --bug 8318932
335 , p_default_raw_cost
336 IN PA_PROJ_FP_OPTIONS.default_raw_cost%TYPE := FND_API.G_MISS_NUM --CBS
337 , p_default_bill_rate
338 IN PA_PROJ_FP_OPTIONS.default_bill_rate%TYPE := FND_API.G_MISS_NUM --CBS
339 , p_def_markup_percentage
340 IN PA_PROJ_FP_OPTIONS.def_markup_percentage%TYPE := FND_API.G_MISS_NUM --CBS
341 , p_def_raw_cost_currency_code
342 IN PA_PROJ_FP_OPTIONS.def_raw_cost_currency_code%TYPE := FND_API.G_MISS_CHAR --CBS
343 , p_def_bill_rate_currency_code
344 IN PA_PROJ_FP_OPTIONS.def_bill_rate_currency_code%TYPE := FND_API.G_MISS_CHAR --CBS
345 ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
346 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
347
348 PROCEDURE Update_Row
349 ( p_proj_fp_options_id
350 IN pa_proj_fp_options.proj_fp_options_id%TYPE := FND_API.G_MISS_NUM
351 ,p_record_version_number
352 IN NUMBER := NULL
353 ,p_project_id
354 IN pa_proj_fp_options.project_id%TYPE := FND_API.G_MISS_NUM
355 ,p_fin_plan_option_level_code
356 IN pa_proj_fp_options.fin_plan_option_level_code%TYPE := FND_API.G_MISS_CHAR
357 ,p_fin_plan_type_id
358 IN pa_proj_fp_options.fin_plan_type_id%TYPE := FND_API.G_MISS_NUM
359 ,p_fin_plan_start_date
360 IN pa_proj_fp_options.fin_plan_start_date%TYPE := FND_API.G_MISS_DATE
361 ,p_fin_plan_end_date
362 IN pa_proj_fp_options.fin_plan_end_date%TYPE := FND_API.G_MISS_DATE
363 ,p_fin_plan_preference_code
364 IN pa_proj_fp_options.fin_plan_preference_code%TYPE := FND_API.G_MISS_CHAR
365 ,p_cost_amount_set_id
369 ,p_all_amount_set_id
366 IN pa_proj_fp_options.cost_amount_set_id%TYPE := FND_API.G_MISS_NUM
367 ,p_revenue_amount_set_id
368 IN pa_proj_fp_options.revenue_amount_set_id%TYPE := FND_API.G_MISS_NUM
370 IN pa_proj_fp_options.all_amount_set_id%TYPE := FND_API.G_MISS_NUM
371 ,p_cost_fin_plan_level_code
372 IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
373 ,p_cost_time_phased_code
374 IN pa_proj_fp_options.cost_time_phased_code%TYPE := FND_API.G_MISS_CHAR
375 ,p_cost_resource_list_id
376 IN pa_proj_fp_options.cost_resource_list_id%TYPE := FND_API.G_MISS_NUM
377 ,p_revenue_fin_plan_level_code
378 IN pa_proj_fp_options.revenue_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
379 ,p_revenue_time_phased_code
380 IN pa_proj_fp_options.revenue_time_phased_code%TYPE := FND_API.G_MISS_CHAR
381 ,p_revenue_resource_list_id
382 IN pa_proj_fp_options.revenue_resource_list_id%TYPE := FND_API.G_MISS_NUM
383 ,p_all_fin_plan_level_code
384 IN pa_proj_fp_options.all_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
385 ,p_all_time_phased_code
386 IN pa_proj_fp_options.all_time_phased_code%TYPE := FND_API.G_MISS_CHAR
387 ,p_all_resource_list_id
388 IN pa_proj_fp_options.all_resource_list_id%TYPE := FND_API.G_MISS_NUM
389 ,p_report_labor_hrs_from_code
390 IN pa_proj_fp_options.report_labor_hrs_from_code%TYPE := FND_API.G_MISS_CHAR
391 ,p_fin_plan_version_id
392 IN pa_proj_fp_options.fin_plan_version_id%TYPE := FND_API.G_MISS_NUM
393 /* added for financial planning */
394 ,p_plan_in_multi_curr_flag
395 IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := FND_API.G_MISS_CHAR
396 ,p_factor_by_code
397 IN pa_proj_fp_options.factor_by_code%TYPE := FND_API.G_MISS_CHAR
398 ,p_default_amount_type_code
399 IN pa_proj_fp_options.default_amount_type_code%TYPE := FND_API.G_MISS_CHAR
400 ,p_default_amount_subtype_code
401 IN pa_proj_fp_options.default_amount_subtype_code%TYPE := FND_API.G_MISS_CHAR
402 ,p_approved_cost_plan_type_flag
403 IN pa_proj_fp_options.approved_cost_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
404 ,p_approved_rev_plan_type_flag
405 IN pa_proj_fp_options.approved_rev_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
406 ,p_projfunc_cost_rate_type
407 IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
408 ,p_projfunc_cost_rate_date_type
409 IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
410 ,p_projfunc_cost_rate_date
411 IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := FND_API.G_MISS_DATE
412 ,p_projfunc_rev_rate_type
413 IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
414 ,p_projfunc_rev_rate_date_type
415 IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
416 ,p_projfunc_rev_rate_date
417 IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := FND_API.G_MISS_DATE
418 ,p_project_cost_rate_type
419 IN pa_proj_fp_options.project_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
420 ,p_project_cost_rate_date_type
421 IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
422 ,p_project_cost_rate_date
423 IN pa_proj_fp_options.project_cost_rate_date%TYPE := FND_API.G_MISS_DATE
424 ,p_project_rev_rate_type
425 IN pa_proj_fp_options.project_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
426 ,p_project_rev_rate_date_type
427 IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
428 ,p_project_rev_rate_date
429 IN pa_proj_fp_options.project_rev_rate_date%TYPE := FND_API.G_MISS_DATE
430 ,p_margin_derived_from_code
431 IN pa_proj_fp_options.margin_derived_from_code%TYPE := FND_API.G_MISS_CHAR
432 /* ended additions for fin plan */
433 /* Bug 2920954 start of additional parameters for post FP-k one off */
434 ,p_select_cost_res_auto_flag
435 IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
436 ,p_cost_res_planning_level
437 IN pa_proj_fp_options.cost_res_planning_level%TYPE := FND_API.G_MISS_CHAR
438 ,p_select_rev_res_auto_flag
439 IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
440 ,p_revenue_res_planning_level
441 IN pa_proj_fp_options.revenue_res_planning_level%TYPE := FND_API.G_MISS_CHAR
442 ,p_select_all_res_auto_flag
443 IN pa_proj_fp_options.select_all_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
444 ,p_all_res_planning_level
445 IN pa_proj_fp_options.all_res_planning_level%TYPE := FND_API.G_MISS_CHAR
446 /* Bug 2920954 end of additional parameters for post FP-k one off */
447 ,p_primary_cost_forecast_flag
448 IN PA_PROJ_FP_OPTIONS.primary_cost_forecast_flag%TYPE := FND_API.G_MISS_CHAR
449 ,p_primary_rev_forecast_flag
450 IN PA_PROJ_FP_OPTIONS.primary_rev_forecast_flag%TYPE := FND_API.G_MISS_CHAR
451 ,p_use_planning_rates_flag
452 IN PA_PROJ_FP_OPTIONS.use_planning_rates_flag%TYPE := FND_API.G_MISS_CHAR
453 ,p_rbs_version_id
454 IN PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE := FND_API.G_MISS_NUM
455 ,p_res_class_raw_cost_sch_id
456 IN PA_PROJ_FP_OPTIONS.res_class_raw_cost_sch_id%TYPE := FND_API.G_MISS_NUM
457 ,p_res_class_bill_rate_sch_id
458 IN PA_PROJ_FP_OPTIONS.res_class_bill_rate_sch_id%TYPE := FND_API.G_MISS_NUM
459 ,p_cost_emp_rate_sch_id
460 IN PA_PROJ_FP_OPTIONS.cost_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
461 ,p_cost_job_rate_sch_id
462 IN PA_PROJ_FP_OPTIONS.cost_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
463 ,P_CST_NON_LABR_RES_RATE_SCH_ID
464 IN PA_PROJ_FP_OPTIONS.cost_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
465 ,p_cost_res_class_rate_sch_id
466 IN PA_PROJ_FP_OPTIONS.cost_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
467 ,p_cost_burden_rate_sch_id
468 IN PA_PROJ_FP_OPTIONS.cost_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
469 ,p_cost_current_planning_period
473 ,p_rev_emp_rate_sch_id
470 IN PA_PROJ_FP_OPTIONS.cost_current_planning_period%TYPE := FND_API.G_MISS_CHAR
471 ,p_cost_period_mask_id
472 IN PA_PROJ_FP_OPTIONS.cost_period_mask_id%TYPE := FND_API.G_MISS_NUM
474 IN PA_PROJ_FP_OPTIONS.rev_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
475 ,p_rev_job_rate_sch_id
476 IN PA_PROJ_FP_OPTIONS.rev_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
477 ,P_REV_NON_LABR_RES_RATE_SCH_ID
478 IN PA_PROJ_FP_OPTIONS.rev_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
479 ,p_rev_res_class_rate_sch_id
480 IN PA_PROJ_FP_OPTIONS.rev_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
481 ,p_rev_current_planning_period
482 IN PA_PROJ_FP_OPTIONS.rev_current_planning_period%TYPE := FND_API.G_MISS_CHAR
483 ,p_rev_period_mask_id
484 IN PA_PROJ_FP_OPTIONS.rev_period_mask_id%TYPE := FND_API.G_MISS_NUM
485 /** Bug 3580727 Columns have been dropped
486 ,p_all_emp_rate_sch_id
487 IN PA_PROJ_FP_OPTIONS.all_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
488 ,p_all_job_rate_sch_id
489 IN PA_PROJ_FP_OPTIONS.all_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
490 ,P_ALL_NON_LABR_RES_RATE_SCH_ID
491 IN PA_PROJ_FP_OPTIONS.all_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
492 ,p_all_res_class_rate_sch_id
493 IN PA_PROJ_FP_OPTIONS.all_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
494 ,p_all_burden_rate_sch_id
495 IN PA_PROJ_FP_OPTIONS.all_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
496 **/
497 ,p_all_current_planning_period
498 IN PA_PROJ_FP_OPTIONS.all_current_planning_period%TYPE := FND_API.G_MISS_CHAR
499 ,p_all_period_mask_id
500 IN PA_PROJ_FP_OPTIONS.all_period_mask_id%TYPE := FND_API.G_MISS_NUM
501 ,p_gen_cost_src_code
502 IN PA_PROJ_FP_OPTIONS.gen_cost_src_code%TYPE := FND_API.G_MISS_CHAR
503 ,p_gen_cost_etc_src_code
504 IN PA_PROJ_FP_OPTIONS.gen_cost_etc_src_code%TYPE := FND_API.G_MISS_CHAR
505 ,P_GN_COST_INCL_CHANGE_DOC_FLAG
506 IN PA_PROJ_FP_OPTIONS.gen_cost_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
507 ,p_gen_cost_incl_open_comm_flag
508 IN PA_PROJ_FP_OPTIONS.gen_cost_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
509 ,P_GN_COST_RET_MANUAL_LINE_FLAG
510 IN PA_PROJ_FP_OPTIONS.gen_cost_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
511 ,P_GN_CST_INCL_UNSPENT_AMT_FLAG
512 IN PA_PROJ_FP_OPTIONS.gen_cost_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
513 ,p_gen_rev_src_code
514 IN PA_PROJ_FP_OPTIONS.gen_rev_src_code%TYPE := FND_API.G_MISS_CHAR
515 ,p_gen_rev_etc_src_code
516 IN PA_PROJ_FP_OPTIONS.gen_rev_etc_src_code%TYPE := FND_API.G_MISS_CHAR
517 ,p_gen_rev_incl_change_doc_flag
518 IN PA_PROJ_FP_OPTIONS.gen_rev_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
519 ,p_gen_rev_incl_bill_event_flag
520 IN PA_PROJ_FP_OPTIONS.gen_rev_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
521 ,p_gen_rev_ret_manual_line_flag
522 IN PA_PROJ_FP_OPTIONS.gen_rev_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
523 /** Bug 3580727 this column has been dropped
524 ,P_GN_REV_INCL_UNSPENT_AMT_FLAG
525 IN PA_PROJ_FP_OPTIONS.gen_rev_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
526 **/
527 ,p_gen_src_cost_plan_type_id
528 IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_type_id%TYPE := FND_API.G_MISS_NUM
529 ,p_gen_src_cost_plan_version_id
530 IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_version_id%TYPE := FND_API.G_MISS_NUM
531 ,p_gen_src_cost_plan_ver_code
532 IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
533 ,p_gen_src_rev_plan_type_id
534 IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_type_id%TYPE := FND_API.G_MISS_NUM
535 ,p_gen_src_rev_plan_version_id
536 IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_version_id%TYPE := FND_API.G_MISS_NUM
537 ,p_gen_src_rev_plan_ver_code
538 IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
539 ,p_gen_src_all_plan_type_id
540 IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_type_id%TYPE := FND_API.G_MISS_NUM
541 ,p_gen_src_all_plan_version_id
542 IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_version_id%TYPE := FND_API.G_MISS_NUM
543 ,p_gen_src_all_plan_ver_code
544 IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
545 ,p_gen_all_src_code
546 IN PA_PROJ_FP_OPTIONS.gen_all_src_code%TYPE := FND_API.G_MISS_CHAR
547 ,p_gen_all_etc_src_code
548 IN PA_PROJ_FP_OPTIONS.gen_all_etc_src_code%TYPE := FND_API.G_MISS_CHAR
549 ,p_gen_all_incl_change_doc_flag
550 IN PA_PROJ_FP_OPTIONS.gen_all_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
551 ,p_gen_all_incl_open_comm_flag
552 IN PA_PROJ_FP_OPTIONS.gen_all_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
553 ,p_gen_all_ret_manual_line_flag
554 IN PA_PROJ_FP_OPTIONS.gen_all_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
555 ,p_gen_all_incl_bill_event_flag
556 IN PA_PROJ_FP_OPTIONS.gen_all_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
557 ,P_GN_ALL_INCL_UNSPENT_AMT_FLAG
558 IN PA_PROJ_FP_OPTIONS.gen_all_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
559 ,P_GN_CST_ACTUAL_AMTS_THRU_CODE
560 IN PA_PROJ_FP_OPTIONS.gen_cost_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
561 ,P_GN_REV_ACTUAL_AMTS_THRU_CODE
562 IN PA_PROJ_FP_OPTIONS.gen_rev_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
563 ,P_GN_ALL_ACTUAL_AMTS_THRU_CODE
564 IN PA_PROJ_FP_OPTIONS.gen_all_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
565 ,p_track_workplan_costs_flag
566 IN PA_PROJ_FP_OPTIONS.track_workplan_costs_flag%TYPE := FND_API.G_MISS_CHAR
567 -- bug 3519062 start of workplan gen source related columns
568 ,p_gen_src_cost_wp_version_id
569 IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_version_id%TYPE := FND_API.G_MISS_NUM
570 ,p_gen_src_cost_wp_ver_code
571 IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
572 ,p_gen_src_rev_wp_version_id
573 IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_version_id%TYPE := FND_API.G_MISS_NUM
574 ,p_gen_src_rev_wp_ver_code
575 IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
576 ,p_gen_src_all_wp_version_id
577 IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_version_id%TYPE := FND_API.G_MISS_NUM
578 ,p_gen_src_all_wp_ver_code
579 IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
580 --Added for webAdi changes for the amount types to be displayed
581 ,p_cost_layout_code
582 IN PA_PROJ_FP_OPTIONS.cost_layout_code%TYPE := FND_API.G_MISS_CHAR
583 ,p_revenue_layout_code
584 IN PA_PROJ_FP_OPTIONS.revenue_layout_code%TYPE := FND_API.G_MISS_CHAR
585 ,p_all_layout_code
586 IN PA_PROJ_FP_OPTIONS.all_layout_code%TYPE := FND_API.G_MISS_CHAR
587 -- bug 3519062 end of workplan gen source related columns
588 ,p_revenue_derivation_method
589 IN PA_PROJ_FP_OPTIONS.revenue_derivation_method%TYPE := FND_API.G_MISS_CHAR --Bug 5462471
590 , p_copy_etc_from_plan_flag
591 IN PA_PROJ_FP_OPTIONS.copy_etc_from_plan_flag%TYPE := FND_API.G_MISS_CHAR --bug 8318932
592 , p_default_raw_cost
593 IN PA_PROJ_FP_OPTIONS.default_raw_cost%TYPE := FND_API.G_MISS_NUM --CBS
594 , p_default_bill_rate
595 IN PA_PROJ_FP_OPTIONS.default_bill_rate%TYPE := FND_API.G_MISS_NUM --CBS
596 , p_def_markup_percentage
597 IN PA_PROJ_FP_OPTIONS.def_markup_percentage%TYPE := FND_API.G_MISS_NUM --CBS
598 , p_def_raw_cost_currency_code
599 IN PA_PROJ_FP_OPTIONS.def_raw_cost_currency_code%TYPE := FND_API.G_MISS_CHAR --CBS
600 , p_def_bill_rate_currency_code
601 IN PA_PROJ_FP_OPTIONS.def_bill_rate_currency_code%TYPE := FND_API.G_MISS_CHAR --CBS
602 ,p_row_id
603 IN ROWID := NULL
604 ,x_return_status OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
605
606
607
608 PROCEDURE Lock_Row
609 ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
610 := FND_API.G_MISS_NUM
611 ,p_record_version_number IN NUMBER
612 := NULL
613 ,p_row_id IN ROWID
614 := NULL
615 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
616
617 PROCEDURE Delete_Row
618 ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
619 := FND_API.G_MISS_NUM
620 ,p_record_version_number IN NUMBER
621 := NULL
622 ,p_row_id IN ROWID
623 := NULL
624 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
625 End pa_proj_fp_options_pkg;