APPS.MSD_COPY_DEMAND_PLAN dependencies on MSD_DP_FORMULA_PARAMETERS

Line 994: INSERT INTO msd_dp_formula_parameters

990:
991: lv_status_id := 190;
992:
993:
994: INSERT INTO msd_dp_formula_parameters
995: ( DEMAND_PLAN_ID
996: ,FORMULA_ID
997: ,WHERE_USED
998: ,PARAMETER_SEQUENCE

Line 1039: msd_dp_formula_parameters mfp

1035: ,NULL
1036: ,NULL
1037: ,SYSDATE
1038: FROM
1039: msd_dp_formula_parameters mfp
1040: WHERE
1041: formula_id = lv_cur_formula_rec.formula_id AND demand_plan_id
1042: = p_source_demand_plan_id;
1043:

Line 1050: insert into msd_dp_formula_parameters

1046: END LOOP;
1047:
1048: if nvl(l_template_flag,'N') <> 'N' then
1049:
1050: insert into msd_dp_formula_parameters
1051:
1052: (
1053:
1054: demand_plan_id

Line 1138: from msd_dp_formula_parameters mdfp,

1134: ,NULL
1135:
1136: ,SYSDATE
1137:
1138: from msd_dp_formula_parameters mdfp,
1139: msd_dp_parameters mdp,
1140: msd_dp_parameters mdp1
1141:
1142: where mdfp.demand_plan_id in

Line 1159: insert into msd_dp_formula_parameters

1155: and mdp1.demand_plan_id=x_demand_plan_id
1156: and mdp1.parameter_type=mdp.parameter_type);
1157:
1158: else
1159: insert into msd_dp_formula_parameters
1160:
1161: (
1162:
1163: demand_plan_id

Line 1247: from msd_dp_formula_parameters mdfp,

1243: ,NULL
1244:
1245: ,SYSDATE
1246:
1247: from msd_dp_formula_parameters mdfp,
1248: msd_dp_parameters mdp,
1249: msd_dp_parameters mdp1
1250:
1251: where mdfp.demand_plan_id = p_source_demand_plan_id