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

Line 53: c_version_type pa_budget_versions.version_type%TYPE,

49: c_allow_burd_cost_rate_flag VARCHAR2,
50: c_allow_bill_rate_flag VARCHAR2,
51: c_project_id pa_projects_all.project_id%TYPE,
52: c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE,
53: c_version_type pa_budget_versions.version_type%TYPE,
54: c_request_id pa_budget_versions.request_id%TYPE
55: )
56: IS
57: SELECT inf.budget_version_id budget_version_id,

Line 54: c_request_id pa_budget_versions.request_id%TYPE

50: c_allow_bill_rate_flag VARCHAR2,
51: c_project_id pa_projects_all.project_id%TYPE,
52: c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE,
53: c_version_type pa_budget_versions.version_type%TYPE,
54: c_request_id pa_budget_versions.request_id%TYPE
55: )
56: IS
57: SELECT inf.budget_version_id budget_version_id,
58: inf.resource_list_member_id resource_list_member_id,

Line 322: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

318: l_data VARCHAR2(2000);
319: l_msg_data VARCHAR2(2000);
320: l_msg_index_out NUMBER;
321: l_del_record_count NUMBER;
322: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
323: l_bv_request_id pa_budget_versions.request_id%TYPE;
324: l_inf_request_id pa_budget_versions.request_id%TYPE;
325: l_preserve_rows_flag VARCHAR2(1);
326: l_nothing_delete_flag VARCHAR2(1);

Line 323: l_bv_request_id pa_budget_versions.request_id%TYPE;

319: l_msg_data VARCHAR2(2000);
320: l_msg_index_out NUMBER;
321: l_del_record_count NUMBER;
322: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
323: l_bv_request_id pa_budget_versions.request_id%TYPE;
324: l_inf_request_id pa_budget_versions.request_id%TYPE;
325: l_preserve_rows_flag VARCHAR2(1);
326: l_nothing_delete_flag VARCHAR2(1);
327:

Line 324: l_inf_request_id pa_budget_versions.request_id%TYPE;

320: l_msg_index_out NUMBER;
321: l_del_record_count NUMBER;
322: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
323: l_bv_request_id pa_budget_versions.request_id%TYPE;
324: l_inf_request_id pa_budget_versions.request_id%TYPE;
325: l_preserve_rows_flag VARCHAR2(1);
326: l_nothing_delete_flag VARCHAR2(1);
327:
328: BEGIN

Line 365: pa_budget_versions bv

361: INTO l_preserve_rows_flag
362: FROM DUAL
363: WHERE EXISTS (SELECT 'X'
364: FROM pa_fp_webadi_upload_inf inf,
365: pa_budget_versions bv
366: WHERE inf.run_id = p_run_id
367: AND inf.budget_version_id = bv.budget_version_id
368: AND Nvl(inf.request_id, -99) = Nvl(bv.request_id, -99)
369: AND bv.plan_processing_code IN ('XLUP', 'XLUE'));

Line 444: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

