APPS.FM_ROUT_DEP_DBL SQL Statements

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

Line: 23

 |      - update_row
 |      - lock_row
 |
 |
 =============================================================================
*/


/* Api start of comments
 +============================================================================
 |   FUNCTION NAME
 |      insert_row
 |
 |   TYPE
 |      Private
 |   USAGE
 |      Insert_Row will insert a row in fm_rout_dep
 |
 |
 |   DESCRIPTION
 |      Insert_Row will insert a row in fm_rout_dep
 |
 |
 |
 |   PARAMETERS
 |     p_out_dep IN  fm_rout_dep%ROWTYPE
 |     x_out_dep OUT fm_rout_dep%ROWTYPE
 |
 |   RETURNS
 |      BOOLEAN
 |   HISTORY
 |   20-MAR-01	Thomas Daniel	 Created
 |
 |
 |
 +=============================================================================
 Api end of comments
*/

  FUNCTION insert_row (
    p_out_dep	IN FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS
  BEGIN

    INSERT INTO FM_ROUT_DEP
     (
      ROUTINGSTEP_NO
     ,DEP_ROUTINGSTEP_NO
     ,ROUTING_ID
     ,DEP_TYPE
     ,REWORK_CODE
     ,STANDARD_DELAY
     ,MINIMUM_DELAY
     ,MAX_DELAY
     ,TRANSFER_QTY
     ,ITEM_UM
     ,TEXT_CODE
     ,LAST_UPDATED_BY
     ,CREATED_BY
     ,LAST_UPDATE_DATE
     ,CREATION_DATE
     ,LAST_UPDATE_LOGIN
     ,TRANSFER_PCT
     )
     VALUES
     (
      p_out_dep.ROUTINGSTEP_NO
     ,p_out_dep.DEP_ROUTINGSTEP_NO
     ,p_out_dep.ROUTING_ID
     ,p_out_dep.DEP_TYPE
     ,p_out_dep.REWORK_CODE
     ,p_out_dep.STANDARD_DELAY
     ,p_out_dep.MINIMUM_DELAY
     ,p_out_dep.MAX_DELAY
     ,p_out_dep.TRANSFER_QTY
     ,p_out_dep.ITEM_UM
     ,p_out_dep.TEXT_CODE
     ,p_out_dep.LAST_UPDATED_BY
     ,p_out_dep.CREATED_BY
     ,p_out_dep.LAST_UPDATE_DATE
     ,p_out_dep.CREATION_DATE
     ,p_out_dep.LAST_UPDATE_LOGIN
     ,p_out_dep.TRANSFER_PCT
     );

Line: 113

  END insert_row;

Line: 155

      SELECT
        ROUTINGSTEP_NO
       ,DEP_ROUTINGSTEP_NO
       ,ROUTING_ID
       ,DEP_TYPE
       ,REWORK_CODE
       ,STANDARD_DELAY
       ,MINIMUM_DELAY
       ,MAX_DELAY
       ,TRANSFER_QTY
       ,ITEM_UM
       ,TEXT_CODE
       ,LAST_UPDATED_BY
       ,CREATED_BY
       ,LAST_UPDATE_DATE
       ,CREATION_DATE
       ,LAST_UPDATE_LOGIN
       ,TRANSFER_PCT
      INTO
        x_out_dep.ROUTINGSTEP_NO
       ,x_out_dep.DEP_ROUTINGSTEP_NO
       ,x_out_dep.ROUTING_ID
       ,x_out_dep.DEP_TYPE
       ,x_out_dep.REWORK_CODE
       ,x_out_dep.STANDARD_DELAY
       ,x_out_dep.MINIMUM_DELAY
       ,x_out_dep.MAX_DELAY
       ,x_out_dep.TRANSFER_QTY
       ,x_out_dep.ITEM_UM
       ,x_out_dep.TEXT_CODE
       ,x_out_dep.LAST_UPDATED_BY
       ,x_out_dep.CREATED_BY
       ,x_out_dep.LAST_UPDATE_DATE
       ,x_out_dep.CREATION_DATE
       ,x_out_dep.LAST_UPDATE_LOGIN
       ,x_out_dep.TRANSFER_PCT
      FROM fm_rout_dep
      WHERE routingstep_no = p_out_dep.routingstep_no
      AND   dep_routingstep_no = p_out_dep.dep_routingstep_no
      AND   routing_id = p_out_dep.routing_id
      ;

Line: 218

 |      delete_row
 |
 |   TYPE
 |      Private
 |   USAGE
 |      Delete_Row will delete a row in fm_rout_dep
 |
 |
 |   DESCRIPTION
 |      Delete_Row will delete a row in fm_rout_dep
 |
 |
 |
 |   PARAMETERS
 |     p_out_dep IN  fm_rout_dep%ROWTYPE
 |
 |   RETURNS
 |      BOOLEAN
 |   HISTORY
 |   20-MAR-01	Thomas Daniel	 Created
 |
 |
 |
 +=============================================================================
 Api end of comments
*/

  FUNCTION delete_row (
    p_out_dep	IN FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS
  BEGIN
    IF p_out_dep.routingstep_no IS NOT NULL
    AND   p_out_dep.dep_routingstep_no IS NOT NULL
    AND   p_out_dep.routing_id IS NOT NULL
    THEN
      DELETE FROM fm_rout_dep
      WHERE routingstep_no = p_out_dep.routingstep_no
      AND   dep_routingstep_no = p_out_dep.dep_routingstep_no
      AND   routing_id = p_out_dep.routing_id
      ;

Line: 275

  END delete_row;

Line: 281

 |      update_row
 |
 |   TYPE
 |      Private
 |   USAGE
 |      Update_Row will update a row in fm_rout_dep
 |
 |
 |   DESCRIPTION
 |      Update_Row will update a row in fm_rout_dep
 |
 |
 |
 |   PARAMETERS
 |     p_out_dep IN  fm_rout_dep%ROWTYPE
 |
 |   RETURNS
 |      BOOLEAN
 |   HISTORY
 |   20-MAR-01	Thomas Daniel	 Created
 |
 |
 |
 +=============================================================================
 Api end of comments
*/

  FUNCTION update_row (
    p_out_dep	IN FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS
    l_dummy			NUMBER;

Line: 318

      SELECT 1 INTO l_dummy FROM fm_rout_dep
      WHERE routingstep_no = p_out_dep.routingstep_no
      AND   dep_routingstep_no = p_out_dep.dep_routingstep_no
      AND   routing_id = p_out_dep.routing_id
      FOR UPDATE NOWAIT;

Line: 324

      UPDATE fm_rout_dep
      SET
        ROUTINGSTEP_NO		= p_out_dep.ROUTINGSTEP_NO
       ,DEP_ROUTINGSTEP_NO		= p_out_dep.DEP_ROUTINGSTEP_NO
       ,ROUTING_ID		= p_out_dep.ROUTING_ID
       ,DEP_TYPE		= p_out_dep.DEP_TYPE
       ,REWORK_CODE		= p_out_dep.REWORK_CODE
       ,STANDARD_DELAY		= p_out_dep.STANDARD_DELAY
       ,MINIMUM_DELAY		= p_out_dep.MINIMUM_DELAY
       ,MAX_DELAY		= p_out_dep.MAX_DELAY
       ,TRANSFER_QTY		= p_out_dep.TRANSFER_QTY
       ,ITEM_UM		= p_out_dep.ITEM_UM
       ,TEXT_CODE		= p_out_dep.TEXT_CODE
       ,LAST_UPDATED_BY		= p_out_dep.LAST_UPDATED_BY
       ,CREATED_BY		= p_out_dep.CREATED_BY
       ,LAST_UPDATE_DATE		= p_out_dep.LAST_UPDATE_DATE
       ,CREATION_DATE		= p_out_dep.CREATION_DATE
       ,LAST_UPDATE_LOGIN		= p_out_dep.LAST_UPDATE_LOGIN
       ,TRANSFER_PCT		= p_out_dep.TRANSFER_PCT
      WHERE routingstep_no = p_out_dep.routingstep_no
      AND   dep_routingstep_no = p_out_dep.dep_routingstep_no
      AND   routing_id = p_out_dep.routing_id
      AND last_update_date = p_out_dep.last_update_date;

Line: 369

  END update_row;

Line: 410

      SELECT 1 INTO l_dummy FROM fm_rout_dep
      WHERE routingstep_no = p_out_dep.routingstep_no
      AND   dep_routingstep_no = p_out_dep.dep_routingstep_no
      AND   routing_id = p_out_dep.routing_id
      FOR UPDATE NOWAIT;