[Home] [Help]
1218: END IF;
1219:
1220: g_ILocDmdSchTbl.extend;
1221: g_ILocDmdSchTbl(g_ILocDmdSchTbl.count) :=
1222: MscILocIODmdSchRec(SchTable(I).OrgId,
1223: SchTable(I).ScenarioSet,
1224: SchTable(I).DmdSchId,
1225: SchTable(I).ShipToConsumptionLvl,
1226: SchTable(I).DmdVariabilityType,
1331: FUNCTION INSERT_LOC_DMD_SCHEDULE(
1332: PlanId IN NUMBER,
1333: InsId IN NUMBER,
1334: UserId IN NUMBER,
1335: SchRec IN MscILocIODmdSchRec
1336: ) RETURN VARCHAR2 AS
1337: BEGIN
1338: BEGIN
1339: INSERT INTO msc_plan_schedules
1456: PROCEDURE UPDATE_LOC_DMD_SCHEDULE(
1457: PlanId IN NUMBER,
1458: InsId IN NUMBER,
1459: UserId IN NUMBER,
1460: SchRec IN MscILocIODmdSchRec
1461: ) AS
1462: BEGIN
1463: BEGIN
1464: UPDATE msc_plan_schedules