APPS.PA_FP_WEBADI_PKG dependencies on PA_CONTROL_ITEMS

Line 483: l_ci_id pa_control_items.ci_id%TYPE;

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

Line 499: l_ci_status_code pa_control_items.status_code%TYPE;

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);
502: l_msg_data VARCHAR2(2000);
503: l_msg_count NUMBER;

Line 712: FROM pa_control_items pci,

708: END IF;
709: BEGIN
710: SELECT pjs.project_system_status_code
711: INTO l_ci_status_code
712: FROM pa_control_items pci,
713: pa_project_statuses pjs
714: WHERE pci.ci_id = l_ci_id
715: and pci.status_code = pjs.project_status_code;
716: EXCEPTION