APPS.GMDRTVAL_PUB SQL Statements

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

Line: 40

     SELECT process_loss
     FROM   gmd_process_loss
     WHERE  routing_class = prouting_class
            AND NVL(max_quantity, 2147484647) >= NVL(pquantity,2147484647)
     ORDER BY max_quantity;

Line: 87

  SELECT 1
  FROM   SYS.DUAL
  WHERE  EXISTS (SELECT 1
                 FROM   fm_rout_hdr
                 WHERE  routing_no = prouting_no
                        AND routing_vers = prouting_vers);

Line: 142

  SELECT 1
  FROM   SYS.DUAL
  WHERE  EXISTS (SELECT 1
                 FROM   fm_rout_cls
                 WHERE  routing_class = prouting_class
                        AND delete_mark = 0);

Line: 197

  SELECT 1
  FROM   SYS.DUAL
  WHERE  EXISTS (SELECT 1
                 FROM   fm_rout_dtl
                 WHERE  routing_id = prouting_id
                        AND routingstep_no = proutingstep_no);

Line: 243

        select routing_id
        from fm_rout_hdr
        where routing_no = pRouting_no AND
              routing_vers = pRouting_vers;

Line: 249

        select routing_id
        from fm_rout_hdr
        where routing_id = xRouting_id;

Line: 313

    SELECT oprn_no, oprn_vers, effective_start_date, effective_end_date
    FROM   gmd_operations_b
    WHERE  ((poprn_id IS NOT NULL AND oprn_id = poprn_id)
            OR (poprn_id IS NULL AND (oprn_no = poprn_no
                                      AND oprn_vers = poprn_vers)
                )
            )
    AND    delete_mark = 0;

Line: 402

    SELECT distinct routingstep_no
    FROM   fm_rout_dep
    WHERE  routing_id = pparent_key;

Line: 408

    SELECT distinct batchstep_id
    FROM   gme_batch_step_dependencies
    WHERE  batch_id = pparent_key;

Line: 414

  SELECT max(routingstep_no)
  FROM (SELECT * FROM FM_ROUT_DEP  WHERE routing_id = pparent_key)
  START WITH routingstep_no = V_routingstep_no
  CONNECT BY (PRIOR dep_routingstep_no = routingstep_no)
             AND (PRIOR routing_id = routing_id);

Line: 421

  SELECT max(batchstep_id)
  FROM   gme_batch_step_dependencies
  START WITH batch_id = pparent_key AND
             batchstep_id = V_batchstep_id
  CONNECT BY (PRIOR dep_step_id = batchstep_id)
             AND (PRIOR batch_id = batch_id);

Line: 479

    SELECT routingstep_no
    FROM   fm_rout_dtl
    WHERE  routing_id = prouting_id
    ORDER BY routingstep_no desc;

Line: 487

    SELECT process_qty_um
    FROM   gmd_operations o, fm_rout_dtl d
    WHERE  d.routing_id = prouting_id
    AND    d.routingstep_no = V_step_no
    AND    d.oprn_id = o.oprn_id;

Line: 506

    insert_failure      EXCEPTION;

Line: 509

  DELETE FROM fm_rout_dep
  WHERE  routing_id = prouting_id;

Line: 535

        l_rout_dep.last_updated_by := l_user_id;

Line: 537

        l_rout_dep.last_update_date := SYSDATE;

Line: 541

        IF NOT FM_ROUT_DEP_DBL.insert_row (l_rout_dep) THEN
          CLOSE Cur_get_routing_steps;

Line: 543

          RAISE INSERT_FAILURE;

Line: 560

  WHEN INSERT_FAILURE THEN
     FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line: 598

    SELECT routingstep_no
    FROM   fm_rout_dtl
    WHERE  routing_id = prouting_id
    ORDER BY routingstep_no desc;

Line: 606

    SELECT process_qty_um
    FROM   gmd_operations o, fm_rout_dtl d
    WHERE  d.routing_id = prouting_id
    AND    d.routingstep_no = V_step_no
    AND    d.oprn_id = o.oprn_id;

Line: 625

    insert_failure      EXCEPTION;

Line: 628

  DELETE FROM fm_rout_dep
  WHERE  routing_id = prouting_id;

Line: 654

        l_rout_dep.last_updated_by := l_user_id;

Line: 656

        l_rout_dep.last_update_date := SYSDATE;

Line: 660

        IF NOT FM_ROUT_DEP_DBL.insert_row (l_rout_dep) THEN
          CLOSE Cur_get_routing_steps;

Line: 662

          RAISE INSERT_FAILURE;

