APPS.WSH_RU_GRANTS_PVT SQL Statements

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

Line: 7

  PROCEDURE Insert_Row(
	p_grant_record	IN  Grant_Type,
	x_rowid		OUT NOCOPY  VARCHAR2,
	x_grant_id	OUT NOCOPY  NUMBER,
	x_return_status OUT NOCOPY  VARCHAR2) IS

    WSH_GRANT_OVERLAP EXCEPTION;

Line: 16

       SELECT grant_id
       FROM wsh_grants
       WHERE user_id = p_grant_record.user_id
       AND   NVL(organization_id, NVL(p_grant_record.organization_id, -1))
              = NVL(p_grant_record.organization_id, NVL(organization_id, -1))
       AND   (
                 (    p_grant_record.end_date IS NULL
                  AND p_grant_record.start_date < start_date)
              OR (    end_date IS NULL
                  AND p_grant_record.end_date > start_date)
              OR (    p_grant_record.end_date IS NULL
                  AND end_date IS NULL)
              OR (p_grant_record.start_date BETWEEN start_date AND end_date)
              OR (p_grant_record.end_date   BETWEEN start_date AND end_date)
              OR (start_date BETWEEN p_grant_record.start_date AND p_grant_record.end_date)
              OR (end_date BETWEEN p_grant_record.start_date AND p_grant_record.end_date)
             )
       AND rownum = 1;

Line: 36

       SELECT wsh_grants_s.nextval FROM DUAL;

Line: 39

       SELECT rowid FROM WSH_GRANTS WHERE grant_id = x_grant_id;

Line: 48

l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'INSERT_ROW';

Line: 90

    INSERT INTO WSH_GRANTS (
	GRANT_ID,
	USER_ID,
	ROLE_ID,
	ORGANIZATION_ID,
	START_DATE,
	END_DATE,
	CREATED_BY,
	CREATION_DATE,
	LAST_UPDATED_BY,
	LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN
	) VALUES (
	l_grant_id,
	p_grant_record.USER_ID,
	p_grant_record.ROLE_ID,
	p_grant_record.ORGANIZATION_ID,
	p_grant_record.START_DATE,
	p_grant_record.END_DATE,
	p_grant_record.CREATED_BY,
	p_grant_record.CREATION_DATE,
	p_grant_record.LAST_UPDATED_BY,
	p_grant_record.LAST_UPDATE_DATE,
	p_grant_record.LAST_UPDATE_LOGIN
	);

Line: 150

	wsh_util_core.default_handler('WSH_RU_GRANTS_PVT.INSERT_ROW');

Line: 160

  END Insert_Row;

Line: 168

	SELECT * FROM WSH_GRANTS
	WHERE rowid = p_rowid
	FOR UPDATE OF GRANT_ID NOWAIT;

Line: 202

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 218

       AND (l_db_rec.LAST_UPDATED_BY = p_grant_record.LAST_UPDATED_BY)
       AND (l_db_rec.LAST_UPDATE_DATE = p_grant_record.LAST_UPDATE_DATE)
       AND ((l_db_rec.LAST_UPDATE_LOGIN = p_grant_record.LAST_UPDATE_LOGIN)
            OR (    l_db_rec.LAST_UPDATE_LOGIN IS NULL
                AND p_grant_record.LAST_UPDATE_LOGIN IS NULL))
    THEN
      --
      -- Debug Statements
      --
      IF l_debug_on THEN
          WSH_DEBUG_SV.pop(l_module_name);

Line: 293

  PROCEDURE Update_Row(
	p_rowid		IN  VARCHAR2,
	p_grant_record	IN  Grant_Type,
	x_return_status OUT NOCOPY  VARCHAR2) IS

    WSH_GRANT_OVERLAP EXCEPTION;

Line: 301

       SELECT grant_id
       FROM wsh_grants
       WHERE user_id = p_grant_record.user_id
       AND   NVL(organization_id, NVL(p_grant_record.organization_id, -1))
              = NVL(p_grant_record.organization_id, NVL(organization_id, -1))
       AND   (
                 (    p_grant_record.end_date IS NULL
                  AND p_grant_record.start_date < start_date)
              OR (    end_date IS NULL
                  AND p_grant_record.end_date > start_date)
              OR (    p_grant_record.end_date IS NULL
                  AND end_date IS NULL)
              OR (p_grant_record.start_date BETWEEN start_date AND end_date)
              OR (p_grant_record.end_date   BETWEEN start_date AND end_date)
              OR (start_date BETWEEN p_grant_record.start_date AND p_grant_record.end_date)
              OR (end_date BETWEEN p_grant_record.start_date AND p_grant_record.end_date)
             )
       AND grant_id <> p_grant_record.grant_id
       AND rownum = 1;

Line: 326

l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ROW';

Line: 360

    UPDATE WSH_GRANTS
    SET
	USER_ID		  =  p_grant_record.USER_ID,
	ROLE_ID		  =  p_grant_record.ROLE_ID,
	ORGANIZATION_ID	  =  p_grant_record.ORGANIZATION_ID,
	START_DATE	  =  p_grant_record.START_DATE,
	END_DATE	  =  p_grant_record.END_DATE,
	CREATED_BY	  =  p_grant_record.CREATED_BY,
	CREATION_DATE	  =  p_grant_record.CREATION_DATE,
	LAST_UPDATED_BY	  =  p_grant_record.LAST_UPDATED_BY,
	LAST_UPDATE_DATE  =  p_grant_record.LAST_UPDATE_DATE,
	LAST_UPDATE_LOGIN =  p_grant_record.LAST_UPDATE_LOGIN
    WHERE GRANT_ID = p_grant_record.GRANT_ID;

Line: 389

        FND_MESSAGE.Set_Name('WSH', 'WSH_RU_GRANTS_OVERLAP_UPDATE');

Line: 403

	wsh_util_core.default_handler('WSH_RU_GRANTS_PVT.UPDATE_ROW');

Line: 413

  END Update_Row;

Line: 416

  PROCEDURE Delete_Row(
	p_rowid		IN  VARCHAR2,
	x_return_status OUT NOCOPY  VARCHAR2) IS
	--
l_debug_on BOOLEAN;

Line: 422

	l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_ROW';

Line: 443

    DELETE FROM WSH_GRANTS
    WHERE rowid = p_rowid;

Line: 460

	wsh_util_core.default_handler('WSH_RU_GRANTS_PVT.DELETE_ROW');

Line: 470

  END Delete_Row;