APPS.GMD_COMPOSITE_SPEC_DISP_PVT SQL Statements

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

Line: 23

FUNCTION insert_row (
  p_composite_spec_disp IN  GMD_COMPOSITE_SPEC_DISP%ROWTYPE
, x_composite_spec_disp OUT NOCOPY GMD_COMPOSITE_SPEC_DISP%ROWTYPE
)
RETURN BOOLEAN IS
BEGIN

    x_composite_spec_disp := p_composite_spec_disp;

Line: 32

   INSERT INTO GMD_COMPOSITE_SPEC_DISP
   (
    COMPOSITE_SPEC_DISP_ID
   ,EVENT_SPEC_DISP_ID
   ,DISPOSITION
   ,LATEST_IND
   ,CREATION_DATE
   ,CREATED_BY
   ,LAST_UPDATE_DATE
   ,LAST_UPDATED_BY
   ,LAST_UPDATE_LOGIN
   ,DELETE_MARK
   )
   VALUES
   (
    gmd_qc_comp_spec_disp_id_s.NEXTVAL
   ,x_composite_spec_disp.EVENT_SPEC_DISP_ID
   ,x_composite_spec_disp.DISPOSITION
   ,x_composite_spec_disp.LATEST_IND
   ,x_composite_spec_disp.CREATION_DATE
   ,x_composite_spec_disp.CREATED_BY
   ,x_composite_spec_disp.LAST_UPDATE_DATE
   ,x_composite_spec_disp.LAST_UPDATED_BY
   ,x_composite_spec_disp.LAST_UPDATE_LOGIN
   ,x_composite_spec_disp.DELETE_MARK
   )
      RETURNING composite_spec_disp_id INTO x_composite_spec_disp.composite_spec_disp_id
   ;

Line: 69

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

Line: 72

END insert_row;

Line: 76

FUNCTION delete_row (p_composite_spec_disp_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: 91

    SELECT 1
    INTO   dummy
    FROM   gmd_composite_spec_disp
    WHERE  composite_spec_disp_id = p_composite_spec_disp_id
    FOR UPDATE NOWAIT;

Line: 97

    UPDATE gmd_composite_spec_disp
    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_spec_disp_id = p_composite_spec_disp_id
    ;

Line: 125

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

Line: 128

END delete_row;

Line: 142

    SELECT 1
    INTO   dummy
    FROM   gmd_composite_spec_disp
    WHERE  composite_spec_disp_id = p_composite_spec_disp_id
    FOR UPDATE NOWAIT;

Line: 163

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

Line: 179

    SELECT *
    INTO   x_composite_spec_disp
    FROM   gmd_composite_spec_disp
    WHERE  composite_spec_disp_id = p_composite_spec_disp.composite_spec_disp_id
    ;