APPS.MSC_GEN_PRIORITIES dependencies on MSC_DRP_PRI_RULES_CALC

Line 77: delete msc_drp_pri_rules_calc

73: v_prev_type_pri number := 0;
74: v_prev_class_pri number := 0;
75: begin
76:
77: delete msc_drp_pri_rules_calc
78: where rule_set_id = p_rule_set_id;
79:
80: Open dmd_type_c;
81: LOOP

Line 89: insert into msc_drp_pri_rules_calc

85: v_dmd_type_rec.class_pri <> v_prev_class_pri then
86: v_priority := v_priority+1;
87: end if;
88: --dbms_output.put_line('v_priority='||v_priority||','||v_dmd_type_rec.demand_class||','||v_dmd_type_rec.demand_type);
89: insert into msc_drp_pri_rules_calc
90: (
91: rule_set_id,
92: demand_type,
93: demand_class,

Line 121: insert into msc_drp_pri_rules_calc

117:
118: -- add safety stock,
119: for a in 4..6 loop
120: v_priority := v_priority +1;
121: insert into msc_drp_pri_rules_calc
122: (
123: rule_set_id,
124: demand_type,
125: demand_class,