APPS.MSC_WS_IO dependencies on MSC_PLAN_SCHEDULES

Line 653: msc_plan_schedules

649: input_schedule_id,
650: demand_variability_type,
651: probability
652: FROM
653: msc_plan_schedules
654: WHERE
655: plan_id = idPlan AND
656: organization_id = -1;
657:

Line 850: msc_plan_schedules

846: input_schedule_id,
847: demand_variability_type,
848: probability
849: FROM
850: msc_plan_schedules
851: WHERE
852: plan_id = idPlan AND
853: organization_id <> -1 AND
854: scenario_set = idScenarioSet;

Line 1293: INSERT INTO msc_plan_schedules

1289: SchRec IN MscIGlbIODmdSchRec
1290: ) RETURN VARCHAR2 AS
1291: BEGIN
1292: BEGIN
1293: INSERT INTO msc_plan_schedules
1294: (
1295: plan_id, organization_id, input_schedule_id, sr_instance_id,
1296: input_type, last_update_date, last_updated_by,
1297: creation_date, created_by, designator_type, ship_to,

Line 1339: INSERT INTO msc_plan_schedules

1335: SchRec IN MscILocIODmdSchRec
1336: ) RETURN VARCHAR2 AS
1337: BEGIN
1338: BEGIN
1339: INSERT INTO msc_plan_schedules
1340: (
1341: plan_id, organization_id, input_schedule_id, sr_instance_id,
1342: input_type, last_update_date, last_updated_by,
1343: creation_date, created_by, designator_type, ship_to,

Line 1427: UPDATE msc_plan_schedules

1423: SchRec IN MscIGlbIODmdSchRec
1424: ) AS
1425: BEGIN
1426: BEGIN
1427: UPDATE msc_plan_schedules
1428: SET
1429: ship_to = SchRec.ShipToConsumptionLvl,
1430: demand_variability_type = SchRec.DmdVariabilityType,
1431: probability = SchRec.Probability,

Line 1464: UPDATE msc_plan_schedules

1460: SchRec IN MscILocIODmdSchRec
1461: ) AS
1462: BEGIN
1463: BEGIN
1464: UPDATE msc_plan_schedules
1465: SET
1466: ship_to = SchRec.ShipToConsumptionLvl,
1467: demand_variability_type = SchRec.DmdVariabilityType,
1468: probability = SchRec.Probability,

Line 1508: FROM msc_plan_schedules

1504: FOR I IN g_IGlbDmdSchTbl.FIRST..g_IGlbDmdSchTbl.LAST
1505: LOOP
1506: BEGIN
1507: Select count(*) INTO l_Dummy
1508: FROM msc_plan_schedules
1509: WHERE
1510: plan_id = PlanId AND
1511: organization_id = -1 AND
1512: sr_instance_id = InsId AND

Line 1532: FROM msc_plan_schedules

1528: FOR I IN g_ILocDmdSchTbl.first..g_ILocDmdSchTbl.last
1529: LOOP
1530: BEGIN
1531: Select count(*) INTO l_Dummy
1532: FROM msc_plan_schedules
1533: WHERE
1534: plan_id = PlanId AND
1535: organization_id = g_ILocDmdSchTbl(I).OrgId AND
1536: sr_instance_id = InsId AND