Line: 679

  WHEN INSERT_FAILURE THEN
     FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line: 705

        SELECT  max_quantity
        FROM    gmd_process_loss
        WHERE   routing_class = pRouting_class AND
                max_quantity > pFromMaxQty AND
                max_quantity <= pToMaxQty;

Line: 744

   SELECT count(*) FROM gmd_operations_b
   WHERE oprn_id IN (select oprn_id from fm_rout_dtl where routing_id = pRouting_id);

Line: 792

   select count(*)
   from gmd_recipe_validity_rules v, gmd_recipes_b r, gmd_routings_b rt
   where v.recipe_id = r.recipe_id
   and r.routing_id = rt.routing_id
   and rt.routing_id = pRouting_id
   and rt.effective_start_date < v.start_date
   and (v.end_date IS NULL OR rt.effective_end_date > v.end_date);

Line: 826

 /* This procedure updates the start and end dates of
    the validity rules with the given start and end dates.
    This procedure is used when the routing effective
    dates falls outside the validity rules date range.  */
 /* =================================================== */
 PROCEDURE Update_VR_with_Rt_Dates( pRouting_id     IN   NUMBER,
                                    x_msg_count      OUT NOCOPY   NUMBER,
                                    x_msg_stack      OUT NOCOPY   VARCHAR2,
                                    x_return_status  OUT NOCOPY   VARCHAR2)  IS

 l_vr_id NUMBER := 0;

Line: 839

   select v.recipe_validity_rule_id vr_id , rt.effective_start_date start_date, rt.effective_end_date end_date
   from gmd_recipe_validity_rules v, gmd_recipes_b r, gmd_routings_b rt
   where v.recipe_id = r.recipe_id
   and r.routing_id = rt.routing_id
   and rt.routing_id = pRouting_id
   and rt.effective_start_date < v.start_date
   and (v.end_date IS NULL OR rt.effective_end_date > v.end_date);

Line: 850

   FOR update_vr_rec IN check_VR_Rout_dates  LOOP
     UPDATE gmd_recipe_validity_rules
     SET    start_date = update_vr_rec.start_date ,
            end_date   = update_vr_rec.end_date
     WHERE  recipe_validity_rule_id = update_vr_rec.vr_id;

Line: 866

 END Update_VR_with_Rt_Dates;

Line: 879

    Select routingStep_id
    From   fm_rout_dtl
    Where  routingStep_no = vRoutingStep_no  AND
           routing_id     = vRouting_id;

Line: 885

    Select routingStep_no
    From   fm_rout_dtl
    Where  routingStep_id = vRoutingStep_id;

Line: 941

      SELECT 1
      FROM   SYS.DUAL
      WHERE  EXISTS (SELECT 1
                     FROM gmd_recipe_routing_steps
                     WHERE routingstep_id = v_routingstep_id);

Line: 948

      SELECT 1
        FROM gmd_recipe_step_materials
       WHERE routingstep_id = v_routingstep_id;

Line: 994

/*    check_delete_mark */
/* */
/*  DESCRIPTION: */
/*    This PL/SQL procedure is responsible for  */
/*    checking the validity of the delete_mark. */
/* */
/*  REQUIREMENTS */
/*    delete_mark should be non null value. */
/*    */
/*  SYNOPSIS: */
/*    l_ret := gmdrtval_pub.check_delete_mark(pdelete_mark, pcalledby_form); */

Line: 1007

PROCEDURE check_delete_mark(pdelete_mark IN NUMBER,
                            x_return_status OUT NOCOPY  VARCHAR2) IS
  inv_delete_mark          EXCEPTION;

Line: 1012

  IF (pdelete_mark NOT IN (0,1)) THEN
    RAISE inv_delete_mark;

Line: 1016

  WHEN inv_delete_mark THEN
    x_return_status := 'E';

Line: 1018

    FND_MESSAGE.SET_NAME('GMA', 'SY_BADDELETEMARK');

Line: 1020

END check_delete_mark;

Line: 1043

  SELECT 1
  FROM   SYS.DUAL
  WHERE  EXISTS (SELECT 1
                 FROM   sy_orgn_usr
                 WHERE  user_id = powner_id
                        AND orgn_code = powner_orgn);

Line: 1093

  SELECT 1
  FROM   SYS.DUAL
  WHERE  EXISTS (SELECT 1
                 FROM   fm_rout_dep
                 WHERE  routing_id = prouting_id
                        AND routingstep_no = proutingStep_no
                        AND dep_routingstep_no = pdeproutingStep_no);

Line: 1142

     SELECT fixed_process_loss
     FROM   fm_rout_cls
     WHERE  routing_class = prouting_class ;