APPS.MRP_SCHEDULE_DESIG_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

  SELECT 1
    INTO dummy
    FROM dual
   WHERE NOT EXISTS (SELECT 1
                      FROM mrp_schedule_designators
                     WHERE schedule_designator = X_schedule_designator
                       AND organization_id = X_organization_id
                     );

Line: 30

PROCEDURE Update_Plans(X_organization_id NUMBER,
		       X_schedule_designator VARCHAR2) IS

BEGIN

  UPDATE mrp_plans
  SET    explosion_start_date      = NULL,
         explosion_completion_date = NULL,
         data_start_date           = NULL,
         data_completion_date      = NULL,
         plan_start_date           = NULL,
         plan_completion_date      = NULL
   WHERE schedule_designator       = X_schedule_designator
   AND   organization_id           = X_organization_id;

Line: 49

END Update_Plans;

Line: 64

  SELECT 1
    INTO dummy
    FROM dual
   WHERE NOT EXISTS (SELECT 1
                      FROM mrp_forecast_designators
                     WHERE forecast_designator = X_schedule_designator
                       AND organization_id = X_organization_id);

Line: 75

  SELECT 1
    INTO dummy
    FROM dual
   WHERE NOT EXISTS (SELECT 1
                      FROM mrp_designators
                     WHERE compile_designator = X_schedule_designator
                       AND organization_id = X_organization_id);

Line: 108

  SELECT 1
    INTO dummy
    FROM mrp_plans
   WHERE explosion_completion_date >= explosion_start_date
     AND data_start_date           >= explosion_completion_date
     AND data_completion_date      >= data_start_date
     AND plan_start_date           >= data_completion_date
     AND plan_completion_date      >= plan_start_date
     AND schedule_designator        = X_schedule_designator
     AND organization_id            = X_organization_id;