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 321: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

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

Line 322: l_bv_request_id pa_budget_versions.request_id%TYPE;

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

Line 323: l_inf_request_id pa_budget_versions.request_id%TYPE;

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

Line 364: pa_budget_versions bv

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

Line 443: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

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

Line 444: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

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

Line 447: p_request_id IN pa_budget_versions.request_id%TYPE,

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

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

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

Line 470: FROM pa_budget_versions bv,

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

Line 478: l_record_version_number pa_budget_versions.record_version_number%TYPE;

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

Line 483: l_version_type pa_budget_versions.version_type%TYPE;

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

Line 484: l_app_cost_plan_type_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;

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

Line 485: l_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

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

Line 486: l_prime_cost_fcst_flag pa_budget_versions.primary_cost_forecast_flag%TYPE;

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

Line 487: l_prime_rev_fcst_flag pa_budget_versions.primary_rev_forecast_flag%TYPE;

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

Line 488: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

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

Line 496: l_locked_by_persion_id pa_budget_versions.locked_by_person_id%TYPE;

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

Line 1017: p_request_id IN pa_budget_versions.request_id%TYPE,

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

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

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

Line 1726: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

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

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

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

Line 6069: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

6065:
6066: --This API is internally called from prepare_pbl_input
6067: PROCEDURE get_total_fcst_amounts
6068: (p_project_id IN pa_projects_all.project_id%TYPE,
6069: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6070: p_task_id IN pa_tasks.task_id%TYPE,
6071: p_resource_list_member_id IN pa_resource_list_members.resource_list_member_id%TYPE,
6072: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
6073: p_line_start_date IN DATE,

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

6667:
6668: PROCEDURE prepare_pbl_input
6669: (p_context IN VARCHAR2,
6670: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
6671: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
6672: p_inf_tbl_rec_tbl IN inf_cur_tbl_typ,
6673: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
6674: p_project_id IN pa_projects_all.project_id%TYPE,
6675: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

Line 6675: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

6671: p_request_id IN pa_budget_versions.request_id%TYPE DEFAULT NULL,
6672: p_inf_tbl_rec_tbl IN inf_cur_tbl_typ,
6673: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
6674: p_project_id IN pa_projects_all.project_id%TYPE,
6675: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6676: p_budget_lines_tbl IN PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE,
6677: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type,
6678: p_etc_start_date IN pa_budget_versions.etc_start_date%TYPE,
6679: p_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,

Line 6678: p_etc_start_date IN pa_budget_versions.etc_start_date%TYPE,

6674: p_project_id IN pa_projects_all.project_id%TYPE,
6675: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
6676: p_budget_lines_tbl IN PA_BUDGET_PUB.G_budget_lines_in_tbl%TYPE,
6677: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type,
6678: p_etc_start_date IN pa_budget_versions.etc_start_date%TYPE,
6679: p_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
6680: p_first_pd_bf_pm_en_dt IN DATE,
6681: p_last_pd_af_pm_st_dt IN DATE,
6682: p_prd_mask_st_date_tbl IN SYSTEM.pa_date_tbl_type,

Line 7971: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

7967: END prepare_pbl_input;
7968:
7969: PROCEDURE process_budget_lines
7970: ( p_context IN VARCHAR2,
7971: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
7972: p_version_info_rec IN pa_fp_gen_amount_utils.fp_cols,
7973: p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
7974: p_rlm_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
7975: p_ra_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

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

10070:
10071: --This procedure will update the budget version and its corresponding data in the interface table with
10072: --the latest request id and plan processing code(XLUP/XLUE).
10073: PROCEDURE update_xl_data_for_new_req
10074: (p_request_id IN pa_budget_versions.request_id%TYPE,
10075: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
10076: p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE,
10077: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
10078: p_null_out_cols IN VARCHAR2)

Line 10076: p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE,

10072: --the latest request id and plan processing code(XLUP/XLUE).
10073: PROCEDURE update_xl_data_for_new_req
10074: (p_request_id IN pa_budget_versions.request_id%TYPE,
10075: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
10076: p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE,
10077: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
10078: p_null_out_cols IN VARCHAR2)
10079: IS
10080: BEGIN

Line 10077: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

10073: PROCEDURE update_xl_data_for_new_req
10074: (p_request_id IN pa_budget_versions.request_id%TYPE,
10075: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
10076: p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE,
10077: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
10078: p_null_out_cols IN VARCHAR2)
10079: IS
10080: BEGIN
10081:

Line 10084: UPDATE pa_budget_versions

10080: BEGIN
10081:
10082: --Record Version Number is not updated since the web ADI code checks the record Version Number at downloand
10083: --with the record version number at upload and throws an error if they dont match.
10084: UPDATE pa_budget_versions
10085: SET request_id = p_request_id,
10086: plan_processing_code=p_plan_processing_code
10087: WHERE budget_version_id = p_budget_version_id;
10088:

Line 10114: p_request_id IN pa_budget_versions.request_id%TYPE,

10110: p_submit_budget_flag IN VARCHAR2,
10111: p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE,
10112: x_success_msg OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
10113: p_submit_forecast_flag IN VARCHAR2,
10114: p_request_id IN pa_budget_versions.request_id%TYPE,
10115: p_calling_mode IN VARCHAR2)
10116:
10117: IS
10118: -- variables used for debugging

Line 10129: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

10125: l_msg_data VARCHAR2(2000);
10126: l_data VARCHAR2(2000);
10127: l_msg_index_out NUMBER;
10128:
10129: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
10130: l_rec_version_number pa_budget_versions.record_version_number%TYPE;
10131: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;
10132: l_project_id pa_projects_all.project_id%TYPE;
10133: l_org_id pa_projects_all.org_id%TYPE;

Line 10130: l_rec_version_number pa_budget_versions.record_version_number%TYPE;

10126: l_data VARCHAR2(2000);
10127: l_msg_index_out NUMBER;
10128:
10129: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
10130: l_rec_version_number pa_budget_versions.record_version_number%TYPE;
10131: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;
10132: l_project_id pa_projects_all.project_id%TYPE;
10133: l_org_id pa_projects_all.org_id%TYPE;
10134: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;

Line 10287: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

10283: l_submit_flag VARCHAR2(1);
10284: l_profile_val VARCHAR2(30);
10285: l_profile_thsld_val NUMBER;
10286: l_profile_thsld_num NUMBER;
10287: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
10288: l_request_id NUMBER;
10289: l_rollback_flag VARCHAR2(1);
10290: l_first_pd_bf_pm_en_dt DATE;
10291: l_last_pd_af_pm_st_dt DATE;

Line 10449: FROM pa_budget_versions bv,

10445: etc_start_date
10446: INTO l_project_id,
10447: l_org_id,
10448: l_etc_start_date
10449: FROM pa_budget_versions bv,
10450: pa_projects_all pl
10451: WHERE bv.budget_version_id = l_budget_version_id
10452: AND bv.project_id = pl.project_id;
10453: EXCEPTION

Line 10886: UPDATE pa_budget_versions

10882: ELSE
10883: --log1('----- STAGE 10.14-------');
10884:
10885: -- updating the budget version with the request_id
10886: UPDATE pa_budget_versions
10887: SET plan_processing_code = 'XLUP',
10888: request_id = l_request_id
10889: WHERE budget_version_id = l_budget_version_id;
10890:

Line 11312: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

11308: l_debug_mode VARCHAR2(30);
11309: l_module_name VARCHAR2(100):='PAFPWAPB.process_MSExcel_data';
11310:
11311: --End of variables used for debugging
11312: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
11313: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
11314: l_request_id pa_budget_versions.request_id%TYPE;
11315: l_submit_bdgt_flag VARCHAR2(1);
11316: l_submit_fcst_flag VARCHAR2(1);

Line 11314: l_request_id pa_budget_versions.request_id%TYPE;

11310:
11311: --End of variables used for debugging
11312: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
11313: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
11314: l_request_id pa_budget_versions.request_id%TYPE;
11315: l_submit_bdgt_flag VARCHAR2(1);
11316: l_submit_fcst_flag VARCHAR2(1);
11317: l_version_type pa_budget_versions.version_type%TYPE;
11318: l_success_msg VARCHAR2(1000);

Line 11317: l_version_type pa_budget_versions.version_type%TYPE;

11313: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
11314: l_request_id pa_budget_versions.request_id%TYPE;
11315: l_submit_bdgt_flag VARCHAR2(1);
11316: l_submit_fcst_flag VARCHAR2(1);
11317: l_version_type pa_budget_versions.version_type%TYPE;
11318: l_success_msg VARCHAR2(1000);
11319:
11320: -- the following cursor would query the interface table for any validation failure
11321: -- error messages present in the interface table corresponding to a set of run_id

Line 11326: c_version_type pa_budget_versions.version_type%TYPE,

11322: -- for the upload session.
11323:
11324: CURSOR l_get_error_msg_to_report_csr (c_run_id pa_fp_webadi_upload_inf.run_id%TYPE,
11325: c_plan_class pa_fin_plan_types_b.plan_class_code%TYPE,
11326: c_version_type pa_budget_versions.version_type%TYPE,
11327: c_request_id pa_budget_versions.request_id%TYPE)
11328: IS
11329: -- 4497321.Perf Fix:Modified SELECT query inorder to improve the performance.
11330: SELECT inf.task_number || '/' || inf.task_name task_info,

Line 11327: c_request_id pa_budget_versions.request_id%TYPE)

11323:
11324: CURSOR l_get_error_msg_to_report_csr (c_run_id pa_fp_webadi_upload_inf.run_id%TYPE,
11325: c_plan_class pa_fin_plan_types_b.plan_class_code%TYPE,
11326: c_version_type pa_budget_versions.version_type%TYPE,
11327: c_request_id pa_budget_versions.request_id%TYPE)
11328: IS
11329: -- 4497321.Perf Fix:Modified SELECT query inorder to improve the performance.
11330: SELECT inf.task_number || '/' || inf.task_name task_info,
11331: inf.resource_alias resource_info,

Line 11389: FROM pa_budget_versions pbv,

11385: SELECT fin.plan_class_code,
11386: pbv.version_type
11387: INTO l_plan_class_code,
11388: l_version_type
11389: FROM pa_budget_versions pbv,
11390: pa_fin_plan_types_b fin
11391: WHERE pbv.budget_version_id = l_budget_version_id
11392: AND fin.fin_plan_type_id = pbv.fin_plan_type_id;
11393:

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

11440: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11441: END IF;
11442:
11443: -- upon successful completion of the concurrent processing,
11444: -- stamp success code in pa_budget_versions and retain the request_id
11445: UPDATE pa_budget_versions
11446: SET plan_processing_code = 'XLUS',
11447: record_version_number = (record_version_number + 1)
11448: WHERE budget_version_id = l_budget_version_id;

Line 11445: UPDATE pa_budget_versions

11441: END IF;
11442:
11443: -- upon successful completion of the concurrent processing,
11444: -- stamp success code in pa_budget_versions and retain the request_id
11445: UPDATE pa_budget_versions
11446: SET plan_processing_code = 'XLUS',
11447: record_version_number = (record_version_number + 1)
11448: WHERE budget_version_id = l_budget_version_id;
11449:

Line 11831: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

11827: --This API is called to insert records into pa_fp_webadi_xface_tmp
11828: --during downloading budget line details into excel spreadsheet.
11829:
11830: PROCEDURE insert_periodic_tmp_table
11831: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
11832: ,x_return_status OUT NOCOPY VARCHAR2
11833: ,x_msg_count OUT NOCOPY NUMBER
11834: ,x_msg_data OUT NOCOPY VARCHAR2 )
11835: IS

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

