APPS.PA_FP_WEBADI_PKG dependencies on PA_CONTROL_ITEMS

Line 482: l_ci_id pa_control_items.ci_id%TYPE;

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

Line 498: l_ci_status_code pa_control_items.status_code%TYPE;

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

Line 711: FROM pa_control_items pci,

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