DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on PA_PERIOD_MASKS_B

Line 446: p_pm_rec_version_number IN pa_period_masks_b.record_version_number%TYPE,

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

Line 480: l_period_mask_id pa_period_masks_b.period_mask_id%TYPE;

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

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

Line 610: FROM pa_period_masks_b

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

Line 10309: l_pm_rec_version_number pa_period_masks_b.record_version_number%TYPE;

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