11837: which is introduced in MRUP3 of 11i. The changes are done as part of merging the MRUP3 changes
11838: done in 11i into R12.
11839: */
11840: --This Cursor is used to get Resource Assignment information associated with the budget version.
11841: CURSOR res_ass_cur(c_budget_version_id pa_budget_versions.budget_version_id%TYPE,
11842: c_project_id pa_projects_all.project_id%TYPE,
11843: c_parent_structure_version_id pa_proj_element_versions.parent_structure_version_id%TYPE,
11844: c_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE)
11845: IS

Line 12038: l_project_id pa_budget_versions.project_id%TYPE;

12034: l_data VARCHAR2(2000);
12035: l_msg_data VARCHAR2(2000);
12036: l_msg_index_out NUMBER;
12037: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.insert_periodic_tmp_table';
12038: l_project_id pa_budget_versions.project_id%TYPE;
12039: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
12040: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
12041: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
12042: l_struct_status_flag VARCHAR2(1);

Line 12039: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

12035: l_msg_data VARCHAR2(2000);
12036: l_msg_index_out NUMBER;
12037: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.insert_periodic_tmp_table';
12038: l_project_id pa_budget_versions.project_id%TYPE;
12039: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
12040: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
12041: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
12042: l_struct_status_flag VARCHAR2(1);
12043: l_ci_id pa_budget_versions.ci_id%TYPE;

