APPS.GMD_COMPOSITE_RESULT_ASSOC_PVT SQL Statements

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

Line: 23

FUNCTION insert_row (
  p_composite_result_assoc IN  GMD_COMPOSITE_RESULT_ASSOC%ROWTYPE
) RETURN BOOLEAN IS
BEGIN

    INSERT INTO GMD_COMPOSITE_RESULT_ASSOC
     (
      COMPOSITE_RESULT_ID
     ,RESULT_ID
     ,EXCLUDE_IND
     ,CREATION_DATE
     ,CREATED_BY
     ,LAST_UPDATE_DATE
     ,LAST_UPDATED_BY
     ,LAST_UPDATE_LOGIN
     )
     VALUES
     (
      p_composite_result_assoc.COMPOSITE_RESULT_ID
     ,p_composite_result_assoc.RESULT_ID
     ,p_composite_result_assoc.EXCLUDE_IND
     ,p_composite_result_assoc.CREATION_DATE
     ,p_composite_result_assoc.CREATED_BY
     ,p_composite_result_assoc.LAST_UPDATE_DATE
     ,p_composite_result_assoc.LAST_UPDATED_BY
     ,p_composite_result_assoc.LAST_UPDATE_LOGIN
     )
     ;

Line: 60

      fnd_msg_pub.add_exc_msg ('GMD_COMPOSITE_RESULT_ASSOC_PVT', 'INSERT_ROW');

Line: 63

END insert_row;

Line: 69

FUNCTION delete_row (p_composite_result_id   IN  NUMBER,
                     p_result_id             IN  NUMBER,
                     p_last_update_date      IN  DATE,
                     p_last_updated_by 	     IN  NUMBER,
                     p_last_update_login     IN  NUMBER)
RETURN BOOLEAN IS

  dummy       PLS_INTEGER;

Line: 86

    SELECT 1
    INTO   dummy
    FROM   gmd_composite_result_assoc
    WHERE  composite_result_id = p_composite_result_id
    AND    result_id           = p_result_id
    FOR UPDATE NOWAIT;

Line: 93

    UPDATE gmd_composite_result_assoc
    SET    delete_mark = 1,
           last_update_date  = NVL(p_last_update_date,SYSDATE),
           last_updated_by   = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
           last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
    WHERE  composite_result_id = p_composite_result_id
    AND    result_id           = p_result_id
    ;

Line: 122

     fnd_msg_pub.add_exc_msg ('GMD_COMPOSITE_RESULT_ASSOC_PVT', 'DELETE_ROW');

Line: 125

END delete_row;

Line: 142

    SELECT 1
    INTO   dummy
    FROM   gmd_composite_result_assoc
    WHERE  composite_result_id = p_composite_result_id
    AND    result_id           = p_result_id
    FOR UPDATE NOWAIT;

Line: 164

     fnd_msg_pub.add_exc_msg ('GMD_COMPOSITE_RESULT_ASSOC_PVT', 'DELETE_ROW');

Line: 181

    SELECT *
    INTO   x_composite_result_assoc
    FROM   gmd_composite_result_assoc
    WHERE  composite_result_id = p_composite_result_assoc.composite_result_id
    AND    result_id           = p_composite_result_assoc.result_id
    ;