APPS.MSC_WS_COMMON dependencies on MSC_PLAN_SCHEDULES

Line 358: DELETE FROM msc_plan_schedules

354: -- =============================================================
355: PROCEDURE PURGE_ALL_SCHEDULES(PlanId IN NUMBER) AS
356: BEGIN
357: BEGIN
358: DELETE FROM msc_plan_schedules
359: WHERE
360: plan_id = PlanId;
361: EXCEPTION WHEN others THEN
362: raise;

Line 440: INSERT INTO msc_plan_schedules

436: SchRec IN MscIGlbDmdSchRec
437: ) RETURN VARCHAR2 AS
438: BEGIN
439: BEGIN
440: INSERT INTO msc_plan_schedules
441: (
442: plan_id, organization_id, input_schedule_id, sr_instance_id,
443: input_type, last_update_date, last_updated_by,
444: creation_date, created_by, designator_type, ship_to

Line 482: INSERT INTO msc_plan_schedules

478: SchRec IN MscILocDmdSchRec
479: ) RETURN VARCHAR2 AS
480: BEGIN
481: BEGIN
482: INSERT INTO msc_plan_schedules
483: (
484: plan_id, organization_id,
485: input_schedule_id, sr_instance_id,
486: input_type, last_update_date, last_updated_by,

Line 532: INSERT INTO msc_plan_schedules

528: SchRec IN MscILocSupSchRec
529: ) RETURN VARCHAR2 AS
530: BEGIN
531: BEGIN
532: INSERT INTO msc_plan_schedules
533: (
534: plan_id, organization_id,
535: input_schedule_id, sr_instance_id,
536: input_type, last_update_date, last_updated_by,

Line 637: UPDATE msc_plan_schedules

633: SchRec IN MscIGlbDmdSchRec
634: ) AS
635: BEGIN
636: BEGIN
637: UPDATE msc_plan_schedules
638: SET
639: ship_to = SchRec.ShipToConsumptionLvl
640: WHERE
641: plan_id = PlanId AND

Line 670: UPDATE msc_plan_schedules

666: SchRec IN MscILocDmdSchRec
667: ) AS
668: BEGIN
669: BEGIN
670: UPDATE msc_plan_schedules
671: SET
672: ship_to = SchRec.ShipToConsumptionLvl,
673: include_target_demands = SchRec.IncludeTargetDmd,
674: interplant_demand_flag = SchRec.InterPlantFlg

Line 720: FROM msc_plan_schedules

716: FOR I IN GlbDmdSchs.first..GlbDmdSchs.last
717: LOOP
718: BEGIN
719: Select count(*) INTO l_Dummy
720: FROM msc_plan_schedules
721: WHERE
722: plan_id = PlanId AND
723: organization_id = -1 AND
724: sr_instance_id = InsId AND

Line 746: FROM msc_plan_schedules

742: FOR I IN LocDmdSchs.first..LocDmdSchs.last
743: LOOP
744: BEGIN
745: Select count(*) INTO l_Dummy
746: FROM msc_plan_schedules
747: WHERE
748: plan_id = PlanId AND
749: organization_id = LocDmdSchs(I).OrgId AND
750: sr_instance_id = InsId AND

Line 772: FROM msc_plan_schedules

768: FOR I IN LocSupSchs.first..LocSupSchs.last
769: LOOP
770: BEGIN
771: Select count(*) INTO l_Dummy
772: FROM msc_plan_schedules
773: WHERE
774: plan_id = PlanId AND
775: organization_id = LocSupSchs(I).OrgId AND
776: sr_instance_id = InsId AND