APPS.MSD_COPY_DEMAND_PLAN dependencies on MSD_DP_PARAMETERS_S

Line 402: ,msd_dp_parameters_s.nextval

398: CALCULATED_ORDER,
399: POST_CALCULATION)
400: SELECT
401: x_demand_plan_id
402: ,msd_dp_parameters_s.nextval
403: ,par.PARAMETER_TYPE
404: ,par.PARAMETER_NAME
405: ,par.START_DATE
406: ,par.END_DATE

Line 461: update msd_dp_parameters set equation = rep_rec.equation, post_calculation=rep_rec.post_calculation where demand_plan_id=x_demand_plan_id and parameter_type=rep_rec.parameter_type;

457: close get_template_id;
458:
459: for rep_rec in replace_equation(l_template_id)
460: loop
461: update msd_dp_parameters set equation = rep_rec.equation, post_calculation=rep_rec.post_calculation where demand_plan_id=x_demand_plan_id and parameter_type=rep_rec.parameter_type;
462:
463: end loop;
464: end if;
465:

Line 918: select msd_dp_parameters_s.nextval into x_new_formula_id

914:
915: for lv_cur_formula_rec in cur_formula LOOP
916:
917:
918: select msd_dp_parameters_s.nextval into x_new_formula_id
919: from dual;
920:
921:
922: INSERT INTO msd_dp_formulas