APPS.PA_FP_CONTROL_ITEMS_IMPACT_PKG dependencies on PA_CI_IMPACTS

Line 48: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;

44: l_msg_count NUMBER;
45: l_ci_impact_id NUMBER;
46: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
47: l_agreement_id PA_AGREEMENTS_ALL.Agreement_Id%TYPE;
48: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
49: l_est_proj_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
50: l_est_proj_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
51: l_est_qty pa_budget_versions.est_quantity%TYPE;
52: l_est_equip_qty pa_budget_versions.est_equipment_quantity%TYPE;

Line 256: PA_CI_IMPACTS_pub.create_ci_impact(

252: (NVL(p_agreement_id,0) <> NVL(est_amt_rec.agreement_id,0) AND l_no_of_app_plan_types = 1 -- Modified for bug 5210100
253: AND p_fp_pref_code = 'COST_AND_REV_SAME') OR -- Modified for bug 6119004
254: NVL(l_est_equip_qty,0) <> NVL(est_amt_rec.est_equipment_quantity,0)
255: )THEN
256: PA_CI_IMPACTS_pub.create_ci_impact(
257: p_ci_id => p_ci_id,
258: p_impact_type_code => 'FINPLAN_COST',
259: p_status_code => 'CI_IMPACT_PENDING',
260: p_commit => 'F',

Line 291: PA_CI_IMPACTS_pub.create_ci_impact(

287: (p_button_pressed_from_page = 'REVENUE_EDIT' OR
288: p_button_pressed_from_page = 'ALL_EDIT' OR
289: NVL(p_agreement_id,0) <> NVL(est_amt_rec.agreement_id,0) OR
290: NVL(p_est_proj_revenue,0) <> NVL(est_amt_rec.est_project_revenue,0)) THEN
291: PA_CI_IMPACTS_pub.create_ci_impact(
292: p_ci_id => p_ci_id,
293: p_impact_type_code => 'FINPLAN_REVENUE',
294: p_status_code => 'CI_IMPACT_PENDING',
295: p_commit => 'F',

Line 942: DELETE FROM pa_ci_impacts

938:
939: END LOOP;
940: /* the finplan impact record also should be deleted from
941: ci table */
942: DELETE FROM pa_ci_impacts
943: WHERE
944: ci_id = p_ci_id AND
945: impact_type_code IN ('FINPLAN','FINPLAN_COST','FINPLAN_REVENUE');
946: