eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_VIEW_PLANS_TXN_PUB dependencies on PA_BUDGET_VERSIONS

Line 93: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

89: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE)
90: return VARCHAR2
91: is
92: l_return_value VARCHAR2(1);
93: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
94: /* bug 3106741
95: pa_fp_txn_curr table doesn't have any index on plan_version_id.
96: But index is available on proj_fp_options_id.
97: So, pa_proj_fp_options_id is used to fetch options_id

Line 205: (p_project_id IN pa_budget_versions.project_id%TYPE,

201: -- populate G_DISPLAY_CURRENCY_TYPE
202: -- 07/30/03: changed logic for populating x_planned_resources_flag and x_grouping_type
203: -- BUG 2813661
204: procedure nonhgrid_view_initialize
205: (p_project_id IN pa_budget_versions.project_id%TYPE,
206: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
207: p_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
208: p_user_id IN NUMBER,
209: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,

Line 206: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,

202: -- 07/30/03: changed logic for populating x_planned_resources_flag and x_grouping_type
203: -- BUG 2813661
204: procedure nonhgrid_view_initialize
205: (p_project_id IN pa_budget_versions.project_id%TYPE,
206: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
207: p_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
208: p_user_id IN NUMBER,
209: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,
210: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895

Line 207: p_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,

203: -- BUG 2813661
204: procedure nonhgrid_view_initialize
205: (p_project_id IN pa_budget_versions.project_id%TYPE,
206: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
207: p_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
208: p_user_id IN NUMBER,
209: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,
210: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
211: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895

Line 209: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,

205: (p_project_id IN pa_budget_versions.project_id%TYPE,
206: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
207: p_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
208: p_user_id IN NUMBER,
209: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,
210: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
211: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
212: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
213: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 210: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895

206: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
207: p_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
208: p_user_id IN NUMBER,
209: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,
210: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
211: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
212: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
213: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
214: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

Line 211: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895

207: p_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
208: p_user_id IN NUMBER,
209: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,
210: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
211: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
212: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
213: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
214: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
215: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

Line 212: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

208: p_user_id IN NUMBER,
209: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,
210: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
211: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
212: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
213: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
214: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
215: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
216: -- x_cost_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,

Line 213: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

209: -- x_budget_status_code OUT pa_budget_versions.budget_status_code%TYPE,
210: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
211: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
212: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
213: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
214: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
215: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
216: -- x_cost_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
217: -- x_rev_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,

Line 214: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

210: x_cost_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
211: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
212: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
213: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
214: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
215: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
216: -- x_cost_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
217: -- x_rev_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
218: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 215: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

211: x_rev_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
212: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
213: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
214: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
215: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
216: -- x_cost_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
217: -- x_rev_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
218: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
219: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895

Line 216: -- x_cost_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,

212: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
213: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
214: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
215: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
216: -- x_cost_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
217: -- x_rev_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
218: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
219: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
220: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895

Line 217: -- x_rev_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,

213: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
214: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
215: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
216: -- x_cost_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
217: -- x_rev_locked_id OUT pa_budget_versions.locked_by_person_id%TYPE,
218: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
219: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
220: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895
221: x_planning_level OUT NOCOPY VARCHAR2, -- valid values: 'P', 'T', 'L', 'M' --File.Sql.39 bug 4440895

Line 226: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895

222: x_multicurrency_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
223: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
224: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
225: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
226: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
227: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
228: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
229: x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
230: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 227: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895

223: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
224: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
225: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
226: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
227: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
228: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
229: x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
230: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
231: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895

Line 247: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

243: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
244: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
245: l_working_or_baselined VARCHAR2(30);
246: l_cost_or_revenue VARCHAR2(30);
247: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
248: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
249: l_c_budget_status_code pa_budget_versions.budget_status_code%TYPE;
250: l_r_budget_status_code pa_budget_versions.budget_status_code%TYPE;
251: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 248: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;

244: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
245: l_working_or_baselined VARCHAR2(30);
246: l_cost_or_revenue VARCHAR2(30);
247: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
248: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
249: l_c_budget_status_code pa_budget_versions.budget_status_code%TYPE;
250: l_r_budget_status_code pa_budget_versions.budget_status_code%TYPE;
251: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
252: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

Line 249: l_c_budget_status_code pa_budget_versions.budget_status_code%TYPE;

245: l_working_or_baselined VARCHAR2(30);
246: l_cost_or_revenue VARCHAR2(30);
247: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
248: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
249: l_c_budget_status_code pa_budget_versions.budget_status_code%TYPE;
250: l_r_budget_status_code pa_budget_versions.budget_status_code%TYPE;
251: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
252: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
253: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 250: l_r_budget_status_code pa_budget_versions.budget_status_code%TYPE;

246: l_cost_or_revenue VARCHAR2(30);
247: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
248: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
249: l_c_budget_status_code pa_budget_versions.budget_status_code%TYPE;
250: l_r_budget_status_code pa_budget_versions.budget_status_code%TYPE;
251: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
252: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;
253: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
254: l_margin_derived_code pa_proj_fp_options.margin_derived_from_code%TYPE;

Line 259: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

255: l_grouping_type VARCHAR2(30);
256: l_compl_grouping_type VARCHAR2(30);
257: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
258: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
259: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
260: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
261: l_rv_number pa_budget_versions.record_version_number%TYPE;
262: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
263: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

Line 260: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;

256: l_compl_grouping_type VARCHAR2(30);
257: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
258: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
259: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
260: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
261: l_rv_number pa_budget_versions.record_version_number%TYPE;
262: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
263: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
264: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

Line 261: l_rv_number pa_budget_versions.record_version_number%TYPE;

257: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
258: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
259: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
260: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
261: l_rv_number pa_budget_versions.record_version_number%TYPE;
262: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
263: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
264: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
265: l_debug_mode VARCHAR2(30);

Line 262: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;

258: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
259: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
260: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
261: l_rv_number pa_budget_versions.record_version_number%TYPE;
262: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
263: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
264: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
265: l_debug_mode VARCHAR2(30);
266: l_is_cost_locked_by_user VARCHAR2(1);

Line 278: l_version_id pa_budget_versions.budget_version_id%TYPE;

274: -- local error handling variables
275: l_return_status VARCHAR2(1);
276: l_msg_count NUMBER;
277: l_msg_data VARCHAR2(2000);
278: l_version_id pa_budget_versions.budget_version_id%TYPE;
279: l_module_name VARCHAR2(100);
280: l_msg_index_out NUMBER;
281:
282: BEGIN

Line 326: FROM pa_budget_versions bv

322: SELECT nvl(bv.approved_cost_plan_type_flag, 'N'),
323: nvl(bv.approved_rev_plan_type_flag, 'N')
324: INTO l_ac_flag,
325: l_ar_flag
326: FROM pa_budget_versions bv
327: WHERE bv.budget_version_id = l_version_id;
328:
329: -- >>>>> BUG FIX 2602849: need to check only AR flag <<<<<
330: -- >>>> BUG FIX 2650878: project or projfunc, depending on AR flag <<<<

Line 418: FROM pa_budget_versions bv,

414: l_resource_list_id,
415: l_rv_number,
416: l_uncategorized_flag,
417: l_c_budget_status_code
418: FROM pa_budget_versions bv,
419: pa_resource_lists_all_bg rl
420: WHERE bv.budget_version_id = p_cost_version_id and
421: bv.resource_list_id = rl.resource_list_id;
422:

Line 461: FROM pa_budget_versions bv,

457: l_compl_resource_list_id,
458: l_compl_rv_number,
459: l_compl_uncategorized_flag,
460: l_r_budget_status_code
461: FROM pa_budget_versions bv,
462: pa_resource_lists_all_bg rl
463: WHERE bv.budget_version_id = p_rev_version_id and
464: bv.resource_list_id = rl.resource_list_id;
465:

Line 860: (p_project_id IN pa_budget_versions.project_id%TYPE,

856: -- 12/30/02: x_project_currency can be AGREEMENT CURRENCY if ci_id is not null
857: -- 07/30/03: changed logic for populating x_planned_resources_flag and x_grouping_type
858: -- BUG 2813661
859: procedure nonhgrid_edit_initialize
860: (p_project_id IN pa_budget_versions.project_id%TYPE,
861: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
862: -- p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,
863: -- p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
864: -- p_working_or_baselined IN VARCHAR2,

Line 861: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

857: -- 07/30/03: changed logic for populating x_planned_resources_flag and x_grouping_type
858: -- BUG 2813661
859: procedure nonhgrid_edit_initialize
860: (p_project_id IN pa_budget_versions.project_id%TYPE,
861: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
862: -- p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,
863: -- p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
864: -- p_working_or_baselined IN VARCHAR2,
865: -- p_cost_or_revenue IN VARCHAR2,

Line 866: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895

862: -- p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE,
863: -- p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
864: -- p_working_or_baselined IN VARCHAR2,
865: -- p_cost_or_revenue IN VARCHAR2,
866: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
867: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895
868: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
869: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
870: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

Line 867: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895

863: -- p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
864: -- p_working_or_baselined IN VARCHAR2,
865: -- p_cost_or_revenue IN VARCHAR2,
866: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
867: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895
868: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
869: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
870: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
871: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

Line 868: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

864: -- p_working_or_baselined IN VARCHAR2,
865: -- p_cost_or_revenue IN VARCHAR2,
866: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
867: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895
868: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
869: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
870: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
871: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
872: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 869: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

865: -- p_cost_or_revenue IN VARCHAR2,
866: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
867: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895
868: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
869: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
870: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
871: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
872: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
873: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895

Line 870: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

866: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
867: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895
868: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
869: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
870: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
871: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
872: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
873: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
874: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895

Line 871: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

867: x_current_working_flag OUT NOCOPY pa_budget_versions.current_working_flag%TYPE, --File.Sql.39 bug 4440895
868: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
869: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
870: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
871: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
872: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
873: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
874: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895
875: x_planning_level OUT NOCOPY VARCHAR2, -- valid values: 'P', 'T', 'L', 'M' --File.Sql.39 bug 4440895

Line 879: x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895

875: x_planning_level OUT NOCOPY VARCHAR2, -- valid values: 'P', 'T', 'L', 'M' --File.Sql.39 bug 4440895
876: x_multicurrency_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
877: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
878: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
879: x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
880: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
881: x_plan_version_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895
882: x_fin_plan_type_id OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE, --File.Sql.39 bug 4440895
883: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 898: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

894: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
895: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
896: l_working_or_baselined VARCHAR2(30);
897: l_cost_or_revenue VARCHAR2(30);
898: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
899: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
900: l_ci_id pa_budget_versions.ci_id%TYPE;
901: l_agreement_id pa_budget_versions.agreement_id%TYPE;
902: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;

Line 899: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;

895: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
896: l_working_or_baselined VARCHAR2(30);
897: l_cost_or_revenue VARCHAR2(30);
898: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
899: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
900: l_ci_id pa_budget_versions.ci_id%TYPE;
901: l_agreement_id pa_budget_versions.agreement_id%TYPE;
902: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
903:

Line 900: l_ci_id pa_budget_versions.ci_id%TYPE;

896: l_working_or_baselined VARCHAR2(30);
897: l_cost_or_revenue VARCHAR2(30);
898: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
899: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
900: l_ci_id pa_budget_versions.ci_id%TYPE;
901: l_agreement_id pa_budget_versions.agreement_id%TYPE;
902: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
903:
904: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

Line 901: l_agreement_id pa_budget_versions.agreement_id%TYPE;

897: l_cost_or_revenue VARCHAR2(30);
898: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
899: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
900: l_ci_id pa_budget_versions.ci_id%TYPE;
901: l_agreement_id pa_budget_versions.agreement_id%TYPE;
902: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
903:
904: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
905: l_report_labor_hrs_from_code pa_proj_fp_options.report_labor_hrs_from_code%TYPE;

Line 912: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

908: l_grouping_type VARCHAR2(30);
909: l_compl_grouping_type VARCHAR2(30);
910: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
911: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
912: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
913: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
914: l_version_type pa_budget_versions.version_type%TYPE;
915: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
916: l_resource_level VARCHAR2(1); -- bug 2813661

Line 913: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;

909: l_compl_grouping_type VARCHAR2(30);
910: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
911: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
912: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
913: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
914: l_version_type pa_budget_versions.version_type%TYPE;
915: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
916: l_resource_level VARCHAR2(1); -- bug 2813661
917:

Line 914: l_version_type pa_budget_versions.version_type%TYPE;

910: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
911: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
912: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
913: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
914: l_version_type pa_budget_versions.version_type%TYPE;
915: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
916: l_resource_level VARCHAR2(1); -- bug 2813661
917:
918: -- local debugging variables

Line 960: from pa_budget_versions bv,

956: x_record_version_number,
957: l_ac_flag,
958: l_ar_flag,
959: l_uncategorized_flag
960: from pa_budget_versions bv,
961: pa_resource_lists_all_bg rl
962: where bv.budget_version_id = p_budget_version_id and
963: bv.resource_list_id = rl.resource_list_id;
964: pa_fp_view_plans_txn_pub.G_SINGLE_VERSION_ID := p_budget_version_id;

Line 980: from pa_budget_versions

976: select ci_id,
977: agreement_id
978: into l_ci_id,
979: l_agreement_id
980: from pa_budget_versions
981: where budget_version_id = p_budget_version_id;
982: if l_ci_id is not null and l_agreement_id is not null then
983: select nvl (agreement_currency_code, 'ANY')
984: into l_agreement_currency_code

Line 1111: from pa_budget_versions

1107: -- this is a cost/revenue version that's part of a cost-revenue pairing
1108: -- we need to find out which one it is
1109: select version_type
1110: into l_version_type
1111: from pa_budget_versions
1112: where budget_version_id = p_budget_version_id;
1113: if l_version_type = 'COST' then
1114: -- COST VERSION: treat as if COST_ONLY
1115: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := p_budget_version_id;

Line 1219: p_project_id IN pa_budget_versions.project_id%TYPE,

1215: -- the project columns or projfunc columns
1216: -- 12/24/02: Bug 2710844-The view plan should show resource assignments for which budget lines exists
1217: PROCEDURE view_plans_txn_populate_tmp
1218: (p_page_mode IN VARCHAR2, /* V - View mode ; E - Edit Mode */
1219: p_project_id IN pa_budget_versions.project_id%TYPE,
1220: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
1221: p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE,
1222: p_both_version_id IN pa_budget_versions.budget_version_id%TYPE,
1223: p_project_currency IN pa_projects_all.project_currency_code%TYPE,

