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_FIN_PLAN_PVT dependencies on PA_BUDGET_VERSIONS

Line 24: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

20: -- This procedure assumes that a person can only unlock the versions he/she has locked.
21: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
22:
23: PROCEDURE lock_unlock_version
24: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
25: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
26: p_action IN VARCHAR2, -- 'L' for lock, 'U' for unlock
27: p_user_id IN NUMBER,
28: p_person_id IN NUMBER, -- can be null

Line 25: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

21: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
22:
23: PROCEDURE lock_unlock_version
24: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
25: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
26: p_action IN VARCHAR2, -- 'L' for lock, 'U' for unlock
27: p_user_id IN NUMBER,
28: p_person_id IN NUMBER, -- can be null
29: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 36: from pa_budget_versions

32: p_unlock_locked_ver_flag IN VARCHAR2) IS
33:
34: cursor bv_csr is
35: select locked_by_person_id
36: from pa_budget_versions
37: where budget_version_id = p_budget_version_id;
38: bv_rec bv_csr%ROWTYPE;
39:
40: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE; -- for lock/unlock toggle

Line 40: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE; -- for lock/unlock toggle

36: from pa_budget_versions
37: where budget_version_id = p_budget_version_id;
38: bv_rec bv_csr%ROWTYPE;
39:
40: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE; -- for lock/unlock toggle
41: l_person_id NUMBER(15);
42: l_resource_id NUMBER(15);
43: l_resource_name per_all_people_f.full_name%TYPE; -- VARCHAR2(80); for bug # 2933777
44:

Line 171: update pa_budget_versions

167: if l_msg_count = l_initial_msg_count then
168: SAVEPOINT PA_FP_LOCK_UNLOCK;
169: -- LOCK the version
170: if p_action = 'L' then
171: update pa_budget_versions
172: set locked_by_person_id = l_person_id,
173: record_version_number = p_record_version_number + 1,
174: last_update_date=SYSDATE,
175: last_updated_by=FND_GLOBAL.user_id,

Line 180: update pa_budget_versions

176: last_update_login=FND_GLOBAL.login_id
177: where budget_version_id = p_budget_version_id;
178: -- UNLOCK the version
179: elsif p_action = 'U' then
180: update pa_budget_versions
181: set locked_by_person_id = null,
182: record_version_number = p_record_version_number + 1,
183: last_update_date=SYSDATE,
184: last_updated_by=FND_GLOBAL.user_id,

Line 191: from pa_budget_versions

187: -- if p_action neither 'L' nor 'U', then we assume it's a lock/unlock toggle
188: else
189: select nvl(locked_by_person_id, -1)
190: into l_locked_by_person_id
191: from pa_budget_versions
192: where budget_version_id = p_budget_version_id;
193: -- it was unlocked before: UNLOCK --> LOCK
194: if l_locked_by_person_id = -1 then
195: update pa_budget_versions

Line 195: update pa_budget_versions

191: from pa_budget_versions
192: where budget_version_id = p_budget_version_id;
193: -- it was unlocked before: UNLOCK --> LOCK
194: if l_locked_by_person_id = -1 then
195: update pa_budget_versions
196: set locked_by_person_id = l_person_id,
197: record_version_number = p_record_version_number + 1,
198: last_update_date=SYSDATE,
199: last_updated_by=FND_GLOBAL.user_id,

Line 204: update pa_budget_versions

200: last_update_login=FND_GLOBAL.login_id
201: where budget_version_id = p_budget_version_id;
202: -- it was locked before: LOCK --> UNLOCK
203: else
204: update pa_budget_versions
205: set locked_by_person_id = null,
206: record_version_number = p_record_version_number + 1,
207: last_update_date=SYSDATE,
208: last_updated_by=FND_GLOBAL.user_id,

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