Line 12041: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;

12037: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.insert_periodic_tmp_table';
12038: l_project_id pa_budget_versions.project_id%TYPE;
12039: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
12040: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
12041: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
12042: l_struct_status_flag VARCHAR2(1);
12043: l_ci_id pa_budget_versions.ci_id%TYPE;
12044: l_AR_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
12045: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;

Line 12043: l_ci_id pa_budget_versions.ci_id%TYPE;

12039: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
12040: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
12041: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
12042: l_struct_status_flag VARCHAR2(1);
12043: l_ci_id pa_budget_versions.ci_id%TYPE;
12044: l_AR_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
12045: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
12046: l_agr_conv_reqd_flag VARCHAR2(1);
12047: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;

Line 12044: l_AR_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

12040: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
12041: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
12042: l_struct_status_flag VARCHAR2(1);
12043: l_ci_id pa_budget_versions.ci_id%TYPE;
12044: l_AR_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
12045: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
12046: l_agr_conv_reqd_flag VARCHAR2(1);
12047: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
12048: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 12049: l_version_type pa_budget_versions.version_type%TYPE;

12045: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
12046: l_agr_conv_reqd_flag VARCHAR2(1);
12047: l_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
12048: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
12049: l_version_type pa_budget_versions.version_type%TYPE;
12050: l_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
12051: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
12052: l_org_id pa_projects_all.org_id%TYPE;
12053: l_current_planning_period pa_proj_fp_options.cost_current_planning_period%TYPE;

Line 12118: FROM pa_budget_versions pbv,

12114: ppa.segment1
12115: INTO l_project_id,
12116: l_project_name,
12117: l_project_number
12118: FROM pa_budget_versions pbv,
12119: pa_projects_all ppa
12120: WHERE pbv.budget_version_id = l_budget_version_id
12121: AND pbv.project_id = ppa.project_id;
12122: EXCEPTION

Line 12190: FROM pa_budget_versions

12186: SELECT ci_id,
12187: approved_rev_plan_type_flag
12188: INTO l_ci_id,
12189: l_AR_flag
12190: FROM pa_budget_versions
12191: WHERE budget_version_id = l_budget_version_id;
12192: EXCEPTION
12193: WHEN NO_DATA_FOUND THEN
12194: IF l_debug_mode = 'Y' THEN