Line 1220: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,

1216: -- 12/24/02: Bug 2710844-The view plan should show resource assignments for which budget lines exists
1217: PROCEDURE view_plans_txn_populate_tmp
1218: (p_page_mode IN VARCHAR2, /* V - View mode ; E - Edit Mode */
1219: p_project_id IN pa_budget_versions.project_id%TYPE,
1220: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
1221: p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE,
1222: p_both_version_id IN pa_budget_versions.budget_version_id%TYPE,
1223: p_project_currency IN pa_projects_all.project_currency_code%TYPE,
1224: p_get_display_from IN VARCHAR2, -- 'COST', 'REVENUE', 'BOTH', 'ANY'

Line 1221: p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE,

1217: PROCEDURE view_plans_txn_populate_tmp
1218: (p_page_mode IN VARCHAR2, /* V - View mode ; E - Edit Mode */
1219: p_project_id IN pa_budget_versions.project_id%TYPE,
1220: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
1221: p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE,
1222: p_both_version_id IN pa_budget_versions.budget_version_id%TYPE,
1223: p_project_currency IN pa_projects_all.project_currency_code%TYPE,
1224: p_get_display_from IN VARCHAR2, -- 'COST', 'REVENUE', 'BOTH', 'ANY'
1225: p_filter_task_id IN pa_resource_assignments.task_id%TYPE,

Line 1222: p_both_version_id IN pa_budget_versions.budget_version_id%TYPE,

1218: (p_page_mode IN VARCHAR2, /* V - View mode ; E - Edit Mode */
1219: p_project_id IN pa_budget_versions.project_id%TYPE,
1220: p_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
1221: p_revenue_version_id IN pa_budget_versions.budget_version_id%TYPE,
1222: p_both_version_id IN pa_budget_versions.budget_version_id%TYPE,
1223: p_project_currency IN pa_projects_all.project_currency_code%TYPE,
1224: p_get_display_from IN VARCHAR2, -- 'COST', 'REVENUE', 'BOTH', 'ANY'
1225: p_filter_task_id IN pa_resource_assignments.task_id%TYPE,
1226: p_filter_resource_id IN pa_resource_list_members.resource_id%TYPE,

Line 2365: (p_project_id IN pa_budget_versions.project_id%TYPE,

2361: -- 05/30/03: x_project_currency can be AGREEMENT CURRENCY if ci_id is not null
2362: -- 07/30/03: changed logic for populating x_planned_resources_flag and x_grouping_type
2363: -- BUG 2813661
2364: procedure nonhgrid_view_initialize_ci
2365: (p_project_id IN pa_budget_versions.project_id%TYPE,
2366: p_ci_id IN pa_budget_versions.ci_id%TYPE,
2367: p_user_id IN NUMBER,
2368: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
2369: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 2366: p_ci_id IN pa_budget_versions.ci_id%TYPE,

2362: -- 07/30/03: changed logic for populating x_planned_resources_flag and x_grouping_type
2363: -- BUG 2813661
2364: procedure nonhgrid_view_initialize_ci
2365: (p_project_id IN pa_budget_versions.project_id%TYPE,
2366: p_ci_id IN pa_budget_versions.ci_id%TYPE,
2367: p_user_id IN NUMBER,
2368: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
2369: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
2370: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

Line 2368: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895

2364: procedure nonhgrid_view_initialize_ci
2365: (p_project_id IN pa_budget_versions.project_id%TYPE,
2366: p_ci_id IN pa_budget_versions.ci_id%TYPE,
2367: p_user_id IN NUMBER,
2368: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
2369: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
2370: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
2371: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
2372: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

Line 2369: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

2365: (p_project_id IN pa_budget_versions.project_id%TYPE,
2366: p_ci_id IN pa_budget_versions.ci_id%TYPE,
2367: p_user_id IN NUMBER,
2368: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
2369: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
2370: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
2371: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
2372: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
2373: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2370: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

2366: p_ci_id IN pa_budget_versions.ci_id%TYPE,
2367: p_user_id IN NUMBER,
2368: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
2369: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
2370: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
2371: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
2372: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
2373: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2374: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895

Line 2371: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

2367: p_user_id IN NUMBER,
2368: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
2369: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
2370: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
2371: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
2372: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
2373: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2374: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
2375: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895

Line 2372: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895

2368: x_budget_status_code OUT NOCOPY pa_budget_versions.budget_status_code%TYPE, --File.Sql.39 bug 4440895
2369: x_cost_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
2370: x_rev_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
2371: x_cost_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
2372: x_rev_rl_id OUT NOCOPY pa_budget_versions.resource_list_id%TYPE, --File.Sql.39 bug 4440895
2373: x_display_from OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2374: x_planned_resources_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
2375: x_grouping_type OUT NOCOPY VARCHAR2, -- valid values: 'GROUPED', 'NONGROUPED', 'MIXED' --File.Sql.39 bug 4440895
2376: x_planning_level OUT NOCOPY VARCHAR2, -- valid values: 'P', 'T', 'L', 'M' --File.Sql.39 bug 4440895

Line 2381: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895

2377: x_multicurrency_flag OUT NOCOPY VARCHAR2, -- valid values: 'Y', 'N' --File.Sql.39 bug 4440895
2378: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
2379: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
2380: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
2381: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
2382: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
2383: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2384: x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2385: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 2382: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895

2378: x_plan_type_name OUT NOCOPY pa_fin_plan_types_tl.name%TYPE, --File.Sql.39 bug 4440895
2379: x_project_currency OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
2380: x_labor_hrs_from_code OUT NOCOPY pa_proj_fp_options.report_labor_hrs_from_code%TYPE, --File.Sql.39 bug 4440895
2381: x_cost_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
2382: x_rev_rv_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE, --File.Sql.39 bug 4440895
2383: x_cost_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2384: x_rev_locked_name OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2385: x_ar_ac_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2386: x_plan_type_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE, --File.Sql.39 bug 4440895

Line 2402: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

2398: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2399: l_proj_fp_options_id2 pa_proj_fp_options.proj_fp_options_id%TYPE;
2400: l_working_or_baselined VARCHAR2(30);
2401: l_cost_or_revenue VARCHAR2(30);
2402: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2403: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
2404:
2405: cursor ci_csr is
2406: select bv.budget_version_id,

Line 2403: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;

2399: l_proj_fp_options_id2 pa_proj_fp_options.proj_fp_options_id%TYPE;
2400: l_working_or_baselined VARCHAR2(30);
2401: l_cost_or_revenue VARCHAR2(30);
2402: l_ar_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2403: l_ac_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
2404:
2405: cursor ci_csr is
2406: select bv.budget_version_id,
2407: po.proj_fp_options_id,

Line 2409: from pa_budget_versions bv,

2405: cursor ci_csr is
2406: select bv.budget_version_id,
2407: po.proj_fp_options_id,
2408: NVL(po.plan_in_multi_curr_flag, 'N') as plan_in_multi_curr_flag
2409: from pa_budget_versions bv,
2410: pa_proj_fp_options po
2411: where bv.project_id = p_project_id and
2412: bv.ci_id = p_ci_id and
2413: bv.budget_version_id = po.fin_plan_version_id and

Line 2426: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

2422: l_grouping_type VARCHAR2(30);
2423: l_compl_grouping_type VARCHAR2(30);
2424: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2425: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2426: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2427: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2428: l_rv_number pa_budget_versions.record_version_number%TYPE;
2429: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
2430: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

Line 2427: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;

2423: l_compl_grouping_type VARCHAR2(30);
2424: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2425: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2426: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2427: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2428: l_rv_number pa_budget_versions.record_version_number%TYPE;
2429: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
2430: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2431: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;

Line 2428: l_rv_number pa_budget_versions.record_version_number%TYPE;

2424: l_cost_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2425: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2426: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2427: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2428: l_rv_number pa_budget_versions.record_version_number%TYPE;
2429: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
2430: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2431: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2432: l_agreement_id pa_agreements_all.agreement_id%TYPE; -- bug 2984679

Line 2429: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;

2425: l_rev_planning_level pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2426: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2427: l_compl_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2428: l_rv_number pa_budget_versions.record_version_number%TYPE;
2429: l_compl_rv_number pa_budget_versions.record_version_number%TYPE;
2430: l_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2431: l_compl_uncategorized_flag pa_resource_lists.uncategorized_flag%TYPE;
2432: l_agreement_id pa_agreements_all.agreement_id%TYPE; -- bug 2984679
2433: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE; -- bug 2984679

Line 2444: l_ci_budget_version_id pa_budget_versions.budget_version_id%TYPE;

2440: l_cost_resource_level VARCHAR2(1); -- bug 2813661
2441: l_revenue_resource_level VARCHAR2(1); -- bug 2813661
2442:
2443: l_ci_row_index NUMBER := 0;
2444: l_ci_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2445:
2446: -- local error handling variables
2447: l_return_status VARCHAR2(1);
2448: l_msg_count NUMBER;

Line 2515: from pa_budget_versions bv,

2511: l_ac_flag,
2512: l_ar_flag,
2513: l_uncategorized_flag,
2514: l_agreement_id
2515: from pa_budget_versions bv,
2516: pa_resource_lists_all_bg rl
2517: where bv.budget_version_id = ci_rec.budget_version_id and
2518: bv.resource_list_id = rl.resource_list_id;
2519:

Line 2680: from pa_budget_versions bv,

2676: into l_compl_grouping_type,
2677: l_compl_resource_list_id,
2678: l_compl_rv_number,
2679: l_compl_uncategorized_flag
2680: from pa_budget_versions bv,
2681: pa_resource_lists_all_bg rl
2682: where bv.budget_version_id = ci_rec.budget_version_id and
2683: bv.resource_list_id = rl.resource_list_id;
2684: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;

Line 2738: from pa_budget_versions bv,

2734: into l_compl_grouping_type,
2735: l_compl_resource_list_id,
2736: l_compl_rv_number,
2737: l_compl_uncategorized_flag
2738: from pa_budget_versions bv,
2739: pa_resource_lists_all_bg rl
2740: where bv.budget_version_id = ci_rec.budget_version_id and
2741: bv.resource_list_id = rl.resource_list_id;
2742: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;

Line 2805: from pa_budget_versions bv,

2801: into l_compl_grouping_type,
2802: l_compl_resource_list_id,
2803: l_compl_rv_number,
2804: l_compl_uncategorized_flag
2805: from pa_budget_versions bv,
2806: pa_resource_lists_all_bg rl
2807: where bv.budget_version_id = ci_rec.budget_version_id and
2808: bv.resource_list_id = rl.resource_list_id;
2809: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := ci_rec.budget_version_id;

Line 2871: from pa_budget_versions bv,

2867: into l_compl_grouping_type,
2868: l_compl_resource_list_id,
2869: l_compl_rv_number,
2870: l_compl_uncategorized_flag
2871: from pa_budget_versions bv,
2872: pa_resource_lists_all_bg rl
2873: where bv.budget_version_id = ci_rec.budget_version_id and
2874: bv.resource_list_id = rl.resource_list_id;
2875: pa_fp_view_plans_txn_pub.G_COST_VERSION_ID := l_ci_budget_version_id;

Line 3205: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

3201: This is the main API which will do the necessary actions for using the Client Extensions
3202: for calculating the raw_cost, burdened_cost and revenue for a complete version.
3203: =========================================================================================*/
3204: PROCEDURE CALCULATE_AMOUNTS_FOR_VERSION
3205: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
3206: ,p_calling_context IN VARCHAR2
3207: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3208: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3209: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895