253: -- pa_resource_list_uses.
254:
255:
256: PROCEDURE Baseline_FinPlan
257: (p_project_id IN pa_budget_versions.project_id%TYPE,
258: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
259: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
260: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
261: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

Line 258: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

254:
255:
256: PROCEDURE Baseline_FinPlan
257: (p_project_id IN pa_budget_versions.project_id%TYPE,
258: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
259: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
260: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
261: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
262: p_verify_budget_rules IN VARCHAR2,

Line 259: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

255:
256: PROCEDURE Baseline_FinPlan
257: (p_project_id IN pa_budget_versions.project_id%TYPE,
258: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
259: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
260: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
261: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
262: p_verify_budget_rules IN VARCHAR2,
263: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 260: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

256: PROCEDURE Baseline_FinPlan
257: (p_project_id IN pa_budget_versions.project_id%TYPE,
258: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
259: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
260: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
261: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
262: p_verify_budget_rules IN VARCHAR2,
263: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
264: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 261: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

257: (p_project_id IN pa_budget_versions.project_id%TYPE,
258: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
259: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
260: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
261: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
262: p_verify_budget_rules IN VARCHAR2,
263: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
264: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
265: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 285: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;

281: x_err_stage VARCHAR2(2000);
282: x_err_stack VARCHAR2(2000);
283:
284: -- local variables
285: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
286: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
287: l_version_type pa_budget_versions.version_type%TYPE;
288: l_ac_flag VARCHAR2(1);
289: l_ar_flag VARCHAR2(1);

Line 287: l_version_type pa_budget_versions.version_type%TYPE;

283:
284: -- local variables
285: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
286: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
287: l_version_type pa_budget_versions.version_type%TYPE;
288: l_ac_flag VARCHAR2(1);
289: l_ar_flag VARCHAR2(1);
290: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
291: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;

Line 290: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

286: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
287: l_version_type pa_budget_versions.version_type%TYPE;
288: l_ac_flag VARCHAR2(1);
289: l_ar_flag VARCHAR2(1);
290: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
291: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
292: l_fin_plan_level_code VARCHAR2(30);
293: l_fin_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
294: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

Line 297: l_pm_product_code pa_budget_versions.pm_product_code%TYPE;

293: l_fin_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
294: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
295: l_budget_entry_method_code pa_budget_entry_methods.budget_entry_method_code%TYPE;
296: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
297: l_pm_product_code pa_budget_versions.pm_product_code%TYPE;
298: l_workflow_is_used VARCHAR2(1); -- flag to determine if workflow is used
299: l_warnings_only_flag VARCHAR2(1);
300: l_funding_level varchar2(2) default NULL;
301: l_mark_as_original varchar2(30) default 'N';

Line 302: l_created_by pa_budget_versions.created_by%TYPE;

298: l_workflow_is_used VARCHAR2(1); -- flag to determine if workflow is used
299: l_warnings_only_flag VARCHAR2(1);
300: l_funding_level varchar2(2) default NULL;
301: l_mark_as_original varchar2(30) default 'N';
302: l_created_by pa_budget_versions.created_by%TYPE;
303: x_resource_list_assgmt_id NUMBER;
304: v_emp_id NUMBER; -- employee id
305: v_project_start_date date;
306: v_project_completion_date date;

Line 309: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;

305: v_project_start_date date;
306: v_project_completion_date date;
307: --The following varible is added to make program consistent with the
308: --changed copy_version procedure prototype
309: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
310: l_fc_version_id1 PA_BUDGET_VERSIONS.budget_version_id%TYPE;
311: l_fc_version_id2 PA_BUDGET_VERSIONS.budget_version_id%TYPE;
312: l_ci_id_tbl pa_plsql_datatypes.idTabTyp;
313: l_fc_version_type PA_BUDGET_VERSIONS.version_type%TYPE;

Line 310: l_fc_version_id1 PA_BUDGET_VERSIONS.budget_version_id%TYPE;

306: v_project_completion_date date;
307: --The following varible is added to make program consistent with the
308: --changed copy_version procedure prototype
309: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
310: l_fc_version_id1 PA_BUDGET_VERSIONS.budget_version_id%TYPE;
311: l_fc_version_id2 PA_BUDGET_VERSIONS.budget_version_id%TYPE;
312: l_ci_id_tbl pa_plsql_datatypes.idTabTyp;
313: l_fc_version_type PA_BUDGET_VERSIONS.version_type%TYPE;
314: l_version_name PA_BUDGET_VERSIONS.version_name%TYPE;

Line 311: l_fc_version_id2 PA_BUDGET_VERSIONS.budget_version_id%TYPE;

307: --The following varible is added to make program consistent with the
308: --changed copy_version procedure prototype
309: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
310: l_fc_version_id1 PA_BUDGET_VERSIONS.budget_version_id%TYPE;
311: l_fc_version_id2 PA_BUDGET_VERSIONS.budget_version_id%TYPE;
312: l_ci_id_tbl pa_plsql_datatypes.idTabTyp;
313: l_fc_version_type PA_BUDGET_VERSIONS.version_type%TYPE;
314: l_version_name PA_BUDGET_VERSIONS.version_name%TYPE;
315: l_base_line_ver_exists VARCHAR2(1);

Line 313: l_fc_version_type PA_BUDGET_VERSIONS.version_type%TYPE;

309: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
310: l_fc_version_id1 PA_BUDGET_VERSIONS.budget_version_id%TYPE;
311: l_fc_version_id2 PA_BUDGET_VERSIONS.budget_version_id%TYPE;
312: l_ci_id_tbl pa_plsql_datatypes.idTabTyp;
313: l_fc_version_type PA_BUDGET_VERSIONS.version_type%TYPE;
314: l_version_name PA_BUDGET_VERSIONS.version_name%TYPE;
315: l_base_line_ver_exists VARCHAR2(1);
316: l_curr_work_ver_id pa_budget_versions.budget_version_id%TYPE;
317: l_curr_work_fp_opt_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 314: l_version_name PA_BUDGET_VERSIONS.version_name%TYPE;

310: l_fc_version_id1 PA_BUDGET_VERSIONS.budget_version_id%TYPE;
311: l_fc_version_id2 PA_BUDGET_VERSIONS.budget_version_id%TYPE;
312: l_ci_id_tbl pa_plsql_datatypes.idTabTyp;
313: l_fc_version_type PA_BUDGET_VERSIONS.version_type%TYPE;
314: l_version_name PA_BUDGET_VERSIONS.version_name%TYPE;
315: l_base_line_ver_exists VARCHAR2(1);
316: l_curr_work_ver_id pa_budget_versions.budget_version_id%TYPE;
317: l_curr_work_fp_opt_id pa_proj_fp_options.proj_fp_options_id%TYPE;
318: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 316: l_curr_work_ver_id pa_budget_versions.budget_version_id%TYPE;

312: l_ci_id_tbl pa_plsql_datatypes.idTabTyp;
313: l_fc_version_type PA_BUDGET_VERSIONS.version_type%TYPE;
314: l_version_name PA_BUDGET_VERSIONS.version_name%TYPE;
315: l_base_line_ver_exists VARCHAR2(1);
316: l_curr_work_ver_id pa_budget_versions.budget_version_id%TYPE;
317: l_curr_work_fp_opt_id pa_proj_fp_options.proj_fp_options_id%TYPE;
318: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
319: l_auto_baseline_project pa_projects_all.baseline_funding_flag%TYPE;
320:

Line 459: pa_budget_versions bv,

455: l_fin_plan_class_code,
456: l_auto_baseline_project
457: from pa_project_types_all pt,
458: pa_projects_all pr,
459: pa_budget_versions bv,
460: pa_proj_fp_options opt,
461: pa_fin_plan_types_b pavl
462: where bv.budget_version_id = p_budget_version_id and
463: opt.fin_plan_version_id = bv.budget_version_id and

Line 655: --dbms_output.put_line('updating pa_budget_versions');

651:
652: END IF; -- of AR revenue budget
653:
654: /* set the status_code back to "Working" from "Submitted" for the version we're baselining */
655: --dbms_output.put_line('updating pa_budget_versions');
656: update pa_budget_versions
657: set last_update_date = SYSDATE,
658: last_updated_by = FND_GLOBAL.user_id,
659: last_update_login = FND_GLOBAL.login_id,

Line 656: update pa_budget_versions

652: END IF; -- of AR revenue budget
653:
654: /* set the status_code back to "Working" from "Submitted" for the version we're baselining */
655: --dbms_output.put_line('updating pa_budget_versions');
656: update pa_budget_versions
657: set last_update_date = SYSDATE,
658: last_updated_by = FND_GLOBAL.user_id,
659: last_update_login = FND_GLOBAL.login_id,
660: budget_status_code = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING, -- bug 3978894 'W',

Line 676: UPDATE pa_budget_versions

672: pa_debug.g_err_stage := 'Updating the rev_partially_impl_flag in partially implemented CIs';
673: pa_debug.write('pa_fin_plan_pvt: ' || l_module_name,pa_debug.g_err_stage,5);
674: END IF;
675:
676: UPDATE pa_budget_versions
677: SET last_update_date = SYSDATE,
678: last_updated_by = FND_GLOBAL.user_id,
679: last_update_login = FND_GLOBAL.login_id,
680: record_version_number = record_version_number+1,

Line 785: update pa_budget_versions

781:
782: else
783: -- IF baselined_version_id EXISTS --> set CURRENT_FLAG to 'N' to remove current baselined
784: -- status
785: update pa_budget_versions
786: set last_update_date = SYSDATE,
787: last_updated_by = FND_GLOBAL.user_id,
788: last_update_login = FND_GLOBAL.login_id,
789: current_flag = 'N',

Line 1021: From Pa_Budget_Versions

1017:
1018: Begin
1019: Select 'Y'
1020: Into l_base_line_ver_exists
1021: From Pa_Budget_Versions
1022: Where Project_id = p_project_id
1023: And budget_type_code is null /* Bug 4200168*/
1024: And Fin_plan_type_id = l_fin_plan_type_id
1025: And Budget_status_code = 'B'

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

1327: -- HISTORY
1328: -- 11/16/02 dlai: bug fix 2668857 - when joining pa_projects_all with
1329: -- pa_project_types_all, need to join based on org_id as well
1330: PROCEDURE Submit_Current_Working_FinPlan
1331: (p_project_id IN pa_budget_versions.project_id%TYPE,
1332: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1333: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
1334: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1335: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 1332: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

1328: -- 11/16/02 dlai: bug fix 2668857 - when joining pa_projects_all with
1329: -- pa_project_types_all, need to join based on org_id as well
1330: PROCEDURE Submit_Current_Working_FinPlan
1331: (p_project_id IN pa_budget_versions.project_id%TYPE,
1332: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1333: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
1334: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1335: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1336: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 1333: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

1329: -- pa_project_types_all, need to join based on org_id as well
1330: PROCEDURE Submit_Current_Working_FinPlan
1331: (p_project_id IN pa_budget_versions.project_id%TYPE,
1332: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1333: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
1334: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1335: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1336: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1337: IS

Line 1353: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;

1349: l_err_stage VARCHAR2(2000);
1350: l_err_stack VARCHAR2(2000);
1351:
1352: -- local variables
1353: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
1354: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1355: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
1356: l_version_type pa_budget_versions.version_type%TYPE;
1357: l_ac_flag VARCHAR2(1);

Line 1354: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

1350: l_err_stack VARCHAR2(2000);
1351:
1352: -- local variables
1353: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
1354: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1355: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
1356: l_version_type pa_budget_versions.version_type%TYPE;
1357: l_ac_flag VARCHAR2(1);
1358: l_ar_flag VARCHAR2(1);

Line 1356: l_version_type pa_budget_versions.version_type%TYPE;

1352: -- local variables
1353: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
1354: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
1355: l_project_type_class_code pa_project_types.project_type_class_code%TYPE;
1356: l_version_type pa_budget_versions.version_type%TYPE;
1357: l_ac_flag VARCHAR2(1);
1358: l_ar_flag VARCHAR2(1);
1359: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
1360: l_fin_plan_level_code VARCHAR2(30);

Line 1364: l_pm_product_code pa_budget_versions.pm_product_code%TYPE;

1360: l_fin_plan_level_code VARCHAR2(30);
1361: l_fin_plan_type_code VARCHAR2(30);
1362: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1363: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
1364: l_pm_product_code pa_budget_versions.pm_product_code%TYPE;
1365: l_workflow_is_used VARCHAR2(1); -- flag to determine if workflow is used
1366: l_warnings_only_flag VARCHAR2(1);
1367: l_mark_as_original varchar2(30) := 'N';
1368: l_created_by pa_budget_versions.created_by%TYPE;

Line 1368: l_created_by pa_budget_versions.created_by%TYPE;

1364: l_pm_product_code pa_budget_versions.pm_product_code%TYPE;
1365: l_workflow_is_used VARCHAR2(1); -- flag to determine if workflow is used
1366: l_warnings_only_flag VARCHAR2(1);
1367: l_mark_as_original varchar2(30) := 'N';
1368: l_created_by pa_budget_versions.created_by%TYPE;
1369: v_emp_id NUMBER; -- employee id
1370:
1371: BEGIN
1372: FND_MSG_PUB.initialize;

Line 1474: pa_budget_versions bv,

1470: /* l_created_by, Commented for bug 6176649 */
1471: l_fin_plan_type_id
1472: from pa_project_types_all pt,
1473: pa_projects_all pr,
1474: pa_budget_versions bv,
1475: -- pa_budget_entry_methods be,
1476: pa_proj_fp_options opt,
1477: pa_fin_plan_types_b pavl
1478: where bv.budget_version_id = p_budget_version_id and

Line 1534: update pa_budget_versions

1530: end if;
1531: --dbms_output.put_line('Verify_Budget_Rules called');
1532: --- BUDGET RULES VERIFIED AND OK, PROCEED WITH SUBMITTING CURRENT WORKING ---
1533: /* set the status_code to "S" for the version we're submitting */
1534: update pa_budget_versions
1535: set last_update_date = SYSDATE,
1536: last_updated_by = FND_GLOBAL.user_id,
1537: last_update_login = FND_GLOBAL.login_id,
1538: budget_status_code = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_SUBMITTED, -- bug 3978894 'S',

Line 1541: --dbms_output.put_line('update pa_budget_versions statement executed');

1537: last_update_login = FND_GLOBAL.login_id,
1538: budget_status_code = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_SUBMITTED, -- bug 3978894 'S',
1539: record_version_number = record_version_number+1
1540: where budget_version_id = p_budget_version_id;
1541: --dbms_output.put_line('update pa_budget_versions statement executed');
1542: -- Check whether workflow is being used for this project budget
1543: -- If so, get the employee id based on the baselined_by_user_id
1544: PA_CLIENT_EXTN_BUDGET_WF.Budget_Wf_Is_Used
1545: (p_draft_version_id => p_budget_version_id,

Line 1583: -- update pa_budget_versions: set wf_status_code = 'IN_ROUTE'

1579: if l_err_code <> 0 then
1580: -- PA_BUDGET_WF.START_BUDGET_WF returned errors
1581: raise pa_fin_plan_pvt.start_wf_error;
1582: else
1583: -- update pa_budget_versions: set wf_status_code = 'IN_ROUTE'
1584: update pa_budget_versions
1585: set wf_status_code = 'IN_ROUTE'
1586: where budget_version_id = p_budget_version_id;
1587: end if;

Line 1584: update pa_budget_versions

1580: -- PA_BUDGET_WF.START_BUDGET_WF returned errors
1581: raise pa_fin_plan_pvt.start_wf_error;
1582: else
1583: -- update pa_budget_versions: set wf_status_code = 'IN_ROUTE'
1584: update pa_budget_versions
1585: set wf_status_code = 'IN_ROUTE'
1586: where budget_version_id = p_budget_version_id;
1587: end if;
1588: end if;

Line 1635: ( p_from_bv_id IN pa_budget_versions.budget_version_id%TYPE

1631: cursors
1632: */
1633:
1634: PROCEDURE Get_Included_Ci
1635: ( p_from_bv_id IN pa_budget_versions.budget_version_id%TYPE
1636: ,p_to_bv_id IN pa_budget_versions.budget_version_id%TYPE --DEFAULT NULL
1637: ,p_impact_status IN pa_ci_impacts.status_code%TYPE
1638: ,x_ci_rec_tab OUT NOCOPY pa_fin_plan_pvt.ci_rec_tab
1639: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1636: ,p_to_bv_id IN pa_budget_versions.budget_version_id%TYPE --DEFAULT NULL

1632: */
1633:
1634: PROCEDURE Get_Included_Ci
1635: ( p_from_bv_id IN pa_budget_versions.budget_version_id%TYPE
1636: ,p_to_bv_id IN pa_budget_versions.budget_version_id%TYPE --DEFAULT NULL
1637: ,p_impact_status IN pa_ci_impacts.status_code%TYPE
1638: ,x_ci_rec_tab OUT NOCOPY pa_fin_plan_pvt.ci_rec_tab
1639: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1640: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1662: pa_budget_versions pbv

1658: f.impl_agr_revenue impl_agr_revenue,
1659: pbv.rev_partially_impl_flag rev_partially_impl_flag
1660: from pa_fp_merged_ctrl_items f,
1661: pa_ci_impacts im ,
1662: pa_budget_versions pbv
1663: where f.plan_version_id = p_from_bv_id
1664: and pbv.budget_version_id=f.ci_plan_version_id
1665: and im.ci_id = f.ci_id
1666: and im.impact_type_code IN ('FINPLAN_COST','FINPLAN_REVENUE')

Line 1697: pa_budget_versions pbv

1693: f.impl_agr_revenue impl_agr_revenue,
1694: pbv.rev_partially_impl_flag rev_partially_impl_flag
1695: from pa_fp_merged_ctrl_items f,
1696: pa_ci_impacts im,
1697: pa_budget_versions pbv
1698: where f.plan_version_id = p_from_bv_id
1699: and pbv.budget_version_id=f.ci_plan_version_id
1700: and im.ci_id = f.ci_id
1701: and im.impact_type_code IN ('FINPLAN_COST','FINPLAN_REVENUE')

Line 1788: ( p_source_bv_id IN pa_budget_versions.budget_version_id%TYPE

1784:
1785: --Modified for 3550073. Handled the FINPLAN_COST, FINPLAN_REVENUE records in pa_ci_impacts
1786: --Reset the rev_partially_impl flag for the CIs partially implemented in the old current working version
1787: PROCEDURE handle_ci_links
1788: ( p_source_bv_id IN pa_budget_versions.budget_version_id%TYPE
1789: ,p_target_bv_id IN pa_budget_versions.budget_version_id%TYPE
1790: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1791: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1792: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 1789: ,p_target_bv_id IN pa_budget_versions.budget_version_id%TYPE

1785: --Modified for 3550073. Handled the FINPLAN_COST, FINPLAN_REVENUE records in pa_ci_impacts
1786: --Reset the rev_partially_impl flag for the CIs partially implemented in the old current working version
1787: PROCEDURE handle_ci_links
1788: ( p_source_bv_id IN pa_budget_versions.budget_version_id%TYPE
1789: ,p_target_bv_id IN pa_budget_versions.budget_version_id%TYPE
1790: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1791: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1792: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1793:

Line 1802: ,pa_budget_versions bv

1798: bv.project_id,
1799: bv.fin_plan_type_id,
1800: bv.version_type
1801: from pa_fin_plan_types_b pt
1802: ,pa_budget_versions bv
1803: where pt.fin_plan_type_id = bv.fin_plan_type_id
1804: and bv.budget_version_id = p_target_bv_id
1805: and (pt.approved_cost_plan_type_flag = 'Y'
1806: OR

Line 1811: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

1807: pt.approved_rev_plan_type_flag = 'Y');
1808:
1809: l_approved_budget_plan_type varchar2(1) := 'N';
1810: l_project_id pa_projects_all.project_id%TYPE;
1811: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1812: l_version_type pa_budget_versions.version_type%TYPE;
1813: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1814: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
1815: l_ci_rec_tab pa_fin_plan_pvt.ci_rec_tab;

Line 1812: l_version_type pa_budget_versions.version_type%TYPE;

1808:
1809: l_approved_budget_plan_type varchar2(1) := 'N';
1810: l_project_id pa_projects_all.project_id%TYPE;
1811: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
1812: l_version_type pa_budget_versions.version_type%TYPE;
1813: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1814: l_fin_plan_version_id pa_proj_fp_options.fin_plan_version_id%TYPE;
1815: l_ci_rec_tab pa_fin_plan_pvt.ci_rec_tab;
1816: l_return_status VARCHAR2(2000);

Line 1965: UPDATE pa_budget_versions

1961: --If the CI has got partially implemented in the old current working version then the
1962: --reset the rev_partially_impl_flag in the ci version
1963: IF l_ci_rec_tab(i).rev_partially_impl_flag ='Y' THEN
1964:
1965: UPDATE pa_budget_versions
1966: SET rev_partially_impl_flag='N',
1967: record_version_number=nvl(record_version_number,0)+1,
1968: last_updated_by=fnd_global.user_id,
1969: last_update_login=fnd_global.login_id,

Line 2079: ( p_project_id IN pa_budget_versions.project_id%TYPE

2075: API is similar to pa_budget_utils.create_draft
2076: */
2077:
2078: PROCEDURE CREATE_DRAFT
2079: ( p_project_id IN pa_budget_versions.project_id%TYPE
2080: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
2081: ,p_version_type IN pa_budget_versions.version_type%TYPE
2082: -- Bug Fix: 4569365. Removed MRC code.
2083: -- ,p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE

Line 2080: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

2076: */
2077:
2078: PROCEDURE CREATE_DRAFT
2079: ( p_project_id IN pa_budget_versions.project_id%TYPE
2080: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
2081: ,p_version_type IN pa_budget_versions.version_type%TYPE
2082: -- Bug Fix: 4569365. Removed MRC code.
2083: -- ,p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
2084: ,p_calling_context IN VARCHAR2

Line 2081: ,p_version_type IN pa_budget_versions.version_type%TYPE

2077:
2078: PROCEDURE CREATE_DRAFT
2079: ( p_project_id IN pa_budget_versions.project_id%TYPE
2080: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
2081: ,p_version_type IN pa_budget_versions.version_type%TYPE
2082: -- Bug Fix: 4569365. Removed MRC code.
2083: -- ,p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
2084: ,p_calling_context IN VARCHAR2
2085: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE

Line 2086: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE

2082: -- Bug Fix: 4569365. Removed MRC code.
2083: -- ,p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
2084: ,p_calling_context IN VARCHAR2
2085: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2086: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
2087: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2088: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2089: ,p_version_name IN pa_budget_versions.version_name%TYPE
2090: ,p_description IN pa_budget_versions.description%TYPE

Line 2089: ,p_version_name IN pa_budget_versions.version_name%TYPE

2085: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
2086: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
2087: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2088: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2089: ,p_version_name IN pa_budget_versions.version_name%TYPE
2090: ,p_description IN pa_budget_versions.description%TYPE
2091: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
2092: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE
2093: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE

Line 2090: ,p_description IN pa_budget_versions.description%TYPE

2086: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
2087: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2088: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2089: ,p_version_name IN pa_budget_versions.version_name%TYPE
2090: ,p_description IN pa_budget_versions.description%TYPE
2091: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
2092: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE
2093: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE
2094: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE

Line 2091: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

2087: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
2088: ,p_plan_in_mc_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE
2089: ,p_version_name IN pa_budget_versions.version_name%TYPE
2090: ,p_description IN pa_budget_versions.description%TYPE
2091: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
2092: ,p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE
2093: ,p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE
2094: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE
2095: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE

Line 2098: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE

2094: ,p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE
2095: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE
2096: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE
2097: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE
2098: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
2099: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
2100: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
2101: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
2102: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

Line 2099: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE

2095: ,p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE
2096: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE
2097: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE
2098: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
2099: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
2100: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
2101: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
2102: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
2103: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

Line 2100: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE

2096: ,p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE
2097: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE
2098: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
2099: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
2100: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
2101: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
2102: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
2103: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
2104: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

Line 2101: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE

2097: ,p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE
2098: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
2099: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
2100: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
2101: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
2102: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
2103: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
2104: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
2105: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

Line 2102: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

2098: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
2099: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
2100: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
2101: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
2102: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
2103: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
2104: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
2105: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
2106: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

Line 2103: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

2099: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
2100: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
2101: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
2102: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
2103: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
2104: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
2105: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
2106: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
2107: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

Line 2104: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

2100: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
2101: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
2102: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
2103: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
2104: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
2105: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
2106: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
2107: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
2108: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

Line 2105: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

2101: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
2102: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
2103: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
2104: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
2105: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
2106: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
2107: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
2108: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
2109: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

Line 2106: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

2102: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
2103: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
2104: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
2105: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
2106: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
2107: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
2108: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
2109: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
2110: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

Line 2107: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

2103: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
2104: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
2105: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
2106: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
2107: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
2108: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
2109: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
2110: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
2111: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

Line 2108: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

2104: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
2105: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
2106: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
2107: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
2108: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
2109: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
2110: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
2111: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
2112: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

Line 2109: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

2105: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
2106: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
2107: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
2108: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
2109: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
2110: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
2111: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
2112: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
2113: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

Line 2110: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

2106: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
2107: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
2108: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
2109: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
2110: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
2111: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
2112: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
2113: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
2114: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE

Line 2111: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

2107: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
2108: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
2109: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
2110: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
2111: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
2112: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
2113: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
2114: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2115: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE

Line 2112: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

2108: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
2109: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
2110: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
2111: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
2112: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
2113: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
2114: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2115: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2116: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE

Line 2113: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

2109: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
2110: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
2111: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
2112: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
2113: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
2114: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE
2115: ,p_projfunc_cost_rate_date_type IN pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE
2116: ,p_projfunc_cost_rate_date IN pa_proj_fp_options.projfunc_cost_rate_date%TYPE
2117: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE

Line 2126: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE

2122: ,p_project_cost_rate_date IN pa_proj_fp_options.project_cost_rate_date%TYPE
2123: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2124: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2125: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2126: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
2127: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
2128: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
2129: -- Start of additional columns for Bug :- 2634900 . Commented out the default parameters.
2130: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL

Line 2127: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE

2123: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
2124: ,p_project_rev_rate_date_type IN pa_proj_fp_options.project_rev_rate_date_type%TYPE
2125: ,p_project_rev_rate_date IN pa_proj_fp_options.project_rev_rate_date%TYPE
2126: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
2127: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
2128: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
2129: -- Start of additional columns for Bug :- 2634900 . Commented out the default parameters.
2130: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
2131: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL

Line 2130: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL

2126: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE
2127: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
2128: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
2129: -- Start of additional columns for Bug :- 2634900 . Commented out the default parameters.
2130: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
2131: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
2132: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
2133: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
2134: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL

Line 2131: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL

2127: ,p_pm_budget_reference IN pa_budget_versions.pm_budget_reference%TYPE
2128: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
2129: -- Start of additional columns for Bug :- 2634900 . Commented out the default parameters.
2130: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
2131: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
2132: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
2133: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
2134: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
2135: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --FP.M

Line 2132: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL

2128: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
2129: -- Start of additional columns for Bug :- 2634900 . Commented out the default parameters.
2130: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
2131: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
2132: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
2133: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
2134: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
2135: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --FP.M
2136: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL

Line 2133: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL

2129: -- Start of additional columns for Bug :- 2634900 . Commented out the default parameters.
2130: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
2131: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
2132: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
2133: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
2134: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
2135: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --FP.M
2136: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
2137: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL

Line 2134: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL

2130: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
2131: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
2132: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
2133: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
2134: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
2135: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --FP.M
2136: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
2137: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
2138: -- End of additional columns for Bug :- 2634900

Line 2135: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --FP.M

2131: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
2132: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
2133: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
2134: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
2135: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --FP.M
2136: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
2137: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
2138: -- End of additional columns for Bug :- 2634900
2139: -- Added the two flags below as part of changes to AMG for finplan model

Line 2137: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL

2133: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
2134: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
2135: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --FP.M
2136: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
2137: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
2138: -- End of additional columns for Bug :- 2634900
2139: -- Added the two flags below as part of changes to AMG for finplan model
2140: ,p_create_new_curr_working_flag IN VARCHAR2
2141: ,p_replace_current_working_flag IN VARCHAR2

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

2138: -- End of additional columns for Bug :- 2634900
2139: -- Added the two flags below as part of changes to AMG for finplan model
2140: ,p_create_new_curr_working_flag IN VARCHAR2
2141: ,p_replace_current_working_flag IN VARCHAR2
2142: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
2143: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2144: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2145: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
2146: IS

Line 2169: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;

2165:
2166: impacted_task_rec impacted_task_cur%ROWTYPE;
2167:
2168: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2169: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
2170: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
2171: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
2172:
2173: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

Line 2170: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;

2166: impacted_task_rec impacted_task_cur%ROWTYPE;
2167:
2168: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2169: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
2170: l_curr_work_version_id pa_budget_versions.budget_version_id%TYPE;
2171: l_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
2172:
2173: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
2174: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

Line 2176: l_created_version_id pa_budget_versions.budget_version_id%TYPE;

2172:
2173: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
2174: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
2175: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
2176: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
2177: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2178: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2179:
2180: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;

Line 2177: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

2173: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
2174: l_rev_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
2175: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
2176: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
2177: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2178: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2179:
2180: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;
2181: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;

Line 2189: l_record_version_number pa_budget_versions.record_version_number%TYPE; /* Bug 2688610 */

2185:
2186: -- Bug Fix: 4569365. Removed MRC code.
2187: -- l_calling_context pa_mrc_finplan.g_calling_module%TYPE; /* Bug# 2674353 */
2188: l_calling_context VARCHAR2(30);
2189: l_record_version_number pa_budget_versions.record_version_number%TYPE; /* Bug 2688610 */
2190:
2191: l_mixed_resource_planned_flag VARCHAR2(1);-- Added for Bug:-2625872
2192:
2193: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 2194: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;

2190:
2191: l_mixed_resource_planned_flag VARCHAR2(1);-- Added for Bug:-2625872
2192:
2193: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2194: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
2195: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
2196: l_user_id NUMBER :=0;
2197: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
2198: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 2195: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;

2191: l_mixed_resource_planned_flag VARCHAR2(1);-- Added for Bug:-2625872
2192:
2193: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2194: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
2195: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
2196: l_user_id NUMBER :=0;
2197: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
2198: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2199: l_rlm_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 2197: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;

2193: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2194: l_CW_version_id pa_budget_versions.budget_version_id%TYPE;
2195: l_CW_record_version_number pa_budget_versions.record_version_number%TYPE;
2196: l_user_id NUMBER :=0;
2197: l_created_ver_rec_ver_num pa_budget_versions.record_version_number%TYPE;
2198: l_task_elem_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2199: l_rlm_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2200: BEGIN
2201:

Line 2618: update pa_budget_versions

2614: need to update the following in budget_versions
2615: change reason code,
2616: product code, budget reference.
2617: */
2618: update pa_budget_versions
2619: set change_reason_code = p_change_reason_code,
2620: pm_product_code = p_pm_product_code,
2621: pm_budget_reference = p_pm_budget_reference,
2622: attribute_category = p_attribute_category,

Line 2915: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE

2911: PROCEDURE CREATE_FINPLAN_LINES
2912: ( -- Bug Fix: 4569365. Removed MRC code.
2913: -- p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE /* Bug# 2674353 */
2914: p_calling_context IN VARCHAR2
2915: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
2916: ,p_budget_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
2917: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2918: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2919: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 3134: FROM pa_budget_versions

3130: INTO l_proj_currency_code
3131: ,l_projfunc_currency_code
3132: FROM pa_projects_all
3133: WHERE project_id = (SELECT project_id
3134: FROM pa_budget_versions
3135: WHERE budget_version_id = p_fin_plan_version_id);
3136:
3137: --Bulk insert into the rollup tmp table.
3138: IF nvl(p_budget_lines_tab.last,0) > 0 THEN

Line 3968: FROM pa_budget_versions

3964: l_sv_id_count NUMBER;
3965:
3966: cursor c_struct_ver(c_project_id pa_projects_all.project_id%TYPE) IS
3967: SELECT project_structure_version_id
3968: FROM pa_budget_versions
3969: WHERE project_id = c_project_id
3970: AND nvl(wp_version_flag,'N') = 'Y';
3971:
3972: BEGIN

Line 4193: cursor c_budget_ver(c_structure_version_id pa_budget_versions.project_structure_version_id%TYPE) IS

4189: --End of variables used for debugging
4190:
4191: l_sv_id_tbl_count NUMBER;
4192:
4193: cursor c_budget_ver(c_structure_version_id pa_budget_versions.project_structure_version_id%TYPE) IS
4194: SELECT budget_version_id,record_version_number,project_id
4195: FROM pa_budget_versions
4196: WHERE project_structure_version_id = nvl(c_structure_version_id,-99)
4197: AND nvl(wp_version_flag,'N')='Y';

Line 4195: FROM pa_budget_versions

4191: l_sv_id_tbl_count NUMBER;
4192:
4193: cursor c_budget_ver(c_structure_version_id pa_budget_versions.project_structure_version_id%TYPE) IS
4194: SELECT budget_version_id,record_version_number,project_id
4195: FROM pa_budget_versions
4196: WHERE project_structure_version_id = nvl(c_structure_version_id,-99)
4197: AND nvl(wp_version_flag,'N')='Y';
4198:
4199: BEGIN

Line 4352: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE

4348: PROCEDURE ADD_FIN_PLAN_LINES
4349: ( -- Bug Fix: 4569365. Removed MRC code.
4350: -- p_calling_context IN pa_mrc_finplan.g_calling_module%TYPE
4351: p_calling_context IN VARCHAR2
4352: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
4353: ,p_finplan_lines_tab IN pa_fin_plan_pvt.budget_lines_tab
4354: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4355: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4356: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 4379: l_project_id pa_budget_versions.project_id%TYPE;

4375: l_line_end_date_tab SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type();
4376: i NUMBER;
4377: l_lines_count NUMBER; -- Bug 3639983
4378: l_module_name VARCHAR2(30) := 'pa.plsql.PA_FIN_PLAN_PVT';
4379: l_project_id pa_budget_versions.project_id%TYPE;
4380: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4381: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
4382: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type := SYSTEM.pa_varchar2_15_tbl_type();
4383: l_total_qty_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 4393: SELECT project_id FROM pa_budget_versions

4389: -- bug 4221650: added the following
4390: l_ver_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
4391:
4392: CURSOR get_proj_id_csr IS
4393: SELECT project_id FROM pa_budget_versions
4394: WHERE budget_version_id = p_fin_plan_version_id ;
4395:
4396: BEGIN
4397: