[Home] [Help]
PACKAGE: APPS.PA_PROJ_FP_OPTIONS_PKG
Source
1 PACKAGE pa_proj_fp_options_pkg as
2 /* $Header: PAFPPOTS.pls 120.3 2007/02/06 10:05:40 dthakker 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
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
263 ,p_gen_rev_ret_manual_line_flag
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
314 ,p_gen_src_rev_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
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 ,x_row_id OUT NOCOPY ROWID --File.Sql.39 bug 4440895
334 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
335
336 PROCEDURE Update_Row
337 ( p_proj_fp_options_id
338 IN pa_proj_fp_options.proj_fp_options_id%TYPE := FND_API.G_MISS_NUM
339 ,p_record_version_number
340 IN NUMBER := NULL
341 ,p_project_id
342 IN pa_proj_fp_options.project_id%TYPE := FND_API.G_MISS_NUM
343 ,p_fin_plan_option_level_code
344 IN pa_proj_fp_options.fin_plan_option_level_code%TYPE := FND_API.G_MISS_CHAR
345 ,p_fin_plan_type_id
346 IN pa_proj_fp_options.fin_plan_type_id%TYPE := FND_API.G_MISS_NUM
347 ,p_fin_plan_start_date
348 IN pa_proj_fp_options.fin_plan_start_date%TYPE := FND_API.G_MISS_DATE
349 ,p_fin_plan_end_date
350 IN pa_proj_fp_options.fin_plan_end_date%TYPE := FND_API.G_MISS_DATE
351 ,p_fin_plan_preference_code
352 IN pa_proj_fp_options.fin_plan_preference_code%TYPE := FND_API.G_MISS_CHAR
353 ,p_cost_amount_set_id
354 IN pa_proj_fp_options.cost_amount_set_id%TYPE := FND_API.G_MISS_NUM
355 ,p_revenue_amount_set_id
356 IN pa_proj_fp_options.revenue_amount_set_id%TYPE := FND_API.G_MISS_NUM
357 ,p_all_amount_set_id
358 IN pa_proj_fp_options.all_amount_set_id%TYPE := FND_API.G_MISS_NUM
359 ,p_cost_fin_plan_level_code
360 IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
361 ,p_cost_time_phased_code
362 IN pa_proj_fp_options.cost_time_phased_code%TYPE := FND_API.G_MISS_CHAR
363 ,p_cost_resource_list_id
364 IN pa_proj_fp_options.cost_resource_list_id%TYPE := FND_API.G_MISS_NUM
365 ,p_revenue_fin_plan_level_code
366 IN pa_proj_fp_options.revenue_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
367 ,p_revenue_time_phased_code
368 IN pa_proj_fp_options.revenue_time_phased_code%TYPE := FND_API.G_MISS_CHAR
369 ,p_revenue_resource_list_id
370 IN pa_proj_fp_options.revenue_resource_list_id%TYPE := FND_API.G_MISS_NUM
371 ,p_all_fin_plan_level_code
372 IN pa_proj_fp_options.all_fin_plan_level_code%TYPE := FND_API.G_MISS_CHAR
373 ,p_all_time_phased_code
374 IN pa_proj_fp_options.all_time_phased_code%TYPE := FND_API.G_MISS_CHAR
375 ,p_all_resource_list_id
376 IN pa_proj_fp_options.all_resource_list_id%TYPE := FND_API.G_MISS_NUM
377 ,p_report_labor_hrs_from_code
378 IN pa_proj_fp_options.report_labor_hrs_from_code%TYPE := FND_API.G_MISS_CHAR
379 ,p_fin_plan_version_id
380 IN pa_proj_fp_options.fin_plan_version_id%TYPE := FND_API.G_MISS_NUM
381 /* added for financial planning */
382 ,p_plan_in_multi_curr_flag
383 IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := FND_API.G_MISS_CHAR
384 ,p_factor_by_code
385 IN pa_proj_fp_options.factor_by_code%TYPE := FND_API.G_MISS_CHAR
386 ,p_default_amount_type_code
387 IN pa_proj_fp_options.default_amount_type_code%TYPE := FND_API.G_MISS_CHAR
388 ,p_default_amount_subtype_code
389 IN pa_proj_fp_options.default_amount_subtype_code%TYPE := FND_API.G_MISS_CHAR
390 ,p_approved_cost_plan_type_flag
391 IN pa_proj_fp_options.approved_cost_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
392 ,p_approved_rev_plan_type_flag
393 IN pa_proj_fp_options.approved_rev_plan_type_flag%TYPE := FND_API.G_MISS_CHAR
394 ,p_projfunc_cost_rate_type
395 IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
396 ,p_projfunc_cost_rate_date_type
397 IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
398 ,p_projfunc_cost_rate_date
399 IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE := FND_API.G_MISS_DATE
400 ,p_projfunc_rev_rate_type
401 IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
402 ,p_projfunc_rev_rate_date_type
403 IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
404 ,p_projfunc_rev_rate_date
405 IN pa_proj_fp_options.projfunc_rev_rate_date%TYPE := FND_API.G_MISS_DATE
406 ,p_project_cost_rate_type
407 IN pa_proj_fp_options.project_cost_rate_type%TYPE := FND_API.G_MISS_CHAR
408 ,p_project_cost_rate_date_type
409 IN pa_proj_fp_options.project_cost_rate_date_type%TYPE := FND_API.G_MISS_CHAR
410 ,p_project_cost_rate_date
411 IN pa_proj_fp_options.project_cost_rate_date%TYPE := FND_API.G_MISS_DATE
412 ,p_project_rev_rate_type
416 ,p_project_rev_rate_date
413 IN pa_proj_fp_options.project_rev_rate_type%TYPE := FND_API.G_MISS_CHAR
414 ,p_project_rev_rate_date_type
415 IN pa_proj_fp_options.project_rev_rate_date_type%TYPE := FND_API.G_MISS_CHAR
417 IN pa_proj_fp_options.project_rev_rate_date%TYPE := FND_API.G_MISS_DATE
418 ,p_margin_derived_from_code
419 IN pa_proj_fp_options.margin_derived_from_code%TYPE := FND_API.G_MISS_CHAR
420 /* ended additions for fin plan */
421 /* Bug 2920954 start of additional parameters for post FP-k one off */
422 ,p_select_cost_res_auto_flag
423 IN pa_proj_fp_options.select_cost_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
424 ,p_cost_res_planning_level
425 IN pa_proj_fp_options.cost_res_planning_level%TYPE := FND_API.G_MISS_CHAR
426 ,p_select_rev_res_auto_flag
427 IN pa_proj_fp_options.select_rev_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
428 ,p_revenue_res_planning_level
429 IN pa_proj_fp_options.revenue_res_planning_level%TYPE := FND_API.G_MISS_CHAR
430 ,p_select_all_res_auto_flag
431 IN pa_proj_fp_options.select_all_res_auto_flag%TYPE := FND_API.G_MISS_CHAR
432 ,p_all_res_planning_level
433 IN pa_proj_fp_options.all_res_planning_level%TYPE := FND_API.G_MISS_CHAR
434 /* Bug 2920954 end of additional parameters for post FP-k one off */
435 ,p_primary_cost_forecast_flag
436 IN PA_PROJ_FP_OPTIONS.primary_cost_forecast_flag%TYPE := FND_API.G_MISS_CHAR
437 ,p_primary_rev_forecast_flag
438 IN PA_PROJ_FP_OPTIONS.primary_rev_forecast_flag%TYPE := FND_API.G_MISS_CHAR
439 ,p_use_planning_rates_flag
440 IN PA_PROJ_FP_OPTIONS.use_planning_rates_flag%TYPE := FND_API.G_MISS_CHAR
441 ,p_rbs_version_id
442 IN PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE := FND_API.G_MISS_NUM
443 ,p_res_class_raw_cost_sch_id
444 IN PA_PROJ_FP_OPTIONS.res_class_raw_cost_sch_id%TYPE := FND_API.G_MISS_NUM
445 ,p_res_class_bill_rate_sch_id
446 IN PA_PROJ_FP_OPTIONS.res_class_bill_rate_sch_id%TYPE := FND_API.G_MISS_NUM
447 ,p_cost_emp_rate_sch_id
448 IN PA_PROJ_FP_OPTIONS.cost_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
449 ,p_cost_job_rate_sch_id
450 IN PA_PROJ_FP_OPTIONS.cost_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
451 ,P_CST_NON_LABR_RES_RATE_SCH_ID
452 IN PA_PROJ_FP_OPTIONS.cost_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
453 ,p_cost_res_class_rate_sch_id
454 IN PA_PROJ_FP_OPTIONS.cost_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
455 ,p_cost_burden_rate_sch_id
456 IN PA_PROJ_FP_OPTIONS.cost_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
457 ,p_cost_current_planning_period
458 IN PA_PROJ_FP_OPTIONS.cost_current_planning_period%TYPE := FND_API.G_MISS_CHAR
459 ,p_cost_period_mask_id
460 IN PA_PROJ_FP_OPTIONS.cost_period_mask_id%TYPE := FND_API.G_MISS_NUM
461 ,p_rev_emp_rate_sch_id
462 IN PA_PROJ_FP_OPTIONS.rev_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
463 ,p_rev_job_rate_sch_id
464 IN PA_PROJ_FP_OPTIONS.rev_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
465 ,P_REV_NON_LABR_RES_RATE_SCH_ID
466 IN PA_PROJ_FP_OPTIONS.rev_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
467 ,p_rev_res_class_rate_sch_id
468 IN PA_PROJ_FP_OPTIONS.rev_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
469 ,p_rev_current_planning_period
470 IN PA_PROJ_FP_OPTIONS.rev_current_planning_period%TYPE := FND_API.G_MISS_CHAR
471 ,p_rev_period_mask_id
472 IN PA_PROJ_FP_OPTIONS.rev_period_mask_id%TYPE := FND_API.G_MISS_NUM
473 /** Bug 3580727 Columns have been dropped
474 ,p_all_emp_rate_sch_id
475 IN PA_PROJ_FP_OPTIONS.all_emp_rate_sch_id%TYPE := FND_API.G_MISS_NUM
476 ,p_all_job_rate_sch_id
477 IN PA_PROJ_FP_OPTIONS.all_job_rate_sch_id%TYPE := FND_API.G_MISS_NUM
478 ,P_ALL_NON_LABR_RES_RATE_SCH_ID
479 IN PA_PROJ_FP_OPTIONS.all_non_labor_res_rate_sch_id%TYPE := FND_API.G_MISS_NUM
480 ,p_all_res_class_rate_sch_id
481 IN PA_PROJ_FP_OPTIONS.all_res_class_rate_sch_id%TYPE := FND_API.G_MISS_NUM
482 ,p_all_burden_rate_sch_id
483 IN PA_PROJ_FP_OPTIONS.all_burden_rate_sch_id%TYPE := FND_API.G_MISS_NUM
484 **/
485 ,p_all_current_planning_period
486 IN PA_PROJ_FP_OPTIONS.all_current_planning_period%TYPE := FND_API.G_MISS_CHAR
487 ,p_all_period_mask_id
488 IN PA_PROJ_FP_OPTIONS.all_period_mask_id%TYPE := FND_API.G_MISS_NUM
489 ,p_gen_cost_src_code
490 IN PA_PROJ_FP_OPTIONS.gen_cost_src_code%TYPE := FND_API.G_MISS_CHAR
491 ,p_gen_cost_etc_src_code
492 IN PA_PROJ_FP_OPTIONS.gen_cost_etc_src_code%TYPE := FND_API.G_MISS_CHAR
493 ,P_GN_COST_INCL_CHANGE_DOC_FLAG
494 IN PA_PROJ_FP_OPTIONS.gen_cost_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
495 ,p_gen_cost_incl_open_comm_flag
496 IN PA_PROJ_FP_OPTIONS.gen_cost_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
497 ,P_GN_COST_RET_MANUAL_LINE_FLAG
498 IN PA_PROJ_FP_OPTIONS.gen_cost_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
499 ,P_GN_CST_INCL_UNSPENT_AMT_FLAG
500 IN PA_PROJ_FP_OPTIONS.gen_cost_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
501 ,p_gen_rev_src_code
502 IN PA_PROJ_FP_OPTIONS.gen_rev_src_code%TYPE := FND_API.G_MISS_CHAR
503 ,p_gen_rev_etc_src_code
504 IN PA_PROJ_FP_OPTIONS.gen_rev_etc_src_code%TYPE := FND_API.G_MISS_CHAR
505 ,p_gen_rev_incl_change_doc_flag
506 IN PA_PROJ_FP_OPTIONS.gen_rev_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
507 ,p_gen_rev_incl_bill_event_flag
508 IN PA_PROJ_FP_OPTIONS.gen_rev_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
509 ,p_gen_rev_ret_manual_line_flag
510 IN PA_PROJ_FP_OPTIONS.gen_rev_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
511 /** Bug 3580727 this column has been dropped
512 ,P_GN_REV_INCL_UNSPENT_AMT_FLAG
513 IN PA_PROJ_FP_OPTIONS.gen_rev_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
514 **/
515 ,p_gen_src_cost_plan_type_id
516 IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_type_id%TYPE := FND_API.G_MISS_NUM
517 ,p_gen_src_cost_plan_version_id
518 IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_version_id%TYPE := FND_API.G_MISS_NUM
519 ,p_gen_src_cost_plan_ver_code
520 IN PA_PROJ_FP_OPTIONS.gen_src_cost_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
521 ,p_gen_src_rev_plan_type_id
522 IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_type_id%TYPE := FND_API.G_MISS_NUM
523 ,p_gen_src_rev_plan_version_id
524 IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_version_id%TYPE := FND_API.G_MISS_NUM
525 ,p_gen_src_rev_plan_ver_code
526 IN PA_PROJ_FP_OPTIONS.gen_src_rev_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
527 ,p_gen_src_all_plan_type_id
528 IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_type_id%TYPE := FND_API.G_MISS_NUM
529 ,p_gen_src_all_plan_version_id
530 IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_version_id%TYPE := FND_API.G_MISS_NUM
531 ,p_gen_src_all_plan_ver_code
532 IN PA_PROJ_FP_OPTIONS.gen_src_all_plan_ver_code%TYPE := FND_API.G_MISS_CHAR
533 ,p_gen_all_src_code
534 IN PA_PROJ_FP_OPTIONS.gen_all_src_code%TYPE := FND_API.G_MISS_CHAR
535 ,p_gen_all_etc_src_code
536 IN PA_PROJ_FP_OPTIONS.gen_all_etc_src_code%TYPE := FND_API.G_MISS_CHAR
537 ,p_gen_all_incl_change_doc_flag
538 IN PA_PROJ_FP_OPTIONS.gen_all_incl_change_doc_flag%TYPE := FND_API.G_MISS_CHAR
539 ,p_gen_all_incl_open_comm_flag
540 IN PA_PROJ_FP_OPTIONS.gen_all_incl_open_comm_flag%TYPE := FND_API.G_MISS_CHAR
541 ,p_gen_all_ret_manual_line_flag
542 IN PA_PROJ_FP_OPTIONS.gen_all_ret_manual_line_flag%TYPE := FND_API.G_MISS_CHAR
543 ,p_gen_all_incl_bill_event_flag
544 IN PA_PROJ_FP_OPTIONS.gen_all_incl_bill_event_flag%TYPE := FND_API.G_MISS_CHAR
545 ,P_GN_ALL_INCL_UNSPENT_AMT_FLAG
546 IN PA_PROJ_FP_OPTIONS.gen_all_incl_unspent_amt_flag%TYPE := FND_API.G_MISS_CHAR
547 ,P_GN_CST_ACTUAL_AMTS_THRU_CODE
548 IN PA_PROJ_FP_OPTIONS.gen_cost_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
549 ,P_GN_REV_ACTUAL_AMTS_THRU_CODE
550 IN PA_PROJ_FP_OPTIONS.gen_rev_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
551 ,P_GN_ALL_ACTUAL_AMTS_THRU_CODE
552 IN PA_PROJ_FP_OPTIONS.gen_all_actual_amts_thru_code%TYPE := FND_API.G_MISS_CHAR
553 ,p_track_workplan_costs_flag
554 IN PA_PROJ_FP_OPTIONS.track_workplan_costs_flag%TYPE := FND_API.G_MISS_CHAR
555 -- bug 3519062 start of workplan gen source related columns
556 ,p_gen_src_cost_wp_version_id
557 IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_version_id%TYPE := FND_API.G_MISS_NUM
558 ,p_gen_src_cost_wp_ver_code
559 IN PA_PROJ_FP_OPTIONS.gen_src_cost_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
560 ,p_gen_src_rev_wp_version_id
561 IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_version_id%TYPE := FND_API.G_MISS_NUM
562 ,p_gen_src_rev_wp_ver_code
563 IN PA_PROJ_FP_OPTIONS.gen_src_rev_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
564 ,p_gen_src_all_wp_version_id
565 IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_version_id%TYPE := FND_API.G_MISS_NUM
566 ,p_gen_src_all_wp_ver_code
567 IN PA_PROJ_FP_OPTIONS.gen_src_all_wp_ver_code%TYPE := FND_API.G_MISS_CHAR
568 --Added for webAdi changes for the amount types to be displayed
569 ,p_cost_layout_code
570 IN PA_PROJ_FP_OPTIONS.cost_layout_code%TYPE := FND_API.G_MISS_CHAR
571 ,p_revenue_layout_code
572 IN PA_PROJ_FP_OPTIONS.revenue_layout_code%TYPE := FND_API.G_MISS_CHAR
573 ,p_all_layout_code
574 IN PA_PROJ_FP_OPTIONS.all_layout_code%TYPE := FND_API.G_MISS_CHAR
575 -- bug 3519062 end of workplan gen source related columns
576 ,p_revenue_derivation_method
577 IN PA_PROJ_FP_OPTIONS.revenue_derivation_method%TYPE := FND_API.G_MISS_CHAR --Bug 5462471
578 ,p_row_id
579 IN ROWID := NULL
580 ,x_return_status OUT NOCOPY VARCHAR2) ; --File.Sql.39 bug 4440895
581
582
583
584 PROCEDURE Lock_Row
585 ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
586 := FND_API.G_MISS_NUM
587 ,p_record_version_number IN NUMBER
588 := NULL
589 ,p_row_id IN ROWID
590 := NULL
591 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
592
593 PROCEDURE Delete_Row
594 ( p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
595 := FND_API.G_MISS_NUM
596 ,p_record_version_number IN NUMBER
597 := NULL
598 ,p_row_id IN ROWID
599 := NULL
600 ,x_return_status OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
601 End pa_proj_fp_options_pkg;