APPS.MSD_DELETE_DEMAND_PLAN SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 30

update msd_demand_plans
  set delete_plan_flag = 'YES'
  where demand_plan_id = planId;

Line: 48

		  DeleteAnyway,
		  can_Connect);

Line: 53

  DELETE FROM msd_demand_plans
  WHERE  demand_plan_id = planId;

Line: 56

  DELETE FROM msd_dp_dimensions
  WHERE  demand_plan_id = planId;

Line: 59

  DELETE FROM msd_dp_parameters
  WHERE  demand_plan_id = planId;

Line: 62

  DELETE FROM msd_dp_scenarios
  WHERE  demand_plan_id = planId;

Line: 65

  DELETE FROM msd_dp_hierarchies
  WHERE  demand_plan_id = planId;

Line: 68

  DELETE FROM msd_dp_express_setup
  WHERE  demand_plan_id = planId;

Line: 71

  DELETE FROM msd_dp_scenario_output_levels
  WHERE  demand_plan_id = planId;

Line: 74

  DELETE FROM msd_dp_scenario_events
  WHERE  demand_plan_id = planId;

Line: 77

  DELETE FROM msd_dp_scenario_entries
  WHERE demand_plan_id = planId;

Line: 80

/* Fix. Need to delete Headers as well when entries are deleted. */

  DELETE FROM msd_dp_scenario_revisions
  WHERE demand_plan_id = planId;

Line: 85

  DELETE FROM msd_dp_events
  WHERE  demand_plan_id = planId;

Line: 88

  DELETE FROM msd_dp_price_lists
  WHERE  demand_plan_id = planId;

Line: 91

  DELETE FROM msd_dp_calendars
  WHERE  demand_plan_id = planId;

Line: 94

  DELETE FROM msd_cs_data_ds
  WHERE  demand_plan_id = planId;

Line: 97

  DELETE FROM msd_dp_parameters_ds
  WHERE  demand_plan_id = planId;

Line: 100

  DELETE FROM msd_level_values_ds
  WHERE  demand_plan_id = planId;

Line: 103

  DELETE FROM msd_dp_seeded_documents
  WHERE  demand_plan_id = planId;

Line: 106

  DELETE FROM msd_dp_seeded_doc_dimensions
  WHERE  demand_plan_id = planId;

Line: 109

  DELETE FROM msd_dp_doc_dim_selections
  WHERE  demand_plan_id = planId;

Line: 112

  DELETE FROM msd_dp_formulas
  WHERE  demand_plan_id = planId;

Line: 115

  DELETE FROM msd_dp_formula_parameters
  WHERE  demand_plan_id = planId;

Line: 119

  DELETE FROM msd_dp_iso_organizations
  where demand_plan_id = planId;

Line: 126

  update msd_demand_plans
  set delete_plan_flag = 'NO'
  where demand_plan_id = planId;

Line: 137

    update msd_demand_plans
    set delete_plan_flag = 'NO'
    where demand_plan_id = planId;

Line: 142

end Delete;