440:
441: PROCEDURE validate_header_info
442: ( p_calling_mode IN VARCHAR2,
443: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
444: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
445: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
446: p_pm_rec_version_number IN pa_period_masks_b.record_version_number%TYPE,
447: p_submit_flag IN VARCHAR2,
448: p_request_id IN pa_budget_versions.request_id%TYPE,

Line 445: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

441: PROCEDURE validate_header_info
442: ( p_calling_mode IN VARCHAR2,
443: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
444: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
445: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
446: p_pm_rec_version_number IN pa_period_masks_b.record_version_number%TYPE,
447: p_submit_flag IN VARCHAR2,
448: p_request_id IN pa_budget_versions.request_id%TYPE,
449: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 448: p_request_id IN pa_budget_versions.request_id%TYPE,

444: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
445: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
446: p_pm_rec_version_number IN pa_period_masks_b.record_version_number%TYPE,
447: p_submit_flag IN VARCHAR2,
448: p_request_id IN pa_budget_versions.request_id%TYPE,
449: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
450: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
451: x_msg_count OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
452:

Line 455: CURSOR l_version_info_csr (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)

451: x_msg_count OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
452:
453: IS
454:
455: CURSOR l_version_info_csr (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)
456: IS
457: SELECT bv.record_version_number,
458: bv.period_mask_id,
459: bv.project_id,

Line 471: FROM pa_budget_versions bv,

467: Nvl(bv.current_working_flag, 'N'),
468: fpt.plan_class_code,
469: Decode(bv.version_type, 'COST', fpo.cost_time_phased_code,
470: 'REVENUE', fpo.revenue_time_phased_code, 'ALL', fpo.all_time_phased_code) time_phased_code
471: FROM pa_budget_versions bv,
472: pa_fin_plan_types_b fpt,
473: pa_proj_fp_options fpo
474: WHERE bv.budget_version_id = c_budget_version_id
475: AND bv.budget_version_id = fpo.fin_plan_version_id

Line 479: l_record_version_number pa_budget_versions.record_version_number%TYPE;

475: AND bv.budget_version_id = fpo.fin_plan_version_id
476: AND bv.project_id = fpo.project_id
477: AND bv.fin_plan_type_id = fpt.fin_plan_type_id;
478:
479: l_record_version_number pa_budget_versions.record_version_number%TYPE;
480: l_period_mask_id pa_period_masks_b.period_mask_id%TYPE;
481: l_project_id pa_projects_all.project_id%TYPE;
482: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
483: l_ci_id pa_control_items.ci_id%TYPE;

Line 484: l_version_type pa_budget_versions.version_type%TYPE;

480: l_period_mask_id pa_period_masks_b.period_mask_id%TYPE;
481: l_project_id pa_projects_all.project_id%TYPE;
482: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
483: l_ci_id pa_control_items.ci_id%TYPE;
484: l_version_type pa_budget_versions.version_type%TYPE;
485: l_app_cost_plan_type_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
486: l_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
487: l_prime_cost_fcst_flag pa_budget_versions.primary_cost_forecast_flag%TYPE;
488: l_prime_rev_fcst_flag pa_budget_versions.primary_rev_forecast_flag%TYPE;

Line 485: l_app_cost_plan_type_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;

481: l_project_id pa_projects_all.project_id%TYPE;
482: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
483: l_ci_id pa_control_items.ci_id%TYPE;
484: l_version_type pa_budget_versions.version_type%TYPE;
485: l_app_cost_plan_type_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
486: l_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
487: l_prime_cost_fcst_flag pa_budget_versions.primary_cost_forecast_flag%TYPE;
488: l_prime_rev_fcst_flag pa_budget_versions.primary_rev_forecast_flag%TYPE;
489: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

Line 486: l_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

482: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
483: l_ci_id pa_control_items.ci_id%TYPE;
484: l_version_type pa_budget_versions.version_type%TYPE;
485: l_app_cost_plan_type_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
486: l_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
487: l_prime_cost_fcst_flag pa_budget_versions.primary_cost_forecast_flag%TYPE;
488: l_prime_rev_fcst_flag pa_budget_versions.primary_rev_forecast_flag%TYPE;
489: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
490: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;

Line 487: l_prime_cost_fcst_flag pa_budget_versions.primary_cost_forecast_flag%TYPE;

483: l_ci_id pa_control_items.ci_id%TYPE;
484: l_version_type pa_budget_versions.version_type%TYPE;
485: l_app_cost_plan_type_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
486: l_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
487: l_prime_cost_fcst_flag pa_budget_versions.primary_cost_forecast_flag%TYPE;
488: l_prime_rev_fcst_flag pa_budget_versions.primary_rev_forecast_flag%TYPE;
489: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
490: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
491: l_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;

Line 488: l_prime_rev_fcst_flag pa_budget_versions.primary_rev_forecast_flag%TYPE;

484: l_version_type pa_budget_versions.version_type%TYPE;
485: l_app_cost_plan_type_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
486: l_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
487: l_prime_cost_fcst_flag pa_budget_versions.primary_cost_forecast_flag%TYPE;
488: l_prime_rev_fcst_flag pa_budget_versions.primary_rev_forecast_flag%TYPE;
489: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
490: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
491: l_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
492: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;

Line 489: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

485: l_app_cost_plan_type_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
486: l_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
487: l_prime_cost_fcst_flag pa_budget_versions.primary_cost_forecast_flag%TYPE;
488: l_prime_rev_fcst_flag pa_budget_versions.primary_rev_forecast_flag%TYPE;
489: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
490: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
491: l_time_phase_code pa_proj_fp_options.all_time_phased_code%TYPE;
492: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;
493:

Line 497: l_locked_by_persion_id pa_budget_versions.locked_by_person_id%TYPE;

493:
494: is_periodic_layout VARCHAR2(1) := 'N';
495:
496: l_sec_ret_code VARCHAR2(30);
497: l_locked_by_persion_id pa_budget_versions.locked_by_person_id%TYPE;
498: l_val_err_code VARCHAR2(30);
499: l_ci_status_code pa_control_items.status_code%TYPE;
500:
501: l_return_status VARCHAR2(1);

Line 1018: p_request_id IN pa_budget_versions.request_id%TYPE,

1014: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1015: p_rlm_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1016: p_txn_curr_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1017: p_amount_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1018: p_request_id IN pa_budget_versions.request_id%TYPE,
1019: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1020: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1021: x_msg_count OUT NOCOPY NUMBER) --File.Sql.39 bug 4440895
1022: IS

Line 1664: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,

1660: END conv_attributes_displayed;
1661:
1662: PROCEDURE prepare_val_input
1663: ( p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
1664: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
1665: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
1666: p_prd_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
1667: p_prd_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
1668: p_org_id IN pa_projects_all.org_id%TYPE,

Line 1728: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

1724: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE;
1725: l_prc_error_code VARCHAR2(30);
1726:
1727: l_unct_rlm_id pa_resource_list_members.resource_list_member_id%TYPE;
1728: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
1729:
1730: l_plan_trans_attr_copied_flag VARCHAR2(1);
1731: l_cost_conv_attr_copied_flag VARCHAR2(1);
1732: l_rev_conv_attr_copied_flag VARCHAR2(1);

Line 1928: CURSOR non_prd_lyt_null_val_cur(c_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

1924: /* Bug 5144013: Made changes in the query of the cursor non_prd_lyt_null_val_cur to refer to the
1925: new entity pa_resource_asgn_curr. This is done as part of merging MRUP3 changes done in 11i
1926: into R12.
1927: */
1928: CURSOR non_prd_lyt_null_val_cur(c_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1929: c_task_id IN pa_resource_assignments.task_id%TYPE,
1930: c_resource_list_member_id IN pa_resource_assignments.resource_list_member_id%TYPE,
1931: c_cbs_element_id IN pa_resource_assignments.cbs_element_id%TYPE,
1932: c_txn_currency_code IN pa_resource_asgn_curr.txn_currency_code%TYPE)

Line 6162: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

6158:
6159: --This API is internally called from prepare_pbl_input
6160: PROCEDURE get_total_fcst_amounts
6161: (p_project_id IN pa_projects_all.project_id%TYPE,
6162: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6163: p_task_id IN pa_tasks.task_id%TYPE,
6164: p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE,
6165: p_cbs_element_id IN pa_resource_assignments.cbs_element_id%TYPE, -- cbs enhancement changes bug#16445106
6166: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

Line 6778: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,

6774:
6775: PROCEDURE prepare_pbl_input
6776: (p_context IN VARCHAR2,
6777: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
6778: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
6779: p_inf_tbl_rec_tbl IN inf_cur_tbl_typ,
6780: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
6781: p_project_id IN pa_projects_all.project_id%TYPE,
6782: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

Line 6782: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

6778: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
6779: p_inf_tbl_rec_tbl IN inf_cur_tbl_typ,
6780: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
6781: p_project_id IN pa_projects_all.project_id%TYPE,
6782: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6783: p_budget_lines_tbl IN PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE,
6784: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type,
6785: p_etc_start_date IN pa_budget_versions.etc_start_date%TYPE,
6786: p_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,

Line 6785: p_etc_start_date IN pa_budget_versions.etc_start_date%TYPE,

6781: p_project_id IN pa_projects_all.project_id%TYPE,
6782: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6783: p_budget_lines_tbl IN PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE,
6784: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type,
6785: p_etc_start_date IN pa_budget_versions.etc_start_date%TYPE,
6786: p_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
6787: p_first_pd_bf_pm_en_dt IN DATE,
6788: p_last_pd_af_pm_st_dt IN DATE,
6789: p_prd_mask_st_date_tbl IN SYSTEM.pa_date_tbl_type,

Line 8120: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

8116: END prepare_pbl_input;
8117:
8118: PROCEDURE process_budget_lines
8119: ( p_context IN VARCHAR2,
8120: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
8121: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
8122: p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8123: p_rlm_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
8124: p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),-- cbs enhancement changes bug#16445106

Line 10252: (p_request_id IN pa_budget_versions.request_id%TYPE,

10248:
10249: --This procedure will update the budget version and its corresponding data in the interface table with
10250: --the latest request id and plan processing code(XLUP/XLUE).
10251: PROCEDURE update_xl_data_for_new_req
10252: (p_request_id IN pa_budget_versions.request_id%TYPE,
10253: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
10254: p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE,
10255: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
10256: p_null_out_cols IN VARCHAR2)

Line 10254: p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE,

10250: --the latest request id and plan processing code(XLUP/XLUE).
10251: PROCEDURE update_xl_data_for_new_req
10252: (p_request_id IN pa_budget_versions.request_id%TYPE,
10253: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
10254: p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE,
10255: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
10256: p_null_out_cols IN VARCHAR2)
10257: IS
10258: BEGIN

Line 10255: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

10251: PROCEDURE update_xl_data_for_new_req
10252: (p_request_id IN pa_budget_versions.request_id%TYPE,
10253: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
10254: p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE,
10255: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
10256: p_null_out_cols IN VARCHAR2)
10257: IS
10258: BEGIN
10259:

Line 10262: UPDATE pa_budget_versions

10258: BEGIN
10259:
10260: --Record Version Number is not updated since the web ADI code checks the record Version Number at downloand
10261: --with the record version number at upload and throws an error if they dont match.
10262: UPDATE pa_budget_versions
10263: SET request_id = p_request_id,
10264: plan_processing_code=p_plan_processing_code
10265: WHERE budget_version_id = p_budget_version_id;
10266:

Line 10292: p_request_id IN pa_budget_versions.request_id%TYPE,

10288: p_submit_budget_flag IN VARCHAR2,
10289: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
10290: x_success_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
10291: p_submit_forecast_flag IN VARCHAR2,
10292: p_request_id IN pa_budget_versions.request_id%TYPE,
10293: p_calling_mode IN VARCHAR2)
10294:
10295: IS
10296: -- variables used for debugging

Line 10307: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

10303: l_msg_data VARCHAR2(2000);
10304: l_data VARCHAR2(2000);
10305: l_msg_index_out NUMBER;
10306:
10307: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
10308: l_rec_version_number pa_budget_versions.record_version_number%TYPE;
10309: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;
10310: l_project_id pa_projects_all.project_id%TYPE;
10311: l_org_id pa_projects_all.org_id%TYPE;

Line 10308: l_rec_version_number pa_budget_versions.record_version_number%TYPE;

10304: l_data VARCHAR2(2000);
10305: l_msg_index_out NUMBER;
10306:
10307: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
10308: l_rec_version_number pa_budget_versions.record_version_number%TYPE;
10309: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;
10310: l_project_id pa_projects_all.project_id%TYPE;
10311: l_org_id pa_projects_all.org_id%TYPE;
10312: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;

Line 10468: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

10464: l_submit_flag VARCHAR2(1);
10465: l_profile_val VARCHAR2(30);
10466: l_profile_thsld_val NUMBER;
10467: l_profile_thsld_num NUMBER;
10468: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
10469: l_request_id NUMBER;
10470: l_rollback_flag VARCHAR2(1);
10471: l_first_pd_bf_pm_en_dt DATE;
10472: l_last_pd_af_pm_st_dt DATE;

Line 10633: FROM pa_budget_versions bv,

10629: etc_start_date
10630: INTO l_project_id,
10631: l_org_id,
10632: l_etc_start_date
10633: FROM pa_budget_versions bv,
10634: pa_projects_all pl
10635: WHERE bv.budget_version_id = l_budget_version_id
10636: AND bv.project_id = pl.project_id;
10637: EXCEPTION

Line 11107: UPDATE pa_budget_versions

11103: ELSE
11104: --log1('----- STAGE 10.14-------');
11105:
11106: -- updating the budget version with the request_id
11107: UPDATE pa_budget_versions
11108: SET plan_processing_code = 'XLUP',
11109: request_id = l_request_id
11110: WHERE budget_version_id = l_budget_version_id;
11111:

Line 11542: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

11538: l_debug_mode VARCHAR2(30);
11539: l_module_name VARCHAR2(100):='PAFPWAPB.process_MSExcel_data';
11540:
11541: --End of variables used for debugging
11542: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
11543: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
11544: l_request_id pa_budget_versions.request_id%TYPE;
11545: l_submit_bdgt_flag VARCHAR2(1);
11546: l_submit_fcst_flag VARCHAR2(1);

Line 11544: l_request_id pa_budget_versions.request_id%TYPE;

11540:
11541: --End of variables used for debugging
11542: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
11543: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
11544: l_request_id pa_budget_versions.request_id%TYPE;
11545: l_submit_bdgt_flag VARCHAR2(1);
11546: l_submit_fcst_flag VARCHAR2(1);
11547: l_version_type pa_budget_versions.version_type%TYPE;
11548: l_success_msg VARCHAR2(1000);

Line 11547: l_version_type pa_budget_versions.version_type%TYPE;

11543: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
11544: l_request_id pa_budget_versions.request_id%TYPE;
11545: l_submit_bdgt_flag VARCHAR2(1);
11546: l_submit_fcst_flag VARCHAR2(1);
11547: l_version_type pa_budget_versions.version_type%TYPE;
11548: l_success_msg VARCHAR2(1000);
11549:
11550: -- the following cursor would query the interface table for any validation failure
11551: -- error messages present in the interface table corresponding to a set of run_id

Line 11556: c_version_type pa_budget_versions.version_type%TYPE,

11552: -- for the upload session.
11553:
11554: CURSOR l_get_error_msg_to_report_csr (c_run_id pa_fp_webadi_upload_inf.run_id%TYPE,
11555: c_plan_class pa_fin_plan_types_b.plan_class_code%TYPE,
11556: c_version_type pa_budget_versions.version_type%TYPE,
11557: c_request_id pa_budget_versions.request_id%TYPE)
11558: IS
11559: -- 4497321.Perf Fix:Modified SELECT query inorder to improve the performance.
11560: SELECT inf.task_number || '/' || inf.task_name task_info,

Line 11557: c_request_id pa_budget_versions.request_id%TYPE)

11553:
11554: CURSOR l_get_error_msg_to_report_csr (c_run_id pa_fp_webadi_upload_inf.run_id%TYPE,
11555: c_plan_class pa_fin_plan_types_b.plan_class_code%TYPE,
11556: c_version_type pa_budget_versions.version_type%TYPE,
11557: c_request_id pa_budget_versions.request_id%TYPE)
11558: IS
11559: -- 4497321.Perf Fix:Modified SELECT query inorder to improve the performance.
11560: SELECT inf.task_number || '/' || inf.task_name task_info,
11561: inf.resource_alias resource_info,

Line 11619: FROM pa_budget_versions pbv,

11615: SELECT fin.plan_class_code,
11616: pbv.version_type
11617: INTO l_plan_class_code,
11618: l_version_type
11619: FROM pa_budget_versions pbv,
11620: pa_fin_plan_types_b fin
11621: WHERE pbv.budget_version_id = l_budget_version_id
11622: AND fin.fin_plan_type_id = pbv.fin_plan_type_id;
11623:

Line 11674: -- stamp success code in pa_budget_versions and retain the request_id

11670: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11671: END IF;
11672:
11673: -- upon successful completion of the concurrent processing,
11674: -- stamp success code in pa_budget_versions and retain the request_id
11675: UPDATE pa_budget_versions
11676: SET plan_processing_code = 'XLUS',
11677: record_version_number = (record_version_number + 1)
11678: WHERE budget_version_id = l_budget_version_id;

Line 11675: UPDATE pa_budget_versions

11671: END IF;
11672:
11673: -- upon successful completion of the concurrent processing,
11674: -- stamp success code in pa_budget_versions and retain the request_id
11675: UPDATE pa_budget_versions
11676: SET plan_processing_code = 'XLUS',
11677: record_version_number = (record_version_number + 1)
11678: WHERE budget_version_id = l_budget_version_id;
11679:

Line 12062: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

12058: --This API is called to insert records into pa_fp_webadi_xface_tmp
12059: --during downloading budget line details into excel spreadsheet.
12060:
12061: PROCEDURE insert_periodic_tmp_table
12062: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
12063: ,x_return_status OUT NOCOPY VARCHAR2
12064: ,x_msg_count OUT NOCOPY NUMBER
12065: ,x_msg_data OUT NOCOPY VARCHAR2 )
12066: IS

Line 12072: CURSOR res_ass_cur(c_budget_version_id pa_budget_versions.budget_version_id%TYPE,

12068: which is introduced in MRUP3 of 11i. The changes are done as part of merging the MRUP3 changes
12069: done in 11i into R12.
12070: */
12071: --This Cursor is used to get Resource Assignment information associated with the budget version.
12072: CURSOR res_ass_cur(c_budget_version_id pa_budget_versions.budget_version_id%TYPE,
12073: c_project_id pa_projects_all.project_id%TYPE,
12074: c_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE,
12075: c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE)
12076: IS

Line 12271: l_project_id pa_budget_versions.project_id%TYPE;

12267: l_data VARCHAR2(2000);
12268: l_msg_data VARCHAR2(2000);
12269: l_msg_index_out NUMBER;
12270: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.insert_periodic_tmp_table';
12271: l_project_id pa_budget_versions.project_id%TYPE;
12272: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
12273: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
12274: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
12275: l_struct_status_flag VARCHAR2(1);

Line 12272: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

12268: l_msg_data VARCHAR2(2000);
12269: l_msg_index_out NUMBER;
12270: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.insert_periodic_tmp_table';
12271: l_project_id pa_budget_versions.project_id%TYPE;
12272: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
12273: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
12274: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
12275: l_struct_status_flag VARCHAR2(1);
12276: l_ci_id pa_budget_versions.ci_id%TYPE;

Line 12274: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;

12270: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.insert_periodic_tmp_table';
12271: l_project_id pa_budget_versions.project_id%TYPE;
12272: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
12273: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
12274: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
12275: l_struct_status_flag VARCHAR2(1);
12276: l_ci_id pa_budget_versions.ci_id%TYPE;
12277: l_AR_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
12278: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;

Line 12276: l_ci_id pa_budget_versions.ci_id%TYPE;

12272: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
12273: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
12274: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
12275: l_struct_status_flag VARCHAR2(1);
12276: l_ci_id pa_budget_versions.ci_id%TYPE;
12277: l_AR_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
12278: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
12279: l_agr_conv_reqd_flag VARCHAR2(1);
12280: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

Line 12277: l_AR_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

12273: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
12274: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
12275: l_struct_status_flag VARCHAR2(1);
12276: l_ci_id pa_budget_versions.ci_id%TYPE;
12277: l_AR_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
12278: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
12279: l_agr_conv_reqd_flag VARCHAR2(1);
12280: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
12281: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 12282: l_version_type pa_budget_versions.version_type%TYPE;

12278: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
12279: l_agr_conv_reqd_flag VARCHAR2(1);
12280: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
12281: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12282: l_version_type pa_budget_versions.version_type%TYPE;
12283: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12284: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12285: l_org_id pa_projects_all.org_id%TYPE;
12286: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;

Line 12358: FROM pa_budget_versions pbv,

12354: INTO l_project_id,
12355: l_project_name,
12356: l_project_number,
12357: l_rec_version_number --Bug 7863205
12358: FROM pa_budget_versions pbv,
12359: pa_projects_all ppa
12360: WHERE pbv.budget_version_id = l_budget_version_id
12361: AND pbv.project_id = ppa.project_id;
12362: EXCEPTION

Line 12430: FROM pa_budget_versions

12426: SELECT ci_id,
12427: approved_rev_plan_type_flag
12428: INTO l_ci_id,
12429: l_AR_flag
12430: FROM pa_budget_versions
12431: WHERE budget_version_id = l_budget_version_id;
12432: EXCEPTION
12433: WHEN NO_DATA_FOUND THEN
12434: IF l_debug_mode = 'Y' THEN