APPS.MSD_DELETE_DEMAND_PLAN dependencies on MSD_DEMAND_PLANS

Line 21: from msd_demand_plans

17:
18:
19: cursor c1 is
20: select nvl(dp_build_refresh_num,0)
21: from msd_demand_plans
22: where demand_plan_id = planId;
23:
24: l_dp_build_refresh_num number := 0;
25:

Line 30: update msd_demand_plans

26:
27: BEGIN
28: retcode := '0';
29:
30: update msd_demand_plans
31: set delete_plan_flag = 'YES'
32: where demand_plan_id = planId;
33:
34: open c1;

Line 53: DELETE FROM msd_demand_plans

49: can_Connect);
50: end if;
51: if ((retcode in ('0','1')) or ((retcode = '2') and ((nvl(can_Connect, 'NO')) = 'YES'))) then
52:
53: DELETE FROM msd_demand_plans
54: WHERE demand_plan_id = planId;
55:
56: DELETE FROM msd_dp_dimensions
57: WHERE demand_plan_id = planId;

Line 126: update msd_demand_plans

122: fnd_file.new_line(fnd_file.log, 1);
123: fnd_file.put_line(fnd_file.log, 'The Planning Server Demand Plan Definition was processed for deletion.');
124:
125: else
126: update msd_demand_plans
127: set delete_plan_flag = 'NO'
128: where demand_plan_id = planId;
129: fnd_file.new_line(fnd_file.log, 1);
130: fnd_file.put_line(fnd_file.log, 'The Planning Server Demand Plan Definition was not processed for deletion.');

Line 137: update msd_demand_plans

133:
134: end if;
135: exception
136: when others then
137: update msd_demand_plans
138: set delete_plan_flag = 'NO'
139: where demand_plan_id = planId;
140:
141: retcode := '2';