APPS.PA_FP_WEBADI_PKG dependencies on PA_PERIOD_MASKS_B

Line 445: p_pm_rec_version_number IN pa_period_masks_b.record_version_number%TYPE,

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
449: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 479: l_period_mask_id pa_period_masks_b.period_mask_id%TYPE;

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;
483: l_version_type pa_budget_versions.version_type%TYPE;

Line 491: l_pm_rec_version_number pa_period_masks_b.record_version_number%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:
493: is_periodic_layout VARCHAR2(1) := 'N';
494:
495: l_sec_ret_code VARCHAR2(30);

Line 609: FROM pa_period_masks_b

605: IF l_time_phase_code <> 'N' THEN
606: BEGIN
607: SELECT record_version_number
608: INTO l_pm_rec_version_number
609: FROM pa_period_masks_b
610: WHERE period_mask_id = l_period_mask_id;
611: EXCEPTION
612: WHEN NO_DATA_FOUND THEN
613: IF l_debug_mode = 'Y' THEN

Line 10131: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;

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;
10135: